DISTINCT ORIGIN_FROM_ADDRESS AS "Users",

COUNT (DISTINCT TX_HASH) AS "Swaps",

SUM(coalesce(AMOUNT_IN_USD, AMOUNT_OUT_USD)) AS "USD Volume",

COUNT (DISTINCT BLOCK_TIMESTAMP :: date) AS "Active Days"

avalanche.defi.ez_dex_swaps

PLATFORM = 'pangolin'

AND BLOCK_TIMESTAMP :: date >= current_date -30

GROUP BY

1

"USD Volume" > 0

ORDER BY

3 DESC