Sbhn_NPlesser-amaranth
    Updated 2025-03-08
    select sum(amount_usd) as usd_volume,
    count(distinct concat('0x', right(topics[2],40))) as traders,
    count(distinct tx_hash) as swaps
    from ink.core.fact_event_logs
    join ink.core.ez_token_transfers a using(tx_hash)
    where topic_0 = '0xd78ad95fa46c994b6551d0da85fc275fe613ce37657fb8d5e3d130840159d822'
    and concat('0x', right(topics[1],40)) = '0xa8c1c38ff57428e5c3a34e0899be5cb385476507'
    and a.contract_address = '0x4200000000000000000000000000000000000006'
    and concat('0x', right(topics[2],40)) != '0xa8c1c38ff57428e5c3a34e0899be5cb385476507'
    Last run: 3 months ago
    USD_VOLUME
    TRADERS
    SWAPS
    1
    2746362.2357598198530
    1
    27B
    3s