Skip to content

Latest commit

 

History

History
204 lines (157 loc) · 10.2 KB

2022-09-30.md

File metadata and controls

204 lines (157 loc) · 10.2 KB

polkadot Summary (Daily)

Source: polkadot.polkaholic.io

Relay Chain: polkadot Para ID: 0

Daily Summary for Month ending in 2022-09-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-09-30 12,267,599 12,281,996 14,398 7,036 3,676 1,063,062 441,670 5,937 ($65,307,466.39) 402 ($607,319.10) 371 ($1,100,002.65) 431 394
2022-09-29 12,253,203 12,267,598 14,396 8,072 4,097 1,062,344 444,269 6,966 ($59,574,002.51) 884 ($2,371,802.67) 769 ($1,636,209.21) 973 842
2022-09-28 12,238,812 12,253,202 14,391 6,471 3,316 1,061,596 431,999 5,176 ($32,102,658.02) 105 ($214,469.29) 192 ($238,263.76) 120 200
2022-09-27 12,224,490 12,238,811 14,322 7,014 3,550 1,061,151 432,953 5,452 ($44,415,947.59) 111 ($578,955.35) 172 ($532,587.28) 114 173
2022-09-26 12,210,112 12,224,489 14,378 6,906 3,449 1,060,794 433,219 5,413 ($44,120,342.88) 93 ($334,924.57) 175 ($349,273.43) 68 160
2022-09-25 12,195,733 12,210,111 14,379 5,797 2,963 1,060,321 424,664 4,426 ($21,317,575.68) 105 ($309,698.55) 229 ($435,826.88) 116 232
2022-09-24 12,181,345 12,195,732 14,388 6,038 3,072 1,059,894 426,412 4,597 ($24,823,350.37) 83 ($277,743.37) 192 ($515,840.07) 93 197
2022-09-23 12,166,951 12,181,344 14,394 6,763 3,497 1,059,420 432,439 5,448 ($38,182,173.30) 123 ($305,010.18) 244 ($517,086.84) 139 253
2022-09-22 12,152,554 12,166,950 14,397 7,393 3,649 1,058,967 439,452 5,846 ($38,437,076.33) 115 ($404,154.44) 265 ($1,824,564.26) 127 270
2022-09-21 12,138,159 12,152,553 14,395 7,030 3,543 1,058,423 433,402 6,170 ($106,649,860.06) 144 ($567,630.45) 299 ($1,470,430.56) 211 341
2022-09-20 12,123,768 12,138,158 14,391 6,505 3,160 1,057,913 427,884 5,907 ($34,601,883.94) 115 ($1,285,831.56) 324 ($495,008.07) 182 377
2022-09-19 12,109,395 12,123,767 14,373 9,053 4,157 1,057,320 450,689 8,561 ($129,522,350.21) 139 ($213,702.15) 393 ($1,218,069.66) 172 422
2022-09-18 12,094,996 12,109,394 14,399 6,726 3,348 1,056,671 425,322 5,493 ($68,404,805.14) 106 ($360,911.49) 240 ($646,134.60) 120 242
2022-09-17 12,080,601 12,094,995 14,395 6,199 3,303 1,056,242 425,749 4,753 ($28,353,242.99) 99 ($350,232.07) 231 ($1,124,388.36) 118 237
2022-09-16 12,066,242 12,080,600 14,359 7,552 3,749 1,055,749 419,531 5,983 ($156,601,701.19) 132 ($218,899.80) 320 ($462,842.47) 161 339
2022-09-15 12,051,849 12,066,241 14,393 7,169 3,742 1,055,247 410,025 5,763 ($102,483,904.91) 106 ($767,681.63) 240 ($1,169,630.26) 137 263
2022-09-14 12,037,455 12,051,848 14,394 6,737 3,468 1,054,807 407,061 5,458 ($39,150,802.04) 102 ($1,556,775.89) 171 ($273,306.08) 128 192
2022-09-13 12,023,061 12,037,454 14,394 6,834 3,437 1,054,302 412,269 5,531 ($75,306,754.49) 99 ($268,015.71) 172 ($443,424.01) 122 182
2022-09-12 12,008,668 12,023,060 14,393 6,999 3,622 1,053,783 404,652 5,564 ($77,924,874.07) 138 ($755,983.31) 202 ($440,359.96) 152 212
2022-09-11 11,994,271 12,008,667 14,397 6,117 3,313 1,053,405 399,937 4,623 ($15,864,957.40) 140 ($101,913.35) 164 ($152,825.85) 156 176
2022-09-10 11,979,875 11,994,270 14,396 6,389 3,348 1,053,021 401,854 4,937 ($20,063,151.91) 85 ($366,917.41) 165 ($267,175.00) 101 179
2022-09-09 11,965,479 11,979,874 14,396 7,444 3,890 1,052,649 408,868 5,968 ($37,943,158.59) 124 ($263,567.30) 211 ($393,579.58) 144 218
2022-09-08 11,951,083 11,965,478 14,396 6,504 3,415 1,052,254 404,704 5,197 ($37,226,799.38) 92 ($221,615.32) 218 ($484,218.31) 124 239
2022-09-07 11,936,686 11,951,082 14,397 7,020 3,543 1,051,889 399,174 5,727 ($36,214,625.26) 98 ($63,536.84) 249 ($488,837.99) 107 252
2022-09-06 11,922,316 11,936,685 14,370 8,553 5,157 1,051,384 414,224 7,185 ($39,907,666.68) 114 ($701,431.12) 209 ($1,917,996.13) 131 221
2022-09-05 11,908,024 11,922,315 14,292 6,579 3,402 1,050,865 405,279 5,064 ($41,147,411.71) 101 ($302,701.72) 217 ($696,053.32) 110 222
2022-09-04 11,893,745 11,908,023 14,279 5,435 2,854 1,050,419 393,522 4,167 ($25,010,064.82) 84 ($219,786.98) 237 ($825,230.27) 97 245
2022-09-03 11,879,474 11,893,744 14,271 5,425 2,806 1,049,942 397,169 4,157 ($10,243,832.73) 74 ($395,650.10) 165 ($384,649.41) 87 173
2022-09-02 11,865,201 11,879,473 14,273 6,487 3,339 1,049,531 396,803 5,081 ($41,309,085.45) 107 ($1,012,541.44) 184 ($1,064,748.68) 118 191
2022-09-01 11,850,941 11,865,200 14,260 6,562 3,451 1,049,112 401,604 5,118 ($18,836,729.63) 70 ($325,331.58) 201 ($734,541.68) 90 215

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.blocks0`  
 where LAST_DAY(date(block_time)) = "2022-09-30" 
 group by logDT 
 order by logDT

Signed Extrinsics

Schema

SELECT date(block_time) as logDT, 
COUNT(*) numSignedExtrinsics 
FROM `bigquery-public-data.crypto_polkadot.extrinsics0`  
where signed and LAST_DAY(date(block_time)) = "2022-09-30" 
group by logDT 
order by logDT

Active Accounts

Schema

SELECT date(ts) as logDT, 
 COUNT(*) numActiveAccounts 
 FROM `bigquery-public-data.crypto_polkadot.accountsactive0` 
 where LAST_DAY(date(ts)) = "2022-09-30" 
 group by logDT 
 order by logDT

Passive Accounts

Schema

SELECT date(ts) as logDT, 
 COUNT(*) numPassiveAccounts 
 FROM `bigquery-public-data.crypto_polkadot.accountspassive0` 
 where LAST_DAY(date(ts)) = "2022-09-30" 
 group by logDT 
 order by logDT

New Accounts

Schema

SELECT date(ts) as logDT, 
 COUNT(*) numNewAccounts 
 FROM `bigquery-public-data.crypto_polkadot.accountsnew0` 
 where LAST_DAY(date(ts)) = "2022-09-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.balances0` 
 where LAST_DAY(date(ts)) = "2022-09-30" 
 group by logDT 
 order by logDT

Events

Schema

SELECT date(block_time) as logDT, 
 COUNT(*) numEvents 
 FROM `bigquery-public-data.crypto_polkadot.events0` 
 where LAST_DAY(date(block_time)) = "2022-09-30" 
 group by logDT 
 order by logDT

Transfers:

Schema

SELECT date(block_time) as logDT, 
 COUNT(*) numEvents 
 FROM `bigquery-public-data.crypto_polkadot.transfers0` 
 where LAST_DAY(date(block_time)) = "2022-09-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 = 0 and LAST_DAY(date(origination_ts)) = "2022-09-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 = 0 and LAST_DAY(date(origination_ts)) = "2022-09-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 = 0 and LAST_DAY(date(origination_ts)) = "2022-09-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 = 0 and LAST_DAY(date(origination_ts)) = "2022-09-30" 
 group by logDT 
order by logDT

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