Skip to content

Latest commit

 

History

History
204 lines (157 loc) · 8.53 KB

2022-06-30.md

File metadata and controls

204 lines (157 loc) · 8.53 KB
Raw

Altair Summary (Daily)

Source: altair.polkaholic.io

Relay Chain: kusama Para ID: 2088

Daily Summary for Month ending in 2022-06-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-06-30 1,149,924 1,154,654 4,731 27 25 22,135 9,589 16 ($1,867.08)
2022-06-29 1,145,197 1,149,923 4,727 28 25 22,129 9,581 6 ($377.58) 1 ($343.11) 1
2022-06-28 1,141,572 1,145,196 3,625 37 36 22,128 7,423 15 ($111.16)
2022-06-27 1,138,684 1,141,571 2,888 32 25 22,124 5,923 10 ($1,872.41)
2022-06-26 1,135,637 1,138,683 3,047 21 20 22,122 6,190 3 ($187.62) 1 ($62.55) 1 ($62.55) 1 1
2022-06-25 1,132,572 1,135,636 3,065 13 13 22,122 6,206 7 ($18.18) 1 ($5.52) 1
2022-06-24 1,129,492 1,132,571 3,080 33 31 22,121 6,314 8 ($14,473.76) 1 ($0.01) 1 ($14,418.38) 1 1
2022-06-23 1,126,444 1,129,491 3,048 49 37 22,119 6,316 9 ($12,718.51) 1 ($2.32) 1
2022-06-22 1,123,418 1,126,443 3,026 61 34 22,118 6,359 7 ($273.39) 4 ($53.13) 4
2022-06-21 1,120,422 1,123,417 2,996 61 43 22,115 6,299 19 ($1,397.73) 4 ($75.54) 4
2022-06-20 1,117,433 1,120,421 2,989 20 15 22,109 6,074 7 ($1,441.24) 1 ($0.22) 1
2022-06-19 1,114,502 1,117,432 2,931 24 20 22,109 5,969 11 ($525.99)
2022-06-18 1,111,505 1,114,501 2,997 17 19 22,105 6,085 8 ($311.78) 3 ($87.26) 3
2022-06-17 1,108,523 1,111,504 2,982 5 6 22,103 5,987 1 ($2.48)
2022-06-16 1,105,528 1,108,522 2,995 24 22 22,103 6,104 13 ($54,828.46) 1 ($5.05) 1
2022-06-15 1,102,571 1,105,527 2,957 21 19 22,098 6,006 7 ($4,591.07)
2022-06-14 1,099,566 1,102,570 3,005 28 22 22,097 6,139 10 ($4,430.12) 1 ($0.04) 1 ($0.04) 1 1
2022-06-13 1,096,628 1,099,565 2,938 45 28 22,094 6,086 17 ($13,830.71) 2 ($0.45) 2 ($0.47) 2 2
2022-06-12 1,093,683 1,096,627 2,945 26 21 22,094 6,007 8 ($18,211.63)
2022-06-11 1,090,728 1,093,682 2,955 26 22 22,092 6,028 17 ($2,147.32)
2022-06-10 1,087,728 1,090,727 3,000 30 20 22,090 6,160 10 ($358.28) 3 ($0.35) 6 ($0.58) 3 6
2022-06-09 1,084,754 1,087,727 2,974 23 22 22,087 6,049 8 ($1,685.37)
2022-06-08 1,081,809 1,084,753 2,945 29 22 22,085 6,025 13 ($13,161.05)
2022-06-07 1,078,885 1,081,808 2,924 41 28 22,084 6,027 21 ($15,550.70)
2022-06-06 1,075,902 1,078,884 2,983 40 31 22,080 6,136 12 ($3,631.77)
2022-06-05 1,072,940 1,075,901 2,962 27 22 22,079 6,049 11 ($100.47)
2022-06-04 1,069,938 1,072,939 3,002 33 20 22,078 6,191 11 ($406.41)
2022-06-03 1,066,980 1,069,937 2,958 39 27 22,075 6,092 14 ($17,872.90)
2022-06-02 1,063,983 1,066,979 2,997 73 54 22,072 6,340 22 ($1,007.62) 1
2022-06-01 1,061,018 1,063,982 2,965 41 28 22,068 6,139 23 ($3,378.75)

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-06-30" 
 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-06-30" 
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-06-30" 
 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-06-30" 
 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-06-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.balances2088` 
 where LAST_DAY(date(ts)) = "2022-06-30" 
 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-06-30" 
 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-06-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 = 2088 and LAST_DAY(date(origination_ts)) = "2022-06-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 = 2088 and LAST_DAY(date(origination_ts)) = "2022-06-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 = 2088 and LAST_DAY(date(origination_ts)) = "2022-06-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 = 2088 and LAST_DAY(date(origination_ts)) = "2022-06-30" 
 group by logDT 
order by logDT

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