Skip to content

Latest commit

 

History

History

2052-polkadot-parathread-2052

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
README.md
README.md
 
 

README.md

null Summary (Monthly)

Source: polkadot-parathread-2052.polkaholic.io

Relay Chain: polkadot Para ID: 2052

Month Start Block End Block # Blocks # Signed Extrinsics (total) # Active Accounts (avg) # Addresses with Balances (max) Issues
2023-11-01 to 2023-11-10 1,582,691 1,616,948 34,258 33 3 1,115 -
2023-10-01 to 2023-10-31 1,471,236 1,582,690 111,455 68 3 1,114 -
2023-09-01 to 2023-09-30 1,363,362 1,471,235 107,874 51 2 1,113 -
2023-08-01 to 2023-08-31 1,251,834 1,363,361 111,528 70 3 1,113 -
2023-07-01 to 2023-07-31 1,140,369 1,251,833 111,465 74 3 1,112 -
2023-06-01 to 2023-06-30 1,032,594 1,140,368 107,775 89 3 1,109 -
2023-05-01 to 2023-05-31 921,142 1,032,593 111,452 85 3 1,109 -
2023-04-01 to 2023-04-30 813,259 921,141 107,883 89 4 1,107 -
2023-03-01 to 2023-03-31 703,587 813,258 109,672 79 3 1,107 -
2023-02-01 to 2023-02-28 602,893 703,586 100,694 88 4 1,106 -
2023-01-01 to 2023-01-31 472,512 602,892 130,381 106 4 1,106 -
2022-12-01 to 2022-12-31 335,848 472,511 136,664 101 4 1,104 -
2022-11-01 to 2022-11-30 227,968 335,847 107,880 110 4 1,103 -
2022-10-01 to 2022-10-31 116,721 227,967 111,247 160 5 1,102 -
2022-09-01 to 2022-09-30 9,549 116,720 107,172 220 4 1,065 -
2022-08-29 to 2022-08-31 1 9,548 9,548 1 1 -

Tables:

  • Blocks: bigquery-public-data.crypto_polkadot.blocks2052 (date-partitioned by block_time) - Schema
  • Extrinsics: bigquery-public-data.crypto_polkadot.extrinsics2052 (date-partitioned by block_time) - Schema
  • Events: bigquery-public-data.crypto_polkadot.events2052 (date-partitioned by block_time) - Schema
  • Transfers: bigquery-public-data.crypto_polkadot.transfers2052 (date-partitioned by block_time) - Schema
  • Balances: bigquery-public-data.crypto_polkadot.balances2052 (date-partitioned by ts) - Schema
  • Active Accounts: bigquery-public-data.crypto_polkadot.accountsactive2052 (date-partitioned by ts) - Schema
  • Passive Accounts: bigquery-public-data.crypto_polkadot.accountspassive2052 (date-partitioned by ts) - Schema
  • New Accounts: bigquery-public-data.crypto_polkadot.accountsnew2052 (date-partitioned by ts) - Schema
  • Reaped Accounts: bigquery-public-data.crypto_polkadot.accountsreaped2052 (date-partitioned by ts) - Schema
  • Assets: bigquery-public-data.crypto_polkadot.assets (filter on 2052) - 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.blocks2052` 
group by monthDT 
order by monthDT desc

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