PLATFORM AS DEX,

max(AMOUNT_IN_USD) AS "max swap size",

Avg(AMOUNT_IN_USD) AS "Average swap size",

count(*) AS "swaps number",

count(distinct ORIGIN_FROM_ADDRESS) AS "swappers number"

from ethereum.core.ez_dex_swaps where (AMOUNT_IN_USD between AMOUNT_OUT_USD - 1000 and AMOUNT_OUT_USD + 1000) and BLOCK_TIMESTAMP::date >= '2022-01-01' group by 1