2013-litentry

litentry Summary (Monthly)

Source: litentry.polkaholic.io

Relay Chain: polkadot Para ID: 2013

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,449,015	5,482,431	33,417	18,972		4,753	-
2024-07-01 to 2024-07-31	5,231,069	5,449,014	217,946	363,276		4,753	-
2024-06-01 to 2024-06-30	5,023,257	5,231,068	207,812	878		4,754	-
2024-05-01 to 2024-05-31	4,810,132	5,023,256	213,125	954		4,746	-
2024-04-01 to 2024-04-30	4,601,125	4,810,131	209,007	1,282		4,737	-
2024-03-01 to 2024-03-31	4,395,812	4,601,124	205,313	1,779		4,720	-
2024-02-01 to 2024-02-29	4,189,081	4,395,811	206,731	1,402		4,747	-
2024-01-01 to 2024-01-31	3,968,726	4,189,080	220,355	1,803		4,769	-
2023-12-01 to 2023-12-31	3,747,670	3,968,725	221,056	1,759	46	4,806	-
2023-11-01 to 2023-11-30	3,533,047	3,747,669	214,623	1,827	55	4,838	-
2023-10-01 to 2023-10-31	3,311,383	3,533,046	221,664	2,664	61	4,886	-
2023-09-01 to 2023-09-30	3,097,227	3,311,382	214,156	2,707	60	4,878	-
2023-08-01 to 2023-08-31	2,875,008	3,097,226	222,219	2,749	60	4,865	-
2023-07-01 to 2023-07-31	2,653,040	2,875,007	221,968	3,093	66	4,853	-
2023-06-01 to 2023-06-30	2,438,714	2,653,039	214,326	3,136	67	4,833	-
2023-05-01 to 2023-05-31	2,216,996	2,438,713	221,718	3,423	65	4,815	-
2023-04-01 to 2023-04-30	2,002,286	2,216,995	214,710	3,816	73	4,800	-
2023-03-01 to 2023-03-31	1,786,894	2,002,285	215,392	4,210	77	4,773	-
2023-02-01 to 2023-02-28	1,587,337	1,786,893	199,557	4,691	92	4,768	-
2023-01-01 to 2023-01-31	1,365,864	1,587,336	221,473	4,495	82	4,751	-
2022-12-01 to 2022-12-31	1,144,608	1,365,863	221,256	3,865	72	4,741	-
2022-11-01 to 2022-11-30	930,803	1,144,607	213,805	2,549	43	4,720	-
2022-10-01 to 2022-10-31	711,127	930,802	219,676	738	18	4,678	-
2022-09-01 to 2022-09-30	514,397	711,126	196,730	412	14	4,671	-
2022-08-01 to 2022-08-31	329,620	514,396	184,777	500	15	4,671	-
2022-07-01 to 2022-07-31	151,698	329,619	177,922	318	10	4,671	-
2022-06-04 to 2022-06-30	1	151,697	151,697	2	3	16	-

Tables:

• Blocks: bigquery-public-data.crypto_polkadot.blocks2013 (date-partitioned by block_time) - Schema
• Extrinsics: bigquery-public-data.crypto_polkadot.extrinsics2013 (date-partitioned by block_time) - Schema
• Events: bigquery-public-data.crypto_polkadot.events2013 (date-partitioned by block_time) - Schema
• Transfers: bigquery-public-data.crypto_polkadot.transfers2013 (date-partitioned by block_time) - Schema
• Balances: bigquery-public-data.crypto_polkadot.balances2013 (date-partitioned by ts) - Schema
• Active Accounts: bigquery-public-data.crypto_polkadot.accountsactive2013 (date-partitioned by ts) - Schema
• Passive Accounts: bigquery-public-data.crypto_polkadot.accountspassive2013 (date-partitioned by ts) - Schema
• New Accounts: bigquery-public-data.crypto_polkadot.accountsnew2013 (date-partitioned by ts) - Schema
• Reaped Accounts: bigquery-public-data.crypto_polkadot.accountsreaped2013 (date-partitioned by ts) - Schema
• Assets: bigquery-public-data.crypto_polkadot.assets (filter on 2013) - 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.blocks2013` 
group by monthDT 
order by monthDT desc

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