Skip to content

Latest commit

 

History

History
205 lines (158 loc) · 9.66 KB

2023-05-31.md

File metadata and controls

205 lines (158 loc) · 9.66 KB

bifrost Summary (Daily)

Source: bifrost.polkaholic.io

Relay Chain: polkadot Para ID: 2030

Daily Summary for Month ending in 2023-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
2023-05-31 2,441,722 2,447,926 6,205 575 82 31 13 4,535 17,874 256 ($28,532.12) 31 ($13,972.50) 12 ($29,786.69) 31 32
2023-05-30 2,435,566 2,441,721 6,156 669 102 30 14 4,522 18,931 333 ($80,953.57) 50 ($28,906.94) 19 ($9,570.49) 50 52
2023-05-29 2,429,407 2,435,565 6,159 550 94 27 8 4,508 17,547 252 ($16,159.96) 34 ($20,973.81) 8 ($5,002.52) 34 28
2023-05-28 2,423,297 2,429,406 6,110 526 84 26 11 4,500 17,239 294 ($43,996.94) 43 ($8,820.52) 10 ($32,829.14) 43 20
2023-05-27 2,417,163 2,423,296 6,134 476 76 24 2 4,489 16,631 189 ($55,083.27) 24 ($27,174.65) 22 ($31,947.25) 24 30
2023-05-26 2,410,982 2,417,162 6,181 540 75 9 4,489 17,040 242 ($79,962.09) 31 ($50,761.32) 4 ($11,530.08) 31 9
2023-05-25 2,404,814 2,410,981 6,168 457 74 26 7 4,481 16,452 132 ($3,001.56) 20 ($1,326.40) 15 ($906.97) 22 24
2023-05-24 2,398,525 2,404,813 6,289 523 92 26 9 4,474 17,438 207 ($11,475.79) 48 ($10,348.40) 9 ($55.12) 47 19
2023-05-23 2,392,267 2,398,524 6,258 505 78 18 3 4,466 17,178 215 ($13,613.64) 22 ($7,279.36) 13 ($1,801.83) 22 23
2023-05-22 2,385,866 2,392,266 6,401 514 77 27 12 4,464 17,575 244 ($12,625.15) 25 ($6,318.48) 9 ($39,196.87) 28 19
2023-05-21 2,379,545 2,385,865 6,321 511 4 80 7 4,452 17,518 249 ($82,610.33) 37 ($46,755.78) 7 ($1,151.59) 37 18
2023-05-20 2,373,368 2,379,544 6,177 466 4 62 9 4,446 16,684 165 ($15,322.20) 27 ($7,596.14) 3 ($13,438.48) 27 12
2023-05-19 2,367,076 2,373,367 6,292 550 79 30 7 4,437 17,816 331 ($29,540.98) 26 ($8,840.10) 7 ($982.94) 26 16
2023-05-18 2,360,847 2,367,075 6,229 551 85 22 13 4,430 17,632 292 ($28,713.24) 35 ($20,920.61) 12 ($3,937.51) 35 22
2023-05-17 2,354,559 2,360,846 6,288 488 72 26 10 4,418 17,414 463 ($39,372.27) 26 ($29,605.97) 13 ($17,498.45) 27 26
2023-05-16 2,348,302 2,354,558 6,257 335 82 27 13 4,409 15,820 237 ($8,363.69) 39 ($5,562.75) 11 ($942.22) 40 22
2023-05-15 2,342,092 2,348,301 6,210 359 78 20 12 4,396 15,974 294 ($18,686.36) 38 ($9,222.66) 15 ($8,636.94) 38 27
2023-05-14 2,335,802 2,342,091 6,290 294 76 26 10 4,385 15,451 185 ($16,337.13) 28 ($2,840.53) 7 ($3,533.79) 28 15
2023-05-13 2,329,467 2,335,801 6,335 414 87 29 15 4,375 16,718 297 ($19,729.57) 34 ($3,146.35) 8 ($13,456.35) 34 19
2023-05-12 2,323,184 2,329,466 6,283 623 99 26 19 4,361 18,399 342 ($58,956.22) 51 ($51,097.37) 31 ($4,807.46) 50 43
2023-05-11 2,316,983 2,323,183 6,201 683 100 35 15 4,343 18,614 365 ($39,680.30) 47 ($31,363.56) 19 ($3,724.66) 52 29
2023-05-10 2,310,799 2,316,982 6,184 761 106 31 15 4,328 19,204 397 ($21,113.92) 52 ($7,285.40) 39 ($7,322.88) 54 53
2023-05-09 2,304,560 2,310,798 6,239 439 87 23 3 4,314 16,604 206 ($310,651.92) 27 ($292,556.98) 16 ($13,707.79) 27 44
2023-05-08 2,298,311 2,304,559 6,249 465 92 24 6 4,311 17,212 425 ($787,551.82) 36 ($607,020.60) 33 ($151,472.88) 40 59
2023-05-07 2,292,098 2,298,310 6,213 1,394 76 9 4,305 25,172 222 ($652,479.70) 20 ($631,002.33) 17 ($6,474.83) 20 43
2023-05-06 2,285,845 2,292,097 6,253 1,314 81 5 4,297 23,610 203 ($649,126.46) 23 ($630,206.10) 19 ($3,825.09) 25 46
2023-05-05 2,279,690 2,285,844 6,155 382 72 20 3 4,293 15,944 255 ($52,922.08) 27 ($51,923.16) 17 ($12.59) 27 35
2023-05-04 2,273,560 2,279,689 6,130 362 57 23 3 4,290 15,720 255 ($54,950.87) 17 ($51,775.76) 12 ($1,102.38) 17 33
2023-05-03 2,267,250 2,273,559 6,310 350 67 20 1 4,287 15,940 211 ($36,431.59) 20 ($35,882.28) 12 ($148.09) 20 31
2023-05-02 2,260,949 2,267,249 6,301 367 71 27 7 4,286 16,168 239 ($221,005.50) 27 ($197,692.16) 13 ($23,852.27) 28 32
2023-05-01 2,254,663 2,260,948 6,286 343 82 26 6 4,279 15,861 184 ($110,913.63) 25 ($108,683.04) 10 ($1,055.01) 25 29

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

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