ACCOUNT | TOTAL_MON_SENT | TOTAL_TRANSACTIONS | PERCENTAGE_OF_TOTAL_MON | |
|---|---|---|---|---|
1 | 0x8371a1bf585d7b11b53c9e3919b63e886b396516 | 1778567.64 | 677 | 1.59% |
2 | 0xfa735cca8424e4ef30980653bf9015331d9929db | 1614842.64 | 5269 | 1.44% |
3 | 0xe2c4d6b951f6737fe0610d703462f6e81729091b | 1415538.38 | 630 | 1.26% |
4 | 0x0ad0ed704eefc04638695a7a51ed57b563b9bf18 | 1391943.15 | 113 | 1.24% |
5 | 0x4d60587e3e97e15c0f443088195df319bcfd6f59 | 885398 | 10133 | 0.79% |
6 | 0x4c0371fdbf4c62d990c19c23c8bafb78573a39cb | 885326.02 | 10125 | 0.79% |
7 | 0xdd6cfa7cede2780cdbc5ea752d5e7781d3f0b051 | 760710.79 | 5019 | 0.68% |
8 | 0x77a6ab7dc9096e7a311eb9bb4791494460f53c82 | 666701.1 | 108491 | 0.59% |
9 | 0x8c826f795466e39acbff1bb4eeeb759609377ba1 | 601324.52 | 185278 | 0.54% |
10 | 0x051785102854b9b9c93c504d9675ffda7a12e07f | 567194.65 | 1110296 | 0.51% |
11 | TOTAL | 10567546.89 | 1436031 | 9.43% |
JeffersTop MON senders
Updated 2025-03-06
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.from_address AS account,
ROUND(SUM(t.value), 2) AS total_mon_sent,
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.from_address, total_mon.grand_total_mon
having count(*) > 100
ORDER BY total_mon_sent DESC
limit 10
)
SELECT * FROM main_query
UNION ALL
SELECT
'TOTAL' AS account,
ROUND(SUM(total_mon_sent), 2) AS total_mon_sent,
SUM(total_transactions) AS total_transactions,
Last run: about 1 month ago
11
745B
6s