POOL_NAME,

COUNT(DISTINCT ORIGIN_FROM_ADDRESS) AS UNIQUE_ADDRESSES,

COUNT(DISTINCT TX_HASH) AS TRANSACTIONS,

SUM(COALESCE(AMOUNT_IN_USD, AMOUNT_OUT_USD)) AS TOTAL_VOLUME

FROM base.defi.ez_dex_swaps

WHERE PLATFORM ILIKE '%aerodrome%'

GROUP BY 1

HAVING TOTAL_VOLUME IS NOT NULL

ORDER BY 4 DESC

LIMIT 15