2023-01-31.md

Tanganika Summary (Daily)

Source: tanganika.polkaholic.io

Relay Chain: kusama Para ID: 2116

Daily Summary for Month ending in 2023-01-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-01-24	1,289,919	1,296,404	6,486	58					94,257	48
2023-01-23	1,283,096	1,289,918	6,823	91					99,435	73

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

Signed Extrinsics

Schema

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

Active Accounts

Schema

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

Passive Accounts

Schema

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

New Accounts

Schema

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

Events

Schema

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

Transfers:

Schema

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

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