mag$WMON wrap volume overtime
    Updated 7 days ago
    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: 7 days ago
    SWAP_DATE
    WMON_SWAP_VOLUME
    1
    2025-02-19 00:00:00.0001412943.10046871
    2
    2025-02-20 00:00:00.0002077705.32896946
    3
    2025-02-21 00:00:00.0001770465.29591584
    4
    2025-02-22 00:00:00.0001036365.65301514
    5
    2025-02-23 00:00:00.0001422301.83627185
    6
    2025-02-24 00:00:00.0001183140.36019581
    7
    2025-02-25 00:00:00.000909256.077023232
    8
    2025-02-26 00:00:00.000985835.240609322
    9
    2025-02-27 00:00:00.000884143.077755034
    10
    2025-02-28 00:00:00.0001376863.44102255
    11
    2025-03-01 00:00:00.000783095.138136521
    12
    2025-03-02 00:00:00.000625229.200913937
    13
    2025-03-03 00:00:00.000569773.852190808
    14
    2025-03-04 00:00:00.000609355.328588518
    15
    2025-03-05 00:00:00.000435746.338158377
    16
    2025-03-06 00:00:00.000404098.438097026
    17
    2025-03-07 00:00:00.000464248.849342938
    18
    2025-03-08 00:00:00.000502172.093201821
    19
    2025-03-09 00:00:00.000591782.194270194
    20
    2025-03-10 00:00:00.000529359.187299192
    22
    990B
    21s