SUM(AMOUNT_IN_USD) AS total_volume_usd,

count(distinct tx_hash) as swaps,

count(distinct swapper) as swappers

FROM

aptos.defi.ez_dex_swaps

where AMOUNT_IN_USD<1e6 and amount_in_usd is not null and block_timestamp>=current_date-INTERVAL '1 MONTH'