select

date_trunc('day',hour) as block_day,

avg(price) as BTC_price

from ethereum.token_prices_hourly

where symbol = 'WBTC'

and block_day >= '2022-01-01'

group by 1

select * from btc_price