Skip to content

Latest commit

 

History

History
205 lines (158 loc) · 9.15 KB

2024-01-31.md

File metadata and controls

205 lines (158 loc) · 9.15 KB

Khala Summary (Daily)

Source: khala.polkaholic.io

Relay Chain: kusama Para ID: 2004

Daily Summary for Month ending in 2024-01-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-01-31 5,530,340 5,536,130 5,791 128,427 26,468 2,143,925 111,941 ($179,600.13) 11 ($55.01) 1
2024-01-30 5,524,734 5,530,339 5,606 125,228 26,464 2,081,708 108,378 ($292,622.60) 9
2024-01-29 5,519,115 5,524,733 5,619 122,165 26,456 1,986,399 108,788 ($254,417.98) 1 1 ($0.81) 1
2024-01-28 5,513,491 5,519,114 5,624 133,381 26,457 2,076,388 107,763 ($191,339.78) 19 ($1,676.11) 2 ($142.20) 3 2
2024-01-27 5,507,934 5,513,490 5,557 141,719 26,444 2,183,070 107,523 ($290,054.77) 6 ($52.32) 2 ($52.32) 2 3
2024-01-26 5,502,373 5,507,933 5,561 144,067 26,432 2,336,242 108,162 ($624,939.25) 23
2024-01-25 5,497,191 5,502,372 5,182 134,117 26,423 2,063,277 101,637 ($201,636.11) 25 1 ($69.83) 1
2024-01-24 5,491,714 5,497,190 5,477 141,338 26,415 2,167,742 105,292 ($316,450.09) 12 1 1
2024-01-23 5,484,961 5,491,713 6,753 170,895 26,419 2,638,902 130,082 ($631,501.27) 7 ($1,463.56) 3 ($661.64) 3 4
2024-01-22 5,478,167 5,484,960 6,794 161,892 26,422 2,568,563 131,465 ($836,739.06) 9 ($61.18) 2 3 2
2024-01-21 5,471,421 5,478,166 6,746 158,751 26,433 2,548,500 132,229 ($1,171,527.13)
2024-01-20 5,464,691 5,471,420 6,730 148,826 26,403 2,410,818 130,496 ($485,268.09)
2024-01-19 5,457,927 5,464,690 6,764 147,414 26,424 2,378,731 129,587 ($541,465.41)
2024-01-18 5,451,092 5,457,926 6,835 149,788 26,401 2,427,145 133,476 ($471,099.53)
2024-01-17 5,444,272 5,451,091 6,820 150,696 26,396 2,427,601 132,464 ($460,186.79)
2024-01-16 5,437,493 5,444,271 6,779 148,728 26,398 2,406,642 131,630 ($521,991.94)
2024-01-15 5,430,751 5,437,492 6,742 149,724 26,351 2,428,140 131,700 ($517,956.45) 14 2 ($83.27) 2
2024-01-14 5,423,994 5,430,750 6,757 145,924 26,383 2,356,436 128,118 ($606,934.10) 4 ($45.20) 1 ($63.34) 6 1
2024-01-13 5,417,235 5,423,993 6,759 143,647 26,376 2,351,395 129,950 ($672,714.11) 3 ($16.29) 1 2 1
2024-01-12 5,410,412 5,417,234 6,823 26,398 131,541 ($649,851.32) 9 4 ($0.53) 1 2
2024-01-11 5,403,630 5,410,411 6,782 142,246 26,389 2,350,097 130,879 ($679,152.77) 3 1 1
2024-01-10 5,396,892 5,403,629 6,738 142,865 26,376 2,350,246 129,597 ($464,334.14) 8 3 4 3
2024-01-09 5,390,134 5,396,891 6,758 145,349 26,359 2,390,421 129,282 ($503,895.12) 3 1 ($32.56) 2 1
2024-01-08 5,383,340 5,390,133 6,794 147,091 26,359 2,443,924 132,074 ($613,526.99) 1 ($38.61) 1 1
2024-01-07 5,376,568 5,383,339 6,772 144,340 26,356 2,407,158 131,695 ($751,698.27) 11
2024-01-06 5,369,772 5,376,567 6,796 144,446 26,350 2,406,104 133,155 ($373,788.79) 2 2 ($0.85) 1 1
2024-01-05 5,362,976 5,369,771 6,796 145,788 26,342 2,392,417 133,755 ($557,852.27) 3
2024-01-04 5,356,228 5,362,975 6,748 144,567 26,341 2,399,391 132,398 ($560,377.01) 7 1 1 1
2024-01-03 5,349,484 5,356,227 6,744 143,469 26,342 2,373,074 131,179 ($1,125,406.41) 8 3
2024-01-02 5,342,701 5,349,483 6,783 146,472 26,343 2,400,944 131,601 ($989,536.83) 14 2 ($0.14) 3 2
2024-01-01 5,335,918 5,342,700 6,783 148,506 26,317 2,424,235 132,735 ($373,089.11) 5 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-01-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-01-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-01-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-01-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-01-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-01-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-01-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-01-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-01-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-01-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-01-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-01-31" 
 group by logDT 
order by logDT

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