Skip to content

Latest commit

 

History

History
202 lines (155 loc) · 8.45 KB

2022-02-28.md

File metadata and controls

202 lines (155 loc) · 8.45 KB

Khala Summary (Daily)

Source: khala.polkaholic.io

Relay Chain: kusama Para ID: 2004

Daily Summary for Month ending in 2022-02-28

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-02-28 1,316,830 1,320,454 3,625 48,073 894 13,698 507,995 256 ($15,263.92)
2022-02-27 1,312,942 1,316,829 3,888 44,018 832 13,696 470,029 341 ($1,358,093.84)
2022-02-26 1,309,027 1,312,941 3,915 43,178 839 13,694 456,054 243 ($112,372.30)
2022-02-25 1,305,438 1,309,026 3,589 40,469 878 13,691 429,961 282 ($121,849.00)
2022-02-24 1,302,087 1,305,437 3,351 37,683 858 13,711 397,951 276 ($1,491,000.63)
2022-02-23 1,298,539 1,302,086 3,548 50,757 857 13,715 553,802 269 ($266,286.25)
2022-02-22 1,295,065 1,298,538 3,474 58,476 910 13,713 639,626 326 ($632,369.06)
2022-02-21 1,291,536 1,295,064 3,529 57,104 884 13,709 613,128 410 ($504,965.99)
2022-02-20 1,287,788 1,291,535 3,748 60,763 816 13,705 650,020 386 ($132,669.03)
2022-02-19 1,284,027 1,287,787 3,761 52,443 775 13,695 552,840 340 ($88,692.62)
2022-02-18 1,280,203 1,284,026 3,824 47,573 690 13,690 496,932 330 ($435,138.66)
2022-02-17 1,276,038 1,280,202 4,165 41,020 693 13,686 427,558 300 ($121,031.46)
2022-02-16 1,271,882 1,276,037 4,156 44,613 701 13,681 466,075 289 ($130,003.78) 2
2022-02-15 1,267,673 1,271,881 4,209 36,906 850 13,679 389,543 318 ($413,422.60)
2022-02-14 1,263,564 1,267,672 4,109 30,439 862 13,679 302,309 313 ($175,243.75) 4 6
2022-02-13 1,259,160 1,263,563 4,404 34,640 736 13,668 345,480 328 ($149,656.24)
2022-02-12 1,254,841 1,259,159 4,319 36,475 785 13,662 385,284 265 ($797,092.39)
2022-02-11 1,250,578 1,254,840 4,263 49,657 831 13,661 519,903 285 ($519,693.39)
2022-02-10 1,246,318 1,250,577 4,260 57,682 863 13,659 603,361 327 ($130,591.00)
2022-02-09 1,242,029 1,246,317 4,289 58,357 770 13,652 607,555 288 ($1,102,698.34)
2022-02-08 1,237,423 1,242,028 4,606 49,770 831 13,647 519,209 322 ($231,335.28)
2022-02-07 1,231,726 1,237,422 5,697 66,828 809 13,680 694,083 414 ($560,586.73)
2022-02-06 1,226,370 1,231,725 5,356 57,944 921 13,675 624,056 359 ($313,729.97)
2022-02-05 1,221,371 1,226,369 4,999 69,114 1,015 13,672 728,477 290 ($35,116.27)
2022-02-04 1,215,268 1,221,370 6,103 84,195 1,019 13,670 889,337 287 ($13,412.75)
2022-02-03 1,209,100 1,215,267 6,168 94,864 1,060 13,667 1,012,288 261 ($1,395.27)
2022-02-02 1,203,087 1,209,099 6,013 94,774 1,047 13,670 1,010,566 330 ($12,643.76)
2022-02-01 1,197,043 1,203,086 6,044 91,209 1,046 13,670 972,434 243 ($30,608.03)

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

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