max(AMOUNT_IN_USD) as max_USD_volume,

count(distinct s.tx_hash) as swaps,

sum(AMOUNT_IN_USD) as USD_volume,

avg(tx_fee) as avg_fee,

sum(tx_fee) as sum_fee,

count(DISTINCT s.ORIGIN_FROM_ADDRESS) as swappers

FROM ethereum.core.ez_dex_swaps s left join ethereum.core.fact_transactions a on s.tx_hash=a.tx_hash

WHERE s.block_timestamp >= '2022-01-01'

and (abs(AMOUNT_IN_USD-AMOUNT_OUT_USD)<1e3)

GROUP BY 1