Skip to content

Latest commit

 

History

History
205 lines (158 loc) · 9.01 KB

2020-12-31.md

File metadata and controls

205 lines (158 loc) · 9.01 KB

polkadot Summary (Daily)

Source: polkadot.polkaholic.io

Relay Chain: polkadot Para ID: 0

Daily Summary for Month ending in 2020-12-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
2020-12-31 3,130,687 3,144,987 14,301 9,663 3,535 63,247 73,885 10,251 ($822,512,582.53)
2020-12-30 3,116,403 3,130,686 14,284 7,518 3,593 61,501 64,136 7,554 ($637,734,121.65)
2020-12-29 3,102,076 3,116,402 14,327 9,118 4,052 60,516 73,401 9,075 ($820,751,910.38)
2020-12-28 3,087,754 3,102,075 14,322 12,619 8,354 59,505 94,866 11,620 ($2,707,667,871.27)
2020-12-27 3,073,425 3,087,753 14,329 4,030 2,051 64,387 42,131 3,331 ($214,694,106.14)
2020-12-26 3,059,081 3,073,424 14,344 3,246 1,792 63,707 36,715 2,635 ($105,032,525.49)
2020-12-25 3,044,741 3,059,080 14,340 2,997 1,676 63,082 35,755 2,372 ($124,507,447.88)
2020-12-24 3,030,388 3,044,740 14,353 3,713 1,880 62,527 39,705 3,076 ($255,834,647.15)
2020-12-23 3,016,044 3,030,387 14,344 4,520 2,263 61,775 44,375 3,745 ($264,081,515.73)
2020-12-22 3,001,698 3,016,043 14,346 4,627 2,160 60,868 45,240 3,722 ($357,638,845.49)
2020-12-21 2,987,344 3,001,697 14,354 3,950 2,160 59,757 44,741 3,312 ($378,025,214.92)
2020-12-20 2,972,988 2,987,343 14,356 3,175 1,841 59,378 37,342 2,530 ($92,228,722.90)
2020-12-19 2,958,624 2,972,987 14,364 3,375 1,872 58,864 37,478 2,545 ($191,231,564.90)
2020-12-18 2,944,274 2,958,623 14,350 3,098 1,965 58,303 35,777 2,503 ($165,790,436.00)
2020-12-17 2,929,931 2,944,273 14,343 3,535 2,037 57,932 40,479 2,995 ($205,313,199.64)
2020-12-16 2,915,606 2,929,930 14,325 3,006 1,827 57,385 36,383 2,217 ($313,993,757.41)
2020-12-15 2,901,288 2,915,605 14,318 5,335 1,894 56,939 50,379 2,276 ($354,520,072.98)
2020-12-14 2,886,960 2,901,287 14,328 2,624 1,714 56,418 34,274 1,803 ($126,718,323.95)
2020-12-13 2,872,633 2,886,959 14,327 2,243 1,474 55,982 32,250 1,586 ($81,738,069.46)
2020-12-12 2,858,311 2,872,632 14,322 2,220 1,534 55,694 32,139 1,690 ($54,197,564.11)
2020-12-11 2,843,982 2,858,310 14,329 2,591 1,694 55,439 34,545 1,879 ($353,372,192.14)
2020-12-10 2,829,654 2,843,981 14,328 2,245 1,459 55,147 32,374 1,660 ($49,416,868.37)
2020-12-09 2,815,362 2,829,653 14,292 2,764 1,582 54,873 35,378 2,007 ($146,101,656.63)
2020-12-08 2,801,054 2,815,361 14,308 2,934 1,794 54,509 35,908 2,343 ($109,928,746.96)
2020-12-07 2,786,741 2,801,053 14,313 2,689 1,681 54,079 39,601 1,925 ($166,603,676.64)
2020-12-06 2,772,404 2,786,740 14,337 2,239 1,564 53,741 32,609 1,706 ($89,131,443.55)
2020-12-05 2,758,037 2,772,403 14,367 2,898 1,730 53,398 35,815 2,281 ($138,617,877.23)
2020-12-04 2,743,667 2,758,036 14,370 2,928 1,798 52,977 36,996 2,216 ($155,096,010.06)
2020-12-03 2,729,314 2,743,666 14,353 2,712 1,762 52,565 35,027 2,104 ($93,242,492.99)
2020-12-02 2,714,951 2,729,313 14,363 2,998 1,932 52,163 37,177 2,318 ($211,362,679.09)
2020-12-01 2,700,565 2,714,950 14,386 3,756 1,880 51,898 40,970 2,942 ($232,151,466.37)

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

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