MetiocreTop pools based on swaps
    Updated 2022-05-18
    select * from (
    select
    pool_name,
    count(tx_id) as swaps,
    sum(amount_usd) as swap_usd_vol
    from ethereum.dex_swaps
    where platform = 'sushiswap'
    -- and tx_id = '0x248127092c1a6274e0749f043cb6adbc73290ef78e832231b1d5de4f18d72255'
    and direction = 'IN'
    group by 1
    )
    where swap_usd_vol is not null
    order by swap_usd_vol desc
    limit 20

    Run a query to Download Data