Skip to content

Latest commit

 

History

History
205 lines (158 loc) · 8.18 KB

2023-07-31.md

File metadata and controls

205 lines (158 loc) · 8.18 KB
Raw

Litmus Summary (Daily)

Source: litmus.polkaholic.io

Relay Chain: kusama Para ID: 2106

Daily Summary for Month ending in 2023-07-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-07-31 3,159,109 3,166,280 7,172 3 6 1 13,905 14,391
2023-07-30 3,151,932 3,159,108 7,177 3 13,904 14,358
2023-07-29 3,144,758 3,151,931 7,174 1 4 1 1 13,904 14,361 1 ($6.99)
2023-07-28 3,137,587 3,144,757 7,171 1 4 13,903 14,378
2023-07-27 3,130,424 3,137,586 7,163 3 13,903 14,330
2023-07-26 3,123,258 3,130,423 7,166 3 13,903 14,339
2023-07-25 3,116,083 3,123,257 7,175 3 13,903 14,362
2023-07-24 3,108,917 3,116,082 7,166 3 13,903 14,724
2023-07-23 3,101,750 3,108,916 7,167 1 4 13,903 14,345
2023-07-22 3,094,580 3,101,749 7,170 3 13,903 14,344
2023-07-21 3,087,418 3,094,579 7,162 3 13,903 14,328
2023-07-20 3,080,246 3,087,417 7,172 3 13,903 14,348
2023-07-19 3,073,091 3,080,245 7,155 3 13,903 14,317
2023-07-18 3,065,934 3,073,090 7,157 1 4 13,903 14,325
2023-07-17 3,058,775 3,065,933 7,159 3 13,903 14,322
2023-07-16 3,051,622 3,058,774 7,153 2 5 1 1 13,903 14,632 2 ($7.19)
2023-07-15 3,044,465 3,051,621 7,157 1 4 13,902 14,325
2023-07-14 3,037,304 3,044,464 7,161 3 13,902 14,640
2023-07-13 3,030,147 3,037,303 7,157 3 13,902 14,318
2023-07-12 3,022,980 3,030,146 7,167 3 13,902 14,341
2023-07-11 3,015,818 3,022,979 7,162 3 13,902 14,328
2023-07-10 3,008,655 3,015,817 7,163 2 5 1 1 13,902 14,346 2 ($360.10)
2023-07-09 3,001,481 3,008,654 7,174 4 5 1 1 13,901 14,382 2 ($66.43)
2023-07-08 2,994,312 3,001,480 7,169 18 12 2 2 13,901 14,471 4 ($5.73)
2023-07-07 2,987,139 2,994,311 7,173 5 7 1 13,902 14,386 1 ($0.43) 1
2023-07-06 2,979,987 2,987,138 7,152 10 9 2 13,903 14,371 4 ($90.82)
2023-07-05 2,972,824 2,979,986 7,163 3 6 1 1 13,903 14,356 2 ($1.42)
2023-07-04 2,965,650 2,972,823 7,174 3 13,902 14,352
2023-07-03 2,958,479 2,965,649 7,171 2 5 1 1 13,902 14,588 2 ($7.61)
2023-07-02 2,951,311 2,958,478 7,168 1 4 1 1 13,901 14,350 1 ($6.97)
2023-07-01 2,944,152 2,951,310 7,159 7 8 3 2 13,901 14,381 5 ($41.74)

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.blocks2106`  
 where LAST_DAY(date(block_time)) = "2023-07-31" 
 group by logDT 
 order by logDT

Signed Extrinsics

Schema

SELECT date(block_time) as logDT, 
COUNT(*) numSignedExtrinsics 
FROM `bigquery-public-data.crypto_kusama.extrinsics2106`  
where signed and LAST_DAY(date(block_time)) = "2023-07-31" 
group by logDT 
order by logDT

Active Accounts

Schema

SELECT date(ts) as logDT, 
 COUNT(*) numActiveAccounts 
 FROM `bigquery-public-data.crypto_kusama.accountsactive2106` 
 where LAST_DAY(date(ts)) = "2023-07-31" 
 group by logDT 
 order by logDT

Passive Accounts

Schema

SELECT date(ts) as logDT, 
 COUNT(*) numPassiveAccounts 
 FROM `bigquery-public-data.crypto_kusama.accountspassive2106` 
 where LAST_DAY(date(ts)) = "2023-07-31" 
 group by logDT 
 order by logDT

New Accounts

Schema

SELECT date(ts) as logDT, 
 COUNT(*) numNewAccounts 
 FROM `bigquery-public-data.crypto_kusama.accountsnew2106` 
 where LAST_DAY(date(ts)) = "2023-07-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.balances2106` 
 where LAST_DAY(date(ts)) = "2023-07-31" 
 group by logDT 
 order by logDT

Events

Schema

SELECT date(block_time) as logDT, 
 COUNT(*) numEvents 
 FROM `bigquery-public-data.crypto_kusama.events2106` 
 where LAST_DAY(date(block_time)) = "2023-07-31" 
 group by logDT 
 order by logDT

Transfers:

Schema

SELECT date(block_time) as logDT, 
 COUNT(*) numEvents 
 FROM `bigquery-public-data.crypto_kusama.transfers2106` 
 where LAST_DAY(date(block_time)) = "2023-07-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 = 2106 and LAST_DAY(date(origination_ts)) = "2023-07-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 = 2106 and LAST_DAY(date(origination_ts)) = "2023-07-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 = 2106 and LAST_DAY(date(origination_ts)) = "2023-07-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 = 2106 and LAST_DAY(date(origination_ts)) = "2023-07-31" 
 group by logDT 
order by logDT

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