Skip to content

Latest commit

 

History

History
205 lines (158 loc) · 9.07 KB

2021-07-31.md

File metadata and controls

205 lines (158 loc) · 9.07 KB

polkadot Summary (Daily)

Source: polkadot.polkaholic.io

Relay Chain: polkadot Para ID: 0

Daily Summary for Month ending in 2021-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
2021-07-31 6,170,589 6,184,984 14,396 11,013 5,505 416,520 99,884 11,657 ($247,654,783.94)
2021-07-30 6,156,194 6,170,588 14,395 10,574 5,328 414,679 94,692 11,398 ($301,776,832.92)
2021-07-29 6,141,802 6,156,193 14,392 9,577 4,965 412,890 87,375 9,587 ($222,182,203.63)
2021-07-28 6,127,422 6,141,801 14,380 10,109 5,149 411,368 89,578 10,285 ($225,724,699.71)
2021-07-27 6,113,028 6,127,421 14,394 9,484 4,752 410,021 88,149 9,015 ($332,311,300.87)
2021-07-26 6,098,630 6,113,027 14,398 13,313 6,417 408,944 107,420 12,758 ($686,244,767.83)
2021-07-25 6,084,232 6,098,629 14,398 8,158 4,231 408,068 77,107 7,249 ($182,390,246.43)
2021-07-24 6,069,832 6,084,231 14,400 10,131 4,870 407,215 88,322 9,241 ($210,779,200.12)
2021-07-23 6,055,436 6,069,831 14,396 9,437 4,483 406,182 83,924 8,600 ($278,968,683.58)
2021-07-22 6,041,041 6,055,435 14,395 10,126 4,744 405,202 87,223 9,229 ($229,510,944.16)
2021-07-21 6,026,644 6,041,040 14,397 11,497 5,338 404,004 94,831 10,620 ($303,831,350.14)
2021-07-20 6,012,248 6,026,643 14,396 12,787 6,209 402,905 106,447 12,685 ($281,842,220.98)
2021-07-19 5,997,852 6,012,247 14,396 13,011 5,915 401,549 105,825 12,407 ($290,330,747.21)
2021-07-18 5,983,453 5,997,851 14,399 7,481 3,916 400,379 73,278 6,718 ($151,085,136.92)
2021-07-17 5,969,054 5,983,452 14,399 9,955 4,845 399,163 85,801 9,583 ($124,548,902.45)
2021-07-16 5,954,662 5,969,053 14,392 11,145 5,338 397,805 94,485 10,827 ($274,453,270.58)
2021-07-15 5,940,265 5,954,661 14,397 10,356 5,145 396,408 89,199 10,258 ($245,116,093.35)
2021-07-14 5,925,867 5,940,264 14,398 10,843 5,326 395,157 92,009 10,843 ($544,348,250.78)
2021-07-13 5,911,471 5,925,866 14,396 9,970 5,387 393,995 89,909 10,343 ($204,107,288.94)
2021-07-12 5,897,073 5,911,470 14,398 8,485 4,574 393,298 78,559 9,084 ($632,793,062.80)
2021-07-11 5,882,677 5,897,072 14,396 5,042 2,789 392,361 57,914 4,085 ($52,331,512.42)
2021-07-10 5,868,282 5,882,676 14,395 5,369 2,931 391,961 59,261 4,345 ($113,351,424.36)
2021-07-09 5,853,890 5,868,281 14,392 6,327 3,259 391,549 64,825 5,458 ($316,618,602.22)
2021-07-08 5,839,502 5,853,889 14,388 8,936 4,336 391,077 82,412 9,411 ($235,162,052.31)
2021-07-07 5,825,107 5,839,501 14,395 10,167 4,928 389,837 93,455 11,011 ($290,314,415.01)
2021-07-06 5,810,711 5,825,106 14,396 8,366 4,261 387,956 80,511 8,528 ($408,317,043.85)
2021-07-05 5,796,315 5,810,710 14,396 7,926 4,095 386,795 75,210 7,665 ($137,416,610.44)
2021-07-04 5,781,917 5,796,314 14,398 8,039 4,069 385,896 76,104 7,700 ($114,468,647.04)
2021-07-03 5,767,520 5,781,916 14,397 8,035 4,038 384,879 75,192 7,873 ($126,859,506.87)
2021-07-02 5,753,148 5,767,519 14,372 9,354 4,589 383,804 83,455 9,240 ($149,745,734.05)
2021-07-01 5,738,775 5,753,147 14,373 9,859 5,692 382,955 95,544 9,166 ($187,096,879.78)

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

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