Top 20 users

HadisehTop 20 users

Updated 2025-02-20

WITH UserActivity AS (

SELECT

FROM_ADDRESS AS user,

CASE

WHEN BLOCK_TIMESTAMP < '2025-02-19' THEN 'Private'

ELSE 'Public'

END AS network_phase,

TX_HASH

FROM

monad.testnet.fact_transactions

)

SELECT

user,

network_phase,

COUNT(DISTINCT TX_HASH) AS total_transactions,

DENSE_RANK() OVER (

ORDER BY

total_transactions DESC

) AS activity_rank

FROM

UserActivity

GROUP BY

user,

network_phase QUALIFY activity_rank <= 20

ORDER BY

total_transactions DESC,

network_phase DESC;

Last run: 26 days ago

	USER	NETWORK_PHASE	TOTAL_TRANSACTIONS	ACTIVITY_RANK
1	0x4b8c4c812fe461dd566c47f70e1bb24be07d54c0	Private	295535	1
2	0x6fa0c81f246c6c83cb77f18002ad8ad9acc5f7b0	Private	295456	2
3	0xee49774aaec94850d3ed4bd039110f6d86382c39	Private	294891	3
4	0x58577d879dec4e25bdbae24fb689f16fa8f93675	Private	293429	4
5	0x184b30c1229b85bb1e93b8107ad7f65b037425e4	Private	293370	5
6	0xf0b0716e159ee9aaf2ec1c90dddd5fdf1386f629	Private	292291	6
7	0x1d15c4f2323da0e87a8f80995644a470c923a0ea	Private	291492	7
8	0x6d7737b3ee5bf83588eb90b4f137500d0c827a06	Private	290951	8
9	0x69dfdd11a7cc6c71e5673575fe3c9dd0b86b7d7a	Private	290846	9
10	0x196fff97f71e75a4acad3f4bb64e45e129338220	Private	289739	10
11	0xc402436610047d4837edc1ab7d0080c12d8ea66d	Private	289177	11
12	0xfa1c001c72bbac1f4b47dfd13e47ce0c6f6c0e8a	Private	288786	12
13	0xef0202f8cb55d07b6ade6b6d5ad99cc2e98ed13f	Private	288729	13
14	0x577b34a0219163a44d04207dc6d5175c3f0eb629	Private	288723	14
15	0x9786532b7a0ba26c445e8275599cd7c082c73374	Private	288235	15
16	0xdb65ca282aba3d0099751b3324a70b478912b09c	Private	288110	16
17	0xcf765454baac2254f0aab8d29ced6faaf9022f4f	Private	287886	17
18	0x81ff8b7dee123bd32996041041b0a0ab8882e44b	Private	287614	18
19	0xcc690e02f639b7c16dba8c5c98561621949e4829	Private	287560	19
20	0x816de77eb5ebecd907105c11d4b17d10083c1067	Private	287504	20

1KB

flipside