MLDZMNdux6
    Updated 2022-10-26
    select
    SYMBOL_out,
    count(tx_hash) as no_swaps,
    count(distinct ORIGIN_FROM_ADDRESS) as no_swapper,
    sum(AMOUNT_out_USD) as volume,
    avg(AMOUNT_out_USD) as avg_volume
    from optimism.sushi.ez_swaps
    where block_timestamp>=CURRENT_DATE-30
    group by 1 having volume is not null
    order by 4 desc limit 10
    Run a query to Download Data