Skip to content

Latest commit

 

History

History
204 lines (157 loc) · 9.68 KB

2022-11-30.md

File metadata and controls

204 lines (157 loc) · 9.68 KB

Khala Summary (Daily)

Source: khala.polkaholic.io

Relay Chain: kusama Para ID: 2004

Daily Summary for Month ending in 2022-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
2022-11-30 2,815,807 2,822,144 6,338 127,876 1,969 19,481 1,705,174 3,577 ($539,123.23) 7 ($2,863.97) 18 ($3,046.68) 22 33
2022-11-29 2,809,548 2,815,806 6,259 127,842 2,040 19,461 1,699,055 3,354 ($298,862.63) 7 ($36.21) 10 ($130.32) 11 14
2022-11-28 2,803,208 2,809,547 6,340 127,824 1,904 19,611 1,696,172 3,273 ($557,902.00) 6 ($329.02) 7 ($175.31) 12 17
2022-11-27 2,796,871 2,803,207 6,337 127,595 1,816 19,594 1,699,096 3,147 ($162,066.65) 6 ($198.02) 13 ($552.88) 16 24
2022-11-26 2,790,517 2,796,870 6,354 127,928 1,799 19,585 1,701,703 2,946 ($275,849.76) 4 ($199.92) 5 ($256.99) 5 6
2022-11-25 2,784,113 2,790,516 6,404 129,851 1,877 19,567 1,722,769 3,224 ($189,122.37) 3 ($15.85) 6 ($203.26) 7 11
2022-11-24 2,777,729 2,784,112 6,384 129,164 1,810 19,543 1,719,667 3,102 ($302,742.19) 11 ($758.58) 7 ($438.71) 15 11
2022-11-23 2,771,287 2,777,728 6,442 130,203 1,828 19,508 1,736,225 3,162 ($546,402.29) 5 ($150.58) 9 ($810.60) 9 13
2022-11-22 2,764,851 2,771,286 6,436 128,708 1,855 19,482 1,713,145 3,308 ($317,515.26) 12 ($863.65) 15 ($639.67) 19 22
2022-11-21 2,758,342 2,764,850 6,509 131,686 1,951 19,458 1,753,307 3,783 ($608,728.22) 8 ($159.94) 8 ($753.18) 12 12
2022-11-20 2,751,875 2,758,341 6,467 130,383 1,899 19,429 1,737,111 3,307 ($362,791.60) 9 ($709.33) 13 ($393.43) 12 17
2022-11-19 2,745,428 2,751,874 6,447 131,023 1,860 19,414 1,745,266 3,399 ($256,819.17) 6 ($207.20) 9 ($279.21) 10 14
2022-11-18 2,738,977 2,745,427 6,451 130,417 1,983 19,397 1,734,966 3,541 ($778,026.45) 6 ($368.72) 9 ($696.80) 10 13
2022-11-17 2,732,506 2,738,976 6,471 130,733 1,913 19,367 1,742,170 3,566 ($455,347.58) 12 ($827.67) 17 ($633.54) 17 21
2022-11-16 2,725,975 2,732,505 6,531 132,053 1,906 19,345 1,754,081 3,430 ($187,822.96) 5 ($88.21) 6 ($244.21) 8 10
2022-11-15 2,719,423 2,725,974 6,552 133,471 1,950 19,306 1,767,779 3,765 ($562,117.63) 10 ($503.17) 11 ($1,047.14) 14 15
2022-11-14 2,712,864 2,719,422 6,559 130,970 2,074 19,273 1,734,963 5,005 ($569,584.90) 17 ($2,163.71) 14 ($1,411.82) 29 23
2022-11-13 2,706,280 2,712,863 6,584 130,248 1,891 19,225 1,734,710 4,183 ($379,255.60) 18 ($918.38) 15 ($1,424.84) 25 22
2022-11-12 2,699,672 2,706,279 6,608 113,506 1,915 19,185 1,506,920 3,104 ($148,760.83) 12 ($1,115.51) 17 ($1,288.29) 25 30
2022-11-11 2,693,137 2,699,671 6,535 130,880 1,929 19,152 1,743,731 3,225 ($556,671.45) 15 ($2,070.26) 12 ($1,776.63) 30 24
2022-11-10 2,686,574 2,693,136 6,563 133,647 2,034 19,118 1,774,584 3,718 ($619,282.30) 22 ($6,338.97) 26 ($4,939.62) 54 58
2022-11-09 2,680,058 2,686,573 6,516 132,333 1,946 19,084 1,756,378 3,360 ($318,664.27) 24 ($2,331.17) 24 ($2,318.99) 49 53
2022-11-08 2,673,568 2,680,057 6,490 132,046 1,900 19,043 1,755,146 3,440 ($626,063.41) 23 ($2,551.97) 45 ($4,796.92) 30 50
2022-11-07 2,666,977 2,673,567 6,591 135,400 2,142 19,012 1,795,459 4,103 ($1,623,011.49) 29 ($3,845.43) 44 ($4,891.54) 47 63
2022-11-06 2,660,387 2,666,976 6,590 132,630 2,126 18,994 1,766,536 4,016 ($1,047,337.59) 43 ($6,113.12) 34 ($3,221.90) 59 50
2022-11-05 2,653,801 2,660,386 6,586 133,024 1,895 18,940 1,773,914 3,158 ($347,583.21) 15 ($1,345.72) 15 ($1,595.29) 23 22
2022-11-04 2,647,296 2,653,800 6,505 132,910 2,280 18,915 1,762,738 3,954 ($421,047.47) 40 ($2,352.18) 17 ($1,970.41) 56 29
2022-11-03 2,640,812 2,647,295 6,484 133,116 2,046 18,761 1,761,591 3,722 ($437,744.50) 48 ($2,916.07) 38 ($2,291.42) 54 46
2022-11-02 2,634,368 2,640,811 6,444 133,126 2,291 18,666 1,755,028 4,259 ($753,880.56) 50 ($3,792.28) 41 ($3,204.26) 69 61
2022-11-01 2,627,833 2,634,367 6,535 133,292 2,060 18,599 1,765,065 3,600 ($746,240.80) 24 ($2,150.85) 20 ($2,086.62) 38 34

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

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