mag$WMON Wrap activity over time
    Updated 10 days ago
    select
    date_trunc('day', block_timestamp) AS swap_date,
    count(*) as number_of_swaps
    from
    monad.testnet.fact_event_logs
    where
    tx_succeeded = 'TRUE'
    and contract_address = '0x760afe86e5de5fa0ee542fc7b7b713e1c5425701'
    and origin_to_address = '0x760afe86e5de5fa0ee542fc7b7b713e1c5425701'
    and origin_function_signature = '0xd0e30db0'
    and block_timestamp::date >= '2025-02-19 04:00:00'
    group by swap_date
    order by swap_date;
    Last run: 10 days ago
    SWAP_DATE
    NUMBER_OF_SWAPS
    1
    2025-02-19 00:00:00.00010465
    2
    2025-02-20 00:00:00.00028859
    3
    2025-02-21 00:00:00.00037465
    4
    2025-02-22 00:00:00.00057737
    5
    2025-02-23 00:00:00.000279824
    6
    2025-02-24 00:00:00.000355875
    7
    2025-02-25 00:00:00.000545739
    8
    2025-02-26 00:00:00.0001212677
    9
    2025-02-27 00:00:00.000791962
    10
    2025-02-28 00:00:00.000640125
    11
    2025-03-01 00:00:00.000454203
    12
    2025-03-02 00:00:00.000383454
    13
    2025-03-03 00:00:00.000393176
    14
    2025-03-04 00:00:00.000328189
    15
    2025-03-05 00:00:00.000328059
    16
    2025-03-06 00:00:00.000343332
    17
    2025-03-07 00:00:00.000388036
    18
    2025-03-08 00:00:00.000471571
    19
    2025-03-09 00:00:00.000346640
    20
    2025-03-10 00:00:00.000452205
    22
    768B
    6s