round(Avg(price),2) AS price_usd

FROM osmosis.core.dim_prices

WHERE symbol LIKE '%ATOM%'

AND day >= Dateadd(day, -7, Getdate())

GROUP BY day

ORDER BY day