SELECT asset_id, asset_name, sum(volume_usd_in_hour) as vol_usd, avg(volatility_measure) as avg_volatility, sum(swaps_in_hour) as vol_swaps
from algorand.prices_swap
where date(block_hour) >= CURRENT_DATE - 90
GROUP by asset_id, asset_name HAVING vol_usd > 0
order by vol_usd DESC
limit 10