Skip to content

Latest commit

 

History

History
202 lines (155 loc) · 10.1 KB

2023-02-28.md

File metadata and controls

202 lines (155 loc) · 10.1 KB

polkadot Summary (Daily)

Source: polkadot.polkaholic.io

Relay Chain: polkadot Para ID: 0

Daily Summary for Month ending in 2023-02-28

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-02-28 14,438,079 14,452,425 14,347 8,727 4,775 1,903 989 1,072,616 593,276 7,450 ($55,059,718.91) 163 ($1,173,869.78) 253 ($419,297.03) 179 259
2023-02-27 14,423,695 14,438,078 14,384 8,302 4,643 1,753 993 1,072,093 577,793 6,983 ($230,703,259.55) 182 ($1,841,322.94) 231 ($903,850.98) 203 245
2023-02-26 14,409,307 14,423,694 14,388 8,496 4,758 1,799 969 1,071,560 578,388 7,078 ($24,424,988.73) 209 ($412,471.65) 316 ($788,007.34) 248 338
2023-02-25 14,394,916 14,409,306 14,391 8,124 4,489 1,724 931 1,071,079 585,883 6,764 ($24,062,474.38) 235 ($521,754.72) 288 ($1,470,019.78) 268 312
2023-02-24 14,380,544 14,394,915 14,372 9,621 5,365 1,990 1,102 1,070,646 586,378 8,428 ($37,103,792.59) 189 ($335,373.09) 282 ($301,513.28) 216 297
2023-02-23 14,366,173 14,380,543 14,371 8,719 4,710 1,641 1,009 1,070,135 585,916 7,173 ($47,851,886.89) 182 ($495,789.49) 309 ($346,694.22) 208 323
2023-02-22 14,351,794 14,366,172 14,379 8,604 4,826 1,634 973 1,069,628 566,150 7,280 ($36,438,997.26) 211 ($724,622.89) 273 ($697,839.03) 250 294
2023-02-21 14,337,422 14,351,793 14,372 9,222 5,064 1,754 1,119 1,069,189 562,745 7,781 ($226,874,378.21) 225 ($500,387.86) 305 ($428,497.17) 265 336
2023-02-20 14,323,039 14,337,421 14,383 10,164 5,558 1,925 1,196 1,068,684 571,517 8,641 ($44,220,501.16) 276 ($1,468,000.59) 381 ($1,281,368.17) 305 402
2023-02-19 14,308,657 14,323,038 14,382 11,900 6,388 2,224 1,481 1,068,106 586,381 10,168 ($39,998,847.98) 336 ($1,181,701.25) 324 ($528,006.87) 364 344
2023-02-18 14,294,268 14,308,656 14,389 10,294 5,685 1,854 1,187 1,067,435 575,632 8,599 ($34,810,994.51) 269 ($706,116.78) 363 ($1,109,245.52) 305 387
2023-02-17 14,279,868 14,294,267 14,400 12,478 6,650 2,153 1,311 1,066,943 589,842 10,820 ($56,411,273.47) 408 ($1,015,630.05) 323 ($578,558.42) 461 374
2023-02-16 14,265,470 14,279,867 14,398 11,371 6,134 2,143 1,313 1,066,483 587,658 9,792 ($45,655,399.38) 316 ($625,123.73) 330 ($448,006.42) 352 357
2023-02-15 14,251,073 14,265,469 14,397 10,376 5,477 2,071 1,260 1,065,885 573,304 8,861 ($69,230,454.26) 229 ($670,274.93) 331 ($645,006.55) 258 351
2023-02-14 14,236,677 14,251,072 14,396 9,456 5,038 2,098 1,330 1,065,289 565,174 8,011 ($29,556,482.44) 258 ($1,723,559.06) 306 ($1,013,946.08) 300 331
2023-02-13 14,222,283 14,236,676 14,394 10,906 5,617 2,540 1,471 1,064,417 584,025 9,980 ($41,809,350.76) 280 ($1,795,372.66) 416 ($1,619,104.09) 325 453
2023-02-12 14,207,889 14,222,282 14,394 8,970 4,660 1,859 1,170 1,063,515 554,772 6,978 ($17,373,290.31) 202 ($897,043.91) 269 ($593,642.47) 224 284
2023-02-11 14,193,514 14,207,888 14,375 9,458 4,716 1,979 1,312 1,062,830 550,790 7,526 ($19,284,651.61) 178 ($444,885.68) 244 ($304,561.56) 200 256
2023-02-10 14,179,143 14,193,513 14,371 12,875 5,991 2,643 1,796 1,061,953 584,216 10,923 ($57,934,379.72) 251 ($631,167.87) 336 ($447,916.73) 283 353
2023-02-09 14,164,752 14,179,142 14,391 11,393 5,546 2,707 1,245 1,060,734 577,486 10,542 ($65,863,850.32) 457 ($991,532.39) 527 ($772,014.76) 532 585
2023-02-08 14,150,370 14,164,751 14,382 9,526 4,978 1,680 1,028 1,060,093 554,618 7,404 ($39,796,584.44) 200 ($687,422.57) 313 ($673,049.57) 225 329
2023-02-07 14,135,980 14,150,369 14,390 9,596 5,121 1,720 964 1,059,652 559,360 7,829 ($31,767,082.31) 263 ($986,263.83) 325 ($469,027.19) 317 369
2023-02-06 14,121,585 14,135,979 14,395 9,225 5,027 1,577 926 1,059,226 558,138 7,095 ($32,599,771.15) 185 ($922,036.77) 261 ($224,872.60) 224 287
2023-02-05 14,107,192 14,121,584 14,393 8,455 4,699 1,681 1,013 1,058,861 546,139 6,962 ($27,143,331.59) 227 ($2,414,459.94) 284 ($799,904.15) 260 307
2023-02-04 14,092,805 14,107,191 14,387 8,634 4,771 1,713 1,024 1,058,395 547,786 6,991 ($39,637,234.84) 256 ($2,565,542.42) 273 ($451,641.35) 282 286
2023-02-03 14,078,410 14,092,804 14,395 11,179 5,702 1,842 1,034 1,057,936 569,985 9,000 ($69,517,031.86) 297 ($801,109.48) 312 ($389,043.87) 334 337
2023-02-02 14,064,017 14,078,409 14,393 11,540 6,053 2,145 1,311 1,057,525 577,770 9,759 ($54,107,175.80) 265 ($669,138.84) 289 ($621,509.49) 303 318
2023-02-01 14,049,653 14,064,016 14,364 10,381 4,889 1,969 1,068 1,057,259 562,907 7,855 ($33,488,188.92) 205 ($430,804.23) 281 ($357,879.82) 226 297

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

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