Skip to content

Latest commit

 

History

History
205 lines (158 loc) · 8.61 KB

2024-05-31.md

File metadata and controls

205 lines (158 loc) · 8.61 KB

bifrost Summary (Daily)

Source: bifrost.polkaholic.io

Relay Chain: polkadot Para ID: 2030

Daily Summary for Month ending in 2024-05-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
2024-05-31 4,820,224 4,827,249 7,026 800 36,093 22,817 736 ($568.31)
2024-05-30 4,813,127 4,820,223 7,097 778 36,083 22,448 651 ($23,884.03)
2024-05-29 4,806,015 4,813,126 7,112 795 36,079 23,116 762 ($3,809.83)
2024-05-28 4,798,928 4,806,014 7,087 885 36,070 24,409 891 ($2,523.31)
2024-05-27 4,791,866 4,798,927 7,062 798 36,064 24,324 998 ($7,711.60)
2024-05-26 4,784,759 4,791,865 7,107 849 36,056 24,062 881 ($5,357.04)
2024-05-25 4,777,662 4,784,758 7,097 830 36,048 24,622 1,007 ($61,255.20)
2024-05-24 4,770,569 4,777,661 7,093 738 36,035 23,016 803 ($20,276.06)
2024-05-23 4,763,481 4,770,568 7,088 796 36,028 24,801 1,165 ($6,351.46)
2024-05-22 4,756,396 4,763,480 7,085 873 36,023 25,807 1,279 ($3,264.52)
2024-05-21 4,749,280 4,756,395 7,116 965 36,012 27,490 1,536 ($7,060.73)
2024-05-20 4,742,150 4,749,279 7,130 1,209 36,002 29,486 1,566 ($36,303.97)
2024-05-19 4,735,010 4,742,149 7,140 882 35,988 27,589 1,586 ($2,997.85)
2024-05-18 4,727,913 4,735,009 7,097 1,157 35,982 30,199 1,875 ($64,027.60)
2024-05-17 4,720,792 4,727,912 7,121 2,091 35,966 46,837 4,723 ($88,425.03)
2024-05-16 4,713,690 4,720,791 7,102 840 35,946 24,113 903 ($3,877.12)
2024-05-15 4,706,582 4,713,689 7,108 888 35,938 27,752 2,895 ($12,353.39)
2024-05-14 4,699,484 4,706,581 7,098 753 35,933 21,285 433 ($4,701.23)
2024-05-13 4,692,362 4,699,483 7,122 822 35,922 22,197 596 ($2,484.10)
2024-05-12 4,685,217 4,692,361 7,145 790 35,915 21,816 524 ($2,872.47)
2024-05-11 4,678,093 4,685,216 7,124 833 35,907 22,458 601 ($9,102.72)
2024-05-10 4,670,964 4,678,092 7,129 884 35,802 22,750 627 ($2,586.35)
2024-05-09 4,663,890 4,670,963 7,074 750 35,895 21,140 516 ($12,575.48)
2024-05-08 4,656,775 4,663,889 7,115 743 35,889 25,212 2,461 ($5,432.84)
2024-05-07 4,649,650 4,656,774 7,125 680 35,875 21,309 527 ($14,720.15)
2024-05-06 4,642,532 4,649,649 7,118 648 35,858 21,893 724 ($3,689.10)
2024-05-05 4,635,402 4,642,531 7,130 639 35,840 21,980 767 ($562,985.07)
2024-05-04 4,628,260 4,635,401 7,142 575 35,827 21,169 677 ($20,168.43)
2024-05-03 4,621,105 4,628,259 7,155 619 35,817 21,642 708 ($4,130.03)
2024-05-02 4,613,933 4,621,104 7,172 692 35,805 22,774 832 ($9,427.51)
2024-05-01 4,606,764 4,613,932 7,169 706 35,794 26,703 2,838 ($18,560.03)

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

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