Afonso_DiazTop Swappers (by volume)
    Updated 2025-03-13
    with

    main as (
    select
    tx_hash,
    block_timestamp,
    origin_from_address as swapper,
    nvl(amount_in_usd, amount_out_usd) as amount_usd,
    symbol_in,
    symbol_out
    from
    base.defi.ez_dex_swaps
    where
    '0xac1bd2486aaf3b5c0fc3fd868558b082a531b2b4' in (token_in, token_out)
    )

    select
    swapper,
    count(distinct tx_hash) as swaps,
    sum(amount_usd) as volume_usd,
    avg(amount_usd) as average_amount_usd
    from
    main
    where
    amount_usd > 0
    group by 1
    order by volume_usd desc
    limit 100



    QueryRunArchived: QueryRun has been archived