Skip to content

Latest commit

 

History

History

2116-tanganika

README.md

tanganika Summary (Monthly)

Source: tanganika.polkaholic.io

Relay Chain: kusama Para ID: 2116

Month Start Block End Block # Blocks # Signed Extrinsics (total) # Active Accounts (avg) # Addresses with Balances (max) Issues
2023-05-01 to 2023-05-30 1,956,317 2,161,094 204,778 1,333 2 3,888 -
2023-04-01 to 2023-04-30 1,750,822 1,956,316 205,495 3,170 3 3,885 -
2023-03-01 to 2023-03-31 1,542,640 1,750,821 208,105 2,925 3,623 - 77 (0.04%)
2023-02-08 to 2023-02-28 1,401,932 1,542,639 140,708 1,922 3 -
2023-01-23 to 2023-01-24 1,283,096 1,296,404 13,309 149 - BROKEN
2022-12-01 to 2022-12-13 935,791 1,009,889 74,036 1,090 34 3,213 - BROKEN (0.09%)
2022-11-01 to 2022-11-30 770,800 935,790 162,603 2,508 13 3,057 - 2,388 (1.45%)
2022-10-01 to 2022-10-31 557,446 770,799 213,354 2,405 39 3,033 -
2022-09-01 to 2022-09-30 363,896 557,445 193,550 1,421 31 2,749 -
2022-08-01 to 2022-08-31 201,235 363,895 162,661 1,024 24 2,617 -
2022-07-01 to 2022-07-31 22,739 201,234 178,496 114 10 2,473 -
2022-06-27 to 2022-06-30 1 22,738 22,738 22 8 2,470 -

Tables:

  • Blocks: bigquery-public-data.crypto_kusama.blocks2116 (date-partitioned by block_time) - Schema
  • Extrinsics: bigquery-public-data.crypto_kusama.extrinsics2116 (date-partitioned by block_time) - Schema
  • Events: bigquery-public-data.crypto_kusama.events2116 (date-partitioned by block_time) - Schema
  • Transfers: bigquery-public-data.crypto_kusama.transfers2116 (date-partitioned by block_time) - Schema
  • Balances: bigquery-public-data.crypto_kusama.balances2116 (date-partitioned by ts) - Schema
  • Active Accounts: bigquery-public-data.crypto_kusama.accountsactive2116 (date-partitioned by ts) - Schema
  • Passive Accounts: bigquery-public-data.crypto_kusama.accountspassive2116 (date-partitioned by ts) - Schema
  • New Accounts: bigquery-public-data.crypto_kusama.accountsnew2116 (date-partitioned by ts) - Schema
  • Reaped Accounts: bigquery-public-data.crypto_kusama.accountsreaped2116 (date-partitioned by ts) - Schema
  • Assets: bigquery-public-data.crypto_kusama.assets (filter on 2116) - 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.blocks2116` 
group by monthDT 
order by monthDT desc

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