Skip to content

Latest commit

 

History

History
204 lines (157 loc) · 9.43 KB

2023-11-30.md

File metadata and controls

204 lines (157 loc) · 9.43 KB

Khala Summary (Daily)

Source: khala.polkaholic.io

Relay Chain: kusama Para ID: 2004

Daily Summary for Month ending in 2023-11-30

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
2023-11-30 5,123,887 5,130,544 6,658 149,354 848 584 31 25,980 2,315,587 128,909 ($806,961.57) 1 ($415.55) 4 ($49.97) 7 12
2023-11-29 5,117,266 5,123,886 6,621 138,813 872 420 25,978 2,167,018 120,214 ($764,471.26) 3 ($151.44) 12 4
2023-11-28 5,110,505 5,117,265 6,761 148,525 851 439 28 25,972 2,333,421 129,914 ($488,509.99) 6
2023-11-27 5,104,042 5,110,504 6,463 140,034 855 582 33 25,956 2,229,834 126,588 ($794,761.17) 2 ($3.40) 1 10 5
2023-11-26 5,097,602 5,104,041 6,440 134,039 830 391 25,937 2,152,883 123,624 ($297,707.38) 1 ($52.80) 3 ($49.80) 10 6
2023-11-25 5,091,194 5,097,601 6,408 133,847 806 458 25,947 2,163,176 125,915 ($247,513.20) 1 ($3.26) 3 ($15.75) 2 14
2023-11-24 5,084,843 5,091,193 6,351 138,652 1,694 460 15 25,945 2,247,479 125,520 ($580,754.34) 3 ($21.85) 9 7
2023-11-23 5,078,500 5,084,842 6,343 144,973 854 513 25,944 2,245,597 125,797 ($1,472,427.72)
2023-11-22 5,072,137 5,078,499 6,363 148,194 867 514 35 25,939 2,306,340 125,376 ($497,104.09) 1 ($1.16) 8
2023-11-21 5,065,877 5,072,136 6,260 155,517 868 443 41 25,934 2,404,605 122,899 ($930,090.74) 2
2023-11-20 5,059,531 5,065,876 6,346 154,113 929 655 25,912 2,380,708 125,881 ($1,904,560.09) 1 ($106.03) 4
2023-11-19 5,053,188 5,059,530 6,343 144,488 827 594 33 25,895 2,265,671 126,658 ($478,893.16) 2 ($59.74) 3 4
2023-11-18 5,046,770 5,053,187 6,418 144,091 828 456 41 25,877 2,266,810 127,876 ($317,403.85) 1 ($0.56) 1
2023-11-17 5,040,350 5,046,769 6,420 141,165 906 500 25,851 2,234,999 127,321 ($585,081.11) 1 ($26.10) 1 11 4
2023-11-16 5,034,209 5,040,349 6,141 134,409 827 556 24 25,859 2,126,171 121,721 ($317,045.69) 1 ($34.89) 1 1 1
2023-11-15 5,028,555 5,034,208 5,654 121,723 813 419 25,852 1,921,997 110,632 ($257,411.68) 2
2023-11-14 5,022,899 5,028,554 5,656 123,047 896 596 19 25,849 1,953,024 112,953 ($911,363.08) 1 ($0.61) 2 ($0.61) 4 2
2023-11-13 5,017,229 5,022,898 5,670 123,909 818 668 22 25,866 1,974,062 114,558 ($672,220.80) 1 ($154.38) 8 4
2023-11-12 5,011,431 5,017,228 5,798 127,666 781 484 31 25,878 2,024,651 116,739 ($282,604.68) 3 ($45.77) 3 ($40.60) 6 5
2023-11-11 5,005,089 5,011,430 6,342 137,970 762 438 18 25,864 2,191,131 126,287 ($751,049.41) 11 ($576.33) 4 ($423.56) 19 12
2023-11-10 4,998,734 5,005,088 6,355 137,220 804 572 17 25,879 2,180,578 126,286 ($513,662.99) 3 ($73.61) 3 ($410.58) 4 4
2023-11-09 4,992,402 4,998,733 6,332 132,375 775 493 31 25,891 2,108,181 121,891 ($452,801.22) 3 ($275.84) 4 ($39.49) 3 4
2023-11-08 4,986,095 4,992,401 6,307 127,965 872 550 25,884 2,050,634 117,875 ($314,457.50) 1 ($154.40) 1 ($0.11) 5 5
2023-11-07 4,979,778 4,986,094 6,317 131,131 843 469 14 25,896 2,122,810 124,531 ($838,542.06) 1 ($29.67) 2 ($89.46) 4 5
2023-11-06 4,973,525 4,979,777 6,253 128,803 888 634 32 25,900 2,085,231 122,322 ($816,707.21) 3 ($60.47) 3 ($1.36) 5 5
2023-11-05 4,967,256 4,973,524 6,269 128,982 846 403 25,895 2,083,106 121,878 ($468,192.16) 2 ($7.70) 2 ($100.08) 2 2
2023-11-04 4,960,910 4,967,255 6,346 128,889 821 405 18 25,892 2,100,701 123,570 ($267,750.85) 1 ($13.54) 1 ($1.58) 1 1
2023-11-03 4,954,616 4,960,909 6,294 129,399 888 449 49 25,900 2,110,532 122,396 ($307,151.66) 1 ($23.18) 1
2023-11-02 4,948,431 4,954,615 6,185 129,137 865 555 10 25,862 2,094,338 120,725 ($575,355.58) 2 2
2023-11-01 4,942,662 4,948,430 5,769 120,181 828 445 15 25,901 1,952,456 111,498 ($292,721.39) 2 ($42.25) 1 ($15.71) 5 4

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)) = "2023-11-30" 
 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)) = "2023-11-30" 
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)) = "2023-11-30" 
 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)) = "2023-11-30" 
 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)) = "2023-11-30" 
 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)) = "2023-11-30" 
 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)) = "2023-11-30" 
 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)) = "2023-11-30" 
 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)) = "2023-11-30" 
 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)) = "2023-11-30" 
 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)) = "2023-11-30" 
 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)) = "2023-11-30" 
 group by logDT 
order by logDT

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