zakkisyedSushi Top 10 pools by TVL
    Updated 2022-02-09
    select
    sum(amount_usd) as current_liquidity,
    pool_name, pool_address
    from ethereum.erc20_balances x
    join ethereum.dex_liquidity_pools y on
    x.user_address = y.pool_address
    where amount_usd > 0 and platform = 'sushiswap' and balance_date=CURRENT_DATE
    group by 3,2
    order by 1 desc
    limit 10