date_trunc('day',recorded_hour) as date,

avg(price) as price

from osmosis.core.ez_prices

where symbol ilike 'OSMO'

and date >= '2022-12-24'

group by 1