Skip to content

Latest commit

 

History

History
205 lines (158 loc) · 9.9 KB

2023-03-31.md

File metadata and controls

205 lines (158 loc) · 9.9 KB

Khala Summary (Daily)

Source: khala.polkaholic.io

Relay Chain: kusama Para ID: 2004

Daily Summary for Month ending in 2023-03-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
2023-03-31 3,603,385 3,609,884 6,500 145,614 1,423 788 53 24,657 2,321,720 130,211 ($552,944.51) 2 ($55.65) 2 ($55.62) 4 13
2023-03-30 3,596,844 3,603,384 6,541 147,852 1,409 635 33 24,625 2,371,644 130,480 ($524,235.45) 3 ($40.09) 1 ($148.09) 9 8
2023-03-29 3,590,296 3,596,843 6,548 149,308 1,400 567 27 24,623 2,379,998 130,262 ($356,931.93) 3 ($613.96) 4 ($328.11) 9 19
2023-03-28 3,583,724 3,590,295 6,572 154,216 1,416 731 25 24,609 2,434,063 130,456 ($590,524.77) 2 ($85.91) 4 ($153.13) 8 5
2023-03-27 3,577,122 3,583,723 6,602 156,098 1,444 754 45 24,598 2,451,744 131,657 ($541,795.64) 5 ($150.13) 6
2023-03-26 3,570,506 3,577,121 6,616 157,491 9 41 24,584 2,446,497 130,561 ($311,416.98) 3 ($32.27) 2 ($1.54) 4 3
2023-03-25 3,563,873 3,570,505 6,633 157,454 1,372 540 67 24,557 2,441,866 130,592 ($387,849.90) 5 ($796.85) 7 ($995.41) 12 14
2023-03-24 3,558,237 3,563,872 5,636 134,809 1,411 583 44 24,503 2,085,817 111,637 ($303,223.09) 3 ($164.18) 2 ($304.72) 4 4
2023-03-23 3,551,491 3,558,236 6,746 156,586 1,497 612 49 24,487 2,460,924 132,783 ($552,588.33) 5 ($239.66) 2 ($40.01) 7 4
2023-03-22 3,544,807 3,551,490 6,684 152,129 1,603 765 88 24,448 2,401,106 128,453 ($1,339,015.90) 4 ($196.83) 5 ($195.23) 4 5
2023-03-21 3,538,139 3,544,806 6,668 154,279 1,427 568 44 24,380 2,433,038 130,837 ($1,508,064.08) 6 ($136.49) 5 ($200.52) 8 11
2023-03-20 3,531,483 3,538,138 6,656 154,992 1,417 863 95 24,383 2,448,667 132,734 ($599,618.11) 3 ($95.97) 1 ($25.19) 3 3
2023-03-19 3,524,760 3,531,482 6,723 152,835 1,384 730 67 24,308 2,428,536 131,814 ($496,222.80) 4 ($140.69) 1 ($1.58) 4 1
2023-03-18 3,517,988 3,524,759 6,772 152,490 1,415 645 32 24,263 2,452,559 135,179 ($722,158.83) 3 ($83.53) 4 ($202.51) 5 7
2023-03-17 3,511,193 3,517,987 6,795 152,746 1,416 616 56 24,249 2,455,396 135,451 ($569,763.66) 3 ($109.53) 4 ($256.90) 3 9
2023-03-16 3,504,396 3,511,192 6,797 155,014 1,440 654 54 24,213 2,477,965 135,971 ($595,767.97) 8 ($385.36) 7 ($223.88) 10 13
2023-03-15 3,497,607 3,504,395 6,789 154,252 1,465 822 81 24,169 2,470,717 135,781 ($732,684.83) 8 ($408.29) 3 ($46.46) 20 6
2023-03-14 3,490,880 3,497,606 6,727 152,359 1,538 741 76 24,107 2,442,073 134,901 ($2,139,606.99) 5 ($321.21) 6 ($25.79) 13 11
2023-03-13 3,484,087 3,490,879 6,793 148,343 1,471 736 101 24,067 2,390,087 133,187 ($2,403,130.89) 2 ($48.57) 3 ($320.01) 5 6
2023-03-12 3,477,284 3,484,086 6,803 150,929 1,320 542 25 24,003 2,411,316 132,640 ($665,443.39) 7 ($320.44) 8 ($351.87) 10 8
2023-03-11 3,470,499 3,477,283 6,785 151,983 1,303 547 38 23,992 2,417,844 131,952 ($567,142.70) 5 ($121.94) 3 ($196.00) 6 8
2023-03-10 3,464,920 3,470,498 5,579 126,598 1,382 700 34 23,965 2,020,242 110,627 ($1,003,314.66) 5 ($186.55) 2 ($162.97) 16 11
2023-03-09 3,458,120 3,464,919 6,800 152,213 1,338 537 60 23,944 2,441,568 134,797 ($405,652.75) 10 ($478.11) 9 ($613.69) 24 13
2023-03-08 3,451,695 3,458,119 6,425 139,213 1,340 726 33 23,891 2,243,565 125,151 ($703,940.40) 4 ($34.52) 3 ($342.26) 7 4
2023-03-07 3,444,945 3,451,694 6,750 138,775 1,374 695 32 23,875 2,288,808 133,563 ($964,197.35) 5 ($155.74) 6 ($114.94) 14 11
2023-03-06 3,438,118 3,444,944 6,827 140,494 1,430 792 35 23,852 2,331,832 135,240 ($1,142,065.52) 5 ($65.98) 1 ($31.99) 16 1
2023-03-05 3,431,547 3,438,117 6,571 137,922 1,372 575 36 23,834 2,256,644 130,942 ($2,527,659.62) 12 ($1,003.62) 6 ($1,684.98) 30 10
2023-03-04 3,424,759 3,431,546 6,788 140,003 1,395 710 39 23,809 2,312,382 135,573 ($786,507.85) 4 ($101.96) 1 ($32.81) 7 4
2023-03-03 3,417,946 3,424,758 6,813 140,609 1,419 683 27 23,788 2,319,140 135,656 ($1,110,284.64) 4 ($42.28) 6 ($470.24) 13 12
2023-03-02 3,411,185 3,417,945 6,761 140,696 1,430 584 34 23,801 2,316,790 134,517 ($843,499.57) 5 ($618.97) 4 ($388.35) 18 8
2023-03-01 3,404,470 3,411,184 6,715 139,099 1,440 809 38 23,788 2,295,105 133,917 ($845,150.90) 8 ($3,564.33) 3 ($146.90) 11 8

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

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