with top_10_ASAs as (select top 10 sum(VOLUME_USD_IN_HOUR),ASSET_NAME from algorand.prices_swap
where VOLUME_USD_IN_HOUR::int > 0 and BLOCK_HOUR > current_date - interval '90 days'
group by 2
order by 1 DESC)
select sum(SWAPS_IN_HOUR),ASSET_NAME from algorand.prices_swap
where ASSET_NAME in (select ASSET_NAME from top_10_ASAs)
group by 2
order by 1 desc