Skip to content

Latest commit

 

History

History
205 lines (158 loc) · 9.51 KB

2023-08-31.md

File metadata and controls

205 lines (158 loc) · 9.51 KB

bifrost Summary (Daily)

Source: bifrost.polkaholic.io

Relay Chain: polkadot Para ID: 2030

Daily Summary for Month ending in 2023-08-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
2023-08-31 2,985,870 2,991,833 5,964 262 67 21 7 5,095 14,640 182 ($17,880.00) 23 ($12,582.92) 1 ($62.80) 32 28
2023-08-30 2,979,896 2,985,869 5,974 288 75 25 5 5,088 14,861 217 ($15,141.11) 23 ($8,299.66) 36 34
2023-08-29 2,973,832 2,979,895 6,064 272 78 30 8 5,084 14,894 185 ($52,767.76) 18 ($29,113.54) 26 30
2023-08-28 2,967,752 2,973,831 6,080 269 72 21 2 5,076 14,843 151 ($8,655.12) 21 ($1,956.60) 1 ($621.32) 7 3
2023-08-27 2,961,703 2,967,751 6,049 454 71 24 6 5,074 16,394 329 ($29,856.11) 18 ($23,973.66) 2 ($838.51) 5 5
2023-08-26 2,955,592 2,961,702 6,111 410 82 23 8 5,068 16,179 273 ($22,818.41) 27 ($13,833.41) 1 ($2.05) 37 33
2023-08-25 2,949,479 2,955,591 6,113 325 75 34 7 5,062 15,592 209 ($84,946.33) 31 ($57,619.74) 3 ($1,908.16) 42 31
2023-08-24 2,943,250 2,949,478 6,229 258 77 22 9 5,056 15,161 183 ($24,683.84) 27 ($15,742.04) 30 17
2023-08-23 2,936,911 2,943,249 6,339 324 75 22 4 5,047 15,991 229 ($27,758.91) 23 ($11,766.83) 1 ($14.92) 31 42
2023-08-22 2,930,526 2,936,910 6,385 304 73 23 5 5,043 15,907 250 ($16,434.76) 28 ($9,217.96) 4 ($150.79) 29 28
2023-08-21 2,926,126 2,930,525 4,400 354 83 23 4 5,038 12,462 236 ($30,289.27) 23 ($11,609.33) 25 38
2023-08-20 2,921,821 2,926,125 4,305 619 82 23 6 5,034 15,139 579 ($71,544.28) 21 ($23,005.20) 5 ($870.15) 26 91
2023-08-19 2,917,564 2,921,820 4,257 426 70 25 5 5,030 12,949 196 ($9,375.85) 24 ($5,681.93) 1 ($0.57) 25 79
2023-08-18 2,913,411 2,917,563 4,153 1,737 83 20 5 5,026 25,684 2,694 ($21,915.97) 28 ($11,905.87) 39 108
2023-08-17 2,909,114 2,913,410 4,297 1,479 90 25 8 5,023 23,405 2,189 ($14,552.78) 21 ($12,198.70) 36 101
2023-08-16 2,904,667 2,909,113 4,447 490 76 23 4 5,016 13,976 234 ($19,009.12) 26 ($11,501.18) 2 ($861.59) 33 106
2023-08-15 2,900,252 2,904,666 4,415 466 79 6 5,012 13,592 220 ($234,686.91) 24 ($226,247.18) 28 94
2023-08-14 2,895,940 2,900,251 4,312 455 77 22 5 5,006 13,344 187 ($16,325.18) 15 ($7,969.03) 2 ($1,832.51) 19 91
2023-08-13 2,891,501 2,895,939 4,439 428 72 19 5 5,001 13,253 209 ($26,368.44) 17 ($11,043.80) 2 ($379.99) 19 81
2023-08-12 2,887,137 2,891,500 4,364 432 74 19 5 4,996 13,074 177 ($6,922.89) 9 ($1,804.44) 18 108
2023-08-11 2,882,829 2,887,136 4,308 458 72 22 6 4,992 13,287 213 ($17,795.52) 16 ($30,308.80) 1 ($12.76) 17 101
2023-08-10 2,878,409 2,882,828 4,420 398 67 19 6 4,986 12,906 139 ($504,217.24) 9 ($501,300.08) 1 ($156.51) 13 90
2023-08-09 2,873,941 2,878,408 4,468 428 69 26 5 4,981 13,243 141 ($4,551.82) 13 ($1,948.07) 1 ($1,169.94) 26 83
2023-08-08 2,869,484 2,873,940 4,457 544 74 25 10 4,977 14,053 174 ($74,960.14) 10 ($46,870.92) 12 ($25,114.81) 11 98
2023-08-07 2,863,774 2,869,483 5,710 312 85 22 5 4,967 14,568 172 ($11,058.19) 22 ($9,522.35) 3 ($1,358.49) 22 39
2023-08-06 2,857,428 2,863,773 6,346 311 85 21 4 4,962 15,978 273 ($21,522.50) 31 ($10,316.17) 4 ($3,554.70) 33 21
2023-08-05 2,851,102 2,857,427 6,326 331 80 25 7 4,959 15,999 231 ($395,638.86) 21 ($387,675.45) 9 ($6,586.17) 30 34
2023-08-04 2,845,001 2,851,101 6,101 362 88 22 7 4,953 15,950 302 ($92,077.81) 26 ($73,627.08) 7 ($5,272.99) 42 39
2023-08-03 2,839,052 2,845,000 5,949 299 77 29 11 4,946 15,045 209 ($100,133.62) 34 ($99,786.03) 7 ($23,283.17) 55 31
2023-08-02 2,832,935 2,839,051 6,117 241 68 25 6 4,937 14,756 146 ($4,680.73) 19 ($2,982.75) 6 ($1,935.08) 33 24
2023-08-01 2,826,888 2,832,934 6,047 285 77 24 5 4,932 14,743 202 ($82,841.20) 25 ($75,873.46) 10 ($26,119.84) 19 16

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

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