Skip to content

Latest commit

 

History

History

2236-kusama-parachain-2236

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
README.md
README.md
 
 

README.md

kusama-parachain-2236 Summary (Monthly)

Source: kusama-parachain-2236.polkaholic.io

Relay Chain: kusama Para ID: 2236

Month Start Block End Block # Blocks # Signed Extrinsics (total) # Active Accounts (avg) # Addresses with Balances (max) Issues
2024-05-01 to 2024-05-19 2,760,326 2,840,903 80,578 13 -
2024-04-01 to 2024-04-30 2,628,953 2,760,325 131,373 12 -
2024-03-01 to 2024-03-31 2,496,771 2,628,952 132,182 5 12 -
2024-02-01 to 2024-02-29 2,375,553 2,496,770 121,218 11 -
2024-01-01 to 2024-01-31 2,232,981 2,375,552 142,572 12 -
2023-12-01 to 2023-12-31 2,085,535 2,232,980 147,446 4 11 -
2023-11-15 to 2023-11-30 2,006,943 2,085,534 78,592 4 11 -
2023-10-01 to 2023-10-04 1,988,964 2,006,942 17,979 4 11 -
2023-09-01 to 2023-09-30 1,797,162 1,988,963 191,802 26 4 11 -
2023-08-01 to 2023-08-31 1,575,179 1,797,161 221,983 3 6 -
2023-07-01 to 2023-07-31 1,353,306 1,575,178 221,873 3 6 -
2023-06-01 to 2023-06-30 1,140,782 1,353,305 212,524 3 6 -
2023-05-01 to 2023-05-31 936,493 1,140,781 204,289 1 3 6 -
2023-04-01 to 2023-04-30 733,279 936,492 203,214 1 6 -
2023-03-01 to 2023-03-31 537,211 733,278 196,068 6 -
2023-02-01 to 2023-02-28 341,779 537,210 195,432 3 6 -
2023-01-01 to 2023-01-31 127,025 341,778 214,754 3 6 -
2022-12-13 to 2022-12-31 1 127,024 127,024 3 6 -

Tables:

  • Blocks: bigquery-public-data.crypto_kusama.blocks2236 (date-partitioned by block_time) - Schema
  • Extrinsics: bigquery-public-data.crypto_kusama.extrinsics2236 (date-partitioned by block_time) - Schema
  • Events: bigquery-public-data.crypto_kusama.events2236 (date-partitioned by block_time) - Schema
  • Transfers: bigquery-public-data.crypto_kusama.transfers2236 (date-partitioned by block_time) - Schema
  • Balances: bigquery-public-data.crypto_kusama.balances2236 (date-partitioned by ts) - Schema
  • Active Accounts: bigquery-public-data.crypto_kusama.accountsactive2236 (date-partitioned by ts) - Schema
  • Passive Accounts: bigquery-public-data.crypto_kusama.accountspassive2236 (date-partitioned by ts) - Schema
  • New Accounts: bigquery-public-data.crypto_kusama.accountsnew2236 (date-partitioned by ts) - Schema
  • Reaped Accounts: bigquery-public-data.crypto_kusama.accountsreaped2236 (date-partitioned by ts) - Schema
  • Assets: bigquery-public-data.crypto_kusama.assets (filter on 2236) - 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.blocks2236` 
group by monthDT 
order by monthDT desc

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