PLATFORM,

count(distinct ORIGIN_FROM_ADDRESS) as users,

count(distinct TX_HASH ) as txs,

sum(AMOUNT_IN_USD) as Total_AMOUNT_IN_USD,

sum(AMOUNT_OUT_USD) as Total_AMOUNT_OUT_USD,

(Total_AMOUNT_OUT_USD-Total_AMOUNT_IN_USD) as total_slippage

from ethereum.core.ez_dex_swaps

where date >= '2022-01-01'

and PLATFORM != 'curve'

and AMOUNT_OUT_USD is not null

and AMOUNT_IN_USD is not null

group by 1,2