SELECT
*
FROM avalanche.core.ez_dex_swaps
WHERE TX_HASH = '0xa8d8f4c2c6c167b515c46282dfff33cf29c49284d412ee2b513e2f25265f835d'
SELECT
TX_HASH,
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