2114-turing

turing Summary (Monthly)

Source: turing.polkaholic.io

Relay Chain: kusama Para ID: 2114

Month	Start Block	End Block	# Blocks	# Signed Extrinsics (total)	# Active Accounts (avg)	# Addresses with Balances (max)	Issues
2024-05-01 to 2024-05-19	4,968,459	5,090,391	121,933	401		10,225	-
2024-04-01 to 2024-04-30	4,767,606	4,968,458	200,853	744		10,224	-
2024-03-01 to 2024-03-31	4,563,839	4,767,605	203,767	971		10,205	-
2024-02-01 to 2024-02-29	4,390,180	4,563,838	173,657	1,220		10,185	- 2 (0.00%)
2024-01-01 to 2024-01-31	4,196,708	4,390,179	193,472	6,424		10,154	-
2023-12-01 to 2023-12-31	3,987,693	20,866,146	209,025	1,817	31	7,858	- 16,669,429 (98.76%)
2023-11-01 to 2023-11-30	3,774,313	3,987,692	212,783	843	30	7,815	- 597 (0.28%)
2023-10-01 to 2023-10-31	3,552,376	3,774,312	221,937	2,515	83	7,775	-
2023-09-01 to 2023-09-30	3,345,137	3,552,375	207,239	899	43	7,729	-
2023-08-01 to 2023-08-31	3,128,003	3,345,136	217,134	943	49	7,710	-
2023-07-01 to 2023-07-31	2,905,584	3,128,002	222,419	1,583	63	7,700	-
2023-06-01 to 2023-06-30	2,691,288	2,905,583	214,296	1,293	55	7,678	-
2023-05-01 to 2023-05-31	2,481,730	2,691,287	209,558	1,948	62	7,653	-
2023-04-01 to 2023-04-30	2,280,764	2,481,729	200,966	3,488	68	7,622	-
2023-03-01 to 2023-03-31	2,062,531	2,280,763	218,233	1,609	61	7,606	-
2023-02-01 to 2023-02-28	1,865,173	2,062,530	197,358	1,832	70	7,584	-
2023-01-01 to 2023-01-31	1,648,489	1,865,172	216,684	11,432	230	7,476	-
2022-12-01 to 2022-12-31	1,440,187	1,648,488	208,302	3,717	68	1,716	-
2022-11-01 to 2022-11-30	1,239,418	1,440,186	200,769	1,747	62	1,694	-
2022-10-01 to 2022-10-31	1,024,223	1,239,417	215,195	2,072	69	1,671	-
2022-09-01 to 2022-09-30	825,217	1,024,222	199,006	2,965	80	1,640	-
2022-08-01 to 2022-08-31	643,580	825,216	181,637	4,436	87	1,563	-
2022-07-01 to 2022-07-31	463,738	643,579	179,842	1,858	62	1,515	-
2022-06-01 to 2022-06-30	277,932	463,737	185,806	1,348	44	1,470	-
2022-05-01 to 2022-05-31	103,439	277,931	174,493	1,564	12	1,435	-
2022-04-03 to 2022-04-30	1	103,438	103,438	27	7	20	-

Tables:

• Blocks: bigquery-public-data.crypto_kusama.blocks2114 (date-partitioned by block_time) - Schema
• Extrinsics: bigquery-public-data.crypto_kusama.extrinsics2114 (date-partitioned by block_time) - Schema
• Events: bigquery-public-data.crypto_kusama.events2114 (date-partitioned by block_time) - Schema
• Transfers: bigquery-public-data.crypto_kusama.transfers2114 (date-partitioned by block_time) - Schema
• Balances: bigquery-public-data.crypto_kusama.balances2114 (date-partitioned by ts) - Schema
• Active Accounts: bigquery-public-data.crypto_kusama.accountsactive2114 (date-partitioned by ts) - Schema
• Passive Accounts: bigquery-public-data.crypto_kusama.accountspassive2114 (date-partitioned by ts) - Schema
• New Accounts: bigquery-public-data.crypto_kusama.accountsnew2114 (date-partitioned by ts) - Schema
• Reaped Accounts: bigquery-public-data.crypto_kusama.accountsreaped2114 (date-partitioned by ts) - Schema
• Assets: bigquery-public-data.crypto_kusama.assets (filter on 2114) - Schema
• XCM Assets: bigquery-public-data.crypto_kusama.xcmassets (filter on para_id) - Schema
• XCM Transfers: bigquery-public-data.crypto_kusama.xcmtransfers (filter on origination_para_id or destination_para_id, date-partitioned by origination_ts) - Schema
• XCM Messages: bigquery-public-data.crypto_kusama.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_kusama.blocks2114` 
group by monthDT 
order by monthDT desc

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