date_trunc('day', RECORDED_HOUR) as date,TOKEN,

avg (CLOSE) as Price

FROM flow.core.fact_hourly_prices

WHERE TOKEN IS NOT NULL and CLOSE > 0

and RECORDED_HOUR >= '2023-01-01'

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

group by 1,2