with table1 AS
(select asset_name,
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)
select asset_name,
usd_volume
from table1
limit 10