0-polkadot

polkadot Summary (Monthly)

Source: polkadot.polkaholic.io

Relay Chain: polkadot Para ID: 0

Month	Start Block	End Block	# Blocks	# Signed Extrinsics (total)	# Active Accounts (avg)	# Addresses with Balances (max)	Issues
2024-08-01 to 2024-08-06	21,893,131	21,964,726	71,596	56,454		1,356,044	-
2024-07-01 to 2024-07-31	21,449,518	21,893,130	443,613	265,194		1,354,533	-
2024-06-01 to 2024-06-30	21,019,665	21,449,517	429,851	299,392		1,344,263	- 2 (0.00%)
2024-05-01 to 2024-05-31	20,575,788	21,019,664	443,875	334,230		1,333,704	- 2 (0.00%)
2024-04-01 to 2024-04-30	20,145,867	20,575,787	429,921	421,938		1,332,026	-
2024-03-01 to 2024-03-31	19,702,419	20,145,866	443,447	603,501		1,321,430	- 1 (0.00%)
2024-02-01 to 2024-02-29	19,287,776	19,702,418	414,636	437,262		1,281,031	- 7 (0.00%)
2024-01-01 to 2024-01-31	18,844,950	19,287,775	442,826	441,971		1,256,140	-
2023-12-01 to 2023-12-31	18,400,714	18,844,949	444,236	17,968,932	6,971	1,226,677	-
2023-11-01 to 2023-11-30	17,969,609	18,400,713	431,105	356,784	6,437	1,182,160	-
2023-10-01 to 2023-10-31	17,523,957	17,969,608	445,652	278,401	4,693	1,160,176	-
2023-09-01 to 2023-09-30	17,092,890	17,523,956	431,067	222,502	4,226	1,151,969	-
2023-08-01 to 2023-08-31	16,647,019	17,092,889	445,871	211,367	3,777	1,147,273	-
2023-07-01 to 2023-07-31	16,200,973	16,647,018	446,046	227,309	4,098	1,136,136	-
2023-06-01 to 2023-06-30	15,769,656	16,200,972	431,317	253,616	4,637	1,121,761	-
2023-05-01 to 2023-05-31	15,323,837	15,769,655	445,819	214,913	3,979	1,103,552	-
2023-04-01 to 2023-04-30	14,892,125	15,323,836	431,712	232,899	4,407	1,092,876	-
2023-03-01 to 2023-03-31	14,452,426	14,892,124	439,699	287,927	5,063	1,081,427	-
2023-02-01 to 2023-02-28	14,049,653	14,452,425	402,773	277,992	5,262	1,072,616	-
2023-01-01 to 2023-01-31	13,603,566	14,049,652	446,087	297,824	5,073	1,056,746	-
2022-12-01 to 2022-12-31	13,158,445	13,603,565	445,121	417,951	9,241	1,175,079	-
2022-11-01 to 2022-11-30	12,726,940	13,158,444	431,505	339,310	4,798	1,151,393	-
2022-10-01 to 2022-10-31	12,281,997	12,726,939	444,943	226,481	3,636	1,082,810	-
2022-09-01 to 2022-09-30	11,850,941	12,281,996	431,056	204,809	3,511	1,063,062	-
2022-08-01 to 2022-08-31	11,408,745	11,850,940	442,196	241,843	3,861	1,050,330	-
2022-07-01 to 2022-07-31	10,969,142	11,408,744	439,603	285,182	4,097	1,029,178	-
2022-06-01 to 2022-06-30	10,549,398	10,969,141	419,744	278,930	4,023	996,753	-
2022-05-01 to 2022-05-31	10,107,695	10,549,397	441,703	371,893	5,621	975,833	-
2022-04-01 to 2022-04-30	9,676,320	10,107,694	431,375	287,779	4,715	966,414	-
2022-03-01 to 2022-03-31	9,230,963	9,676,319	445,357	315,718	4,995	945,779	-
2022-02-01 to 2022-02-28	8,828,006	9,230,962	402,957	350,077	6,147	910,831	-
2022-01-01 to 2022-01-31	8,381,792	8,828,005	446,214	465,068	6,885	888,101	-
2021-12-01 to 2021-12-31	7,935,672	8,381,791	446,120	628,560	9,160	830,186	-
2021-11-01 to 2021-11-30	7,505,915	7,935,671	429,757	1,188,682	17,414	756,624	-
2021-10-01 to 2021-10-31	7,061,905	7,505,914	444,010	571,804	9,777	619,211	-
2021-09-01 to 2021-09-30	6,630,197	7,061,904	431,708	490,085	7,770	515,456	-
2021-08-01 to 2021-08-31	6,184,985	6,630,196	445,212	390,235	6,364	466,153	-
2021-07-01 to 2021-07-31	5,738,775	6,184,984	446,210	294,872	4,756	416,520	-
2021-06-01 to 2021-06-30	5,308,563	5,738,774	430,212	291,296	4,759	383,778	-
2021-05-01 to 2021-05-31	4,866,038	5,308,562	442,525	1,868,503	6,128	348,753	-
2021-04-01 to 2021-04-30	4,434,979	4,866,037	431,059	380,820	6,231	292,440	-
2021-03-01 to 2021-03-31	3,991,450	4,434,978	443,529	357,096	5,750	230,799	-
2021-02-01 to 2021-02-28	3,589,593	3,991,449	401,857	331,257	5,566	175,724	-
2021-01-01 to 2021-01-31	3,144,988	3,589,592	444,605	300,640	4,314	102,610	-
2020-12-01 to 2020-12-31	2,700,565	3,144,987	444,423	125,366	2,211	64,387	-
2020-11-01 to 2020-11-30	2,270,711	2,700,564	429,854	94,485	1,834	51,600	-
2020-10-01 to 2020-10-31	1,826,891	2,270,710	443,820	93,407	1,744	41,455	-
2020-09-01 to 2020-09-30	1,396,338	1,826,890	430,553	117,871	1,971	32,326	-
2020-08-01 to 2020-08-31	952,103	1,396,337	444,235	90,812	1,534	17,421	-
2020-07-01 to 2020-07-31	507,735	952,102	444,368	15,485	658	3,718	-
2020-06-01 to 2020-06-30	77,028	507,734	430,707	6,520	262	1,994	-
2020-05-26 to 2020-05-31	1	77,027	77,027	615	102	505	-

Tables:

• Blocks: bigquery-public-data.crypto_polkadot.blocks0 (date-partitioned by block_time) - Schema
• Extrinsics: bigquery-public-data.crypto_polkadot.extrinsics0 (date-partitioned by block_time) - Schema
• Events: bigquery-public-data.crypto_polkadot.events0 (date-partitioned by block_time) - Schema
• Transfers: bigquery-public-data.crypto_polkadot.transfers0 (date-partitioned by block_time) - Schema
• Balances: bigquery-public-data.crypto_polkadot.balances0 (date-partitioned by ts) - Schema
• Active Accounts: bigquery-public-data.crypto_polkadot.accountsactive0 (date-partitioned by ts) - Schema
• Passive Accounts: bigquery-public-data.crypto_polkadot.accountspassive0 (date-partitioned by ts) - Schema
• New Accounts: bigquery-public-data.crypto_polkadot.accountsnew0 (date-partitioned by ts) - Schema
• Reaped Accounts: bigquery-public-data.crypto_polkadot.accountsreaped0 (date-partitioned by ts) - Schema
• Assets: bigquery-public-data.crypto_polkadot.assets (filter on 0) - Schema
• XCM Assets: bigquery-public-data.crypto_polkadot.xcmassets (filter on para_id) - Schema
• XCM Transfers: bigquery-public-data.crypto_polkadot.xcmtransfers (filter on origination_para_id or destination_para_id, date-partitioned by origination_ts) - Schema
• XCM Messages: bigquery-public-data.crypto_polkadot.xcm (filter on origination_para_id or destination_para_id, date-partitioned by origination_ts) - Schema

# Blocks

SELECT LAST_DAY( date(block_time)) as monthDT,
  Min(date(block_time)) startBN, max(date(block_time)) endBN, 
 min(number) minBN, max(number) maxBN, 
 count(*) numBlocks, max(number)-min(number)+1-count(*) as numBlocks_missing 
FROM `bigquery-public-data.crypto_polkadot.blocks0` 
group by monthDT 
order by monthDT desc

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