select hour::date as date,

avg(price) as eth_price

from flipside_prod_db.ethereum_core.fact_hourly_token_prices

where symbol = 'WETH'

and date >= '2022-04-01'

group by 1