PLATFORM,

count(DISTINCT tx_hash) as swaps,

count(DISTINCT origin_from_address) as users,

sum(amount_in_usd) as swap_volume,

avg(amount_in_usd) as avg_swap_volume

FROM ethereum.core.ez_dex_swaps

where block_timestamp > '2022-09-16'

AND amount_in_usd < 100000000000

GROUP BY 1