with
PriceData as (
select
date(hour) as date,
max(price) as daily_price
from base.price.ez_prices_hourly
where token_address = '0x04d5ddf5f3a8939889f11e97f8c4bb48317f1938'
group by date
)
select
date as time,
daily_price as price
from PriceData
order by time