Skip to content

Latest commit

 

History

History
205 lines (158 loc) · 8.72 KB

2024-03-31.md

File metadata and controls

205 lines (158 loc) · 8.72 KB

bifrost Summary (Daily)

Source: bifrost.polkaholic.io

Relay Chain: polkadot Para ID: 2030

Daily Summary for Month ending in 2024-03-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-03-31 4,387,739 4,394,873 7,135 2,890 35,294 37,236 2,083 ($15,620.73)
2024-03-30 4,380,613 4,387,738 7,126 13,818 36,036 101,400 12,057 ($9,594.31)
2024-03-29 4,373,499 4,380,612 7,114 1,460 35,888 29,191 1,410 ($4,151.40)
2024-03-28 4,366,376 4,373,498 7,123 1,369 35,754 28,079 1,247 ($17,118.96)
2024-03-27 4,359,298 4,366,375 7,078 1,584 35,704 34,818 3,585 ($27,718.32)
2024-03-26 4,352,216 4,359,297 7,082 1,504 35,628 38,507 4,789 ($230,032.17)
2024-03-25 4,345,163 4,352,215 7,053 1,332 35,487 28,419 1,509 ($10,324.62)
2024-03-24 4,338,096 4,345,162 7,067 1,133 35,449 25,698 1,167 ($19,301.14)
2024-03-23 4,331,034 4,338,095 7,062 2,119 35,369 35,451 2,918 ($11,705.56)
2024-03-22 4,323,961 4,331,033 7,073 1,385 35,338 29,266 1,535 ($8,433.64)
2024-03-21 4,316,890 4,323,960 7,071 1,532 35,291 31,722 2,021 ($109,706.44)
2024-03-20 4,309,850 4,316,889 7,040 1,357 35,228 32,949 3,656 ($18,255.98)
2024-03-19 4,302,741 4,309,849 7,109 1,432 35,187 30,095 1,670 ($78,854.47)
2024-03-18 4,295,671 4,302,740 7,070 1,343 35,133 29,024 1,544 ($66,275.38)
2024-03-17 4,288,567 4,295,670 7,104 1,419 35,086 29,854 1,791 ($20,945.82)
2024-03-16 4,281,501 4,288,566 7,066 1,396 35,051 29,105 1,483 ($36,106.02)
2024-03-15 4,274,424 4,281,500 7,077 1,656 34,996 32,623 1,911 ($35,007.18)
2024-03-14 4,267,352 4,274,423 7,072 1,569 34,938 33,367 2,270 ($25,842.33)
2024-03-13 4,260,289 4,267,351 7,063 1,594 34,889 37,771 4,463 ($56,896.81)
2024-03-12 4,253,242 4,260,288 7,047 1,056 34,833 26,812 1,312 ($53,374.15)
2024-03-11 4,246,142 4,253,241 7,100 1,105 34,782 28,353 1,614 ($1,846,204.84)
2024-03-10 4,239,049 4,246,141 7,093 980 34,703 27,510 1,681 ($82,869.50)
2024-03-09 4,231,989 4,239,048 7,060 1,167 34,638 29,537 1,997 ($115,761.79)
2024-03-08 4,225,072 4,231,988 6,917 1,094 34,533 29,025 2,018 ($14,617.39)
2024-03-07 4,218,149 4,225,071 6,923 1,156 34,444 29,686 2,083 ($24,884.79)
2024-03-06 4,211,205 4,218,148 6,944 1,153 34,324 32,854 3,835 ($99,012.43)
2024-03-05 4,204,454 4,211,204 6,751 1,151 34,234 28,772 1,967 ($18,806.62)
2024-03-04 4,197,838 4,204,453 6,616 1,221 34,183 29,133 2,047 ($77,052.19)
2024-03-03 4,191,003 4,197,837 6,835 1,042 34,105 27,659 1,951 ($35,013.04)
2024-03-02 4,184,107 4,191,002 6,896 993 34,045 27,190 1,645 ($25,893.82)
2024-03-01 4,177,054 4,184,106 7,053 1,313 33,949 31,774 1,976 ($29,658.42)

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

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