2034-hydradx

hydradx Summary (Monthly)

Source: hydradx.polkaholic.io

Relay Chain: polkadot Para ID: 2034

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,671,100	5,706,684	35,585	31,068		37,404	-
2024-07-01 to 2024-07-31	5,450,684	5,671,099	220,416	73,041		37,177	-
2024-06-01 to 2024-06-30	5,239,984	5,450,683	210,700	80,871		36,076	-
2024-05-01 to 2024-05-31	5,019,592	5,239,983	220,392	73,724		34,636	-
2024-04-01 to 2024-04-30	4,806,374	5,019,591	213,218	91,414		33,996	-
2024-03-01 to 2024-03-31	4,586,859	4,806,373	219,515	101,841		31,744	-
2024-02-01 to 2024-02-29	4,380,260	4,586,858	206,599	68,994		29,460	-
2024-01-01 to 2024-01-31	4,161,953	4,380,259	218,307	89,556		28,219	-
2023-12-01 to 2023-12-31	3,944,652	4,161,952	217,301	61,946	262	26,428	-
2023-11-01 to 2023-11-30	3,733,650	3,944,651	211,002	29,488	201	25,203	-
2023-10-01 to 2023-10-31	3,515,832	3,733,649	217,818	21,082	164	24,693	-
2023-09-01 to 2023-09-30	3,305,404	3,515,831	210,428	22,235	201	24,486	-
2023-08-01 to 2023-08-31	3,088,436	3,305,403	216,968	17,088	106	24,235	-
2023-07-01 to 2023-07-31	2,874,242	3,088,435	214,194	14,069	103	24,061	-
2023-06-01 to 2023-06-30	2,667,533	2,874,241	206,709	11,746	107	23,872	-
2023-05-01 to 2023-05-31	2,455,370	2,667,532	212,163	8,853	85	23,712	-
2023-04-01 to 2023-04-30	2,252,045	2,455,369	203,325	6,845	82	23,570	-
2023-03-01 to 2023-03-31	2,047,177	2,252,044	204,868	8,120	89	23,413	-
2023-02-01 to 2023-02-28	1,868,702	2,047,176	178,475	11,712	128	23,305	-
2023-01-01 to 2023-01-31	1,672,353	1,868,701	196,349	33,155	222	23,185	-
2022-12-01 to 2022-12-31	1,483,335	1,672,352	189,018	1,135	44	22,525	-
2022-11-01 to 2022-11-30	1,326,016	1,483,334	157,319	1,154	43	22,404	-
2022-10-01 to 2022-10-31	1,158,699	1,326,015	167,317	309	31	21,139	-
2022-09-01 to 2022-09-30	997,422	1,158,698	161,277	198	29	21,131	-
2022-08-01 to 2022-08-31	829,196	997,421	168,226	241	30	21,125	-
2022-07-01 to 2022-07-31	658,260	829,195	170,936	508	35	21,117	-
2022-06-01 to 2022-06-30	475,506	658,259	182,754	5	25	27	-
2022-05-01 to 2022-05-31	288,657	475,505	186,849	7	24	27	-
2022-04-01 to 2022-04-30	99,601	288,656	189,056	28	4	27	-
2022-03-12 to 2022-03-31	1	99,600	99,600	30	12	23	-

Tables:

• Blocks: bigquery-public-data.crypto_polkadot.blocks2034 (date-partitioned by block_time) - Schema
• Extrinsics: bigquery-public-data.crypto_polkadot.extrinsics2034 (date-partitioned by block_time) - Schema
• Events: bigquery-public-data.crypto_polkadot.events2034 (date-partitioned by block_time) - Schema
• Transfers: bigquery-public-data.crypto_polkadot.transfers2034 (date-partitioned by block_time) - Schema
• Balances: bigquery-public-data.crypto_polkadot.balances2034 (date-partitioned by ts) - Schema
• Active Accounts: bigquery-public-data.crypto_polkadot.accountsactive2034 (date-partitioned by ts) - Schema
• Passive Accounts: bigquery-public-data.crypto_polkadot.accountspassive2034 (date-partitioned by ts) - Schema
• New Accounts: bigquery-public-data.crypto_polkadot.accountsnew2034 (date-partitioned by ts) - Schema
• Reaped Accounts: bigquery-public-data.crypto_polkadot.accountsreaped2034 (date-partitioned by ts) - Schema
• Assets: bigquery-public-data.crypto_polkadot.assets (filter on 2034) - 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.blocks2034` 
group by monthDT 
order by monthDT desc

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