Skip to content

Latest commit

 

History

History

2123-kusama-parachain-2123

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
README.md
README.md
 
 

README.md

kusama-parachain-2123 Summary (Monthly)

Source: kusama-parachain-2123.polkaholic.io

Relay Chain: kusama Para ID: 2123

Month Start Block End Block # Blocks # Signed Extrinsics (total) # Active Accounts (avg) # Addresses with Balances (max) Issues
2023-09-01 to 2023-09-01 1,834,618 1,835,448 831 2 1,363 -
2023-08-05 to 2023-08-31 1,748,665 1,834,617 85,953 277 5 1,364 -
2023-07-01 to 2023-07-12 1,684,110 1,748,664 64,555 24 5 1,361 -
2023-06-01 to 2023-06-30 1,474,387 1,684,109 209,723 147 8 1,361 -
2023-05-01 to 2023-05-31 1,267,051 1,474,386 207,336 449 10 1,359 -
2023-04-01 to 2023-04-30 1,128,161 1,267,050 138,890 832 11 1,357 -
2023-03-01 to 2023-03-31 1,012,128 1,128,160 116,033 1,448 9 1,344 -
2023-02-01 to 2023-02-28 892,317 1,012,127 119,811 909 11 1,342 -
2023-01-01 to 2023-01-31 740,806 892,316 151,511 697 13 1,337 -
2022-12-01 to 2022-12-31 581,227 740,805 159,579 1,358 14 1,334 -
2022-11-01 to 2022-11-30 419,791 581,226 161,436 3,460 22 1,329 -
2022-10-01 to 2022-10-31 254,949 419,790 164,842 8,547 43 1,325 -
2022-09-01 to 2022-09-30 85,830 254,948 169,119 27,794 99 1,269 -
2022-08-15 to 2022-08-31 1 85,829 85,829 163 20 42 -

Tables:

  • Blocks: bigquery-public-data.crypto_kusama.blocks2123 (date-partitioned by block_time) - Schema
  • Extrinsics: bigquery-public-data.crypto_kusama.extrinsics2123 (date-partitioned by block_time) - Schema
  • Events: bigquery-public-data.crypto_kusama.events2123 (date-partitioned by block_time) - Schema
  • Transfers: bigquery-public-data.crypto_kusama.transfers2123 (date-partitioned by block_time) - Schema
  • Balances: bigquery-public-data.crypto_kusama.balances2123 (date-partitioned by ts) - Schema
  • Active Accounts: bigquery-public-data.crypto_kusama.accountsactive2123 (date-partitioned by ts) - Schema
  • Passive Accounts: bigquery-public-data.crypto_kusama.accountspassive2123 (date-partitioned by ts) - Schema
  • New Accounts: bigquery-public-data.crypto_kusama.accountsnew2123 (date-partitioned by ts) - Schema
  • Reaped Accounts: bigquery-public-data.crypto_kusama.accountsreaped2123 (date-partitioned by ts) - Schema
  • Assets: bigquery-public-data.crypto_kusama.assets (filter on 2123) - Schema
  • XCM Assets: bigquery-public-data.crypto_kusama.xcmassets (filter on para_id) - Schema
  • XCM Transfers: bigquery-public-data.crypto_kusama.xcmtransfers (filter on origination_para_id or destination_para_id, date-partitioned by origination_ts) - Schema
  • XCM Messages: bigquery-public-data.crypto_kusama.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_kusama.blocks2123` 
group by monthDT 
order by monthDT desc

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