jak-IWUlHqTop 10 Swap Pairs of Sushiswap based on Volume of Swaps
    Updated 2022-10-10
    select case when sum( (amount_in_usd + amount_out_usd) / 2) is null then 0
    else sum( (amount_in_usd + amount_out_usd) / 2) end as volume_usd ,
    concat(symbol_in,' -> ',symbol_out) as pairs
    from ethereum.sushi.ez_swaps
    where BLOCK_TIMESTAMP::date >= '2022-01-01'
    group by 2
    order by 1 desc
    limit 10




    Run a query to Download Data