SWAP_DATE | WMON_SWAP_VOLUME | |
|---|---|---|
1 | 2025-02-19 00:00:00.000 | 1412943.10046871 |
2 | 2025-02-20 00:00:00.000 | 2077705.32896946 |
3 | 2025-02-21 00:00:00.000 | 1770465.29591584 |
4 | 2025-02-22 00:00:00.000 | 1036365.65301514 |
5 | 2025-02-23 00:00:00.000 | 1422301.83627185 |
6 | 2025-02-24 00:00:00.000 | 1183140.36019581 |
7 | 2025-02-25 00:00:00.000 | 909256.077023232 |
8 | 2025-02-26 00:00:00.000 | 985835.240609322 |
9 | 2025-02-27 00:00:00.000 | 884143.077755034 |
10 | 2025-02-28 00:00:00.000 | 1376863.44102255 |
11 | 2025-03-01 00:00:00.000 | 783095.138136521 |
12 | 2025-03-02 00:00:00.000 | 625229.200913937 |
13 | 2025-03-03 00:00:00.000 | 569773.852190808 |
14 | 2025-03-04 00:00:00.000 | 609355.328588518 |
15 | 2025-03-05 00:00:00.000 | 435746.338158377 |
16 | 2025-03-06 00:00:00.000 | 404098.438097026 |
17 | 2025-03-07 00:00:00.000 | 464248.849342938 |
18 | 2025-03-08 00:00:00.000 | 502172.093201821 |
19 | 2025-03-09 00:00:00.000 | 591782.194270194 |
20 | 2025-03-10 00:00:00.000 | 529359.187299192 |
mag$WMON wrap volume overtime
Updated 6 days ago
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;
Last run: 6 days ago
22
990B
21s