Skip to content

Latest commit

 

History

History
205 lines (158 loc) · 10.4 KB

2022-07-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-07-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-07-31 11,394,531 11,408,744 14,214 12,797 5,932 1,029,178 410,823 11,267 ($51,266,982.90) 559 ($2,574,276.18) 2,463 ($2,683,184.03) 571 2,471
2022-07-30 11,380,274 11,394,530 14,257 11,609 5,291 1,027,371 398,065 10,074 ($40,801,445.93) 640 ($613,288.31) 2,393 ($957,447.70) 650 2,399
2022-07-29 11,365,992 11,380,273 14,282 11,881 6,005 1,026,049 406,180 10,476 ($88,809,418.41) 453 ($2,049,977.72) 1,792 ($1,945,947.70) 467 1,795
2022-07-28 11,351,686 11,365,991 14,306 9,927 4,624 1,024,766 383,515 8,274 ($113,071,869.30) 211 ($942,141.89) 444 ($1,206,745.09) 221 449
2022-07-27 11,337,387 11,351,685 14,299 8,265 3,555 1,024,004 374,425 6,853 ($57,326,517.17) 146 ($342,703.28) 315 ($405,312.63) 165 324
2022-07-26 11,323,110 11,337,386 14,277 8,358 3,628 1,023,004 379,117 6,992 ($59,552,851.51) 117 ($176,528.95) 316 ($264,276.03) 128 326
2022-07-25 11,308,815 11,323,109 14,295 8,016 3,693 1,022,033 372,662 6,489 ($71,172,816.72) 82 ($231,755.07) 278 ($404,728.42) 94 287
2022-07-24 11,294,538 11,308,814 14,277 7,319 3,265 1,021,287 365,652 5,559 ($45,797,127.54) 142 ($426,385.90) 296 ($322,086.19) 152 304
2022-07-23 11,280,296 11,294,537 14,242 7,411 3,403 1,020,422 363,413 6,107 ($44,290,239.01) 119 ($1,899,792.04) 316 ($778,556.06) 128 322
2022-07-22 11,266,089 11,280,295 14,207 9,074 4,195 1,019,512 381,196 7,127 ($56,826,339.49) 166 ($764,111.65) 387 ($2,302,054.82) 178 400
2022-07-21 11,251,889 11,266,088 14,200 9,097 4,530 1,018,586 380,844 7,623 ($82,270,045.24) 134 ($524,494.18) 258 ($2,715,941.88) 144 265
2022-07-20 11,237,714 11,251,888 14,175 10,047 5,047 1,018,491 380,959 8,412 ($85,473,521.99) 167 ($862,834.43) 300 ($1,295,273.93) 179 306
2022-07-19 11,223,498 11,237,713 14,216 11,716 4,718 1,018,353 391,448 10,146 ($81,746,149.44) 165 ($2,152,349.65) 337 ($1,289,157.50) 179 345
2022-07-18 11,209,297 11,223,497 14,201 9,988 4,746 1,017,400 377,193 8,674 ($58,388,086.82) 187 ($1,203,516.04) 281 ($1,583,867.10) 198 284
2022-07-17 11,195,094 11,209,296 14,203 8,327 3,670 1,016,561 372,001 6,418 ($23,331,251.57) 115 ($1,142,466.49) 241 ($1,993,820.18) 121 243
2022-07-16 11,180,878 11,195,093 14,216 7,837 3,576 1,015,629 351,606 6,521 ($20,181,412.35) 126 ($514,215.12) 259 ($406,398.14) 134 261
2022-07-15 11,166,698 11,180,877 14,180 9,010 4,173 1,014,653 371,887 7,006 ($49,068,595.39) 142 ($3,260,454.87) 253 ($2,835,722.81) 146 254
2022-07-14 11,152,553 11,166,697 14,145 9,194 4,155 1,013,915 371,736 7,639 ($59,432,026.86) 133 ($467,338.11) 309 ($398,317.11) 138 312
2022-07-13 11,138,399 11,152,552 14,154 7,778 3,746 1,013,014 365,895 6,488 ($55,130,157.44) 129 ($531,711.31) 342 ($463,007.36) 135 344
2022-07-12 11,124,265 11,138,398 14,134 9,127 4,067 1,012,262 364,256 7,587 ($61,319,506.76) 155 ($920,423.83) 386 ($482,394.97) 164 393
2022-07-11 11,110,074 11,124,264 14,191 8,325 3,840 1,011,369 368,052 6,841 ($48,843,926.82) 127 ($585,936.62) 255 ($1,033,554.70) 132 256
2022-07-10 11,095,881 11,110,073 14,193 7,623 3,447 1,010,516 358,646 6,161 ($35,902,198.31) 100 ($846,423.72) 248 ($924,470.49) 105 250
2022-07-09 11,081,771 11,095,880 14,110 7,106 3,417 1,009,659 356,585 5,717 ($16,143,177.15) 98 ($163,504.87) 211 ($343,068.05) 112 214
2022-07-08 11,067,658 11,081,770 14,113 8,664 3,891 1,008,894 366,807 7,140 ($41,855,280.07) 125 ($984,565.81) 232 ($975,638.96) 135 237
2022-07-07 11,053,569 11,067,657 14,089 9,649 4,478 1,007,803 374,792 8,133 ($51,564,201.51) 170 ($1,115,545.80) 300 ($805,051.94) 182 303
2022-07-06 11,039,469 11,053,568 14,100 8,958 3,922 1,006,600 369,881 7,422 ($179,678,945.61) 117 ($764,751.78) 259 ($635,392.06) 132 268
2022-07-05 11,025,397 11,039,468 14,072 9,337 3,728 1,005,389 371,627 7,883 ($58,623,969.64) 95 ($272,190.70) 313 ($579,412.76) 102 314
2022-07-04 11,011,326 11,025,396 14,071 8,658 3,422 1,004,020 361,717 7,191 ($29,796,943.80) 87 ($1,185,470.17) 253 ($419,274.94) 94 255
2022-07-03 10,997,277 11,011,325 14,049 8,527 3,227 1,002,448 361,808 7,051 ($18,758,562.53) 122 ($397,382.26) 237 ($387,978.89) 129 238
2022-07-02 10,983,269 10,997,276 14,008 11,573 3,797 1,000,817 382,775 10,083 ($66,469,915.64) 152 ($750,917.61) 336 ($873,000.53) 162 338
2022-07-01 10,969,142 10,983,268 14,127 9,984 3,818 998,193 374,891 8,549 ($92,195,483.09) 169 ($1,951,376.84) 371 ($1,813,790.24) 183 379

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-07-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-07-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-07-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-07-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-07-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-07-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-07-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-07-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-07-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-07-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-07-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-07-31" 
 group by logDT 
order by logDT

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