TOKEN,

avg (CLOSE) as Price

FROM flow.core.fact_hourly_prices

WHERE TOKEN IS NOT NULL and CLOSE > 0

and RECORDED_HOUR >= current_date -1

AND TOKEN not in ('USDT','USDC','FUSD')

group by 1