Skip to content

Latest commit

 

History

History
203 lines (156 loc) · 8.62 KB

2024-02-29.md

File metadata and controls

203 lines (156 loc) · 8.62 KB

bifrost Summary (Daily)

Source: bifrost.polkaholic.io

Relay Chain: polkadot Para ID: 2030

Daily Summary for Month ending in 2024-02-29

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-02-29 4,171,006 4,177,053 6,048 1,298 33,830 28,737 1,817 ($52,422.30)
2024-02-28 4,165,191 4,171,005 5,815 1,148 33,760 32,995 4,493 ($26,687.56)
2024-02-27 4,158,174 4,165,190 7,017 975 33,647 26,860 1,565 ($8,763.05)
2024-02-26 4,151,165 4,158,173 7,009 891 33,596 25,545 1,314 ($11,866.94)
2024-02-25 4,144,133 4,151,164 7,032 844 33,556 24,725 1,342 ($11,716.22)
2024-02-24 4,137,082 4,144,132 7,051 896 33,517 25,564 1,370 ($9,225.99)
2024-02-23 4,130,028 4,137,081 7,054 863 33,473 25,605 1,327 ($15,270.60)
2024-02-22 4,122,992 4,130,027 7,036 1,021 33,416 27,280 1,545 ($15,486.60)
2024-02-21 4,115,994 4,122,991 6,998 2,179 33,351 37,993 1,665 ($7,589.32)
2024-02-20 4,109,032 4,115,993 6,962 2,798 33,299 44,749 2,327 ($25,593.41)
2024-02-19 4,102,035 4,109,031 6,997 3,071 33,204 49,584 3,435 ($46,433.74)
2024-02-18 4,095,009 4,102,034 7,026 2,983 33,003 48,592 3,214 ($10,731.25)
2024-02-17 4,088,035 4,095,008 6,974 2,078 32,773 35,706 1,233 ($16,444.16)
2024-02-16 4,081,010 4,088,034 7,025 2,407 32,737 39,801 1,568 ($10,127.51)
2024-02-15 4,073,982 4,081,009 7,028 2,494 32,666 44,860 3,601 ($18,878.12)
2024-02-14 4,066,959 4,073,981 7,023 2,485 32,590 42,121 2,397 ($45,537.86)
2024-02-13 4,059,961 4,066,958 6,998 1,747 32,456 32,860 1,144 ($24,144.40)
2024-02-12 4,052,934 4,059,960 7,027 807 32,424 24,696 1,238 ($1,378.21)
2024-02-11 4,045,879 4,052,933 7,055 803 32,360 24,399 1,172 ($15,557.53)
2024-02-10 4,038,875 4,045,878 7,004 927 32,313 25,379 1,223 ($6,946.73)
2024-02-09 4,031,943 4,038,874 6,932 964 32,267 26,378 1,426 ($10,701.75)
2024-02-08 4,024,946 4,031,942 6,997 1,111 32,201 28,125 1,735 ($12,626.86)
2024-02-07 4,017,980 4,024,945 6,966 1,369 32,134 32,773 3,420 ($21,651.94)
2024-02-06 4,010,941 4,017,979 7,039 1,187 32,061 26,962 1,231 ($28,390.64)
2024-02-05 4,004,112 4,010,940 6,829 1,290 32,018 27,855 1,344 ($27,388.50) 134 ($124,634.04) 37 ($1,252.87)
2024-02-04 3,997,106 4,004,111 7,006 1,212 31,974 27,374 1,287 ($27,134.56) 111 ($51,952.84) 24 ($1,884.77)
2024-02-03 3,990,098 3,997,105 7,008 1,419 31,927 30,123 1,675 ($63,125.76) 145 ($93,176.07) 19 ($1,701.53) 320 281
2024-02-02 3,983,091 3,990,097 7,007 1,760 31,877 34,145 2,559 ($43,243.87) 143 ($140,161.03) 32 ($31,296.22) 367 314
2024-02-01 3,976,043 3,983,090 7,048 1,455 31,834 30,107 1,642 ($8,326.24) 152 ($2,715,506.26) 23 ($33,674.03) 350 288

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-02-29" 
 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-02-29" 
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-02-29" 
 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-02-29" 
 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-02-29" 
 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-02-29" 
 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-02-29" 
 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-02-29" 
 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-02-29" 
 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-02-29" 
 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-02-29" 
 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-02-29" 
 group by logDT 
order by logDT

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