2008-crust

crust Summary (Monthly)

Source: crust.polkaholic.io

Relay Chain: polkadot Para ID: 2008

Month	Start Block	End Block	# Blocks	# Signed Extrinsics (total)	# Active Accounts (avg)	# Addresses with Balances (max)	Issues
2024-08-01 to 2024-08-06	3,818,438	3,854,058	35,621	117		1,172	-
2024-07-01 to 2024-07-31	3,597,834	3,818,437	220,604	407		1,171	-
2024-06-01 to 2024-06-30	3,384,147	3,597,833	213,687	1,692		1,154	-
2024-05-01 to 2024-05-31	3,222,647	3,384,146	161,500	356		1,133	-
2024-04-01 to 2024-04-30	3,062,862	3,222,646	159,785	598		1,118	-
2024-03-01 to 2024-03-31	2,897,422	3,062,861	165,440	1,369		1,093	-
2024-02-01 to 2024-02-29	2,710,407	2,897,421	187,015	67		1,033	-
2024-01-01 to 2024-01-31	2,496,333	2,710,406	214,074	125		1,019	-
2023-12-01 to 2023-12-31	2,281,538	2,496,332	214,795	38	3	1,018	-
2023-11-01 to 2023-11-30	2,078,063	2,281,537	203,475	65	5	1,013	-
2023-10-01 to 2023-10-31	1,860,116	2,078,062	217,947	24	4	1,010	-
2023-09-01 to 2023-09-30	1,661,809	1,860,115	198,307	11	4	1,007	-
2023-08-01 to 2023-08-31	1,501,285	1,661,808	160,524	16	3	1,006	-
2023-07-01 to 2023-07-31	1,379,079	1,501,284	122,206	6	3	1,003	-
2023-06-01 to 2023-06-30	1,225,259	1,379,078	153,820	27	4	1,001	-
2023-05-01 to 2023-05-31	1,059,197	1,225,258	166,062	15	3	999	-
2023-04-01 to 2023-04-30	898,428	1,059,196	160,769	12	3	997	-
2023-03-01 to 2023-03-31	701,814	898,427	196,614	33	4	996	-
2023-02-01 to 2023-02-28	504,230	701,813	197,584	105	5	990	-
2023-01-01 to 2023-01-31	285,366	504,229	218,864	78		974	-
2022-12-01 to 2022-12-31	67,183	285,365	218,183	2		9	-
2022-11-21 to 2022-11-30	1	67,182	67,182			9	-
2022-10-26 to 2022-10-26	288,820	289,071	252				-

Tables:

• Blocks: bigquery-public-data.crypto_polkadot.blocks2008 (date-partitioned by block_time) - Schema
• Extrinsics: bigquery-public-data.crypto_polkadot.extrinsics2008 (date-partitioned by block_time) - Schema
• Events: bigquery-public-data.crypto_polkadot.events2008 (date-partitioned by block_time) - Schema
• Transfers: bigquery-public-data.crypto_polkadot.transfers2008 (date-partitioned by block_time) - Schema
• Balances: bigquery-public-data.crypto_polkadot.balances2008 (date-partitioned by ts) - Schema
• Active Accounts: bigquery-public-data.crypto_polkadot.accountsactive2008 (date-partitioned by ts) - Schema
• Passive Accounts: bigquery-public-data.crypto_polkadot.accountspassive2008 (date-partitioned by ts) - Schema
• New Accounts: bigquery-public-data.crypto_polkadot.accountsnew2008 (date-partitioned by ts) - Schema
• Reaped Accounts: bigquery-public-data.crypto_polkadot.accountsreaped2008 (date-partitioned by ts) - Schema
• Assets: bigquery-public-data.crypto_polkadot.assets (filter on 2008) - 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.blocks2008` 
group by monthDT 
order by monthDT desc

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