SELECT POOL_ADDRESS, POOL_NAME, sum(zeroifnull(b.amount_usd)) as tvl
from ethereum.core.dim_dex_liquidity_pools a
join flipside_prod_db.ethereum.erc20_balances b on a.POOL_ADDRESS = b.USER_ADDRESS and b.balance_date = CURRENT_DATE - 5 and b.LABEL in ('uniswap', 'sushiswap')
where pool_address not in ('0xf4bfe9b4ef01f27920e490cea87fe2642a8da18d', '0x9cbfb60a09a9a33a10312da0f39977cbdb7fde23') -- clean junk
and PLATFORM in ('uniswap-v3', 'uniswap-v2', 'sushiswap')
GROUP by POOL_ADDRESS, POOL_NAME having tvl >= 100000 -- above $100K
order by tvl DESC