Skip to content

Latest commit

 

History

History
203 lines (156 loc) · 8.73 KB

2024-02-29.md

File metadata and controls

203 lines (156 loc) · 8.73 KB

Khala Summary (Daily)

Source: khala.polkaholic.io

Relay Chain: kusama Para ID: 2004

Daily Summary for Month ending in 2024-02-29

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-02-29 5,716,564 5,723,096 6,533 132,647 26,682 2,166,221 124,479 ($1,745,088.88)
2024-02-28 5,709,978 5,716,563 6,586 134,761 26,680 2,205,033 127,006 ($1,516,888.00)
2024-02-27 5,703,411 5,709,977 6,567 135,285 26,665 2,205,747 126,614 ($1,920,334.66)
2024-02-26 5,696,826 5,703,410 6,585 135,134 26,651 2,204,313 125,942 ($334,569.21)
2024-02-25 5,690,246 5,696,825 6,580 135,311 26,639 2,202,494 125,540 ($528,963.67)
2024-02-24 5,683,783 5,690,245 6,463 134,174 26,634 2,178,040 123,496 ($171,298.13)
2024-02-23 5,677,270 5,683,782 6,513 136,859 26,637 2,217,683 125,604 ($332,140.30)
2024-02-22 5,670,952 5,677,269 6,318 128,119 26,626 2,110,882 120,130 ($824,446.74)
2024-02-21 5,664,578 5,670,951 6,374 129,460 26,626 2,147,902 122,077 ($655,198.34)
2024-02-20 5,658,072 5,664,577 6,506 132,450 26,628 2,175,816 124,126 ($440,754.40)
2024-02-19 5,651,630 5,658,071 6,442 131,302 26,621 2,158,382 122,996 ($368,256.28)
2024-02-18 5,645,182 5,651,629 6,448 132,884 26,609 2,176,165 124,124 ($513,191.36)
2024-02-17 5,638,775 5,645,181 6,407 130,971 26,595 2,150,339 121,229 ($709,312.73)
2024-02-16 5,632,596 5,638,774 6,179 123,190 26,567 2,007,688 109,676 ($298,843.57)
2024-02-15 5,627,888 5,632,595 4,708 100,217 26,579 1,598,881 86,728 ($680,576.62)
2024-02-14 5,621,688 5,627,887 6,200 129,166 26,570 2,100,033 119,213 ($1,964,878.82)
2024-02-13 5,615,411 5,621,687 6,277 131,231 26,558 2,132,302 121,257 ($592,002.40)
2024-02-12 5,608,730 5,615,410 6,681 134,262 26,548 2,202,263 125,785 ($354,640.64)
2024-02-11 5,602,076 5,608,729 6,654 136,793 26,548 2,226,772 127,215 ($258,675.63)
2024-02-10 5,595,382 5,602,075 6,694 137,089 26,544 2,226,222 127,041 ($1,360,696.58)
2024-02-09 5,588,742 5,595,381 6,640 136,309 26,537 2,217,714 127,010 ($337,284.11)
2024-02-08 5,582,208 5,588,741 6,534 132,906 26,520 2,162,192 123,486 ($557,644.40)
2024-02-07 5,575,646 5,582,207 6,562 137,654 26,507 2,238,268 125,818 ($373,948.18)
2024-02-06 5,568,994 5,575,645 6,652 140,814 26,496 2,260,700 125,054 ($245,569.80)
2024-02-05 5,562,428 5,568,993 6,566 144,317 26,498 2,302,813 124,725 ($300,183.22) 5 2
2024-02-04 5,555,866 5,562,427 6,562 144,024 26,491 2,307,792 124,961 ($555,712.40) 3 ($63.93) 2
2024-02-03 5,549,250 5,555,865 6,616 145,014 26,485 2,383,633 125,200 ($306,406.87) 2 1 ($4.95)
2024-02-02 5,542,641 5,549,249 6,609 144,883 26,476 2,395,020 125,678 ($284,767.90) 1 1 ($1.07)
2024-02-01 5,536,131 5,542,640 6,510 144,809 26,468 2,428,159 126,755 ($653,513.72) 9 ($174.13) 1 ($0.99) 3 1

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-02-29" 
 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-02-29" 
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-02-29" 
 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-02-29" 
 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-02-29" 
 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-02-29" 
 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-02-29" 
 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-02-29" 
 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-02-29" 
 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-02-29" 
 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-02-29" 
 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-02-29" 
 group by logDT 
order by logDT

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