select

timestamp::date as days,

avg(price_usd) as price

from near.core.fact_prices

where symbol = 'wNEAR'

and timestamp::date > current_date - 7

and timestamp::date <= current_date

group by days

select * from near_price_usd order by days