Skip to content

Latest commit

 

History

History
205 lines (158 loc) · 9.72 KB

2024-01-31.md

File metadata and controls

205 lines (158 loc) · 9.72 KB

bifrost Summary (Daily)

Source: bifrost.polkaholic.io

Relay Chain: polkadot Para ID: 2030

Daily Summary for Month ending in 2024-01-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-01-31 3,968,996 3,976,042 7,047 1,753 31,780 38,424 4,418 ($328,538.13) 162 ($530,122.28) 28 ($419,592.76) 409 363
2024-01-30 3,961,979 3,968,995 7,017 1,623 31,684 32,685 2,284 ($81,099.33) 122 ($767,462.50) 20 ($56,606.60) 398 269
2024-01-29 3,954,972 3,961,978 7,007 2,176 31,620 39,861 3,674 ($54,203.28) 191 ($193,737.92) 25 ($17,425.75) 433 312
2024-01-28 3,947,919 3,954,971 7,053 1,123 31,493 28,488 1,811 ($55,053.28) 125 ($104,565.96) 20 ($18,284.11) 352 255
2024-01-27 3,940,861 3,947,918 7,058 1,105 31,433 27,483 1,322 ($16,382.58) 144 ($193,112.22) 12 ($5,403.54) 367 260
2024-01-26 3,933,809 3,940,860 7,052 1,032 31,358 28,171 1,625 ($188,277.76) 162 ($104,751.42) 23 ($68,298.48) 433 288
2024-01-25 3,926,780 3,933,808 7,029 1,066 31,286 28,799 1,767 ($44,943.15) 166 ($212,308.20) 33 ($58,621.99) 465 306
2024-01-24 3,919,754 3,926,779 7,026 893 31,216 29,386 2,965 ($11,589.74) 144 ($3,775,399.15) 18 ($1,083.33) 378 297
2024-01-23 3,912,737 3,919,753 7,017 1,131 31,134 27,600 1,129 ($57,908.52) 169 ($956,619.38) 15 ($6,066.05) 370 312
2024-01-22 3,905,705 3,912,736 7,032 1,554 31,086 30,825 1,394 ($136,393.83) 131 ($415,732.78) 13 238 264
2024-01-21 3,898,754 3,905,704 6,951 590 31,059 21,572 742 ($4,853.75) 100 ($323,505.53) 13 ($4,702.27) 215 254
2024-01-20 3,891,767 3,898,753 6,987 817 31,027 23,567 797 ($2,999.46) 113 ($107,767.92) 7 ($2,301.83) 223 244
2024-01-19 3,884,704 3,891,766 7,063 832 30,981 24,567 1,035 ($309,876.38) 138 ($1,260,192.96) 20 ($59,004.78) 278 294
2024-01-18 3,878,170 3,884,703 6,534 1,121 30,947 27,232 1,494 ($60,327.47) 210 ($616,492.39) 20 ($51,430.26) 326 331
2024-01-17 3,871,133 3,878,169 7,037 1,482 30,865 36,914 3,974 ($173,646.22) 348 ($1,936,338.43) 24 ($33,587.09) 491 476
2024-01-16 3,864,098 3,871,132 7,035 2,081 30,783 40,641 3,019 ($581,702.93) 436 ($12,846,795.90) 39 ($311,613.67) 651 502
2024-01-15 3,857,082 3,864,097 7,016 568 30,679 20,548 620 ($41,716.61) 42 ($356,415.82) 15 ($86,593.11) 77 133
2024-01-14 3,850,036 3,857,081 7,046 406 30,670 18,965 416 ($47,749.21) 54 ($20,616,283.59) 11 ($37,757.40) 84 154
2024-01-13 3,842,981 3,850,035 7,055 470 30,654 19,880 617 ($42,427.62) 53 ($27,418.25) 5 ($27,794.08) 85 123
2024-01-12 3,835,944 3,842,980 7,037 587 30,640 20,793 694 ($136,796.04) 65 ($166,553.66) 12 ($46,518.36) 138 185
2024-01-11 3,828,939 3,835,943 7,005 606 30,617 24,745 2,620 ($52,503.33) 73 ($157,965.04) 18 ($47,518.18) 161 157
2024-01-10 3,821,892 3,828,938 7,047 520 30,594 20,049 643 ($31,447.74) 49 ($100,448.58) 10 ($21,712.09) 115 92
2024-01-09 3,814,828 3,821,891 7,064 437 30,587 19,239 494 ($27,355.85) 47 ($60,738.10) 5 ($21,112.18) 119 107
2024-01-08 3,807,883 3,814,827 6,945 669 30,574 21,803 936 ($201,241.68) 67 ($33,912.67) 19 ($14,024.00) 147 140
2024-01-07 3,800,910 3,807,882 6,973 639 30,559 21,287 824 ($20,772.82) 91 ($302,882.41) 23 ($75,052.25) 143 106
2024-01-06 3,793,830 3,800,909 7,080 452 30,531 19,008 433 ($6,523.16) 34 ($11,680.64) 10 ($6,177.62) 66 85
2024-01-05 3,786,740 3,793,829 7,090 526 30,528 20,022 591 ($75,959.35) 56 ($103,594.71) 10 ($33,776.38) 92 92
2024-01-04 3,779,670 3,786,739 7,070 1,049 30,517 24,982 1,135 ($333,341.05) 56 ($114,491.88) 16 ($570,336.49) 132 138
2024-01-03 3,772,750 3,779,669 6,920 1,001 30,517 97,793 25,992 ($315,709.64) 80 ($303,315.86) 21 ($68,089.46) 186 200
2024-01-02 3,765,659 3,772,749 7,091 521 30,524 20,438 630 ($147,803.53) 66 ($69,561.49) 21 ($59,662.01) 115 98
2024-01-01 3,758,524 3,765,658 7,135 345 30,504 18,289 419 ($87,194.18) 31 ($29,562.87) 7 ($64,044.09) 60 51

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

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