Skip to content

Latest commit

 

History

History
186 lines (139 loc) · 6.08 KB

2024-03-31.md

File metadata and controls

186 lines (139 loc) · 6.08 KB

mythos Summary (Daily)

Source: mythos.polkaholic.io

Relay Chain: polkadot Para ID: 3369

Daily Summary for Month ending in 2024-03-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-03-31 75,106 82,253 7,148 2 14,300
2024-03-30 67,953 75,105 7,153 2 14,310
2024-03-29 60,823 67,952 7,130 2 14,264
2024-03-28 53,678 60,822 7,145 2 14,294
2024-03-27 46,536 53,677 7,142 2 14,288
2024-03-26 39,389 46,535 7,147 2 14,298
2024-03-25 32,255 39,388 7,134 2 14,272
2024-03-24 25,118 32,254 7,137 2 14,278
2024-03-23 17,967 25,117 7,151 2 14,306
2024-03-22 10,827 17,966 7,140 2 14,283
2024-03-21 3,684 10,826 7,143 2 14,290
2024-03-20 1 3,683 3,683 1 2 7,374

Sample Queries:

You can generate the above summary data using the following queries using the public dataset bigquery-public-data.crypto_polkadot in Google BigQuery:

Blocks

Schema

SELECT date(block_time) as logDT, MIN(number) startBN, MAX(number) endBN, COUNT(*) numBlocks 
 FROM `bigquery-public-data.crypto_polkadot.blocks3369`  
 where LAST_DAY(date(block_time)) = "2024-03-31" 
 group by logDT 
 order by logDT

Signed Extrinsics

Schema

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

Active Accounts

Schema

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

Passive Accounts

Schema

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

New Accounts

Schema

SELECT date(ts) as logDT, 
 COUNT(*) numNewAccounts 
 FROM `bigquery-public-data.crypto_polkadot.accountsnew3369` 
 where LAST_DAY(date(ts)) = "2024-03-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_polkadot.balances3369` 
 where LAST_DAY(date(ts)) = "2024-03-31" 
 group by logDT 
 order by logDT

Events

Schema

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

Transfers:

Schema

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

XCM Transfers In:

Schema

SELECT date(origination_ts) as logDT, 
 COUNT(*) numXCMTransfersOut 
 FROM `bigquery-public-data.crypto_polkadot.xcmtransfers` 
 where destination_para_id = 3369 and LAST_DAY(date(origination_ts)) = "2024-03-31" 
 group by logDT order by logDT

XCM Transfers Out:

Schema

SELECT date(origination_ts) as logDT, 
 COUNT(*) numXCMTransfersIn 
 FROM `bigquery-public-data.crypto_polkadot.xcmtransfers` 
 where origination_para_id = 3369 and LAST_DAY(date(origination_ts)) = "2024-03-31" 
 group by logDT 
order by logDT

XCM Messages In:

Schema

SELECT date(origination_ts) as logDT, 
 COUNT(*) numXCMMessagesOut 
 FROM `bigquery-public-data.crypto_polkadot.xcm` 
 where destination_para_id = 3369 and LAST_DAY(date(origination_ts)) = "2024-03-31" 
 group by logDT order by logDT

XCM Messages Out:

Schema

SELECT date(origination_ts) as logDT, 
 COUNT(*) numXCMMessagesIn 
 FROM `bigquery-public-data.crypto_polkadot.xcm` 
 where origination_para_id = 3369 and LAST_DAY(date(origination_ts)) = "2024-03-31" 
 group by logDT 
order by logDT

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