date_trunc('hour',recorded_hour) as "date",

token as "symbol",

avg(close) as "price"

from flow.core.fact_hourly_prices

where token in ('Revv') and

recorded_hour::date >= CURRENT_DATE - 90

group by 1,2