Skip to content

Latest commit

 

History

History
190 lines (143 loc) · 7.04 KB

2024-05-31.md

File metadata and controls

190 lines (143 loc) · 7.04 KB

Khala Summary (Daily)

Source: khala.polkaholic.io

Relay Chain: kusama Para ID: 2004

Daily Summary for Month ending in 2024-05-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
2024-05-18 6,250,574 6,257,475 6,902 143,409 27,576 2,139,205 136,108 ($291,187.24)
2024-05-17 6,243,605 6,250,573 6,969 145,392 27,579 2,163,111 137,346 ($418,983.49)
2024-05-16 6,236,664 6,243,604 6,941 143,925 27,577 2,139,876 135,129 ($473,875.29)
2024-05-15 6,229,689 6,236,663 6,975 145,365 27,571 2,155,704 135,264 ($584,480.63)
2024-05-14 6,222,772 6,229,688 6,917 151,985 27,563 2,222,853 134,431 ($1,886,879.53)
2024-05-13 6,215,827 6,222,771 6,945 152,457 27,549 2,231,330 136,178 ($505,105.05)
2024-05-12 6,208,844 6,215,826 6,983 148,980 27,544 2,175,640 134,714 ($241,854.18)
2024-05-11 6,201,941 6,208,843 6,903 144,203 27,536 2,126,619 132,136 ($295,450.10)
2024-05-10 6,195,047 6,201,940 6,894 144,357 27,525 2,137,576 133,729 ($1,041,777.67)
2024-05-09 6,188,104 6,195,046 6,943 143,973 27,519 2,136,803 133,576 ($563,592.65)
2024-05-08 6,181,137 6,188,103 6,967 145,179 27,510 2,126,842 132,342 ($748,301.96)
2024-05-07 6,174,203 6,181,136 6,934 140,753 27,499 2,073,048 128,797 ($415,673.02)
2024-05-06 6,167,245 6,174,202 6,958 141,215 27,474 2,083,332 128,948 ($992,771.11)
2024-05-05 6,160,276 6,167,244 6,969 141,906 27,471 2,125,158 133,870 ($306,985.47)
2024-05-04 6,153,326 6,160,275 6,950 140,115 27,461 2,092,456 131,758 ($233,462.81)
2024-05-03 6,146,383 6,153,325 6,943 136,903 27,457 2,043,738 129,998 ($212,981.81)

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

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