2012-parallel

parallel Summary (Monthly)

Source: parallel.polkaholic.io

Relay Chain: polkadot Para ID: 2012

Month	Start Block	End Block	# Blocks	# Signed Extrinsics (total)	# Active Accounts (avg)	# Addresses with Balances (max)	Issues
2024-08-01 to 2024-08-06	6,490,461	6,522,272	31,812	8,009		51,384	-
2024-07-01 to 2024-07-31	6,291,918	6,490,460	198,543	75,852		51,378	-
2024-06-01 to 2024-06-30	6,100,613	6,291,917	191,305	123,518		51,328	-
2024-05-01 to 2024-05-31	5,923,869	6,100,612	176,744	122,306		51,290	-
2024-04-01 to 2024-04-30	5,733,451	5,923,868	190,418	114,283		51,222	-
2024-03-01 to 2024-03-31	5,514,547	5,733,450	218,904	92,154		51,078	-
2024-02-01 to 2024-02-29	5,308,406	5,514,546	206,141	38,733		50,735	-
2024-01-01 to 2024-01-31	5,097,009	5,308,405	211,397	96,239		50,181	-
2023-12-01 to 2023-12-31	4,878,257	5,097,008	218,752	152,232	237	49,747	-
2023-11-01 to 2023-11-30	4,665,269	4,878,256	212,988	122,929	326	48,732	-
2023-10-01 to 2023-10-31	4,450,711	4,665,268	214,558	152,295	265	48,474	-
2023-09-01 to 2023-09-30	4,238,335	4,450,710	212,376	96,744	118	48,260	-
2023-08-01 to 2023-08-31	4,016,751	4,238,334	221,584	115,321	165	48,168	-
2023-07-01 to 2023-07-31	3,818,424	4,016,750	198,327	83,230	188	48,046	-
2023-06-01 to 2023-06-30	3,629,882	3,818,423	188,542	140,392	193	47,920	-
2023-05-01 to 2023-05-31	3,424,573	3,629,881	205,309	144,830	204	47,781	-
2023-04-01 to 2023-04-30	3,210,744	3,424,572	213,829	128,648	235	47,645	-
2023-03-01 to 2023-03-31	2,998,501	3,210,743	212,243	138,631	258	47,476	-
2023-02-01 to 2023-02-28	2,799,332	2,998,500	199,169	161,424	368	47,248	-
2023-01-01 to 2023-01-31	2,578,329	2,799,331	221,003	183,405	441	46,950	-
2022-12-01 to 2022-12-31	2,357,760	2,578,328	220,569	176,326	443	46,490	-
2022-11-01 to 2022-11-30	2,143,686	2,357,759	214,074	217,849	583	46,079	-
2022-10-01 to 2022-10-31	1,923,316	2,143,685	220,370	206,404	612	45,325	-
2022-09-01 to 2022-09-30	1,712,060	1,923,315	211,256	216,681	632	44,262	-
2022-08-01 to 2022-08-31	1,495,864	1,712,059	216,196	144,996	480	42,069	-
2022-07-01 to 2022-07-31	1,283,353	1,495,863	212,511	118,099	479	40,712	-
2022-06-01 to 2022-06-30	1,080,082	1,283,352	203,271	142,598	584	39,211	-
2022-05-01 to 2022-05-31	865,409	1,080,081	214,673	175,486	712	38,284	-
2022-04-01 to 2022-04-30	664,185	865,408	201,224	46,475	378	36,783	-
2022-03-01 to 2022-03-31	466,488	664,184	197,697	8,732	242	35,540	-
2022-02-01 to 2022-02-28	295,557	466,487	170,931	4,792	98	34,442	-
2022-01-01 to 2022-01-31	92,106	295,556	203,451	2,972	7	29,470	-
2021-12-18 to 2021-12-31	1	92,105	92,105	1	5	2	-

Tables:

• Blocks: bigquery-public-data.crypto_polkadot.blocks2012 (date-partitioned by block_time) - Schema
• Extrinsics: bigquery-public-data.crypto_polkadot.extrinsics2012 (date-partitioned by block_time) - Schema
• Events: bigquery-public-data.crypto_polkadot.events2012 (date-partitioned by block_time) - Schema
• Transfers: bigquery-public-data.crypto_polkadot.transfers2012 (date-partitioned by block_time) - Schema
• Balances: bigquery-public-data.crypto_polkadot.balances2012 (date-partitioned by ts) - Schema
• Active Accounts: bigquery-public-data.crypto_polkadot.accountsactive2012 (date-partitioned by ts) - Schema
• Passive Accounts: bigquery-public-data.crypto_polkadot.accountspassive2012 (date-partitioned by ts) - Schema
• New Accounts: bigquery-public-data.crypto_polkadot.accountsnew2012 (date-partitioned by ts) - Schema
• Reaped Accounts: bigquery-public-data.crypto_polkadot.accountsreaped2012 (date-partitioned by ts) - Schema
• Assets: bigquery-public-data.crypto_polkadot.assets (filter on 2012) - 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.blocks2012` 
group by monthDT 
order by monthDT desc

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