Skip to content

Latest commit

 

History

History
204 lines (157 loc) · 9.59 KB

2022-09-30.md

File metadata and controls

204 lines (157 loc) · 9.59 KB

Khala Summary (Daily)

Source: khala.polkaholic.io

Relay Chain: kusama Para ID: 2004

Daily Summary for Month ending in 2022-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
2022-09-30 2,419,594 2,426,071 6,478 128,864 1,859 17,683 1,713,465 3,085 ($538,033.45) 12 ($632.89) 10 ($394.91) 12 10
2022-09-29 2,413,050 2,419,593 6,544 123,193 1,748 17,673 1,641,931 2,437 ($285,537.25) 6 ($438.61) 15 ($588.75) 7 18
2022-09-28 2,406,647 2,413,049 6,403 128,189 1,734 17,654 1,702,027 2,567 ($112,998.59) 13 ($721.21) 11 ($468.55) 13 13
2022-09-27 2,400,205 2,406,646 6,442 129,612 1,717 17,635 1,719,091 2,483 ($162,721.57) 14 ($1,182.92) 20 ($1,755.02) 17 22
2022-09-26 2,393,745 2,400,204 6,460 120,092 1,779 17,622 1,592,407 2,264 ($161,510.63) 29 ($623.18) 30 ($757.86) 33 31
2022-09-25 2,387,333 2,393,744 6,412 127,330 1,654 17,615 1,688,842 2,463 ($528,010.49) 6 ($270.78) 11 ($734.10) 8 13
2022-09-24 2,380,939 2,387,332 6,394 127,157 1,656 17,602 1,678,872 2,251 ($82,591.58) 8 ($328.51) 7 ($316.63) 13 7
2022-09-23 2,374,554 2,380,938 6,385 128,455 1,717 17,601 1,706,762 2,461 ($155,931.03) 11 ($882.05) 16 ($1,238.58) 17 20
2022-09-22 2,368,232 2,374,553 6,322 125,633 1,715 17,595 1,667,843 2,459 ($116,638.23) 8 ($640.01) 14 ($7,849.52) 8 14
2022-09-21 2,361,891 2,368,231 6,341 121,914 1,713 17,579 1,618,478 2,415 ($77,697.98) 6 ($160.55) 14 ($1,457.84) 6 14
2022-09-20 2,355,664 2,361,890 6,227 120,970 1,745 17,557 1,606,007 2,473 ($268,752.31) 9 ($449.86) 15 ($655.33) 11 17
2022-09-19 2,349,494 2,355,663 6,170 123,536 1,760 17,532 1,650,582 2,920 ($220,355.65) 9 ($1,271.57) 13 ($1,402.11) 9 22
2022-09-18 2,343,275 2,349,493 6,219 125,142 1,694 17,503 1,665,561 2,403 ($106,076.30) 7 ($2,877.57) 6 ($368.54) 7 9
2022-09-17 2,337,035 2,343,274 6,240 125,416 1,703 17,484 1,669,531 2,240 ($67,786.79) 4 ($1,011.88) 2 ($228.10) 4 4
2022-09-16 2,330,876 2,337,034 6,159 124,932 1,670 17,465 1,661,817 2,598 ($116,659.33) 2 ($227.40) 2 ($144.17) 2 6
2022-09-15 2,324,876 2,330,875 6,000 125,662 1,715 17,452 1,672,400 2,684 ($431,407.15) 4 ($1,188.27) 7 ($1,004.29) 5 7
2022-09-14 2,318,853 2,324,875 6,023 126,609 1,675 17,432 1,676,595 2,474 ($94,915.46) 2 ($180.59) 5 ($231.77) 4 11
2022-09-13 2,313,034 2,318,852 5,819 119,364 1,707 17,421 1,574,372 2,571 ($235,729.37) 1 ($0.39) 4 ($289.62) 2 4
2022-09-12 2,307,326 2,313,033 5,708 118,187 1,699 17,402 1,575,588 2,498 ($203,210.50) 4 ($859.65) 7 ($1,054.76) 6 7
2022-09-11 2,301,555 2,307,325 5,771 120,796 1,687 17,390 1,601,553 2,247 ($154,937.20) 6 ($525.08) 6 ($259.77) 6 6
2022-09-10 2,295,760 2,301,554 5,795 118,281 1,673 17,381 1,571,652 2,355 ($194,820.05) 5 ($53.15) 8 ($1,222.40) 6 8
2022-09-09 2,289,922 2,295,759 5,838 117,482 1,719 17,375 1,559,702 2,252 ($156,362.17) 7 ($203.47) 6 ($354.16) 7 6
2022-09-08 2,284,089 2,289,921 5,833 115,914 1,707 17,358 1,536,021 2,243 ($810,293.64) 4 ($1,135.31) 5 ($1,068.72) 7 5
2022-09-07 2,278,282 2,284,088 5,807 115,728 1,601 17,342 1,524,970 2,066 ($266,844.26) 6 ($305.86) 8 ($473.29) 8 10
2022-09-06 2,272,288 2,278,281 5,994 120,578 1,655 17,325 1,591,684 2,464 ($297,314.72) 1 ($179.72) 5 ($387.51) 3 10
2022-09-05 2,266,373 2,272,287 5,915 120,005 1,787 17,319 1,576,821 2,549 ($467,189.02) 5 ($836.37) 7 ($672.46) 5 9
2022-09-04 2,260,503 2,266,372 5,870 119,719 1,651 17,302 1,589,769 1,960 ($119,221.35) 1 ($184.73) 4 ($180.17) 1 7
2022-09-03 2,254,566 2,260,502 5,937 120,338 1,611 17,294 1,600,123 1,871 ($97,960.96) 2 ($216.35) 4 ($139.85) 3 4
2022-09-02 2,248,650 2,254,565 5,916 119,926 1,707 17,285 1,595,605 2,265 ($202,540.51) 9 ($339.17) 14 ($189.51) 15 14
2022-09-01 2,242,788 2,248,649 5,862 117,693 1,770 17,279 1,566,440 2,642 ($693,381.86) 5 ($258.24) 9 ($437.68) 7 9

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

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