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