Skip to content

Latest commit

 

History

History
204 lines (157 loc) · 8.97 KB

2022-11-30.md

File metadata and controls

204 lines (157 loc) · 8.97 KB

bifrost Summary (Daily)

Source: bifrost.polkaholic.io

Relay Chain: polkadot Para ID: 2030

Daily Summary for Month ending in 2022-11-30

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
2022-11-30 1,205,664 1,212,433 6,770 270 53 3,181 16,024 178 20 ($2,874.31) 5 ($65.35) 21 22
2022-11-29 1,198,950 1,205,663 6,714 334 65 3,173 16,571 204 33 ($11,526.31) 6 ($1,645.56) 33 23
2022-11-28 1,192,123 1,198,949 6,827 298 56 3,165 16,553 326 35 ($12,857.97) 4 ($2,377.32) 35 13
2022-11-27 1,185,395 1,192,122 6,728 215 53 3,160 15,503 148 23 ($2,094.21) 2 ($401.51) 23 12
2022-11-26 1,178,550 1,185,394 6,845 171 57 3,158 15,363 132 23 ($7,548.49) 1 23 10
2022-11-25 1,171,625 1,178,549 6,925 297 59 3,153 16,466 106 21 ($35,165.78) 4 ($56.84) 23 15
2022-11-24 1,164,723 1,171,624 6,902 271 65 3,150 16,344 176 ($57.77) 26 ($3,495.57) 1 ($0.03) 26 18
2022-11-23 1,157,843 1,164,722 6,880 333 73 3,142 16,779 252 32 ($18,882.23) 2 ($5.63) 32 17
2022-11-22 1,151,003 1,157,842 6,840 480 79 3,129 17,993 297 40 ($64,358.70) 9 ($13,989.58) 40 28
2022-11-21 1,144,156 1,151,002 6,847 298 82 3,116 16,478 218 72 ($12,729.64) 36 ($7,620.70) 72 43
2022-11-20 1,137,323 1,144,155 6,833 153 62 2,189 14,961 136 8 ($2,464.17) 2 ($4,949.68) 8 3
2022-11-19 1,130,468 1,137,322 6,855 124 46 3,100 14,857 125 7 ($4,507.56) 3 ($1,091.15) 7 4
2022-11-18 1,123,595 1,130,467 6,873 269 57 3,099 15,916 110 6 ($1,423.84) 4 ($244.51) 6 13
2022-11-17 1,117,142 1,123,594 6,453 177 57 3,097 14,486 159 15 ($4,084.65) 4 ($1,196.21) 15 14
2022-11-16 1,114,815 1,117,141 2,327 222 65 3,091 6,606 178 19 ($13,242.83) 13 ($1,738.83) 19 17
2022-11-15 1,109,763 1,114,814 5,052 213 63 3,075 11,973 222 19 ($7,676.89) 8 ($249.18) 19 12
2022-11-14 1,102,858 1,109,762 6,905 279 70 3,052 16,203 293 23 ($2,643.19) 10 ($5,352.49) 26 15
2022-11-13 1,096,000 1,102,857 6,858 187 54 3,038 15,316 169 11 ($5,043.07) 3 ($1,485.67) 11 5
2022-11-12 1,089,046 1,095,999 6,954 104 34 3,022 14,864 90 9 ($4,578.72) 1 ($289.51) 11 3
2022-11-11 1,082,125 1,089,045 6,921 202 49 3,015 15,655 239 13 ($21,895.03) 5 ($298.48) 13 7
2022-11-10 1,075,210 1,082,124 6,915 188 53 3,007 15,484 205 14 ($9,891.85) 6 ($3,551.31) 14 8
2022-11-09 1,068,317 1,075,209 6,893 262 72 3,004 16,239 336 15 ($22,928.12) 13 ($11,018.11) 15 16
2022-11-08 1,061,471 1,068,316 6,846 360 75 2,996 17,081 524 18 ($11,482.49) 7 ($2,100.06) 18 8
2022-11-07 1,054,598 1,061,470 6,873 101 36 2,986 14,641 59 7 ($3,319.92) 2 ($1,946.24) 7 5
2022-11-06 1,047,718 1,054,597 6,880 84 48 2,985 14,571 93 11 ($4,972.93) 7 ($4,451.97) 11 8
2022-11-05 1,040,840 1,047,717 6,878 144 53 2,982 15,254 174 ($165.52) 15 ($27,500.73) 8 ($15,060.71) 15 9
2022-11-04 1,033,918 1,040,839 6,922 225 64 2,974 15,947 264 21 ($19,564.86) 8 ($2,232.23) 21 11
2022-11-03 1,027,173 1,033,917 6,745 379 90 2,965 17,133 463 39 ($10,747.31) 3 ($5,532.04) 39 7
2022-11-02 1,020,439 1,027,172 6,734 75 36 2,952 14,110 52 6 ($129.90) 3 ($89.35) 8 5
2022-11-01 1,013,658 1,020,438 6,781 75 46 2,947 14,234 53 7 ($735.10) 4 ($6,453.17) 7 8

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)) = "2022-11-30" 
 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)) = "2022-11-30" 
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)) = "2022-11-30" 
 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)) = "2022-11-30" 
 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)) = "2022-11-30" 
 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)) = "2022-11-30" 
 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)) = "2022-11-30" 
 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)) = "2022-11-30" 
 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)) = "2022-11-30" 
 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)) = "2022-11-30" 
 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)) = "2022-11-30" 
 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)) = "2022-11-30" 
 group by logDT 
order by logDT

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