select

case when hour::date between '2023-07-01' and '2023-07-30' then 'July 2023'

when hour::date between '2024-07-01' and '2024-07-30' then 'July 2024'

end as periods,

avg(price) as avg_rune_price,

max(price) as max_rune_price

from thorchain.price.ez_prices_hourly

where symbol = 'RUNE'

and hour::date between '2023-07-01' and '2023-07-30'

or hour::date between '2024-07-01' and '2024-07-30'

group by 1

order by 1