Skip to content

Latest commit

 

History

History
204 lines (157 loc) · 8.26 KB

2024-06-30.md

File metadata and controls

204 lines (157 loc) · 8.26 KB

hydradx Summary (Daily)

Source: hydradx.polkaholic.io

Relay Chain: polkadot Para ID: 2034

Daily Summary for Month ending in 2024-06-30

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-06-30 5,443,549 5,450,683 7,135 2,159 112,648 18,624
2024-06-29 5,436,402 5,443,548 7,147 2,009 106,106 16,820
2024-06-28 5,429,246 5,436,401 7,156 2,536 124,661 20,579
2024-06-27 5,422,150 5,429,245 7,096 3,082 138,605 23,016
2024-06-26 5,415,026 5,422,149 7,124 2,399 116,781 18,927
2024-06-25 5,407,930 5,415,025 7,096 2,806 128,782 21,154
2024-06-24 5,400,821 5,407,929 7,109 3,094 139,474 23,342
2024-06-23 5,393,712 5,400,820 7,109 2,069 36,076 108,993 17,575
2024-06-22 5,386,603 5,393,711 7,109 2,376 36,025 113,815 18,041
2024-06-21 5,379,469 5,386,602 7,134 2,892 35,973 125,113 20,180
2024-06-20 5,372,334 5,379,468 7,135 2,939 35,931 123,265 19,389
2024-06-19 5,365,211 5,372,333 7,123 3,174 35,882 138,259 22,630
2024-06-18 5,358,148 5,365,210 7,063 4,112 35,809 184,320 33,226
2024-06-17 5,351,056 5,358,147 7,092 3,043 35,747 129,940 20,814
2024-06-16 5,343,938 5,351,055 7,118 2,537 35,674 115,233 17,168
2024-06-15 5,336,813 5,343,937 7,125 2,409 35,545 108,289 15,715
2024-06-14 5,329,685 5,336,812 7,128 4,137 35,397 140,032 22,269
2024-06-13 5,322,538 5,329,684 7,147 3,134 35,348 118,999 18,283
2024-06-12 5,315,397 5,322,537 7,141 3,832 35,302 307,885 61,359
2024-06-11 5,308,250 5,315,396 7,147 5,017 35,227 236,226 41,827
2024-06-10 5,301,125 5,308,249 7,125 5,025 35,124 148,822 21,064
2024-06-09 5,294,302 5,301,124 6,823 1,362 35,038 80,170 12,675
2024-06-08 5,287,521 5,294,301 6,781 1,602 35,022 81,172 12,670
2024-06-07 5,280,726 5,287,520 6,795 2,246 35,013 91,736 14,033
2024-06-06 5,273,949 5,280,725 6,777 2,169 34,993 95,175 15,166
2024-06-05 5,267,162 5,273,948 6,787 2,387 34,963 98,264 15,651
2024-06-04 5,260,370 5,267,161 6,792 2,386 34,932 97,003 14,893
2024-06-03 5,253,570 5,260,369 6,800 1,506 34,913 78,720 12,102
2024-06-02 5,246,780 5,253,569 6,790 1,361 34,905 74,129 11,206
2024-06-01 5,239,984 5,246,779 6,796 1,071 34,652 68,550 10,281

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-06-30" 
 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-06-30" 
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-06-30" 
 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-06-30" 
 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-06-30" 
 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-06-30" 
 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-06-30" 
 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-06-30" 
 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-06-30" 
 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-06-30" 
 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-06-30" 
 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-06-30" 
 group by logDT 
order by logDT

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