Skip to content

Latest commit

 

History

History
204 lines (157 loc) · 8.44 KB

2024-06-30.md

File metadata and controls

204 lines (157 loc) · 8.44 KB

bifrost Summary (Daily)

Source: bifrost.polkaholic.io

Relay Chain: polkadot Para ID: 2030

Daily Summary for Month ending in 2024-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
2024-06-30 5,029,090 5,036,167 7,078 837 22,115 424 ($2,087.49)
2024-06-29 5,022,006 5,029,089 7,084 970 23,600 401 ($31,749.83)
2024-06-28 5,014,942 5,022,005 7,064 824 22,532 664 ($4,755.24)
2024-06-27 5,008,114 5,014,941 6,828 1,082 24,422 748 ($8,108.98)
2024-06-26 5,001,251 5,008,113 6,863 756 21,101 493 ($42,228.55)
2024-06-25 4,994,421 5,001,250 6,830 874 22,284 581 ($2,523.39)
2024-06-24 4,987,560 4,994,420 6,861 865 22,456 670 ($2,260.69)
2024-06-23 4,980,689 4,987,559 6,871 814 39,105 21,672 529 ($647.78)
2024-06-22 4,973,822 4,980,688 6,867 861 39,102 22,449 684 ($4,149.80)
2024-06-21 4,966,962 4,973,821 6,860 882 39,096 22,913 692 ($22,107.23)
2024-06-20 4,960,103 4,966,961 6,859 860 39,086 22,130 607 ($7,566.13)
2024-06-19 4,953,251 4,960,102 6,852 1,004 39,077 24,849 1,015 ($12,227.22)
2024-06-18 4,946,646 4,953,250 6,605 1,033 39,059 24,609 1,065 ($22,936.62)
2024-06-17 4,939,848 4,946,645 6,798 917 39,055 22,815 712 ($19,027.90)
2024-06-16 4,932,915 4,939,847 6,933 881 39,042 23,036 803 ($9,556.43)
2024-06-15 4,925,889 4,932,914 7,026 761 39,035 21,820 533 ($4,895.21)
2024-06-14 4,918,856 4,925,888 7,033 1,078 39,027 25,291 878 ($186,656.56)
2024-06-13 4,911,777 4,918,855 7,079 931 39,015 23,362 600 ($4,770.76)
2024-06-12 4,904,688 4,911,776 7,089 1,011 24,362 872 ($9,540.05)
2024-06-11 4,897,616 4,904,687 7,072 1,106 38,995 25,167 957 ($431,282.33)
2024-06-10 4,890,536 4,897,615 7,080 1,041 38,987 24,574 876 ($9,119.23)
2024-06-09 4,883,486 4,890,535 7,050 750 38,979 21,664 568 ($3,559.18)
2024-06-08 4,876,446 4,883,485 7,040 772 38,970 21,936 567 ($13,797.04)
2024-06-07 4,869,412 4,876,445 7,034 1,020 38,968 24,109 900 ($37,821.67)
2024-06-06 4,862,425 4,869,411 6,987 820 38,957 22,567 704 ($858.30)
2024-06-05 4,855,391 4,862,424 7,034 933 38,942 23,801 773 ($3,892.52)
2024-06-04 4,848,316 4,855,390 7,075 1,011 38,928 24,843 916 ($5,721.92)
2024-06-03 4,841,294 4,848,315 7,022 880 38,922 22,997 668 ($551,961.40)
2024-06-02 4,834,253 4,841,293 7,041 823 38,912 22,636 674 ($9,417.82)
2024-06-01 4,827,250 4,834,252 7,003 1,151 36,105 24,139 608 ($4,299.57)

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

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