select

date(date_trunc('day', hour)) as date,

avg(price) as price

from optimism.core.fact_hourly_token_prices

where token_address = '0x4200000000000000000000000000000000000042'

group by date

select * from price