Skip to content

Latest commit

 

History

History
205 lines (158 loc) · 8.84 KB

2022-10-31.md

File metadata and controls

205 lines (158 loc) · 8.84 KB

bifrost Summary (Daily)

Source: bifrost.polkaholic.io

Relay Chain: polkadot Para ID: 2030

Daily Summary for Month ending in 2022-10-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-10-31 1,006,803 1,013,657 6,855 105 46 2,939 14,586 45 5 ($15.64) 3 ($1,719.23) 7 5
2022-10-30 999,959 1,006,802 6,844 83 32 2,935 14,445 34 10 ($2,108.81) 9 ($2,062.00) 10 10
2022-10-29 993,150 999,958 6,809 78 31 2,933 14,330 39 7 ($1,394.79) 3 ($3,722.11) 7 4
2022-10-28 986,295 993,149 6,855 108 40 2,927 14,622 55 5 ($6,995.65) 9 ($4,790.26) 5 10
2022-10-27 979,421 986,294 6,874 54 34 2,925 14,210 31 4 ($494.55) 3 ($2,252.19) 4 6
2022-10-26 972,531 979,420 6,890 118 47 2,922 14,820 72 6 ($2,004.24) 1 ($447.81) 6 4
2022-10-25 965,640 972,530 6,891 78 40 2,917 14,423 36 5 ($150.92) 1 ($147.10) 5 2
2022-10-24 958,784 965,639 6,856 72 35 2,915 14,398 60 8 ($6,164.90) 9 ($7,009.69) 8 10
2022-10-23 951,933 958,783 6,851 71 37 2,910 14,279 39 2 ($1,163.07) 1 ($5,150.95) 2 2
2022-10-22 945,144 951,932 6,789 52 26 2,901 14,091 36 7 ($6,161.29) 2 ($6,333.94) 7 3
2022-10-21 938,344 945,143 6,800 155 41 2,899 15,000 80 11 ($1,711.38) 7 ($12.88) 11 9
2022-10-20 931,557 938,343 6,787 86 42 2,893 14,309 56 6 ($1,334.41) 3 ($7,620.18) 8 5
2022-10-19 924,770 931,556 6,787 80 29 2,889 14,276 34 4 ($2,830.64) 6 ($1,961.54) 4 7
2022-10-18 917,886 924,769 6,884 143 42 2,885 15,015 68 8 ($5,415.40) 2 ($933.33) 7 7
2022-10-17 911,017 917,885 6,869 127 47 2,879 14,793 75 7 ($1,748.72) 7 1
2022-10-16 904,169 911,016 6,848 91 35 2,872 14,457 41 4 ($196.73) 4 ($1,071.73) 4 5
2022-10-15 897,297 904,168 6,872 74 34 2,870 14,381 42 4 ($212.70) 4 2
2022-10-14 890,407 897,296 6,890 97 41 2,867 14,605 42 5 ($252.83) 2 ($278.92) 5 4
2022-10-13 883,540 890,406 6,867 77 42 2,864 14,518 71 13 ($5,117.32) 4 ($2,511.93) 13 6
2022-10-12 876,622 883,539 6,918 115 48 2,858 14,841 83 9 ($560.22) 9 1
2022-10-11 869,672 876,621 6,950 113 36 2,853 14,875 80 7 ($1,503.14) 6 ($2,128.82) 7 7
2022-10-10 862,727 869,671 6,945 63 30 2,849 14,424 43 2 ($248.79) 3 ($103.29) 2 4
2022-10-09 855,749 862,726 6,978 150 55 2,847 15,174 96 5 ($1,488.24) 10 ($1,937.94) 5 13
2022-10-08 848,766 855,748 6,983 61 31 2,841 14,516 37 6 ($1,287.66) 3 ($1,610.11) 6 4
2022-10-07 841,795 848,765 6,971 93 34 2,840 14,767 51 7 ($7,543.22) 3 ($2,339.61) 7 4
2022-10-06 834,819 841,794 6,976 124 36 2,837 15,008 86 7 ($3,031.77) 9 ($4,048.58) 7 10
2022-10-05 827,870 834,818 6,949 113 48 2,833 14,899 72 10 ($4,589.01) 3 ($4,917.49) 10 4
2022-10-04 820,890 827,869 6,980 80 42 2,828 14,651 65 6 ($4,293.27) 2 ($4,609.81) 6 3
2022-10-03 813,871 820,889 7,019 104 41 2,823 14,879 47 5 ($457.39) 1 ($95.47) 5 3
2022-10-02 806,872 813,870 6,999 109 34 2,820 14,959 52 14 ($88,448.74) 1 ($626.92) 14 4
2022-10-01 799,904 806,871 6,968 128 42 2,813 15,050 79 16 ($8,692.02) 5 ($1,621.37) 16 7

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

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