select avg(s.PRICE) As Price_Avrage, s.RECORDED_AT::date As Dt

from osmosis.core.dim_prices s

where SYMBOL='ATOM' and s.RECORDED_AT::date >= '2022-10-01'

group by Dt)

select * from AVG_Price_Atom order by Dt