HOUR::date as p_date,

avg(PRICE) as price

from kaia.price.ez_prices_hourly

where SYMBOL = 'SIX'

and hour::date >= '2024-01-01'

group by 1