ravelmon giveaways
Updated 2025-02-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
with total_transfers AS (
SELECT from_address as sender,
value
FROM monad.testnet.fact_traces
WHERE type = 'CALL'
AND from_address NOT IN (SELECT address FROM monad.testnet.dim_contracts WHERE address IS NOT NULL)
AND block_timestamp::DATE >= DATE '2025-02-19'
AND input = '0x' -- Ensure '0x' is treated as a string
AND TX_SUCCEEDED = 'TRUE'
AND TRACE_SUCCEEDED = 'TRUE'
)
select sender,
sum(value) AS total_sent
from total_transfers
group by 1
order by 2 desc
limit 200
QueryRunArchived: QueryRun has been archived