Skip to content

Latest commit

 

History

History
205 lines (158 loc) · 10.4 KB

2022-08-31.md

File metadata and controls

205 lines (158 loc) · 10.4 KB

polkadot Summary (Daily)

Source: polkadot.polkaholic.io

Relay Chain: polkadot Para ID: 0

Daily Summary for Month ending in 2022-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
2022-08-31 11,836,677 11,850,940 14,264 6,466 3,437 1,048,663 401,433 5,001 ($44,574,110.56) 88 ($379,666.82) 212 ($700,660.69) 103 223
2022-08-30 11,822,437 11,836,676 14,240 6,757 3,564 1,048,187 404,747 5,921 ($75,307,658.61) 122 ($273,831.42) 222 ($653,219.71) 142 237
2022-08-29 11,808,209 11,822,436 14,228 10,058 6,601 1,047,650 431,269 8,685 ($107,800,166.94) 130 ($460,669.27) 235 ($572,740.03) 206 302
2022-08-28 11,794,007 11,808,208 14,202 5,547 2,675 1,050,330 359,317 4,292 ($23,344,121.79) 84 ($228,301.47) 150 ($122,499.32) 96 156
2022-08-27 11,779,763 11,794,006 14,244 6,137 3,008 1,049,776 361,078 4,874 ($20,188,779.86) 79 ($218,469.44) 178 ($183,937.50) 92 185
2022-08-26 11,765,501 11,779,762 14,262 6,218 3,055 1,049,241 360,005 4,835 ($48,792,106.66) 102 ($992,178.24) 176 ($378,847.58) 115 184
2022-08-25 11,751,235 11,765,500 14,266 5,992 3,105 1,048,742 363,363 4,587 ($18,865,916.21) 94 ($223,643.79) 144 ($2,059,467.90) 129 177
2022-08-24 11,736,937 11,751,234 14,298 6,080 3,278 1,048,271 364,171 4,639 ($25,556,941.13) 83 ($1,028,011.76) 153 ($280,290.69) 39 72
2022-08-23 11,722,674 11,736,936 14,263 6,593 3,350 1,047,726 368,832 5,235 ($27,988,947.26) 115 ($1,384,938.41) 181 ($872,040.56) 7 29
2022-08-22 11,708,401 11,722,673 14,273 8,462 5,169 1,046,915 384,067 7,063 ($36,804,888.79) 86 ($216,756.90) 216 ($2,422,608.64) 91 214
2022-08-21 11,694,105 11,708,400 14,296 6,162 3,056 1,046,357 362,713 4,795 ($12,604,023.23) 102 ($225,621.04) 205 ($211,618.44) 111 209
2022-08-20 11,679,842 11,694,104 14,263 6,577 3,113 1,045,753 373,311 5,421 ($31,112,450.89) 94 ($748,730.94) 226 ($597,100.40) 110 235
2022-08-19 11,665,560 11,679,841 14,282 8,493 3,848 1,045,067 382,550 7,363 ($53,052,430.07) 132 ($1,347,044.09) 293 ($1,127,172.71) 141 299
2022-08-18 11,651,281 11,665,559 14,279 9,073 4,898 1,044,212 388,089 7,354 ($89,544,708.68) 131 ($821,220.42) 193 ($536,761.85) 144 197
2022-08-17 11,637,024 11,651,280 14,257 8,477 4,001 1,043,415 382,412 6,889 ($40,861,738.59) 96 ($1,369,480.40) 237 ($2,688,135.17) 107 242
2022-08-16 11,622,748 11,637,023 14,276 7,192 3,540 1,042,451 370,893 5,710 ($59,558,629.82) 155 ($274,083.29) 402 ($989,310.47) 189 422
2022-08-15 11,608,489 11,622,747 14,259 7,881 3,869 1,041,685 378,626 6,349 ($54,536,198.66) 177 ($689,635.97) 557 ($965,897.02) 186 564
2022-08-14 11,594,203 11,608,488 14,286 9,516 4,391 1,040,805 396,105 8,307 ($37,296,815.79) 549 ($4,721,892.51) 1,461 ($2,560,833.11) 563 1,471
2022-08-13 11,579,944 11,594,202 14,259 6,983 3,512 1,039,767 365,664 5,388 ($25,719,840.38) 278 ($1,263,192.95) 371 ($2,697,855.71) 290 378
2022-08-12 11,565,655 11,579,943 14,289 7,478 3,586 1,039,017 375,171 5,827 ($31,317,696.57) 259 ($2,926,840.79) 428 ($723,272.96) 297 461
2022-08-11 11,551,373 11,565,654 14,282 8,245 4,034 1,038,124 381,097 6,759 ($271,150,765.85) 299 ($5,234,805.71) 481 ($7,029,852.94) 363 536
2022-08-10 11,537,117 11,551,372 14,256 8,774 4,195 1,037,175 387,744 7,253 ($56,531,498.02) 415 ($2,028,489.93) 560 ($2,665,329.80) 499 637
2022-08-09 11,522,840 11,537,116 14,277 7,917 3,857 1,036,084 372,353 6,314 ($78,857,967.54) 304 ($792,606.84) 484 ($1,172,643.87) 332 498
2022-08-08 11,508,595 11,522,839 14,245 9,195 4,592 1,035,360 384,282 7,532 ($72,953,089.44) 321 ($1,039,935.50) 489 ($717,569.83) 339 501
2022-08-07 11,494,287 11,508,594 14,308 7,122 3,421 1,034,718 365,442 5,502 ($36,376,186.23) 261 ($490,459.06) 425 ($571,841.00) 292 451
2022-08-06 11,480,015 11,494,286 14,272 7,664 3,688 1,034,019 368,643 6,170 ($40,161,033.77) 308 ($940,794.11) 651 ($1,367,501.39) 318 657
2022-08-05 11,465,729 11,480,014 14,286 8,180 3,893 1,033,375 384,751 6,522 ($83,026,706.22) 251 ($1,602,249.53) 509 ($2,598,367.15) 265 520
2022-08-04 11,451,466 11,465,728 14,263 7,796 3,707 1,032,689 371,656 6,119 ($68,674,998.18) 243 ($985,925.74) 579 ($659,451.86) 267 601
2022-08-03 11,437,211 11,451,465 14,255 8,686 3,794 1,032,045 378,954 6,667 ($133,670,193.42) 204 ($745,717.48) 433 ($494,347.33) 216 440
2022-08-02 11,422,928 11,437,210 14,283 10,175 3,974 1,031,334 388,361 7,170 ($121,003,606.53) 539 ($4,745,812.62) 874 ($2,600,789.28) 548 879
2022-08-01 11,408,745 11,422,927 14,183 11,947 5,491 1,030,587 399,822 9,952 ($65,645,795.96) 575 ($694,830.72) 2,465 ($935,547.92) 590 2,477

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-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.extrinsics0`  
where signed and LAST_DAY(date(block_time)) = "2022-08-31" 
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-08-31" 
 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-08-31" 
 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-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.balances0` 
 where LAST_DAY(date(ts)) = "2022-08-31" 
 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-08-31" 
 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-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 = 0 and LAST_DAY(date(origination_ts)) = "2022-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 = 0 and LAST_DAY(date(origination_ts)) = "2022-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 = 0 and LAST_DAY(date(origination_ts)) = "2022-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 = 0 and LAST_DAY(date(origination_ts)) = "2022-08-31" 
 group by logDT 
order by logDT

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