date_trunc('{{Granularity}}', timestamp) as date,

symbol,

avg(price_usd) as price

from near.core.fact_prices

where symbol = 'wNEAR'

and timestamp >= CURRENT_DATE - interval '{{Period}} days'

group by 1,2