Skip to content

Latest commit

 

History

History
205 lines (158 loc) · 7.96 KB

2022-08-31.md

File metadata and controls

205 lines (158 loc) · 7.96 KB

bifrost Summary (Daily)

Source: bifrost.polkaholic.io

Relay Chain: polkadot Para ID: 2030

Daily Summary for Month ending in 2022-08-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-08-31 586,411 593,247 6,837 27 16 1,329 13,858 23 ($6,014.41)
2022-08-30 579,561 586,410 6,850 10 7 1,323 13,766 4 ($2.16)
2022-08-29 572,660 579,560 6,901 4 6 1,319 13,833 2 ($2.84)
2022-08-28 565,789 572,659 6,871 1 5 1,317 13,752
2022-08-27 558,872 565,788 6,917 4 1,317 13,838
2022-08-26 551,966 558,871 6,906 7 9 1,317 13,862 3 ($1.09)
2022-08-25 545,015 551,965 6,951 80 12 1,315 20,883 1,328 ($1,718,831.94)
2022-08-24 538,091 545,014 6,924 15 11 15 13,968 14 ($2.54)
2022-08-23 531,192 538,090 6,899 4 11 13,801
2022-08-22 524,284 531,191 6,908 4 11 13,820
2022-08-21 517,331 524,283 6,953 4 11 13,914
2022-08-20 510,444 517,330 6,887 4 11 13,778
2022-08-19 503,524 510,443 6,920 4 11 13,845
2022-08-18 496,603 503,523 6,921 4 11 13,846
2022-08-17 489,709 496,602 6,894 4 11 13,791
2022-08-16 482,814 489,708 6,895 4 11 13,794
2022-08-15 475,905 482,813 6,909 4 11 13,822
2022-08-14 469,041 475,904 6,864 4 11 13,732
2022-08-13 462,155 469,040 6,886 4 11 13,776
2022-08-12 455,322 462,154 6,833 1 5 11 13,690 3 ($3,300,957.80)
2022-08-11 448,605 455,321 6,717 13 10 8 13,554 5 ($109.99)
2022-08-10 441,684 448,604 6,921 4 3 13,846
2022-08-09 434,780 441,683 6,904 1 5 3 13,820
2022-08-08 427,877 434,779 6,903 4 2 13,810
2022-08-07 420,960 427,876 6,917 4 2 13,838
2022-08-06 414,064 420,959 6,896 4 2 13,795
2022-08-05 407,282 414,063 6,782 4 2 13,568
2022-08-04 400,638 407,281 6,644 2 5 2 13,304
2022-08-03 393,820 400,637 6,818 4 2 13,640
2022-08-02 386,985 393,819 6,835 4 2 13,674
2022-08-01 380,234 386,984 6,751 4 2 13,505

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-08-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-08-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-08-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-08-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-08-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-08-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-08-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-08-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-08-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-08-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-08-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-08-31" 
 group by logDT 
order by logDT

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