Skip to content

Latest commit

 

History

History
205 lines (158 loc) · 7.8 KB

2022-07-31.md

File metadata and controls

205 lines (158 loc) · 7.8 KB

bifrost Summary (Daily)

Source: bifrost.polkaholic.io

Relay Chain: polkadot Para ID: 2030

Daily Summary for Month ending in 2022-07-31

Date Start Block End Block # Blocks # Extrinsics # Active Accounts # Passive Accounts # New Accounts # Addresses # Events # Transfers ($USD) # XCM Transfers In ($USD) # XCM Transfers Out ($USD) # XCM In # XCM Out Issues
2022-07-31 373,472 380,233 6,762 4 2 13,528
2022-07-30 366,740 373,471 6,732 4 2 13,468
2022-07-29 359,918 366,739 6,822 4 2 13,648
2022-07-28 353,145 359,917 6,773 4 2 13,549
2022-07-27 346,403 353,144 6,742 4 2 13,488
2022-07-26 339,627 346,402 6,776 8 5 2 13,597
2022-07-25 332,805 339,626 6,822 4 2 13,648
2022-07-24 326,020 332,804 6,785 4 2 13,573
2022-07-23 319,243 326,019 6,777 4 2 13,558
2022-07-22 312,516 319,242 6,727 4 2 13,458
2022-07-21 305,741 312,515 6,775 4 2 13,554
2022-07-20 299,020 305,740 6,721 4 2 13,445
2022-07-19 292,269 299,019 6,751 4 2 13,506
2022-07-18 285,499 292,268 6,770 4 2 13,544
2022-07-17 278,808 285,498 6,691 4 2 13,386
2022-07-16 275,489 278,807 3,319 4 2 6,639
2022-07-15 270,136 275,488 5,353 2 5 2 10,715
2022-07-14 263,406 270,135 6,730 4 2 13,464
2022-07-13 256,629 263,405 6,777 4 2 13,561
2022-07-12 249,945 256,628 6,684 4 2 13,372
2022-07-11 243,207 249,944 6,738 2 13,479
2022-07-10 236,410 243,206 6,797 2 13,598
2022-07-09 229,660 236,409 6,750 2 13,504
2022-07-08 222,914 229,659 6,746 2 13,496
2022-07-07 216,142 222,913 6,772 2 13,547
2022-07-06 209,382 216,141 6,760 2 13,527
2022-07-05 202,596 209,381 6,786 2 13,576
2022-07-04 195,925 202,595 6,671 2 13,346
2022-07-03 189,176 195,924 6,749 2 13,501
2022-07-02 182,487 189,175 6,689 2 13,382
2022-07-01 175,695 182,486 6,792 2 13,588

Sample Queries:

You can generate the above summary data using the following queries using the public dataset bigquery-public-data.crypto_polkadot in Google BigQuery:

Blocks

Schema

SELECT date(block_time) as logDT, MIN(number) startBN, MAX(number) endBN, COUNT(*) numBlocks 
 FROM `bigquery-public-data.crypto_polkadot.blocks2030`  
 where LAST_DAY(date(block_time)) = "2022-07-31" 
 group by logDT 
 order by logDT

Signed Extrinsics

Schema

SELECT date(block_time) as logDT, 
COUNT(*) numSignedExtrinsics 
FROM `bigquery-public-data.crypto_polkadot.extrinsics2030`  
where signed and LAST_DAY(date(block_time)) = "2022-07-31" 
group by logDT 
order by logDT

Active Accounts

Schema

SELECT date(ts) as logDT, 
 COUNT(*) numActiveAccounts 
 FROM `bigquery-public-data.crypto_polkadot.accountsactive2030` 
 where LAST_DAY(date(ts)) = "2022-07-31" 
 group by logDT 
 order by logDT

Passive Accounts

Schema

SELECT date(ts) as logDT, 
 COUNT(*) numPassiveAccounts 
 FROM `bigquery-public-data.crypto_polkadot.accountspassive2030` 
 where LAST_DAY(date(ts)) = "2022-07-31" 
 group by logDT 
 order by logDT

New Accounts

Schema

SELECT date(ts) as logDT, 
 COUNT(*) numNewAccounts 
 FROM `bigquery-public-data.crypto_polkadot.accountsnew2030` 
 where LAST_DAY(date(ts)) = "2022-07-31" 
 group by logDT
 order by logDT

Addresses with Balances

Schema

SELECT date(ts) as logDT,
 COUNT(distinct address_pubkey) numAddress 
 FROM `bigquery-public-data.crypto_polkadot.balances2030` 
 where LAST_DAY(date(ts)) = "2022-07-31" 
 group by logDT 
 order by logDT

Events

Schema

SELECT date(block_time) as logDT, 
 COUNT(*) numEvents 
 FROM `bigquery-public-data.crypto_polkadot.events2030` 
 where LAST_DAY(date(block_time)) = "2022-07-31" 
 group by logDT 
 order by logDT

Transfers:

Schema

SELECT date(block_time) as logDT, 
 COUNT(*) numEvents 
 FROM `bigquery-public-data.crypto_polkadot.transfers2030` 
 where LAST_DAY(date(block_time)) = "2022-07-31" 
 group by logDT 
 order by logDT

XCM Transfers In:

Schema

SELECT date(origination_ts) as logDT, 
 COUNT(*) numXCMTransfersOut 
 FROM `bigquery-public-data.crypto_polkadot.xcmtransfers` 
 where destination_para_id = 2030 and LAST_DAY(date(origination_ts)) = "2022-07-31" 
 group by logDT order by logDT

XCM Transfers Out:

Schema

SELECT date(origination_ts) as logDT, 
 COUNT(*) numXCMTransfersIn 
 FROM `bigquery-public-data.crypto_polkadot.xcmtransfers` 
 where origination_para_id = 2030 and LAST_DAY(date(origination_ts)) = "2022-07-31" 
 group by logDT 
order by logDT

XCM Messages In:

Schema

SELECT date(origination_ts) as logDT, 
 COUNT(*) numXCMMessagesOut 
 FROM `bigquery-public-data.crypto_polkadot.xcm` 
 where destination_para_id = 2030 and LAST_DAY(date(origination_ts)) = "2022-07-31" 
 group by logDT order by logDT

XCM Messages Out:

Schema

SELECT date(origination_ts) as logDT, 
 COUNT(*) numXCMMessagesIn 
 FROM `bigquery-public-data.crypto_polkadot.xcm` 
 where origination_para_id = 2030 and LAST_DAY(date(origination_ts)) = "2022-07-31" 
 group by logDT 
order by logDT

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