-- origin_from_address

-- , CASE WHEN symbol_in = 'WETH' THEN token_out ELSE token_in end AS tokenAddress

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

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

-- , 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_received - weth_spent AS weth_pl

-- , usd_received - usd_spent AS usd_pl

-- , weth_spent + weth_received AS eth_volume

-- FROM ethereum.core.ez_dex_swaps

-- WHERE block_timestamp > '2023-04-14'

-- AND symbol_in IS NOT NULL

-- AND symbol_out IS NOT NULL

-- AND (

-- -- buys -> where TOKEN_IN is the token and TOKEN_OUT = WETH

-- (token_in IN ('0x25722cd432d02895d9be45f5deb60fc479c8781e','0xe1ec350ea16d1ddaff57f31387b2d9708eb7ce28','0x6982508145454ce325ddbe47a25d4ec3d2311933')

-- AND

-- token_out = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2')

-- OR

-- -- sells -> where TOKEN_IN = WETH and TOKEN_OUT is the token

-- (token_out IN ('0x25722cd432d02895d9be45f5deb60fc479c8781e','0xe1ec350ea16d1ddaff57f31387b2d9708eb7ce28','0x6982508145454ce325ddbe47a25d4ec3d2311933')

-- AND

-- token_in = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2')

-- )

-- GROUP BY origin_from_address, tokenAddress

-- HAVING eth_volume > 0.1

-- ORDER BY eth_volume DESC

with cexWallets AS (

SELECT address, address_name, label

FROM ethereum.core.dim_labels

WHERE address_name REGEXP '^coinbase [0-9]+|^binance [0-9]+|^kucoin [0-9]+|^okex [0-9]+'