Top 100 Depositers

web3kobe-xn5jvRTop 100 Depositers

Updated 2025-03-15

SELECT

ORIGIN_FROM_ADDRESS AS user,

COUNT(*) as number_of_deposits,

AVG(VALUE) AS avg_deposit_amount,

SUM(VALUE) AS total_deposit_amount,

MIN(VALUE) AS min_deposit,

MAX(VALUE) AS max_deposit

FROM monad.testnet.fact_traces

WHERE TO_ADDRESS = '0x3ad50059d6008b711209a509fe58e68f0b672a42'

AND block_timestamp >= DATEADD(day, -30, CURRENT_TIMESTAMP())

AND VALUE > 0 -- Only include actual deposits

AND trace_succeeded = TRUE -- Only include successful traces

GROUP BY ORIGIN_FROM_ADDRESS

HAVING number_of_deposits > 0 -- Only include addresses that actually made deposits

ORDER BY avg_deposit_amount DESC

LIMIT 100; -- Limit to top 100 depositors

Last run: about 1 month ago

	USER	NUMBER_OF_DEPOSITS	AVG_DEPOSIT_AMOUNT	TOTAL_DEPOSIT_AMOUNT	MIN_DEPOSIT	MAX_DEPOSIT
1	0x5e792a8797186551c765c3108d4b16943b10e890	1	100	100	100	100
2	0x0ffa64e46fdfa06190572c8173c97fb9daa8e071	1	10	10	10	10
3	0xb8d39409a55320929d151ed6102a326cf5a0e76b	5	10	50	10	10
4	0x53eb4025c3dcd12352fa7cf11e24164993fdfda6	1	10	10	10	10
5	0xc240392b5e36d129e34ab405c45b730878e41b7d	2	10	20	10	10
6	0x9717b0bc3a2b49efca87f95d41454802c99c6079	1	10	10	10	10
7	0x6bc26c34a0e26cb1efa4019bf9f3f442b1ad4513	1	10	10	10	10
8	0x5524f7dfa0beecfd880cf88b69244201d84de37a	1	10	10	10	10
9	0xcb1063d6b0d8bc7e5fa7fc91c2b4c45df0f7a59b	2	10	20	10	10
10	0xb4a7da8312db8d071fc9bdd38446de0583b8d878	22	10	220	10	10
11	0x710fe0b0d7be5bd1f6f5f3bf4e2d55ddcaad2af6	1	10	10	10	10
12	0x997366d22591c1199d1cd5d1e1ca1ad45d659c3d	1	10	10	10	10
13	0x2eb453c55f4f28a9d310880bd488ffd6e6170382	1	10	10	10	10
14	0x0f48efe014c77496ee6308b08779bf476f2236dd	1	10	10	10	10
15	0x18db619b21237b08fe4b57e07f7139736fb9e0a8	1	10	10	10	10
16	0xe383db78ee18ae7cbfe285ae4745b9d395480f15	1	10	10	10	10
17	0x89bb24235e0235f8508d33c805a2034e512da24f	1	10	10	10	10
18	0x0aab921f90e6b9a4ce1a57930b2137941b481066	3	10	30	10	10
19	0x3711dfa008f4b9e646b2301c6be3ee83d4a4029c	5	10	50	10	10
20	0xb94e4c48917734bc7f9b94dcbda41793a4fb06fe	1	10	10	10	10

100

6KB

10s

flipside