Skip to content

Latest commit

 

History

History

2004-khala

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
2021-07-31.md
2021-07-31.md
 
 
2021-08-31.md
2021-08-31.md
 
 
2021-09-30.md
2021-09-30.md
 
 
2021-10-31.md
2021-10-31.md
 
 
2021-11-30.md
2021-11-30.md
 
 
2021-12-31.md
2021-12-31.md
 
 
2022-01-31.md
2022-01-31.md
 
 
2022-02-28.md
2022-02-28.md
 
 
2022-03-31.md
2022-03-31.md
 
 
2022-04-30.md
2022-04-30.md
 
 
2022-05-31.md
2022-05-31.md
 
 
2022-06-30.md
2022-06-30.md
 
 
2022-07-31.md
2022-07-31.md
 
 
2022-08-31.md
2022-08-31.md
 
 
2022-09-30.md
2022-09-30.md
 
 
2022-10-31.md
2022-10-31.md
 
 
2022-11-30.md
2022-11-30.md
 
 
2022-12-31.md
2022-12-31.md
 
 
2023-01-31.md
2023-01-31.md
 
 
2023-02-28.md
2023-02-28.md
 
 
2023-03-31.md
2023-03-31.md
 
 
2023-04-30.md
2023-04-30.md
 
 
2023-05-31.md
2023-05-31.md
 
 
2023-06-30.md
2023-06-30.md
 
 
2023-07-31.md
2023-07-31.md
 
 
2023-08-31.md
2023-08-31.md
 
 
2023-09-30.md
2023-09-30.md
 
 
2023-10-31.md
2023-10-31.md
 
 
2023-11-30.md
2023-11-30.md
 
 
2023-12-31.md
2023-12-31.md
 
 
2024-01-31.md
2024-01-31.md
 
 
2024-02-29.md
2024-02-29.md
 
 
2024-03-31.md
2024-03-31.md
 
 
2024-04-30.md
2024-04-30.md
 
 
2024-05-31.md
2024-05-31.md
 
 
README.md
README.md
 
 

README.md

khala Summary (Monthly)

Source: khala.polkaholic.io

Relay Chain: kusama Para ID: 2004

Month Start Block End Block # Blocks # Signed Extrinsics (total) # Active Accounts (avg) # Addresses with Balances (max) Issues
2024-05-03 to 2024-05-19 6,146,383 6,257,475 111,093 2,310,117 27,579 -
2024-04-01 to 2024-04-03 5,927,779 5,946,355 18,577 485,057 27,216 - BROKEN
2024-03-01 to 2024-03-31 5,723,097 5,927,776 204,680 4,575,564 27,198 - BROKEN
2024-02-01 to 2024-02-29 5,536,131 5,723,096 186,966 3,892,035 26,682 -
2024-01-01 to 2024-01-31 5,335,918 5,536,130 200,213 4,341,866 26,468 -
2023-12-01 to 2023-12-31 5,130,545 5,335,917 205,372 4,439,113 716 26,327 - 1 (0.00%)
2023-11-01 to 2023-11-30 4,942,662 5,130,544 187,883 4,078,611 872 25,980 -
2023-10-01 to 2023-10-31 4,758,501 4,942,661 184,161 3,882,338 848 25,896 -
2023-09-01 to 2023-09-30 4,590,102 4,758,500 168,399 3,735,260 790 25,789 -
2023-08-01 to 2023-08-31 4,381,601 4,590,101 208,501 4,295,605 823 25,695 -
2023-07-01 to 2023-07-31 4,182,765 4,381,600 198,836 4,091,582 918 25,646 -
2023-06-01 to 2023-06-30 3,992,668 4,182,764 190,097 4,048,721 1,106 25,550 -
2023-05-01 to 2023-05-31 3,802,720 3,992,667 189,946 4,102,937 1,146 25,372 - 2 (0.00%)
2023-04-01 to 2023-04-30 3,609,885 3,802,719 192,835 4,027,289 1,265 25,013 -
2023-03-01 to 2023-03-31 3,404,470 3,609,884 205,415 4,587,401 1,371 24,657 -
2023-02-01 to 2023-02-28 3,224,780 3,404,469 179,690 3,821,812 1,415 23,764 -
2023-01-01 to 2023-01-31 3,021,555 3,224,779 203,225 4,363,410 1,415 23,240 -
2022-12-01 to 2022-12-31 2,822,145 3,021,554 199,410 3,092,577 1,544 22,893 -
2022-11-01 to 2022-11-30 2,627,833 2,822,144 194,312 3,913,885 1,963 19,611 -
2022-10-01 to 2022-10-31 2,426,072 2,627,832 201,761 4,074,406 1,898 18,546 -
2022-09-01 to 2022-09-30 2,242,788 2,426,071 183,284 3,676,717 1,708 17,683 -
2022-08-01 to 2022-08-31 2,067,816 2,242,787 174,972 3,510,607 1,731 17,257 -
2022-07-01 to 2022-07-31 1,893,934 2,067,815 173,882 3,533,401 2,106 17,299 -
2022-06-01 to 2022-06-30 1,713,500 1,893,933 180,434 3,648,150 2,286 16,813 -
2022-05-01 to 2022-05-31 1,546,024 1,713,499 167,476 3,318,867 2,036 15,917 -
2022-04-01 to 2022-04-30 1,440,156 1,546,023 105,868 1,819,275 1,109 14,797 -
2022-03-01 to 2022-03-31 1,320,455 1,440,155 119,701 1,706,949 789 13,765 -
2022-02-01 to 2022-02-28 1,197,043 1,320,454 123,412 1,539,024 860 13,715 -
2022-01-01 to 2022-01-31 1,003,115 1,197,042 193,928 2,430,129 992 13,766 -
2021-12-01 to 2021-12-31 821,668 1,003,114 96,945 351,054 432 13,764 - 84,502 (46.57%)
2021-11-01 to 2021-11-30 657,770 821,649 2,559 45 8 13,550 - BROKEN (98.44%)
2021-10-01 to 2021-10-31 488,043 657,750 5,554 207 10 13,428 - BROKEN (96.73%)
2021-09-01 to 2021-09-30 303,773 487,927 114,445 914 17 11,717 - BROKEN (37.85%)
2021-08-01 to 2021-08-31 102,052 303,772 201,670 266 8 3,198 - 51 (0.03%)
2021-07-13 to 2021-07-31 1 102,051 102,051 530 14 3,172 -

Tables:

  • Blocks: bigquery-public-data.crypto_kusama.blocks2004 (date-partitioned by block_time) - Schema
  • Extrinsics: bigquery-public-data.crypto_kusama.extrinsics2004 (date-partitioned by block_time) - Schema
  • Events: bigquery-public-data.crypto_kusama.events2004 (date-partitioned by block_time) - Schema
  • Transfers: bigquery-public-data.crypto_kusama.transfers2004 (date-partitioned by block_time) - Schema
  • Balances: bigquery-public-data.crypto_kusama.balances2004 (date-partitioned by ts) - Schema
  • Active Accounts: bigquery-public-data.crypto_kusama.accountsactive2004 (date-partitioned by ts) - Schema
  • Passive Accounts: bigquery-public-data.crypto_kusama.accountspassive2004 (date-partitioned by ts) - Schema
  • New Accounts: bigquery-public-data.crypto_kusama.accountsnew2004 (date-partitioned by ts) - Schema
  • Reaped Accounts: bigquery-public-data.crypto_kusama.accountsreaped2004 (date-partitioned by ts) - Schema
  • Assets: bigquery-public-data.crypto_kusama.assets (filter on 2004) - 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.blocks2004` 
group by monthDT 
order by monthDT desc

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