2022-02-28.md

polkadot Summary (Daily)

Source: polkadot.polkaholic.io

Relay Chain: polkadot Para ID: 0

Daily Summary for Month ending in 2022-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
2022-02-28	9,216,568	9,230,962	14,395	11,128	4,715			910,831	231,356	11,651 ($229,341,456.93)
2022-02-27	9,202,172	9,216,567	14,396	9,064	4,143			908,871	221,842	9,234 ($65,199,612.96)
2022-02-26	9,187,796	9,202,171	14,376	10,236	4,705			905,926	225,823	9,730 ($261,517,390.26)
2022-02-25	9,173,461	9,187,795	14,335	10,478	5,072			905,729	223,063	9,750 ($250,006,700.91)
2022-02-24	9,159,064	9,173,460	14,397	16,219	6,779			904,558	272,553	16,011 ($262,571,800.17)
2022-02-23	9,144,667	9,159,063	14,397	13,748	6,983			902,831	254,315	13,526 ($119,931,275.77)
2022-02-22	9,130,267	9,144,666	14,400	14,574	7,420			901,456	258,696	14,120 ($798,877,139.77)
2022-02-21	9,115,869	9,130,266	14,398	12,572	5,761			901,233	246,780	11,990 ($140,795,271.68)
2022-02-20	9,101,472	9,115,868	14,397	12,630	5,690			899,899	240,388	11,975 ($109,985,980.83)
2022-02-19	9,087,073	9,101,471	14,399	12,541	6,925			898,574	243,564	11,964 ($69,984,282.61)
2022-02-18	9,072,704	9,087,072	14,369	10,706	5,038			899,410	221,422	10,076 ($106,979,676.63)
2022-02-17	9,058,321	9,072,703	14,383	10,342	5,010			898,357	222,413	9,786 ($118,760,391.14)
2022-02-16	9,043,925	9,058,320	14,396	10,817	5,202			897,553	227,192	10,189 ($59,595,220.69)
2022-02-15	9,029,526	9,043,924	14,399	11,550	5,656			896,360	233,332	10,780 ($153,818,860.64)
2022-02-14	9,015,128	9,029,525	14,398	9,977	4,861			895,131	219,497	9,407 ($79,662,540.93)
2022-02-13	9,000,729	9,015,127	14,399	10,021	4,831			893,828	223,995	9,384 ($52,835,883.09)
2022-02-12	8,986,330	9,000,728	14,399	10,506	4,939			892,744	228,055	10,097 ($60,916,553.78)
2022-02-11	8,971,931	8,986,329	14,399	14,362	7,031			891,761	258,241	14,256 ($160,896,893.77)
2022-02-10	8,957,537	8,971,930	14,394	14,797	7,014			891,232	263,235	14,576 ($223,103,252.18)
2022-02-09	8,943,142	8,957,536	14,395	15,070	7,552			889,788	256,788	15,305 ($138,471,419.40)
2022-02-08	8,928,757	8,943,141	14,385	16,509	9,861			888,223	278,034	16,500 ($184,307,004.26)
2022-02-07	8,914,361	8,928,756	14,396	18,528	8,339			889,895	308,461	15,319 ($201,398,114.96)
2022-02-06	8,899,963	8,914,360	14,398	9,816	4,804			890,287	222,805	9,525 ($52,072,085.79)
2022-02-05	8,885,570	8,899,962	14,393	11,028	5,287			889,029	233,690	10,656 ($77,007,101.17)
2022-02-04	8,871,178	8,885,569	14,392	10,781	5,108			887,677	229,864	10,406 ($171,845,554.56)
2022-02-03	8,856,786	8,871,177	14,392	11,757	5,771			886,319	240,882	11,630 ($140,962,998.65)
2022-02-02	8,842,395	8,856,785	14,391	12,340	6,550			884,930	245,434	12,157 ($123,888,204.39)
2022-02-01	8,828,006	8,842,394	14,389	17,980	11,056			884,663	299,204	17,927 ($734,375,842.60)

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

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