mag$WMON wrap volume overtime
Updated 2025-03-12Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
select
date_trunc('day', e.block_timestamp) AS swap_date,
sum(value) as wmon_swap_volume
from
monad.testnet.fact_event_logs e
join
monad.testnet.fact_transactions t
on
e.tx_hash = t.tx_hash
where
e.tx_succeeded = 'TRUE'
and e.contract_address = '0x760afe86e5de5fa0ee542fc7b7b713e1c5425701'
and e.origin_to_address = '0x760afe86e5de5fa0ee542fc7b7b713e1c5425701'
and e.origin_function_signature = '0xd0e30db0'
and e.block_timestamp::date >= '2025-02-19 04:00:00'
group by swap_date
order by swap_date;
QueryRunArchived: QueryRun has been archived