SUM(AMOUNT_IN_USD) AS volume_30d,

COUNT(DISTINCT ORIGIN_FROM_ADDRESS) AS swappers_30d,

COUNT(DISTINCT TX_HASH) AS swaps_30d

FROM avalanche.defi.ez_dex_swaps

WHERE AMOUNT_IN_USD IS NOT NULL

AND BLOCK_TIMESTAMP >= CURRENT_TIMESTAMP - INTERVAL '30 days'