Skip to content

Latest commit

 

History

History

2104-manta

README.md

manta Summary (Monthly)

Source: manta.polkaholic.io

Relay Chain: polkadot Para ID: 2104

Month Start Block End Block # Blocks # Signed Extrinsics (total) # Active Accounts (avg) # Addresses with Balances (max) Issues
2024-08-01 to 2024-08-06 3,519,918 3,554,170 34,253 2,851 24,108 -
2024-07-01 to 2024-07-31 3,306,511 3,519,917 213,407 15,774 24,066 -
2024-06-01 to 2024-06-30 3,071,265 3,306,510 235,246 28,816 24,073 -
2024-05-01 to 2024-05-31 2,853,352 3,071,264 217,913 30,886 23,906 -
2024-04-01 to 2024-04-30 2,647,954 2,853,351 205,398 34,623 23,332 -
2024-03-01 to 2024-03-31 2,441,069 2,647,953 206,885 50,156 22,269 -
2024-02-01 to 2024-02-29 2,237,304 2,441,068 203,765 54,226 20,298 -
2024-01-01 to 2024-01-31 2,016,763 2,237,303 220,541 69,861 17,227 -
2023-12-01 to 2023-12-31 1,795,327 2,016,762 221,436 45 4 33 -
2023-11-01 to 2023-11-30 1,580,497 1,795,326 214,830 1 5 28 -
2023-10-01 to 2023-10-31 1,360,281 1,580,496 220,216 1 5 27 -
2023-09-01 to 2023-09-30 1,148,469 1,360,280 211,812 15 5 28 -
2023-08-01 to 2023-08-31 926,801 1,148,468 221,668 102 6 26 -
2023-07-01 to 2023-07-31 708,303 926,800 218,498 206 5 23 -
2023-06-01 to 2023-06-30 498,028 708,302 210,275 45 1 12 -
2023-05-01 to 2023-05-31 281,525 498,027 216,503 21 9 -
2023-04-01 to 2023-04-30 70,511 281,524 211,014 7 9 -
2023-03-21 to 2023-03-31 1 70,510 70,510 9 -

Tables:

  • Blocks: bigquery-public-data.crypto_polkadot.blocks2104 (date-partitioned by block_time) - Schema
  • Extrinsics: bigquery-public-data.crypto_polkadot.extrinsics2104 (date-partitioned by block_time) - Schema
  • Events: bigquery-public-data.crypto_polkadot.events2104 (date-partitioned by block_time) - Schema
  • Transfers: bigquery-public-data.crypto_polkadot.transfers2104 (date-partitioned by block_time) - Schema
  • Balances: bigquery-public-data.crypto_polkadot.balances2104 (date-partitioned by ts) - Schema
  • Active Accounts: bigquery-public-data.crypto_polkadot.accountsactive2104 (date-partitioned by ts) - Schema
  • Passive Accounts: bigquery-public-data.crypto_polkadot.accountspassive2104 (date-partitioned by ts) - Schema
  • New Accounts: bigquery-public-data.crypto_polkadot.accountsnew2104 (date-partitioned by ts) - Schema
  • Reaped Accounts: bigquery-public-data.crypto_polkadot.accountsreaped2104 (date-partitioned by ts) - Schema
  • Assets: bigquery-public-data.crypto_polkadot.assets (filter on 2104) - 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.blocks2104` 
group by monthDT 
order by monthDT desc

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