Skip to content

Latest commit

 

History

History
204 lines (157 loc) · 9.43 KB

2023-09-30.md

File metadata and controls

204 lines (157 loc) · 9.43 KB

Khala Summary (Daily)

Source: khala.polkaholic.io

Relay Chain: kusama Para ID: 2004

Daily Summary for Month ending in 2023-09-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
2023-09-30 4,752,447 4,758,500 6,054 122,619 857 684 15 25,760 1,980,443 117,249 ($1,350,996.05) 1 ($0.54) 2
2023-09-29 4,746,421 4,752,446 6,026 124,128 806 489 19 25,789 1,996,079 117,315 ($370,192.34) 2 ($145.01) 5 8
2023-09-28 4,740,412 4,746,420 6,009 129,849 841 619 24 25,780 2,059,857 119,665 ($1,745,510.85) 1 6
2023-09-27 4,734,338 4,740,411 6,074 130,032 879 413 18 25,782 2,049,931 117,912 ($495,408.13) 1 ($1.79) 3 2
2023-09-26 4,728,957 4,734,337 5,381 118,494 849 474 63 25,783 1,860,623 105,255 ($300,725.22) 1 ($256.61) 2 2
2023-09-25 4,723,539 4,728,956 5,418 118,058 835 587 31 25,725 1,849,109 105,704 ($309,564.24) 2 ($126.65) 8 6
2023-09-24 4,718,054 4,723,538 5,485 120,897 774 474 34 25,712 1,907,205 106,863 ($279,151.96) 4 ($117.65) 2 ($73.86) 5 3
2023-09-23 4,712,390 4,718,053 5,664 124,870 740 467 9 25,689 1,949,386 110,223 ($74,557.36)
2023-09-22 4,706,641 4,712,389 5,749 126,179 741 465 6 25,715 1,969,410 111,351 ($168,237.55) 3 ($109.53) 2 ($83.77) 3 2
2023-09-21 4,700,944 4,706,640 5,697 123,721 756 400 14 25,729 1,943,467 110,395 ($233,163.80) 3 ($416.57) 2 11
2023-09-20 4,695,249 4,700,943 5,695 129,081 774 601 1,722 25,719 2,013,382 111,753 ($308,217.57) 4 ($939.85) 1 ($1,465.82) 8 5
2023-09-19 4,689,506 4,695,248 5,743 131,720 777 447 24 24,012 2,125,047 112,043 ($416,331.74) 2 ($15.38) 2
2023-09-18 4,683,588 4,689,505 5,918 134,834 734 463 19 25,701 2,360,410 112,574 ($165,305.50) 1 ($1.90) 1
2023-09-17 4,677,973 4,683,587 5,615 137,137 740 355 25 25,700 2,184,471 105,834 ($120,680.89) 2 ($3.49) 2
2023-09-16 4,672,328 4,677,972 5,645 132,174 760 535 29 25,682 2,214,120 103,838 ($266,628.16) 1 ($38.01) 1
2023-09-15 4,666,655 4,672,327 5,673 129,840 762 573 20 25,667 2,298,389 109,655 ($736,871.13) 1 ($4.58) 1
2023-09-14 4,661,086 4,666,654 5,569 126,932 724 406 48 25,683 2,157,536 105,628 ($861,605.42)
2023-09-13 4,655,475 4,661,085 5,611 125,357 745 433 23 25,648 2,151,839 107,287 ($374,707.67)
2023-09-12 4,649,901 4,655,474 5,574 124,186 827 438 26 25,645 2,007,303 109,226 ($681,278.29) 1 ($45.75) 1 2
2023-09-11 4,644,265 4,649,900 5,636 122,314 794 482 15 25,637 1,934,650 110,011 ($512,562.10) 2 ($113.71) 2 ($59.80) 2 2
2023-09-10 4,638,642 4,644,264 5,623 122,566 784 439 10 25,636 1,953,450 108,793 ($289,713.65) 1 ($131.49) 1 ($0.61) 1 1
2023-09-09 4,633,028 4,638,641 5,614 123,767 805 472 24 25,638 1,943,235 110,668 ($317,591.19) 1 ($22.16) 3 ($48.60) 1 3
2023-09-08 4,627,407 4,633,027 5,621 122,987 829 591 24 25,623 1,931,523 109,895 ($974,282.93) 1 ($0.10) 1 ($0.00998) 1 1
2023-09-07 4,621,752 4,627,406 5,655 124,445 787 561 25 25,615 1,968,194 111,457 ($3,018,858.04) 1 ($95.76) 1 ($8.40) 3 3
2023-09-06 4,616,061 4,621,751 5,691 124,208 755 310 16 25,599 2,021,197 109,433 ($146,252.49) 1 ($41.23) 1 ($9.57) 1 1
2023-09-05 4,610,357 4,616,060 5,704 123,613 816 566 16 25,596 1,972,816 109,708 ($192,929.84) 1 ($20.84) 1 ($5.78) 1 1
2023-09-04 4,604,682 4,610,356 5,675 128,787 808 408 22 25,615 2,016,671 110,920 ($595,838.80) 1 ($1.23) 4 ($135.19) 1 4
2023-09-03 4,599,028 4,604,681 5,654 127,901 807 432 24 25,608 2,117,471 111,076 ($462,777.89) 3 ($252.79) 3 ($240.12) 4 4
2023-09-02 4,593,403 4,599,027 5,625 125,914 843 617 44 25,604 2,046,449 109,788 ($853,656.33) 12 ($449.60) 5 ($314.94) 17 10
2023-09-01 4,590,102 4,593,402 3,301 78,650 757 398 14 25,587 1,199,707 62,916 ($178,084.48)

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)) = "2023-09-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)) = "2023-09-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)) = "2023-09-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)) = "2023-09-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)) = "2023-09-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)) = "2023-09-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)) = "2023-09-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)) = "2023-09-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)) = "2023-09-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)) = "2023-09-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)) = "2023-09-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)) = "2023-09-30" 
 group by logDT 
order by logDT

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