date_trunc('day',HOUR) as daily,

avg (price) as AVG_price,

median (price) as median_price,

max (price) as max_price,

min (price) as min_price

from optimism.core.fact_hourly_token_prices

where symbol = 'OP'

group by 1