Skip to content

Latest commit

 

History

History
204 lines (157 loc) · 9.63 KB

2022-06-30.md

File metadata and controls

204 lines (157 loc) · 9.63 KB

Khala Summary (Daily)

Source: khala.polkaholic.io

Relay Chain: kusama Para ID: 2004

Daily Summary for Month ending in 2022-06-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-06-30 1,888,231 1,893,933 5,703 115,904 2,188 16,813 1,294,754 2,146 ($232,229.13) 4 ($189.08) 9 ($1,663.96) 4 11
2022-06-29 1,882,600 1,888,230 5,631 114,902 2,200 16,801 1,284,019 2,010 ($111,297.67) 8 ($415.51) 6 ($238.11) 8 7
2022-06-28 1,876,909 1,882,599 5,691 116,525 2,176 16,783 1,301,745 1,983 ($121,876.63) 9 ($882.21) 6 ($1,429.44) 11 6
2022-06-27 1,871,184 1,876,908 5,725 117,462 2,199 16,764 1,313,402 2,139 ($160,600.32) 5 ($578.76) 6 ($1,406.77) 8 6
2022-06-26 1,864,962 1,871,183 6,222 127,244 2,192 16,748 1,423,888 2,341 ($139,822.92) 14 ($315.93) 5 ($252.63) 14 5
2022-06-25 1,858,723 1,864,961 6,239 125,056 2,278 16,709 1,406,506 1,981 ($260,531.33) 16 ($3,472.30) 13 ($586.47) 17 13
2022-06-24 1,852,537 1,858,722 6,186 125,493 2,330 16,678 1,373,173 1,898 ($248,882.19) 22 ($459.50) 9 ($280.41) 22 11
2022-06-23 1,846,391 1,852,536 6,146 124,306 2,323 16,645 1,278,083 2,208 ($160,614.25) 27 ($1,297.00) 5 ($653.30) 28 6
2022-06-22 1,840,249 1,846,390 6,142 125,152 2,542 16,597 1,275,396 2,268 ($186,521.66) 43 ($675.05) 8 ($1,422.15) 44 8
2022-06-21 1,835,092 1,840,248 5,157 107,023 2,576 16,435 1,090,648 2,349 ($239,437.04) 46 ($992.57) 5 ($206.84) 46 5
2022-06-20 1,829,154 1,835,091 5,938 119,595 2,305 16,281 1,224,645 2,249 ($168,785.43) 3 ($83.71) 4 ($271.52) 6 5
2022-06-19 1,823,092 1,829,153 6,062 121,552 2,221 16,275 1,248,091 2,288 ($167,982.73) 4 ($1,728.46) 3 ($253.82) 4 3
2022-06-18 1,817,009 1,823,091 6,083 120,961 2,159 16,267 1,244,608 1,855 ($79,422.71) 1 ($5.00) 11 ($1,185.62) 6 13
2022-06-17 1,810,937 1,817,008 6,072 122,944 2,312 16,263 1,259,076 2,339 ($141,962.17) 9 ($1,906.27) 4 ($234.80) 10 7
2022-06-16 1,804,904 1,810,936 6,033 121,492 2,316 16,221 1,246,481 2,273 ($268,675.05) 3 ($256.76) 6 ($281.84) 4 7
2022-06-15 1,798,915 1,804,903 5,989 121,124 2,292 16,254 1,244,796 2,526 ($184,427.27) 7 ($2,456.41) 6 ($1,755.05) 8 11
2022-06-14 1,792,887 1,798,914 6,028 121,504 2,276 16,229 1,247,928 2,482 ($167,057.86) 9 ($230.27) 14 ($259.29) 16 16
2022-06-13 1,786,877 1,792,886 6,010 121,473 2,322 16,204 1,246,789 2,809 ($274,225.96) 10 ($6,141.28) 9 ($3,770.42) 10 13
2022-06-12 1,780,903 1,786,876 5,974 121,763 2,394 16,146 1,247,768 2,747 ($87,916.02) 8 ($1,664.75) 11 ($3,647.09) 11 14
2022-06-11 1,774,900 1,780,902 6,003 120,570 2,215 16,133 1,266,480 2,243 ($215,208.15) 6 ($2,254.90) 9 ($1,935.87) 6 13
2022-06-10 1,768,758 1,774,899 6,142 123,404 2,285 16,128 1,295,141 2,356 ($285,226.87) 2 ($502.36) 10 ($1,414.66) 6 14
2022-06-09 1,762,618 1,768,757 6,140 122,452 2,223 16,112 1,283,915 1,860 ($159,845.14) 8 ($1,293.14) 9 ($676.37) 15 10
2022-06-08 1,756,410 1,762,617 6,208 123,767 2,311 16,091 1,297,938 2,174 ($241,695.81) 12 ($897.40) 11 ($797.00) 12 12
2022-06-07 1,750,331 1,756,409 6,079 121,931 2,274 16,063 1,271,813 2,243 ($279,451.54) 20 ($1,939.59) 11 ($329.29) 25 15
2022-06-06 1,744,198 1,750,330 6,133 123,311 2,297 16,031 1,290,715 2,332 ($212,392.45) 8 ($207.51) 8 ($7,573.49) 13 12
2022-06-05 1,738,031 1,744,197 6,167 126,732 2,310 16,013 1,317,900 2,004 ($142,417.35) 5 ($232.05) 8 ($254.51) 5 8
2022-06-04 1,731,880 1,738,030 6,151 124,945 2,235 16,008 1,301,072 1,659 ($124,906.62) 2 ($82.61) 9 ($349.13) 2 9
2022-06-03 1,725,817 1,731,879 6,063 122,020 2,239 15,997 1,267,160 1,941 ($172,685.52) 6 ($2,984.20) 16 ($3,005.22) 6 16
2022-06-02 1,719,695 1,725,816 6,122 123,446 2,318 15,971 1,284,877 2,120 ($305,724.01) 12 ($1,644.96) 17 ($1,691.81) 14 20
2022-06-01 1,713,500 1,719,694 6,195 124,097 2,278 15,938 1,294,337 2,079 ($111,774.84) 7 ($66.17) 17 ($777.12) 8 18

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-06-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-06-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-06-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-06-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-06-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-06-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-06-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-06-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-06-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-06-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-06-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-06-30" 
 group by logDT 
order by logDT

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