Skip to content

Latest commit

 

History

History
205 lines (158 loc) · 8.18 KB

2021-12-31.md

File metadata and controls

205 lines (158 loc) · 8.18 KB

Khala Summary (Daily)

Source: khala.polkaholic.io

Relay Chain: kusama Para ID: 2004

Daily Summary for Month ending in 2021-12-31

Date Start Block End Block # Blocks # Extrinsics # Active Accounts # Passive Accounts # New Accounts # Addresses # Events # Transfers ($USD) # XCM Transfers In ($USD) # XCM Transfers Out ($USD) # XCM In # XCM Out Issues
2021-12-31 996,765 1,003,114 6,350 70,850 1,299 13,764 744,218 125 ($120,909.19)
2021-12-30 990,422 996,764 6,343 88,073 1,304 13,763 926,617 102 ($460,007.06)
2021-12-29 983,968 990,421 6,454 74,934 1,298 13,760 784,967 77 ($84,158.76)
2021-12-28 977,411 983,967 6,557 11,056 908 13,751 115,254 19 ($3,922.56)
2021-12-27 970,954 977,410 6,457 7,153 686 13,745 74,724 17 ($311.69)
2021-12-26 964,482 970,953 6,472 3,369 421 13,728 35,730 10 ($9.53)
2021-12-25 957,970 964,481 6,512 7,197 698 13,755 75,319 26 ($825.68)
2021-12-24 951,424 957,969 6,546 3,493 429 13,751 36,437
2021-12-23 945,006 951,423 6,418 14,118 999 13,745 145,057 18 ($199.75)
2021-12-22 938,434 945,005 6,572 15,027 1,173 13,741 155,460 99 ($71.44)
2021-12-21 931,911 938,433 6,523 11,264 1,024 13,739 117,357 56 ($4,441.65)
2021-12-20 925,262 931,910 6,649 15,543 1,151 13,734 161,173 74 ($1,587.85)
2021-12-19 918,567 925,261 6,695 11,317 858 13,731 117,799 45 ($88.72)
2021-12-18 911,883 918,566 6,684 10,980 775 13,726 112,510 130 ($545.32)
2021-12-17 905,400 911,882 3,860 6,632 270 13,723 71,007 14 ($1,178.84)
2021-12-16 900,000 904,651 7 4 13,715 21
2021-12-15 893,838 898,200 7 2 13,710 17
2021-12-14 888,313 892,800 4 1 3 13,702 18
2021-12-13 883,800 887,400 6 1 5 13,699 22 1 ($958.31)
2021-12-12 878,324 882,000 6 5 13,693 19
2021-12-11 873,000 876,804 5 4 13,688 13
2021-12-10 867,600 872,027 6 3 13,679 19
2021-12-09 862,200 865,800 7 4 13,666 27
2021-12-08 856,800 860,436 4 3 13,661 22
2021-12-07 850,759 855,000 6 6 13,652 46
2021-12-06 847,800 849,600 4 2 13,641 14
2021-12-05 842,400 846,000 6 4 13,626 19
2021-12-04 837,399 840,600 108 1 7 13,616 195 1 ($3.21)
2021-12-03 831,258 837,372 435 10 15 13,613 894 9 ($936.51)
2021-12-02 826,410 831,203 601 23 30 13,607 1,217 20 ($229.65)
2021-12-01 821,668 826,370 641 12 16 13,626 1,243 10 ($1,248.61)

Sample Queries:

You can generate the above summary data using the following queries using the public dataset bigquery-public-data.crypto_kusama in Google BigQuery:

Blocks

Schema

SELECT date(block_time) as logDT, MIN(number) startBN, MAX(number) endBN, COUNT(*) numBlocks 
 FROM `bigquery-public-data.crypto_kusama.blocks2004`  
 where LAST_DAY(date(block_time)) = "2021-12-31" 
 group by logDT 
 order by logDT

Signed Extrinsics

Schema

SELECT date(block_time) as logDT, 
COUNT(*) numSignedExtrinsics 
FROM `bigquery-public-data.crypto_kusama.extrinsics2004`  
where signed and LAST_DAY(date(block_time)) = "2021-12-31" 
group by logDT 
order by logDT

Active Accounts

Schema

SELECT date(ts) as logDT, 
 COUNT(*) numActiveAccounts 
 FROM `bigquery-public-data.crypto_kusama.accountsactive2004` 
 where LAST_DAY(date(ts)) = "2021-12-31" 
 group by logDT 
 order by logDT

Passive Accounts

Schema

SELECT date(ts) as logDT, 
 COUNT(*) numPassiveAccounts 
 FROM `bigquery-public-data.crypto_kusama.accountspassive2004` 
 where LAST_DAY(date(ts)) = "2021-12-31" 
 group by logDT 
 order by logDT

New Accounts

Schema

SELECT date(ts) as logDT, 
 COUNT(*) numNewAccounts 
 FROM `bigquery-public-data.crypto_kusama.accountsnew2004` 
 where LAST_DAY(date(ts)) = "2021-12-31" 
 group by logDT
 order by logDT

Addresses with Balances

Schema

SELECT date(ts) as logDT,
 COUNT(distinct address_pubkey) numAddress 
 FROM `bigquery-public-data.crypto_kusama.balances2004` 
 where LAST_DAY(date(ts)) = "2021-12-31" 
 group by logDT 
 order by logDT

Events

Schema

SELECT date(block_time) as logDT, 
 COUNT(*) numEvents 
 FROM `bigquery-public-data.crypto_kusama.events2004` 
 where LAST_DAY(date(block_time)) = "2021-12-31" 
 group by logDT 
 order by logDT

Transfers:

Schema

SELECT date(block_time) as logDT, 
 COUNT(*) numEvents 
 FROM `bigquery-public-data.crypto_kusama.transfers2004` 
 where LAST_DAY(date(block_time)) = "2021-12-31" 
 group by logDT 
 order by logDT

XCM Transfers In:

Schema

SELECT date(origination_ts) as logDT, 
 COUNT(*) numXCMTransfersOut 
 FROM `bigquery-public-data.crypto_kusama.xcmtransfers` 
 where destination_para_id = 2004 and LAST_DAY(date(origination_ts)) = "2021-12-31" 
 group by logDT order by logDT

XCM Transfers Out:

Schema

SELECT date(origination_ts) as logDT, 
 COUNT(*) numXCMTransfersIn 
 FROM `bigquery-public-data.crypto_kusama.xcmtransfers` 
 where origination_para_id = 2004 and LAST_DAY(date(origination_ts)) = "2021-12-31" 
 group by logDT 
order by logDT

XCM Messages In:

Schema

SELECT date(origination_ts) as logDT, 
 COUNT(*) numXCMMessagesOut 
 FROM `bigquery-public-data.crypto_kusama.xcm` 
 where destination_para_id = 2004 and LAST_DAY(date(origination_ts)) = "2021-12-31" 
 group by logDT order by logDT

XCM Messages Out:

Schema

SELECT date(origination_ts) as logDT, 
 COUNT(*) numXCMMessagesIn 
 FROM `bigquery-public-data.crypto_kusama.xcm` 
 where origination_para_id = 2004 and LAST_DAY(date(origination_ts)) = "2021-12-31" 
 group by logDT 
order by logDT

Report source: https://cdn.polkaholic.io/substrate-etl/kusama/2004.json | See Definitions for details