mag$WMON wrap volume overtime
    Updated 2025-03-12
    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