hour::date as day,

avg(price) as eth_price

from ethereum.core.fact_hourly_token_prices

where symbol = 'WETH'

and day >= '2022-11-01'

and day < '2022-12-01'

group by day

order by day