Skip to content

Latest commit

 

History

History
180 lines (133 loc) · 5.66 KB

2024-08-31.md

File metadata and controls

180 lines (133 loc) · 5.66 KB

hydradx Summary (Daily)

Source: hydradx.polkaholic.io

Relay Chain: polkadot Para ID: 2034

Daily Summary for Month ending in 2024-08-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-08-06
2024-08-05 5,699,569 5,706,684 7,116 10,021 37,404 263,077 41,856
2024-08-04 5,692,448 5,699,568 7,121 7,843 37,356 195,527 29,109
2024-08-03 5,685,335 5,692,447 7,113 5,588 37,279 160,758 24,511
2024-08-02 5,678,227 5,685,334 7,108 3,892 37,228 136,471 22,814
2024-08-01 5,671,100 5,678,226 7,127 3,724 37,207 136,937 22,652

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

Signed Extrinsics

Schema

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

Active Accounts

Schema

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

Passive Accounts

Schema

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

New Accounts

Schema

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

Events

Schema

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

Transfers:

Schema

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

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