Skip to content

Latest commit

 

History

History
192 lines (145 loc) · 6.84 KB

2024-05-31.md

File metadata and controls

192 lines (145 loc) · 6.84 KB
Raw

Turing Summary (Daily)

Source: turing.polkaholic.io

Relay Chain: kusama Para ID: 2114

Daily Summary for Month ending in 2024-05-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
2024-05-18 5,083,620 5,090,391 6,772 33 10,219 111,916 5
2024-05-17 5,076,833 5,083,619 6,787 35 10,219 120,934 9
2024-05-16 5,070,054 5,076,832 6,779 20 10,219 111,959 4
2024-05-15 5,063,259 5,070,053 6,795 21 10,219 112,010 7
2024-05-14 5,056,469 5,063,258 6,790 43 10,219 121,205 11
2024-05-13 5,049,668 5,056,468 6,801 10 10,217 112,069 4
2024-05-12 5,042,885 5,049,667 6,783 22 10,217 112,130 4
2024-05-11 5,036,115 5,042,884 6,770 15 10,217 120,945 5
2024-05-10 5,029,354 5,036,114 6,761 18 10,216 112,019 5
2024-05-09 5,022,591 5,029,353 6,763 17 10,215 112,129 6
2024-05-08 5,015,799 5,022,590 6,792 15 10,215 112,139 11
2024-05-07 5,009,034 5,015,798 6,765 22 10,214 121,089 9
2024-05-06 5,002,258 5,009,033 6,776 30 10,214 112,156 15
2024-05-05 4,995,475 5,002,257 6,783 20 10,225 112,115 5
2024-05-04 4,988,715 4,995,474 6,760 23 10,224 121,028 5
2024-05-03 4,981,935 4,988,714 6,780 20 10,224 112,161 4
2024-05-02 4,975,182 4,981,934 6,753 11 10,225 112,045 4
2024-05-01 4,968,459 4,975,181 6,723 26 10,224 112,138 5

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.blocks2114`  
 where LAST_DAY(date(block_time)) = "2024-05-31" 
 group by logDT 
 order by logDT

Signed Extrinsics

Schema

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

Active Accounts

Schema

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

Passive Accounts

Schema

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

New Accounts

Schema

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

Events

Schema

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

Transfers:

Schema

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

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