iboo-jbj2MVThe highest average volatility
    Updated 2022-05-16
    with table1 AS
    (select asset_name,
    avg(volatility_measure)
    AS average,
    sum(volume_usd_in_hour)
    AS usd_volume
    from algorand.prices_swap
    where block_hour::date >= current_date - 90 -- Last 90 days
    group by asset_name,
    asset_name having usd_volume >= 1
    order by usd_volume desc
    limit 10)
    select asset_name,
    average
    from table1