2026-nodle

nodle Summary (Monthly)

Source: nodle.polkaholic.io

Relay Chain: polkadot Para ID: 2026

Month	Start Block	End Block	# Blocks	# Signed Extrinsics (total)	# Active Accounts (avg)	# Addresses with Balances (max)	Issues
2024-08-01 to 2024-08-06	5,593,822	5,629,297	35,476	40,040		1,257,675	-
2024-07-01 to 2024-07-31	5,374,425	5,593,821	219,397	286,472		1,253,679	-
2024-06-01 to 2024-06-30	5,162,927	5,374,424	211,494	284,348		1,212,896	- 4 (0.00%)
2024-05-01 to 2024-05-31	4,945,009	5,162,926	217,918	294,427		1,179,042	-
2024-04-01 to 2024-04-30	4,737,368	4,945,008	207,641	331,057		1,114,777	-
2024-03-01 to 2024-03-31	4,519,812	4,737,367	217,556	424,479		1,050,578	-
2024-02-01 to 2024-02-29	4,315,926	4,519,811	203,886	364,081		993,049	-
2024-01-01 to 2024-01-31	4,099,866	4,315,925	216,060	290,680		939,380	-
2023-12-01 to 2023-12-31	3,882,325	4,099,865	217,541	202,205	2,022	900,323	-
2023-11-01 to 2023-11-30	3,670,776	3,882,324	211,549	131,641	2,980	865,580	-
2023-10-01 to 2023-10-31	3,453,248	3,670,775	217,528	123,877	2,703	847,597	-
2023-09-16 to 2023-09-30	3,351,853	3,453,247	101,395	53,853	2,453	830,917	-
2023-08-01 to 2023-08-21	3,204,465	3,351,852	147,388	61,846	1,952	816,717	-
2023-07-01 to 2023-07-31	3,001,253	3,204,464	203,212	77,569	1,677	799,053	-
2023-06-01 to 2023-06-30	2,803,284	3,001,252	197,969	52,966	1,171	785,233	-
2023-05-01 to 2023-05-31	2,582,765	2,803,283	220,519	52,225	1,114	771,768	-
2023-04-01 to 2023-04-30	2,375,573	2,582,764	207,192	60,152	1,351	757,170	-
2023-03-01 to 2023-03-31	2,166,684	2,375,572	208,889	65,283	1,347	739,258	-
2023-02-01 to 2023-02-28	1,967,955	2,166,683	198,729	56,004	1,352	711,279	-
2023-01-01 to 2023-01-31	1,747,359	1,967,954	220,596	42,018	956	684,937	-
2022-12-01 to 2022-12-31	1,527,413	1,747,358	219,946	26,649	587	662,613	-
2022-11-01 to 2022-11-30	1,314,477	1,527,412	212,936	27,795	648	651,074	-
2022-10-01 to 2022-10-31	1,093,803	1,314,476	220,674	282,305	8,777	716,738	-
2022-09-01 to 2022-09-30	882,252	1,093,802	211,551	134,872	4,021	698,455	-
2022-08-01 to 2022-08-31	665,361	882,251	216,891	326,215	9,980	560,440	-
2022-07-01 to 2022-07-31	468,196	665,360	197,165	167,884	4,615	505,397	-
2022-06-01 to 2022-06-30	340,966	468,195	127,230	53,930	1,177	468,722	-
2022-05-01 to 2022-05-31	212,127	340,965	128,839	43,308	1,233	447,980	-
2022-04-01 to 2022-04-30	84,991	212,126	127,136		3	4	-
2022-03-12 to 2022-03-31	1	84,990	84,990			4	-

Tables:

• Blocks: bigquery-public-data.crypto_polkadot.blocks2026 (date-partitioned by block_time) - Schema
• Extrinsics: bigquery-public-data.crypto_polkadot.extrinsics2026 (date-partitioned by block_time) - Schema
• Events: bigquery-public-data.crypto_polkadot.events2026 (date-partitioned by block_time) - Schema
• Transfers: bigquery-public-data.crypto_polkadot.transfers2026 (date-partitioned by block_time) - Schema
• Balances: bigquery-public-data.crypto_polkadot.balances2026 (date-partitioned by ts) - Schema
• Active Accounts: bigquery-public-data.crypto_polkadot.accountsactive2026 (date-partitioned by ts) - Schema
• Passive Accounts: bigquery-public-data.crypto_polkadot.accountspassive2026 (date-partitioned by ts) - Schema
• New Accounts: bigquery-public-data.crypto_polkadot.accountsnew2026 (date-partitioned by ts) - Schema
• Reaped Accounts: bigquery-public-data.crypto_polkadot.accountsreaped2026 (date-partitioned by ts) - Schema
• Assets: bigquery-public-data.crypto_polkadot.assets (filter on 2026) - 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.blocks2026` 
group by monthDT 
order by monthDT desc

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