with
tops as (SELECT
ORIGIN_FROM_ADDRESS,
max (AMOUNT_IN_USD) as USD
FROM avalanche.core.ez_dex_swaps
WHERE AMOUNT_IN_USD > 0
and EVENT_NAME = 'Swap'
GROUP BY 1 ORDER by USD DESC LIMIT 10)
SELECT
ORIGIN_FROM_ADDRESS as User,
max (AMOUNT_IN_USD) as USD
FROM avalanche.core.ez_dex_swaps
WHERE AMOUNT_IN_USD > 0
AND ORIGIN_FROM_ADDRESS in (SELECT ORIGIN_FROM_ADDRESS FROM tops)
and EVENT_NAME = 'Swap'
GROUP BY 1