zakkisyed1.Sushiswap top 3 pools by liquidity volume
    Updated 2022-01-25

    select e1.pool_name, e1.pool_address, sum(e2.amount_usd) as liquidity_usd

    FROM
    (

    select *

    from ethereum.dex_liquidity_pools
    where platform = 'sushiswap'
    ) as e1
    INNER JOIN ethereum.erc20_balances as e2
    ON e1.pool_address = e2.user_address

    where e2.amount_usd != 0
    and e2.balance_date >= CURRENT_DATE - 1
    group by 1,2
    order by 3 DESC
    limit 3



    Run a query to Download Data