Skip to content

Latest commit

 

History

History

2051-ajuna

README.md

ajuna Summary (Monthly)

Source: ajuna.polkaholic.io

Relay Chain: polkadot Para ID: 2051

Month Start Block End Block # Blocks # Signed Extrinsics (total) # Active Accounts (avg) # Addresses with Balances (max) Issues
2024-08-01 to 2024-08-06 4,621,335 4,678,153 56,819 127 981 -
2024-07-01 to 2024-07-31 4,166,569 4,564,330 397,762 184 838 - BROKEN
2024-06-01 to 2024-06-30 3,857,292 4,166,568 309,277 106 22 -
2024-05-01 to 2024-05-31 3,635,795 3,857,291 221,497 72 21 -
2024-04-01 to 2024-04-30 3,422,496 3,635,794 213,299 8 -
2024-03-01 to 2024-03-31 3,202,166 3,422,495 220,330 -
2024-02-01 to 2024-02-29 3,002,182 3,202,165 199,984 2 -
2024-01-01 to 2024-01-31 2,788,386 3,002,181 213,796 -
2023-12-01 to 2023-12-31 2,567,380 2,788,385 221,006 -
2023-11-01 to 2023-11-30 2,352,922 2,567,379 214,458 -
2023-10-01 to 2023-10-31 2,147,608 2,352,921 205,314 -
2023-09-01 to 2023-09-30 1,933,781 2,147,607 213,827 1 9 -
2023-08-01 to 2023-08-31 1,711,939 1,933,780 221,842 4 9 -
2023-07-01 to 2023-07-31 1,530,394 1,711,938 181,545 1 3 9 -
2023-06-01 to 2023-06-30 1,316,370 1,530,393 214,024 4 9 -
2023-05-01 to 2023-05-31 1,095,067 1,316,369 221,303 4 9 -
2023-04-01 to 2023-04-30 880,587 1,095,066 214,480 4 9 -
2023-03-01 to 2023-03-31 678,772 880,586 201,815 4 9 -
2023-02-01 to 2023-02-28 486,290 678,771 192,482 2 4 9 -
2023-01-01 to 2023-01-31 277,227 486,289 209,063 3 4 7 -
2022-12-01 to 2022-12-31 65,407 277,226 211,820 4 6 -
2022-11-21 to 2022-11-30 1 65,406 65,406 9 4 6 -

Tables:

  • Blocks: bigquery-public-data.crypto_polkadot.blocks2051 (date-partitioned by block_time) - Schema
  • Extrinsics: bigquery-public-data.crypto_polkadot.extrinsics2051 (date-partitioned by block_time) - Schema
  • Events: bigquery-public-data.crypto_polkadot.events2051 (date-partitioned by block_time) - Schema
  • Transfers: bigquery-public-data.crypto_polkadot.transfers2051 (date-partitioned by block_time) - Schema
  • Balances: bigquery-public-data.crypto_polkadot.balances2051 (date-partitioned by ts) - Schema
  • Active Accounts: bigquery-public-data.crypto_polkadot.accountsactive2051 (date-partitioned by ts) - Schema
  • Passive Accounts: bigquery-public-data.crypto_polkadot.accountspassive2051 (date-partitioned by ts) - Schema
  • New Accounts: bigquery-public-data.crypto_polkadot.accountsnew2051 (date-partitioned by ts) - Schema
  • Reaped Accounts: bigquery-public-data.crypto_polkadot.accountsreaped2051 (date-partitioned by ts) - Schema
  • Assets: bigquery-public-data.crypto_polkadot.assets (filter on 2051) - 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.blocks2051` 
group by monthDT 
order by monthDT desc

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