origin_from_address

-- , contract_address

-- , pool_name

, sum(CASE WHEN symbol_in = 'WETH' THEN 1 else 0 end) AS buys

, sum(CASE WHEN symbol_in = 'WETH' AND block_timestamp < '2023-01-12' THEN 1 else 0 end) AS buys_before

, sum(CASE WHEN symbol_in = 'WETH' AND block_timestamp >= '2023-01-12' THEN 1 else 0 end) AS buys_after

, sum(CASE WHEN symbol_out = 'WETH' THEN 1 else 0 end) AS sells

, sum(CASE WHEN symbol_out = 'WETH' AND block_timestamp < '2023-01-12' THEN 1 else 0 end) AS sells_before

, sum(CASE WHEN symbol_out = 'WETH' AND block_timestamp >= '2023-01-12' THEN 1 else 0 end) AS sells_after

, sum(CASE WHEN symbol_in = 'WETH' THEN amount_in else 0 end) AS weth_spent

, sum(CASE WHEN symbol_in = 'WETH' THEN amount_in_usd else 0 end) AS usd_spent

, sum(CASE WHEN symbol_out = 'WETH' THEN amount_out else 0 end) AS weth_received

, sum(CASE WHEN symbol_out = 'WETH' THEN amount_out_usd else 0 end) AS usd_received

, weth_spent + weth_received AS eth_volume

, weth_received - weth_spent AS weth_pl

, usd_received - usd_spent AS usd_pl

FROM ethereum.defi.ez_dex_swaps

WHERE block_timestamp BETWEEN '2023-01-01' AND '2023-01-25'

-- AND pool_name = 'JONES-WETH'

--AND contract_address = lower('0x30361f9963adb6c05f15655cb77d2da90f34c2d7')

AND (

(token_in = lower('0xe7eF051C6EA1026A70967E8F04da143C67Fa4E1f') AND token_out = lower('0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'))

OR

(token_out = lower('0xe7eF051C6EA1026A70967E8F04da143C67Fa4E1f') AND token_in = lower('0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'))

)

-- AND token_out = lower('0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2')

-- AND (token_in = lower('0xF5BC3B4cFc47f0B2128D2f7Ae5647463c19A4F7a')

-- token_out = lower('0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'))

-- AND (token_in = lower('0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2') OR

-- token_out = lower('0xF5BC3B4cFc47f0B2128D2f7Ae5647463c19A4F7a'))

-- AND usd_spent IS NOT NULL

-- AND origin_from_address = lower('0x8a2ec1337217dc52de95230a2979a408e7b4d78e')

-- AND origin_from_address = tx_to

GROUP BY origin_from_address --, contract_address -- , pool_name --, symbol_in, symbol_out -- , date

HAVING eth_volume > 1