Skip to content

Latest commit

 

History

History
71 lines (61 loc) · 6.78 KB

README.md

File metadata and controls

71 lines (61 loc) · 6.78 KB

hydradx Summary (Monthly)

Source: hydradx.polkaholic.io

Relay Chain: polkadot Para ID: 2034

Month Start Block End Block # Blocks # Signed Extrinsics (total) # Active Accounts (avg) # Addresses with Balances (max) Issues
2024-08-01 to 2024-08-06 5,671,100 5,706,684 35,585 31,068 37,404 -
2024-07-01 to 2024-07-31 5,450,684 5,671,099 220,416 73,041 37,177 -
2024-06-01 to 2024-06-30 5,239,984 5,450,683 210,700 80,871 36,076 -
2024-05-01 to 2024-05-31 5,019,592 5,239,983 220,392 73,724 34,636 -
2024-04-01 to 2024-04-30 4,806,374 5,019,591 213,218 91,414 33,996 -
2024-03-01 to 2024-03-31 4,586,859 4,806,373 219,515 101,841 31,744 -
2024-02-01 to 2024-02-29 4,380,260 4,586,858 206,599 68,994 29,460 -
2024-01-01 to 2024-01-31 4,161,953 4,380,259 218,307 89,556 28,219 -
2023-12-01 to 2023-12-31 3,944,652 4,161,952 217,301 61,946 262 26,428 -
2023-11-01 to 2023-11-30 3,733,650 3,944,651 211,002 29,488 201 25,203 -
2023-10-01 to 2023-10-31 3,515,832 3,733,649 217,818 21,082 164 24,693 -
2023-09-01 to 2023-09-30 3,305,404 3,515,831 210,428 22,235 201 24,486 -
2023-08-01 to 2023-08-31 3,088,436 3,305,403 216,968 17,088 106 24,235 -
2023-07-01 to 2023-07-31 2,874,242 3,088,435 214,194 14,069 103 24,061 -
2023-06-01 to 2023-06-30 2,667,533 2,874,241 206,709 11,746 107 23,872 -
2023-05-01 to 2023-05-31 2,455,370 2,667,532 212,163 8,853 85 23,712 -
2023-04-01 to 2023-04-30 2,252,045 2,455,369 203,325 6,845 82 23,570 -
2023-03-01 to 2023-03-31 2,047,177 2,252,044 204,868 8,120 89 23,413 -
2023-02-01 to 2023-02-28 1,868,702 2,047,176 178,475 11,712 128 23,305 -
2023-01-01 to 2023-01-31 1,672,353 1,868,701 196,349 33,155 222 23,185 -
2022-12-01 to 2022-12-31 1,483,335 1,672,352 189,018 1,135 44 22,525 -
2022-11-01 to 2022-11-30 1,326,016 1,483,334 157,319 1,154 43 22,404 -
2022-10-01 to 2022-10-31 1,158,699 1,326,015 167,317 309 31 21,139 -
2022-09-01 to 2022-09-30 997,422 1,158,698 161,277 198 29 21,131 -
2022-08-01 to 2022-08-31 829,196 997,421 168,226 241 30 21,125 -
2022-07-01 to 2022-07-31 658,260 829,195 170,936 508 35 21,117 -
2022-06-01 to 2022-06-30 475,506 658,259 182,754 5 25 27 -
2022-05-01 to 2022-05-31 288,657 475,505 186,849 7 24 27 -
2022-04-01 to 2022-04-30 99,601 288,656 189,056 28 4 27 -
2022-03-12 to 2022-03-31 1 99,600 99,600 30 12 23 -

Tables:

  • Blocks: bigquery-public-data.crypto_polkadot.blocks2034 (date-partitioned by block_time) - Schema
  • Extrinsics: bigquery-public-data.crypto_polkadot.extrinsics2034 (date-partitioned by block_time) - Schema
  • Events: bigquery-public-data.crypto_polkadot.events2034 (date-partitioned by block_time) - Schema
  • Transfers: bigquery-public-data.crypto_polkadot.transfers2034 (date-partitioned by block_time) - Schema
  • Balances: bigquery-public-data.crypto_polkadot.balances2034 (date-partitioned by ts) - Schema
  • Active Accounts: bigquery-public-data.crypto_polkadot.accountsactive2034 (date-partitioned by ts) - Schema
  • Passive Accounts: bigquery-public-data.crypto_polkadot.accountspassive2034 (date-partitioned by ts) - Schema
  • New Accounts: bigquery-public-data.crypto_polkadot.accountsnew2034 (date-partitioned by ts) - Schema
  • Reaped Accounts: bigquery-public-data.crypto_polkadot.accountsreaped2034 (date-partitioned by ts) - Schema
  • Assets: bigquery-public-data.crypto_polkadot.assets (filter on 2034) - Schema
  • XCM Assets: bigquery-public-data.crypto_polkadot.xcmassets (filter on para_id) - Schema
  • XCM Transfers: bigquery-public-data.crypto_polkadot.xcmtransfers (filter on origination_para_id or destination_para_id, date-partitioned by origination_ts) - Schema
  • XCM Messages: bigquery-public-data.crypto_polkadot.xcm (filter on origination_para_id or destination_para_id, date-partitioned by origination_ts) - Schema

# Blocks

SELECT LAST_DAY( date(block_time)) as monthDT,
  Min(date(block_time)) startBN, max(date(block_time)) endBN, 
 min(number) minBN, max(number) maxBN, 
 count(*) numBlocks, max(number)-min(number)+1-count(*) as numBlocks_missing 
FROM `bigquery-public-data.crypto_polkadot.blocks2034` 
group by monthDT 
order by monthDT desc

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