Skip to content

Latest commit

 

History

History

2119-kusama-parachain-2119

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
README.md
README.md
 
 

README.md

kusama-parachain-2119 Summary (Monthly)

Source: kusama-parachain-2119.polkaholic.io

Relay Chain: kusama Para ID: 2119

Month Start Block End Block # Blocks # Signed Extrinsics (total) # Active Accounts (avg) # Addresses with Balances (max) Issues
2024-05-03 to 2024-05-19 4,490,317 4,603,583 113,267 4,484 -
2024-04-01 to 2024-04-09 4,266,441 4,327,175 60,724 1,153 - BROKEN (0.02%)
2024-03-01 to 2024-03-31 4,055,131 4,266,440 211,310 10,697 -
2024-02-01 to 2024-02-29 3,876,424 4,055,130 178,707 7,646 -
2024-01-01 to 2024-01-31 3,686,556 3,876,423 189,868 7,516 -
2023-12-01 to 2023-12-31 3,489,726 3,686,555 196,830 4,701 -
2023-11-01 to 2023-11-30 3,293,853 3,489,725 195,873 35,785 -
2023-10-01 to 2023-10-31 3,072,635 3,293,852 221,218 184,003 -
2023-09-01 to 2023-09-30 2,861,739 3,072,634 210,896 426,365 30 -
2023-08-01 to 2023-08-31 2,640,457 2,861,738 220,389 402,154 183 8,097 - 893 (0.40%)
2023-07-01 to 2023-07-31 2,442,581 2,640,456 197,876 126,583 83 7,743 -
2023-06-01 to 2023-06-30 2,228,459 2,442,580 214,122 2,801 28 7,346 -
2023-05-01 to 2023-05-31 2,019,171 2,228,458 209,288 2,802 22 6,685 -
2023-04-01 to 2023-04-30 1,814,496 2,019,170 204,675 6,492 38 6,391 -
2023-03-01 to 2023-03-31 1,595,381 1,814,495 218,845 12,422 79 6,180 - 270 (0.12%)
2023-02-01 to 2023-02-28 1,397,502 1,595,380 197,879 190,118 213 5,830 -
2023-01-01 to 2023-01-31 1,179,201 1,397,501 218,301 1,505 24 4,244 -
2022-12-01 to 2022-12-31 969,372 1,179,200 209,829 1,710 41 3,686 -
2022-11-01 to 2022-11-30 772,506 969,371 196,866 55 5 3,291 -
2022-10-01 to 2022-10-31 556,790 772,505 215,716 150 6 3,285 -
2022-09-01 to 2022-09-30 358,487 556,789 198,303 10 3 11 -
2022-08-01 to 2022-08-31 180,292 358,486 178,195 3 2 7 -
2022-07-01 to 2022-07-31 658 180,291 179,634 3 4 -
2022-06-30 to 2022-06-30 1 657 657 2 4 -

Tables:

  • Blocks: bigquery-public-data.crypto_kusama.blocks2119 (date-partitioned by block_time) - Schema
  • Extrinsics: bigquery-public-data.crypto_kusama.extrinsics2119 (date-partitioned by block_time) - Schema
  • Events: bigquery-public-data.crypto_kusama.events2119 (date-partitioned by block_time) - Schema
  • Transfers: bigquery-public-data.crypto_kusama.transfers2119 (date-partitioned by block_time) - Schema
  • Balances: bigquery-public-data.crypto_kusama.balances2119 (date-partitioned by ts) - Schema
  • Active Accounts: bigquery-public-data.crypto_kusama.accountsactive2119 (date-partitioned by ts) - Schema
  • Passive Accounts: bigquery-public-data.crypto_kusama.accountspassive2119 (date-partitioned by ts) - Schema
  • New Accounts: bigquery-public-data.crypto_kusama.accountsnew2119 (date-partitioned by ts) - Schema
  • Reaped Accounts: bigquery-public-data.crypto_kusama.accountsreaped2119 (date-partitioned by ts) - Schema
  • Assets: bigquery-public-data.crypto_kusama.assets (filter on 2119) - 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.blocks2119` 
group by monthDT 
order by monthDT desc

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