Skip to content

Latest commit

 

History

History

3369-mythos

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
2024-03-31.md
2024-03-31.md
 
 
2024-04-30.md
2024-04-30.md
 
 
2024-05-31.md
2024-05-31.md
 
 
2024-06-30.md
2024-06-30.md
 
 
2024-07-31.md
2024-07-31.md
 
 
2024-08-31.md
2024-08-31.md
 
 
README.md
README.md
 
 

README.md

mythos Summary (Monthly)

Source: mythos.polkaholic.io

Relay Chain: polkadot Para ID: 3369

Month Start Block End Block # Blocks # Signed Extrinsics (total) # Active Accounts (avg) # Addresses with Balances (max) Issues
2024-08-01 to 2024-08-06 1,195,197 1,266,102 70,906 86,495 792,230 -
2024-07-01 to 2024-07-31 754,634 1,195,196 440,563 3,528,218 791,359 -
2024-06-01 to 2024-06-30 517,218 754,633 237,416 791,055 10 -
2024-05-01 to 2024-05-31 296,157 517,217 221,061 2 3 -
2024-04-01 to 2024-04-30 82,254 296,156 213,903 3 2 -
2024-03-20 to 2024-03-31 1 82,253 82,253 1 2 -

Tables:

  • Blocks: bigquery-public-data.crypto_polkadot.blocks3369 (date-partitioned by block_time) - Schema
  • Extrinsics: bigquery-public-data.crypto_polkadot.extrinsics3369 (date-partitioned by block_time) - Schema
  • Events: bigquery-public-data.crypto_polkadot.events3369 (date-partitioned by block_time) - Schema
  • Transfers: bigquery-public-data.crypto_polkadot.transfers3369 (date-partitioned by block_time) - Schema
  • Balances: bigquery-public-data.crypto_polkadot.balances3369 (date-partitioned by ts) - Schema
  • Active Accounts: bigquery-public-data.crypto_polkadot.accountsactive3369 (date-partitioned by ts) - Schema
  • Passive Accounts: bigquery-public-data.crypto_polkadot.accountspassive3369 (date-partitioned by ts) - Schema
  • New Accounts: bigquery-public-data.crypto_polkadot.accountsnew3369 (date-partitioned by ts) - Schema
  • Reaped Accounts: bigquery-public-data.crypto_polkadot.accountsreaped3369 (date-partitioned by ts) - Schema
  • Assets: bigquery-public-data.crypto_polkadot.assets (filter on 3369) - Schema
  • XCM Assets: bigquery-public-data.crypto_polkadot.xcmassets (filter on para_id) - Schema
  • XCM Transfers: bigquery-public-data.crypto_polkadot.xcmtransfers (filter on origination_para_id or destination_para_id, date-partitioned by origination_ts) - Schema
  • XCM Messages: bigquery-public-data.crypto_polkadot.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_polkadot.blocks3369` 
group by monthDT 
order by monthDT desc

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