select
block_hour as date,
asset_name,
price_usd,
avg(price_usd) OVER(ORDER BY date
ROWS BETWEEN 6 PRECEDING AND CURRENT ROW )
as moving_average,
volatility_measure,
swaps_in_hour,
volume_usd_in_hour
from algorand.prices_swap
where asset_name = 'Yieldly'
and block_hour > '2022-04-01'
and block_hour < '2022-04-05'