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 | - |
- Blocks:
bigquery-public-data.crypto_kusama.blocks2116
(date-partitioned byblock_time
) - Schema - Extrinsics:
bigquery-public-data.crypto_kusama.extrinsics2116
(date-partitioned byblock_time
) - Schema - Events:
bigquery-public-data.crypto_kusama.events2116
(date-partitioned byblock_time
) - Schema - Transfers:
bigquery-public-data.crypto_kusama.transfers2116
(date-partitioned byblock_time
) - Schema - Balances:
bigquery-public-data.crypto_kusama.balances2116
(date-partitioned byts
) - Schema - Active Accounts:
bigquery-public-data.crypto_kusama.accountsactive2116
(date-partitioned byts
) - Schema - Passive Accounts:
bigquery-public-data.crypto_kusama.accountspassive2116
(date-partitioned byts
) - Schema - New Accounts:
bigquery-public-data.crypto_kusama.accountsnew2116
(date-partitioned byts
) - Schema - Reaped Accounts:
bigquery-public-data.crypto_kusama.accountsreaped2116
(date-partitioned byts
) - Schema - Assets:
bigquery-public-data.crypto_kusama.assets
(filter on2116
) - Schema - XCM Assets:
bigquery-public-data.crypto_kusama.xcmassets
(filter onpara_id
) - Schema - XCM Transfers:
bigquery-public-data.crypto_kusama.xcmtransfers
(filter onorigination_para_id
ordestination_para_id
, date-partitioned byorigination_ts
) - Schema - XCM Messages:
bigquery-public-data.crypto_kusama.xcm
(filter onorigination_para_id
ordestination_para_id
, date-partitioned byorigination_ts
) - Schema
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