2035-phala

phala Summary (Monthly)

Source: phala.polkaholic.io

Relay Chain: polkadot Para ID: 2035

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,703,182	5,738,801	35,620	728,787		5,645	-
2024-07-01 to 2024-07-31	5,482,308	5,703,181	220,872	4,503,514		5,620	- 2 (0.00%)
2024-06-01 to 2024-06-30	5,268,814	5,482,307	213,488	4,283,118		5,474	- 6 (0.00%)
2024-05-01 to 2024-05-31	5,048,081	5,268,813	220,733	4,309,031		5,374	-
2024-04-01 to 2024-04-30	4,834,015	5,048,080	214,066	4,227,519		5,264	-
2024-03-01 to 2024-03-31	4,612,658	4,834,014	221,357	4,391,030		5,163	-
2024-02-01 to 2024-02-29	4,405,839	4,612,657	206,819	4,162,233		5,010	-
2024-01-01 to 2024-01-31	4,185,157	4,405,838	220,682	4,329,897		4,823	-
2023-12-01 to 2023-12-31	3,963,760	4,185,156	221,397	4,313,964	153	4,725	-
2023-11-01 to 2023-11-30	3,750,338	3,963,759	213,422	4,077,914	200	4,579	-
2023-10-01 to 2023-10-31	3,530,821	3,750,337	219,517	4,073,142	194	4,459	-
2023-09-01 to 2023-09-30	3,317,265	3,530,820	213,556	3,808,922	158	4,320	-
2023-08-01 to 2023-08-31	3,095,522	3,317,264	221,743	3,924,103	137	4,146	-
2023-07-01 to 2023-07-31	2,874,985	3,095,521	220,537	3,737,968	111	4,016	-
2023-06-01 to 2023-06-30	2,660,890	2,874,984	214,095	3,034,987	86	3,777	-
2023-05-01 to 2023-05-31	2,439,169	2,660,889	221,721	1,998,464	49	3,515	-
2023-04-01 to 2023-04-30	2,224,279	2,439,168	214,890	17,520	24	3,316	-
2023-03-01 to 2023-03-31	2,009,121	2,224,278	215,158	949	23	3,200	-
2023-02-01 to 2023-02-28	1,809,602	2,009,120	199,519	924	26	3,128	-
2023-01-01 to 2023-01-31	1,587,962	1,809,601	221,640	616	20	3,021	-
2022-12-01 to 2022-12-31	1,367,180	1,587,961	220,782	502	18	2,979	-
2022-11-01 to 2022-11-30	1,153,086	1,367,179	214,094	812	23	2,925	-
2022-10-01 to 2022-10-31	932,129	1,153,085	220,957	1,297	29	2,791	-
2022-09-01 to 2022-09-30	721,408	932,128	210,721	576	20	2,630	-
2022-08-01 to 2022-08-31	505,584	721,407	215,824	395	16	2,563	-
2022-07-01 to 2022-07-31	293,542	505,583	212,042	325	15	2,507	-
2022-06-01 to 2022-06-30	92,105	293,541	201,437	284	11	2,466	-
2022-05-31 to 2022-05-31	90,052	92,104	2,053		3	5	-
2022-04-01 to 2022-04-15	1	90,051	90,051		3	5	-

Tables:

• Blocks: bigquery-public-data.crypto_polkadot.blocks2035 (date-partitioned by block_time) - Schema
• Extrinsics: bigquery-public-data.crypto_polkadot.extrinsics2035 (date-partitioned by block_time) - Schema
• Events: bigquery-public-data.crypto_polkadot.events2035 (date-partitioned by block_time) - Schema
• Transfers: bigquery-public-data.crypto_polkadot.transfers2035 (date-partitioned by block_time) - Schema
• Balances: bigquery-public-data.crypto_polkadot.balances2035 (date-partitioned by ts) - Schema
• Active Accounts: bigquery-public-data.crypto_polkadot.accountsactive2035 (date-partitioned by ts) - Schema
• Passive Accounts: bigquery-public-data.crypto_polkadot.accountspassive2035 (date-partitioned by ts) - Schema
• New Accounts: bigquery-public-data.crypto_polkadot.accountsnew2035 (date-partitioned by ts) - Schema
• Reaped Accounts: bigquery-public-data.crypto_polkadot.accountsreaped2035 (date-partitioned by ts) - Schema
• Assets: bigquery-public-data.crypto_polkadot.assets (filter on 2035) - 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.blocks2035` 
group by monthDT 
order by monthDT desc

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