ACCOUNT | TOTAL_MON_RECEIVED | TOTAL_TRANSACTIONS | PERCENTAGE_OF_TOTAL_MON | |
|---|---|---|---|---|
1 | 0x8371a1bf585d7b11b53c9e3919b63e886b396516 | 1768393.1 | 93 | 1.61% |
2 | 0xe2c4d6b951f6737fe0610d703462f6e81729091b | 1361131.29 | 86 | 1.24% |
3 | 0x4c0371fdbf4c62d990c19c23c8bafb78573a39cb | 885417.02 | 10127 | 0.8% |
4 | 0x4d60587e3e97e15c0f443088195df319bcfd6f59 | 885411.37 | 10127 | 0.8% |
5 | 0xdd6cfa7cede2780cdbc5ea752d5e7781d3f0b051 | 741183.54 | 313 | 0.67% |
6 | 0x77a6ab7dc9096e7a311eb9bb4791494460f53c82 | 672377.01 | 141 | 0.61% |
7 | 0x8c826f795466e39acbff1bb4eeeb759609377ba1 | 667325.87 | 15423 | 0.61% |
8 | 0xf22b976ea899662017ec98d3e1b1299adfd89df2 | 506827.65 | 64 | 0.46% |
9 | 0xe6e483000d4707d506d814d88714fa2041bd3bd2 | 388935.13 | 88 | 0.35% |
10 | 0x051785102854b9b9c93c504d9675ffda7a12e07f | 301000.3 | 53 | 0.27% |
11 | TOTAL | 8178002.28 | 36515 | 7.42% |
JeffersTop MON receivers
Updated 2025-03-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH total_mon AS (
SELECT SUM(t.value) AS grand_total_mon
FROM monad.testnet.fact_transactions t
LEFT JOIN monad.testnet.dim_contracts c
ON t.to_address = c.address -- Check if receiver is a smart contract
WHERE value > 0
AND t.block_timestamp >= '2025-02-19 15:00'
AND t.tx_succeeded = 'TRUE'
AND c.address IS NULL -- Only keep EOAs (not in dim_contracts)
AND t.from_address != t.to_address -- Exclude self-transfers
),
main_query as (
select
t.to_address AS account,
ROUND(SUM(t.value), 2) AS total_mon_received,
COUNT(*) AS total_transactions,
ROUND((SUM(t.value) / total_mon.grand_total_mon) * 100, 2) || '%' AS percentage_of_total_mon
from monad.testnet.fact_transactions t
LEFT JOIN monad.testnet.dim_contracts c
ON t.to_address = c.address -- Check if receiver is a smart contract
JOIN total_mon -- Join the total MON sent across all accounts
where t.value > 0 and t.block_timestamp >= '2025-02-19 15:00' and t.tx_succeeded = 'TRUE'
AND c.address IS NULL -- Only keep EOAs (not in dim_contracts)
AND t.from_address != t.to_address -- Exclude self-transfers
group by t.to_address, total_mon.grand_total_mon
having count(*) > 50
ORDER BY total_mon_received DESC
LIMIT 10;
)
SELECT * FROM main_query
UNION ALL
SELECT
'TOTAL' AS account,
ROUND(SUM(total_mon_received), 2) AS total_mon_received,
SUM(total_transactions) AS total_transactions,
Last run: about 2 months ago
11
725B
17s