Skip to content

Latest commit

 

History

History
201 lines (154 loc) · 7.41 KB

2022-06-30.md

File metadata and controls

201 lines (154 loc) · 7.41 KB

bifrost Summary (Daily)

Source: bifrost.polkaholic.io

Relay Chain: polkadot Para ID: 2030

Daily Summary for Month ending in 2022-06-30

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-06-30 169,008 175,694 6,687 4 2 13,381
2022-06-29 162,260 169,007 6,748 4 2 13,499
2022-06-28 155,484 162,259 6,776 4 2 13,556
2022-06-27 148,770 155,483 6,714 4 2 13,432
2022-06-26 142,105 148,769 6,665 2 13,334
2022-06-25 135,412 142,104 6,693 2 13,389
2022-06-24 128,718 135,411 6,694 2 13,395
2022-06-23 122,046 128,717 6,672 2 13,348
2022-06-22 115,399 122,045 6,647 2 13,297
2022-06-21 108,755 115,398 6,644 4 2 13,292
2022-06-20 102,177 108,754 6,578 4 2 13,160
2022-06-19 95,549 102,176 6,628 4 2 13,259
2022-06-18 88,940 95,548 6,609 4 2 13,222
2022-06-17 82,317 88,939 6,623 4 2 13,253
2022-06-16 75,716 82,316 6,601 4 2 13,205
2022-06-15 69,099 75,715 6,617 4 2 13,238
2022-06-14 62,515 69,098 6,584 4 2 13,172
2022-06-13 55,887 62,514 6,628 4 2 13,259
2022-06-12 49,264 55,886 6,623 4 2 13,250
2022-06-11 42,599 49,263 6,665 4 2 13,337
2022-06-10 35,886 42,598 6,713 4 2 13,430
2022-06-09 29,220 35,885 6,666 4 2 13,335
2022-06-08 22,492 29,219 6,728 4 2 13,460
2022-06-07 15,821 22,491 6,671 4 2 13,346
2022-06-06 9,088 15,820 6,733 4 2 13,469
2022-06-05 2,360 9,087 6,728 4 2 13,460
2022-06-04 1 2,359 2,359 4 2 4,719

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-06-30" 
 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-06-30" 
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-06-30" 
 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-06-30" 
 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-06-30" 
 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-06-30" 
 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-06-30" 
 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-06-30" 
 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-06-30" 
 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-06-30" 
 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-06-30" 
 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-06-30" 
 group by logDT 
order by logDT

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