date(date_trunc('day', timestamp)) as date,

avg(price_usd) as price

from near.core.fact_prices

where token = 'Wrapped NEAR fungible token'

group by date)

select * from near_price