date(block_timestamp) as date,

CASE when pool_id LIKE 678 then 'Deepest_axlUSDC_Pool'

when pool_id LIKE 831 then 'Deepest_axlUSDT_Pool'

when pool_id LIKE 704 then 'Deepest_axlETH_Pool'

when pool_id LIKE 712 then 'Deepest_axlBTC_Pool'

when pool_id LIKE 899 then 'Deepest_axlAVAX_Pool'

when pool_id LIKE 789 then 'Deepest_axlMATIC_Pool' end as pool,

avg(LIQUIDITY_USD) as tvl_usd

FROM osmosis.core.fact_pool_hour

WHERE pool_id in (678, 831, 704, 712, 899, 789, 831)

GROUP BY 1,2

having pool like '%{{ token }}%'