PapasotYieldly hourly volatility
    Updated 2023-01-03
    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'

    Run a query to Download Data