ORIGIN_FROM_ADDRESS AS "User",

COUNT(DISTINCT TX_HASH) AS "Transactions",

SUM(COALESCE(AMOUNT_IN_USD, AMOUNT_OUT_USD)) AS "Volume"

FROM ethereum.core.ez_dex_swaps

WHERE BLOCK_TIMESTAMP > CURRENT_DATE() - INTERVAL'720 day' AND ORIGIN_TO_ADDRESS = '0x881d40237659c251811cec9c364ef91dc08d300c'

GROUP BY "User"

ORDER BY "Transactions" DESC

LIMIT 100