with all_sushipools as (
select POOL_ADDRESS , token0 , token1 from ethereum.core.dim_dex_liquidity_pools where platform = 'sushiswap'
) select sum(amount_usd) as "TVL in USD" ,balance_date as "balance date"
from flipside_prod_db.ethereum.erc20_balances ,all_sushipools
where
user_address = POOL_ADDRESS and
(contract_address =token0 or contract_address =token1 ) and
balance_date >= CURRENT_DATE - 90
group by balance_date