magcummulative, total $WMON swaps values & swaps and total $WMON holders
    Updated 6 days ago
    select
    sum(value) as cummulative_wmon_wraps_values,
    count(e.tx_hash) AS total_wmon_wraps,
    count(distinct e.origin_from_address) AS total_wmon_wrappers
    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';


    Last run: 6 days ago
    CUMMULATIVE_WMON_WRAPS_VALUES
    TOTAL_WMON_WRAPS
    TOTAL_WMON_WRAPPERS
    1
    19169864.20439418596099891159
    1
    35B
    11s