2023-moonriver

moonriver Summary (Monthly)

Source: moonriver.polkaholic.io

Relay Chain: kusama Para ID: 2023

Month	Start Block	End Block	# Blocks	# Signed Extrinsics (total)	# Active Accounts (avg)	# Addresses with Balances (max)	Issues
2024-03-01 to 2024-03-25	6,246,586	6,411,972	165,387	3,590		902,610	-
2024-02-01 to 2024-02-29	6,055,490	6,246,585	191,096	4,091		865,695	-
2024-01-01 to 2024-01-31	5,852,226	6,055,489	203,237	4,795		764,661	- 27 (0.01%)
2023-12-01 to 2023-12-31	5,646,344	5,852,225	205,385	7,529	48	664,368	- 497 (0.24%)
2023-11-01 to 2023-11-30	5,440,577	5,646,343	205,591	5,287	89	532,935	- 176 (0.09%)
2023-10-01 to 2023-10-31	5,225,762	5,440,576	214,815	2,633	51	510,253	-
2023-09-01 to 2023-09-30	5,015,245	5,225,761	210,517	2,148	47	482,771	-
2023-08-01 to 2023-08-31	4,794,222	5,015,244	221,023	2,268	47	443,729	-
2023-07-01 to 2023-07-31	4,573,905	4,794,221	220,317	2,385	50	373,801	-
2023-06-01 to 2023-06-30	4,360,973	4,573,904	212,932	2,296	49	289,658	-
2023-05-01 to 2023-05-31	4,148,267	4,360,972	212,706	3,602	46	251,384	-
2023-04-01 to 2023-04-30	3,940,325	4,148,266	207,942	2,582	55	249,651	-
2023-03-01 to 2023-03-31	3,723,310	3,940,324	217,015	2,799	58	248,137	-
2023-02-01 to 2023-02-28	3,526,185	3,723,309	197,125	2,981	65	246,250	-
2023-01-01 to 2023-01-31	3,309,107	3,526,184	217,078	2,955	58	243,921	-
2022-12-01 to 2022-12-31	3,100,104	3,309,106	209,003	2,950	56	242,066	-
2022-11-01 to 2022-11-30	2,893,806	3,100,103	206,298	3,074	61	239,597	-
2022-10-01 to 2022-10-31	2,678,168	2,893,805	215,638	2,134	43	235,142	-
2022-09-01 to 2022-09-30	2,480,900	2,678,167	197,268	2,341	39	232,360	-
2022-08-01 to 2022-08-31	2,299,970	2,480,899	180,930	3,291	38	229,165	-
2022-07-01 to 2022-07-31	2,121,690	2,299,969	178,280	2,199	36	227,409	-
2022-06-01 to 2022-06-30	1,935,610	2,121,689	186,080	1,968	26	223,240	-
2022-05-01 to 2022-05-31	1,765,262	1,935,609	170,348	2,671	25	215,464	-
2022-04-01 to 2022-04-30	1,660,607	1,765,261	104,655	3,199	58	207,345	-
2022-03-01 to 2022-03-31	1,539,200	1,660,606	121,407	8,482	115	200,509	-
2022-02-01 to 2022-02-28	1,411,886	1,539,199	127,314	10,456	147	188,882	-
2022-01-01 to 2022-01-31	1,203,998	1,411,885	207,888	23,071	234	181,984	-
2021-12-01 to 2021-12-31	996,844	1,203,997	207,154	25,877	229	156,047	-
2021-11-01 to 2021-11-30	829,171	996,843	167,673	4,797,730	401	125,110	-
2021-10-01 to 2021-10-31	635,165	829,170	194,006	2,225,368	416	61,281	-
2021-09-01 to 2021-09-30	437,778	635,164	197,387	2,722,438	508	46,904	-
2021-08-01 to 2021-08-31	226,357	437,777	211,421	679,093	38	8,506	-
2021-07-01 to 2021-07-31	10,200	226,356	216,157	475,672	7	120	-
2021-06-29 to 2021-06-30	1	10,199	10,199	7		61	-

Tables:

• Blocks: bigquery-public-data.crypto_kusama.blocks2023 (date-partitioned by block_time) - Schema
• Extrinsics: bigquery-public-data.crypto_kusama.extrinsics2023 (date-partitioned by block_time) - Schema
• Events: bigquery-public-data.crypto_kusama.events2023 (date-partitioned by block_time) - Schema
• Transfers: bigquery-public-data.crypto_kusama.transfers2023 (date-partitioned by block_time) - Schema
• Balances: bigquery-public-data.crypto_kusama.balances2023 (date-partitioned by ts) - Schema
• Active Accounts: bigquery-public-data.crypto_kusama.accountsactive2023 (date-partitioned by ts) - Schema
• Passive Accounts: bigquery-public-data.crypto_kusama.accountspassive2023 (date-partitioned by ts) - Schema
• New Accounts: bigquery-public-data.crypto_kusama.accountsnew2023 (date-partitioned by ts) - Schema
• Reaped Accounts: bigquery-public-data.crypto_kusama.accountsreaped2023 (date-partitioned by ts) - Schema
• Assets: bigquery-public-data.crypto_kusama.assets (filter on 2023) - 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.blocks2023` 
group by monthDT 
order by monthDT desc

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