2030-bifrost

bifrost Summary (Monthly)

Source: bifrost.polkaholic.io

Relay Chain: polkadot Para ID: 2030

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,255,901	5,291,522	35,622	2,870		39,409	-
2024-07-01 to 2024-07-31	5,036,168	5,255,900	219,733	20,763		39,381	-
2024-06-01 to 2024-06-30	4,827,250	5,036,167	208,918	27,548		39,105	-
2024-05-01 to 2024-05-31	4,606,764	4,827,249	220,486	26,308		36,093	-
2024-04-01 to 2024-04-30	4,394,874	4,606,763	211,890	25,937		35,776	-
2024-03-01 to 2024-03-31	4,177,054	4,394,873	217,820	55,323		36,036	-
2024-02-01 to 2024-02-29	3,976,043	4,177,053	201,011	44,482		33,830	-
2024-01-01 to 2024-01-31	3,758,524	3,976,042	217,519	29,175		31,780	-
2023-12-01 to 2023-12-31	3,557,602	3,758,523	200,922	1,540,974	116	30,495	-
2023-11-01 to 2023-11-30	3,367,289	3,557,601	190,313	21,439	161	7,107	-
2023-10-01 to 2023-10-31	3,175,500	3,367,288	191,789	17,811	126	6,029	-
2023-09-01 to 2023-09-30	2,991,834	3,175,499	183,666	15,832	74	5,276	-
2023-08-01 to 2023-08-31	2,826,888	2,991,833	164,946	14,021	77	5,095	-
2023-07-01 to 2023-07-31	2,634,275	2,826,887	192,613	9,747	83	4,927	-
2023-06-01 to 2023-06-30	2,447,927	2,634,274	186,348	9,958	81	4,739	-
2023-05-01 to 2023-05-31	2,254,663	2,447,926	193,264	16,786	77	4,535	-
2023-04-01 to 2023-04-30	2,053,652	2,254,662	201,011	13,454	81	4,273	-
2023-03-01 to 2023-03-31	1,842,354	2,053,651	211,298	14,034	96	4,092	-
2023-02-01 to 2023-02-28	1,645,275	1,842,353	197,079	11,360	104	3,822	-
2023-01-01 to 2023-01-31	1,426,953	1,645,274	218,322	9,277	77	3,568	-
2022-12-01 to 2022-12-31	1,212,434	1,426,952	214,519	9,329	67	3,405	-
2022-11-01 to 2022-11-30	1,013,658	1,212,433	198,776	6,790	59	3,181	-
2022-10-01 to 2022-10-31	799,904	1,013,657	213,754	3,002	39	2,939	-
2022-09-01 to 2022-09-30	593,248	799,903	206,656	3,397	42	2,801	-
2022-08-01 to 2022-08-31	380,234	593,247	213,014	161	6	1,329	-
2022-07-01 to 2022-07-31	175,695	380,233	204,539	10	3	2	-
2022-06-04 to 2022-06-30	1	175,694	175,694		3	2	-

Tables:

• Blocks: bigquery-public-data.crypto_polkadot.blocks2030 (date-partitioned by block_time) - Schema
• Extrinsics: bigquery-public-data.crypto_polkadot.extrinsics2030 (date-partitioned by block_time) - Schema
• Events: bigquery-public-data.crypto_polkadot.events2030 (date-partitioned by block_time) - Schema
• Transfers: bigquery-public-data.crypto_polkadot.transfers2030 (date-partitioned by block_time) - Schema
• Balances: bigquery-public-data.crypto_polkadot.balances2030 (date-partitioned by ts) - Schema
• Active Accounts: bigquery-public-data.crypto_polkadot.accountsactive2030 (date-partitioned by ts) - Schema
• Passive Accounts: bigquery-public-data.crypto_polkadot.accountspassive2030 (date-partitioned by ts) - Schema
• New Accounts: bigquery-public-data.crypto_polkadot.accountsnew2030 (date-partitioned by ts) - Schema
• Reaped Accounts: bigquery-public-data.crypto_polkadot.accountsreaped2030 (date-partitioned by ts) - Schema
• Assets: bigquery-public-data.crypto_polkadot.assets (filter on 2030) - 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.blocks2030` 
group by monthDT 
order by monthDT desc

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