date_trunc('hour', timestamp) as hour,

avg(price_usd) as price_usd

from near.core.fact_prices

where timestamp >= current_date - 180

and symbol = 'wNEAR'

group by hour

order by hour asc