hour::date as day,

avg (price) as price_usd,

avg (price_usd) over (order by day rows between 6 preceding and current row) as moving_average_1_week

from ethereum.core.fact_hourly_token_prices

where token_address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2' --WETH

and year(day) >= 2022

group by day

order by day asc