Sbhn_NPTop 5 Pools on Sushiswap by Swaps Count
    Updated 2023-03-04
    SELECT
    pool_name,
    CONTRACT_ADDRESS as pool_address,
    sum(amount_in_usd) as swap_volume_usd,
    count(DISTINCT tx_hash) as swaps,
    count(DISTINCT ORIGIN_FROM_ADDRESS) as users
    FROM ethereum.core.ez_dex_swaps
    WHERE platform LIKE 'sushiswap'
    GROUP BY 1,2
    having swap_volume_usd>0
    ORDER BY 4 DESC
    LIMIT 5
    Run a query to Download Data