Skip to content

Latest commit

 

History

History
202 lines (155 loc) · 8.12 KB

2022-02-28.md

File metadata and controls

202 lines (155 loc) · 8.12 KB
Raw

Altair Summary (Daily)

Source: altair.polkaholic.io

Relay Chain: kusama Para ID: 2088

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 837,762 840,046 2,285 46 38 21,206 4,866 32 ($41,399.36)
2022-02-27 835,465 837,761 2,297 56 48 21,197 4,907 29 ($27,152.85)
2022-02-26 833,165 835,464 2,300 57 42 21,192 4,878 31 ($3,495.79)
2022-02-25 830,869 833,164 2,296 50 39 21,188 4,866 37 ($3,921.90)
2022-02-24 828,623 830,868 2,246 37 30 21,184 4,746 26 ($3,366.71)
2022-02-23 826,417 828,622 2,206 97 76 21,177 4,954 78 ($6,979.34)
2022-02-22 824,165 826,416 2,252 97 65 21,170 5,009 61 ($13,545.62)
2022-02-21 821,789 824,164 2,376 107 50 21,160 5,413 92 ($40,601.99)
2022-02-20 819,374 821,788 2,415 81 67 21,113 5,335 68 ($6,221.00)
2022-02-19 816,943 819,373 2,431 99 68 21,105 5,497 80 ($8,852.15)
2022-02-18 814,532 816,942 2,411 94 75 21,100 5,345 59 ($61,360.25)
2022-02-17 812,109 814,531 2,423 97 67 21,091 5,483 78 ($34,657.83)
2022-02-16 809,555 812,108 2,554 178 138 21,075 6,115 142 ($69,313.26)
2022-02-15 805,860 809,554 3,695 157 90 21,062 8,333 108 ($25,828.37)
2022-02-14 802,189 805,859 3,671 120 90 21,041 8,133 102 ($13,414.54)
2022-02-13 798,570 802,188 3,619 209 116 21,026 8,257 136 ($11,995.69)
2022-02-12 794,951 798,569 3,619 149 116 21,016 8,444 154 ($22,426.30)
2022-02-11 791,356 794,950 3,595 293 196 20,976 8,928 233 ($58,902.97)
2022-02-10 787,751 791,355 3,605 364 236 20,964 9,562 310 ($46,200.24)
2022-02-09 784,005 787,750 3,746 1,029 668 20,918 13,812 860 ($782,141.41)
2022-02-08 780,080 784,004 3,925 2,580 1,440 20,808 21,603 2,026 ($808,882.65)
2022-02-07 775,753 780,079 4,327 76 51 20,739 9,180 33 ($3,562.72)
2022-02-06 771,434 775,752 4,319 84 69 20,719 9,077 19 ($713.67)
2022-02-05 766,150 771,433 5,284 177 149 20,709 11,408 115 ($44,588.10)
2022-02-04 759,799 766,149 6,351 337 227 20,688 14,149 162 ($578,309.97)
2022-02-03 753,353 759,798 6,446 58 45 20,669 13,192 11 ($1,092,090.97)
2022-02-02 748,232 753,352 5,121 37 32 20,658 10,510 14 ($1,260.42)
2022-02-01 743,672 748,231 4,560 34 26 20,644 9,368 13 ($358.77)

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.blocks2088`  
 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.extrinsics2088`  
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.accountsactive2088` 
 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.accountspassive2088` 
 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.accountsnew2088` 
 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.balances2088` 
 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.events2088` 
 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.transfers2088` 
 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 = 2088 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 = 2088 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 = 2088 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 = 2088 and LAST_DAY(date(origination_ts)) = "2022-02-28" 
 group by logDT 
order by logDT

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