Skip to content

Latest commit

 

History

History
203 lines (156 loc) · 8.35 KB

2024-02-29.md

File metadata and controls

203 lines (156 loc) · 8.35 KB

hydradx Summary (Daily)

Source: hydradx.polkaholic.io

Relay Chain: polkadot Para ID: 2034

Daily Summary for Month ending in 2024-02-29

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-02-29 4,579,728 4,586,858 7,131 4,159 29,460 131,485 20,731
2024-02-28 4,572,613 4,579,727 7,115 3,268 29,392 122,986 20,134
2024-02-27 4,565,489 4,572,612 7,124 2,489 29,354 85,213 11,666
2024-02-26 4,558,357 4,565,488 7,132 1,965 29,307 79,652 11,133
2024-02-25 4,551,222 4,558,356 7,135 1,585 29,273 72,332 10,132
2024-02-24 4,544,102 4,551,221 7,120 1,830 29,239 82,382 12,221
2024-02-23 4,536,984 4,544,101 7,118 2,303 29,193 103,125 16,722
2024-02-22 4,529,851 4,536,983 7,133 2,315 29,148 97,408 15,268
2024-02-21 4,522,714 4,529,850 7,137 1,979 29,111 72,720 9,361
2024-02-20 4,515,600 4,522,713 7,114 2,297 29,061 78,341 10,172
2024-02-19 4,508,464 4,515,599 7,136 2,589 28,996 81,648 10,389
2024-02-18 4,501,338 4,508,463 7,126 2,055 28,933 68,422 7,993
2024-02-17 4,494,214 4,501,337 7,124 1,802 28,896 60,386 6,375
2024-02-16 4,487,088 4,494,213 7,126 1,965 28,860 77,955 10,617
2024-02-15 4,479,972 4,487,087 7,116 2,164 28,840 94,780 14,338
2024-02-14 4,472,853 4,479,971 7,119 2,409 28,804 97,779 14,566
2024-02-13 4,465,763 4,472,852 7,090 1,930 28,770 93,144 14,219
2024-02-12 4,458,645 4,465,762 7,118 1,859 28,738 88,056 13,110
2024-02-11 4,451,518 4,458,644 7,127 1,474 28,711 79,475 11,392
2024-02-10 4,444,402 4,451,517 7,116 1,622 28,688 80,281 11,335
2024-02-09 4,437,297 4,444,401 7,105 2,117 28,647 91,516 13,325
2024-02-08 4,430,169 4,437,296 7,128 2,251 28,616 76,710 9,519
2024-02-07 4,423,036 4,430,168 7,133 2,034 28,587 68,026 7,987
2024-02-06 4,415,908 4,423,035 7,128 1,772 28,553 64,849 7,539
2024-02-05 4,408,787 4,415,907 7,121 2,432 28,526 94,830 14,006 229 ($313,636.66) 123 ($32,479.42)
2024-02-04 4,401,652 4,408,786 7,135 2,588 28,472 103,819 15,964 290 ($748,618.40) 120 ($6,668.38)
2024-02-03 4,394,518 4,401,651 7,134 3,381 28,410 133,121 21,597 418 ($1,747,887.42) 266 ($265,563.86) 626 518
2024-02-02 4,387,383 4,394,517 7,135 4,056 28,333 191,838 35,072 473 ($2,354,574.74) 309 ($812,042.51) 698 642
2024-02-01 4,380,260 4,387,382 7,123 4,304 28,271 139,381 22,108 484 ($2,797,534.50) 342 ($565,430.81) 692 605

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-02-29" 
 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-02-29" 
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-02-29" 
 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-02-29" 
 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-02-29" 
 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-02-29" 
 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-02-29" 
 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-02-29" 
 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-02-29" 
 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-02-29" 
 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-02-29" 
 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-02-29" 
 group by logDT 
order by logDT

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