date_trunc('day', block_timestamp) as day,

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-08-01'

AND amount_in_usd < 100000000000

GROUP BY 1,2