date_trunc('day', block_timestamp) as date,

count(DISTINCT tx_to) as unique_users,

count(tx_hash) as tx_count,

sum(amount_in_usd) as USD_in,

sum(amount_out_usd)*(-1) as USD_out

from ethereum.core.ez_dex_swaps

where date between '2022-11-01' and '2022-11-16'

and platform = 'curve'

group by 1

order by 1