COUNT(TX_HASH) AS transaction_count

FROM (

SELECT ORIGIN_FROM_ADDRESS AS address, TX_HASH

FROM avalanche.defi.ez_dex_swaps

WHERE BLOCK_TIMESTAMP >= '2024-01-01'

and event_name = 'swap'

UNION ALL

SELECT ORIGIN_TO_ADDRESS AS address, TX_HASH

FROM avalanche.defi.ez_dex_swaps

WHERE BLOCK_TIMESTAMP >= '2024-01-01'

) AS combined_addresses

GROUP BY address

ORDER BY transaction_count DESC

LIMIT 10;