Skip to content

Latest commit

 

History

History
63 lines (53 loc) · 5.99 KB

README.md

File metadata and controls

63 lines (53 loc) · 5.99 KB

kusama-parathread-2124 Summary (Monthly)

Source: kusama-parathread-2124.polkaholic.io

Relay Chain: kusama Para ID: 2124

Month Start Block End Block # Blocks # Signed Extrinsics (total) # Active Accounts (avg) # Addresses with Balances (max) Issues
2024-05-01 to 2024-05-19 3,772,052 3,868,065 96,014 77,174 2,738 -
2024-04-01 to 2024-04-30 3,610,642 3,772,051 161,410 131,551 2,738 -
2024-03-01 to 2024-03-31 3,446,765 3,610,641 163,877 115,261 2,728 -
2024-02-01 to 2024-02-29 3,275,394 3,446,764 171,371 102,115 2,726 -
2024-01-01 to 2024-01-31 3,067,321 3,275,393 208,073 162,385 2,720 -
2023-12-01 to 2023-12-31 2,866,383 3,067,320 200,938 189,325 24 2,637 -
2023-11-01 to 2023-11-30 2,692,175 2,866,382 174,208 127,884 29 2,627 -
2023-10-01 to 2023-10-31 2,510,392 2,692,174 181,783 127,031 25 2,620 -
2023-09-01 to 2023-09-30 2,352,545 2,510,391 157,847 86,466 31 2,610 -
2023-08-01 to 2023-08-31 2,177,875 2,352,544 174,670 112,355 27 975 -
2023-07-01 to 2023-07-31 1,977,695 2,177,874 200,180 126,326 29 972 -
2023-06-01 to 2023-06-30 1,783,999 1,977,694 193,696 130,129 29 971 -
2023-05-01 to 2023-05-31 1,582,230 1,783,998 201,769 131,449 32 968 -
2023-04-01 to 2023-04-30 1,382,337 1,582,229 199,893 125,806 34 967 -
2023-03-01 to 2023-03-31 1,166,960 1,382,336 215,377 42,248 36 953 -
2023-02-01 to 2023-02-28 972,507 1,166,959 194,453 1,016 30 923 -
2023-01-01 to 2023-01-31 757,812 972,506 214,695 788 25 727 -
2022-12-01 to 2022-12-31 561,962 757,811 195,850 1,082 25 727 -
2022-11-01 to 2022-11-30 379,402 561,961 182,560 587 19 709 -
2022-10-01 to 2022-10-31 197,201 379,401 182,201 88 10 674 -
2022-09-01 to 2022-09-30 27,839 197,200 169,362 76 9 674 -
2022-08-11 to 2022-08-31 1 27,838 27,838 2 6 -

Tables:

  • Blocks: bigquery-public-data.crypto_kusama.blocks2124 (date-partitioned by block_time) - Schema
  • Extrinsics: bigquery-public-data.crypto_kusama.extrinsics2124 (date-partitioned by block_time) - Schema
  • Events: bigquery-public-data.crypto_kusama.events2124 (date-partitioned by block_time) - Schema
  • Transfers: bigquery-public-data.crypto_kusama.transfers2124 (date-partitioned by block_time) - Schema
  • Balances: bigquery-public-data.crypto_kusama.balances2124 (date-partitioned by ts) - Schema
  • Active Accounts: bigquery-public-data.crypto_kusama.accountsactive2124 (date-partitioned by ts) - Schema
  • Passive Accounts: bigquery-public-data.crypto_kusama.accountspassive2124 (date-partitioned by ts) - Schema
  • New Accounts: bigquery-public-data.crypto_kusama.accountsnew2124 (date-partitioned by ts) - Schema
  • Reaped Accounts: bigquery-public-data.crypto_kusama.accountsreaped2124 (date-partitioned by ts) - Schema
  • Assets: bigquery-public-data.crypto_kusama.assets (filter on 2124) - 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.blocks2124` 
group by monthDT 
order by monthDT desc

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