SELECT ORIGIN_FROM_ADDRESS, SUM(buy_volume) AS BUY_VOLUME,

SUM(sell_volume) AS SELL_VOLUME,

COUNT(*) as TOTAL_TRANSACTIONS,

COUNT(CASE WHEN side = 'BUY' THEN 1 END) AS N_BUYS,

COUNT(CASE WHEN side = 'SELL' THEN 1 END) AS N_SELLS,

SUM(sell_volume) - SUM(buy_volume) AS PROFIT

FROM (

SELECT tx_hash,

MAX(symbol_in) as symbol_in,

MAX(symbol_out) as symbol_out,

MAX(origin_from_address) as origin_from_address,

MAX(amount_in) as amount_in,

MAX(amount_out) as amount_out,

CASE when MAX(SYMBOL_IN) = 'WETH' THEN 'BUY'

ELSE 'SELL'

END AS Side,

CASE WHEN MAX(SYMBOL_IN) = 'WETH' THEN MAX(AMOUNT_IN)

ELSE 0

END AS buy_volume,

CASE WHEN MAX(SYMBOL_OUT) = 'WETH' THEN MAX(AMOUNT_OUT)

ELSE 0

END AS sell_volume

FROM

ethereum.defi.ez_dex_swaps

WHERE

(token_in = lower('0x88df592f8eb5d7bd38bfef7deb0fbc02cf3778a0')

OR token_out = lower('0x88df592f8eb5d7bd38bfef7deb0fbc02cf3778a0'))

AND contract_address = lower('0x8e40fc101cc88b94744f1716a0a46e64929ef757')

GROUP BY TX_HASH

GROUP BY origin_from_address