count(distinct trader) as active_users,

count(distinct tx_hash) as sales,

sum(amount_out_usd) as volume

from near.defi.ez_dex_swaps

where block_timestamp>=current_date-interval '1 MONTH' and block_timestamp<current_date