hbd1994Top Swappers Breakdown by USD Volume of Swaps
    Updated 2023-08-29
    select
    'Volume' as "Top Swappers Type",
    ORIGIN_FROM_ADDRESS as "Swapper Wallet Address",
    sum(coalesce(AMOUNT_OUT_USD , AMOUNT_IN_USD)) as "Total Swaps or Volume"
    from base.defi.ez_dex_swaps
    where block_timestamp >= '{{Start_Date}}'
    and block_timestamp <= '{{End_Date}}'
    and AMOUNT_IN_USD is not null
    and AMOUNT_OUT_USD is not null
    group by 2
    order by 3 desc
    limit 10
    Run a query to Download Data