Skip to content

Latest commit

 

History

History

2011-sora_ksm

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
README.md
README.md
 
 

README.md

sora_ksm Summary (Monthly)

Source: sora_ksm.polkaholic.io

Relay Chain: kusama Para ID: 2011

Month Start Block End Block # Blocks # Signed Extrinsics (total) # Active Accounts (avg) # Addresses with Balances (max) Issues
2024-01-01 to 2024-01-22 3,283,501 3,434,463 150,960 1 - 3 (0.00%)
2023-12-01 to 2023-12-31 3,070,131 3,283,500 213,298 26 - 72 (0.03%)
2023-11-01 to 2023-11-30 2,858,374 3,070,130 211,751 48 - 6 (0.00%)
2023-10-01 to 2023-10-31 2,638,920 2,858,373 219,454 45 -
2023-09-01 to 2023-09-30 2,429,321 2,638,919 209,599 3 -
2023-08-01 to 2023-08-31 2,208,438 2,429,320 220,883 3 -
2023-07-01 to 2023-07-31 1,987,263 2,208,437 221,175 3 -
2023-06-01 to 2023-06-30 1,774,628 1,987,262 212,635 3 -
2023-05-01 to 2023-05-31 1,564,825 1,774,627 209,784 3 - 19 (0.01%)
2023-04-01 to 2023-04-30 1,359,068 1,564,824 205,757 1 3 -
2023-03-17 to 2023-03-31 1,255,193 1,359,067 82,752 3 - 21,123 (20.34%)
2023-01-01 to 2023-01-24 1,090,754 1,255,192 164,439 1 3 -
2022-12-01 to 2022-12-31 882,691 1,090,753 208,063 3 -
2022-11-01 to 2022-11-30 692,820 882,690 189,871 3 -
2022-10-01 to 2022-10-31 478,432 692,819 214,388 3 -
2022-09-01 to 2022-09-30 284,581 478,431 193,851 3 -
2022-08-01 to 2022-08-31 109,657 284,580 174,924 3 -
2022-07-12 to 2022-07-31 1 109,656 109,656 3 -

Tables:

  • Blocks: bigquery-public-data.crypto_kusama.blocks2011 (date-partitioned by block_time) - Schema
  • Extrinsics: bigquery-public-data.crypto_kusama.extrinsics2011 (date-partitioned by block_time) - Schema
  • Events: bigquery-public-data.crypto_kusama.events2011 (date-partitioned by block_time) - Schema
  • Transfers: bigquery-public-data.crypto_kusama.transfers2011 (date-partitioned by block_time) - Schema
  • Balances: bigquery-public-data.crypto_kusama.balances2011 (date-partitioned by ts) - Schema
  • Active Accounts: bigquery-public-data.crypto_kusama.accountsactive2011 (date-partitioned by ts) - Schema
  • Passive Accounts: bigquery-public-data.crypto_kusama.accountspassive2011 (date-partitioned by ts) - Schema
  • New Accounts: bigquery-public-data.crypto_kusama.accountsnew2011 (date-partitioned by ts) - Schema
  • Reaped Accounts: bigquery-public-data.crypto_kusama.accountsreaped2011 (date-partitioned by ts) - Schema
  • Assets: bigquery-public-data.crypto_kusama.assets (filter on 2011) - 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.blocks2011` 
group by monthDT 
order by monthDT desc

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