Skip to content

Latest commit

 

History

History
205 lines (158 loc) · 9.73 KB

2022-12-31.md

File metadata and controls

205 lines (158 loc) · 9.73 KB

Khala Summary (Daily)

Source: khala.polkaholic.io

Relay Chain: kusama Para ID: 2004

Daily Summary for Month ending in 2022-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
2022-12-31 3,015,136 3,021,554 6,419 134,004 1,399 22,893 5,596,999 117,404 ($454,619.67) 18 ($416.42) 13 ($297.20) 22 16
2022-12-30 3,008,599 3,015,135 6,537 134,862 1,398 22,872 6,546,853 119,257 ($600,922.05) 17 ($1,482.33) 21 ($1,202.50) 31 35
2022-12-29 3,002,034 3,008,598 6,565 136,649 1,330 22,872 5,899,101 117,073 ($1,425,764.18) 6 ($173.60) 5 ($200.74) 7 6
2022-12-28 2,995,171 3,002,033 6,863 125,161 1,337 22,828 3,020,218 92,027 ($1,037,180.56) 12 ($790.67) 17 ($1,204.98) 15 20
2022-12-27 2,988,298 2,995,170 6,873 133,360 1,552 22,814 3,175,848 119,156 ($1,269,538.93) 11 ($191.77) 4 ($550.68) 8 5
2022-12-26 2,981,432 2,988,297 6,866 139,074 1,604 22,268 3,024,183 123,299 ($1,662,031.19) 14 ($1,047.56) 10 ($828.75) 17 17
2022-12-25 2,974,521 2,981,431 6,911 139,940 1,548 22,243 2,862,914 124,727 ($952,680.86) 5 ($91.41) 3 ($47.11) 5 4
2022-12-24 2,967,578 2,974,520 6,943 142,373 1,543 22,214 2,766,467 129,534 ($548,794.15) 8 ($388.70) 8 ($497.09) 9 10
2022-12-23 2,960,621 2,967,577 6,957 102,483 1,570 22,200 1,831,986 87,620 ($4,230,416.50) 17 ($1,256.55) 11 ($398.58) 13 14
2022-12-22 2,953,623 2,960,620 6,998 4,821 294 21,881 60,907 846 ($4,052,912.28) 14 ($461.45) 4 ($245.08) 12 7
2022-12-21 2,946,614 2,953,622 7,009 7,630 117 21,933 69,018 50 ($58,737.72) 14 ($879.71) 9 ($255.33) 15 13
2022-12-20 2,939,791 2,946,613 6,823 10,132 176 21,926 79,921 52 ($96,473.05) 11 ($437.91) 4 ($110.24) 11 7
2022-12-19 2,933,059 2,939,790 6,732 38,772 406 21,919 928,104 9,399 ($24,843,170.96) 11 ($597.08) 21 ($780.15) 13 26
2022-12-18 2,926,341 2,933,058 6,718 3,403 152 19,741 30,689 39 ($11,091.75) 12 ($464.19) 6 ($117.08) 12 9
2022-12-17 2,919,665 2,926,340 6,676 5,771 104 19,730 42,414 66 ($65,549.51) 8 ($284.59) 8 ($464.83) 5 8
2022-12-16 2,913,082 2,919,664 6,583 4,132 325 19,723 45,240 574 ($77,218.60) 3 ($45.76) 9 ($406.24) 9 16
2022-12-15 2,906,630 2,913,081 6,452 49,100 1,666 19,717 644,778 2,320 ($260,767.01) 11 ($1,107.14) 8 ($376.65) 8 9
2022-12-14 2,900,449 2,906,629 6,181 128,305 1,815 19,709 1,697,503 3,038 ($489,188.48) 10 ($332.46) 11 ($713.28) 8 13
2022-12-13 2,894,477 2,900,448 5,972 126,616 2,433 19,696 1,645,317 2,911 ($340,094.72) 13 ($355.82) 11 ($2,154.01) 19 12
2022-12-12 2,889,042 2,894,476 5,435 118,104 2,416 19,684 1,518,503 2,736 ($143,382.18) 4 ($36.72) 4 ($158.04) 8 7
2022-12-11 2,883,659 2,889,041 5,383 119,085 2,416 19,668 1,520,371 2,743 ($91,861.70) 4 ($585.91) 7 ($297.22) 8 7
2022-12-10 2,878,228 2,883,658 5,431 118,974 2,402 19,660 1,523,766 2,478 ($175,101.50) 5 ($295.00) 8 ($819.12) 10 15
2022-12-09 2,872,978 2,878,227 5,250 115,906 2,456 19,638 1,480,505 3,035 ($470,711.68) 18 ($1,985.69) 16 ($752.80) 24 24
2022-12-08 2,866,724 2,872,977 6,254 131,496 2,481 19,635 1,703,840 2,837 ($207,181.68) 13 ($1,137.77) 15 ($969.75) 16 19
2022-12-07 2,860,380 2,866,723 6,344 135,796 2,492 19,617 1,760,855 2,761 ($163,325.81) 6 ($175.04) 19 ($898.73) 9 24
2022-12-06 2,854,029 2,860,379 6,351 133,347 2,507 19,597 1,735,998 3,011 ($214,059.12) 13 ($137.77) 9 ($164.72) 15 12
2022-12-05 2,847,668 2,854,028 6,361 134,388 2,454 19,574 1,752,697 3,669 ($253,549.35) 9 ($116.46) 18 ($687.01) 14 23
2022-12-04 2,841,286 2,847,667 6,382 130,264 1,851 19,550 1,730,821 3,172 ($404,874.15) 5 ($87.32) 8 ($319.12) 7 9
2022-12-03 2,834,901 2,841,285 6,385 130,456 1,824 19,534 1,727,138 2,926 ($197,987.81) 16 ($1,160.93) 26 ($1,188.01) 21 32
2022-12-02 2,828,517 2,834,900 6,384 129,712 1,897 19,511 1,727,385 3,254 ($298,688.33) 19 ($789.45) 22 ($883.56) 30 33
2022-12-01 2,822,145 2,828,516 6,372 128,461 1,907 19,493 1,709,975 3,371 ($318,294.47) 15 ($171.87) 11 ($187.49) 15 11

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

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