SELECT *

FROM arbitrum.defi.ez_dex_swaps

WHERE SYMBOL_OUT LIKE '%ETH' OR SYMBOL_IN LIKE '%ETH'

),

eth_trade_out AS (

SELECT

BLOCK_TIMESTAMP,

TOKEN_OUT as TOKEN,

SYMBOL_OUT as SYMBOL,

AMOUNT_OUT as AMOUNT,

AMOUNT_OUT_USD as AMOUNT_USD,

'1' as TYPE -- '0' for IN , '1' for OUT

FROM

arbitrum.defi.ez_dex_swaps

WHERE

TOKEN_OUT IN (SELECT DISTINCT TOKEN_OUT FROM TOKEN_LIST WHERE SYMBOL_OUT LIKE '%ETH')

),

eth_trade_in AS (

SELECT

BLOCK_TIMESTAMP,

TOKEN_IN as TOKEN,

SYMBOL_IN as SYMBOL,

AMOUNT_IN as AMOUNT,

AMOUNT_IN_USD as AMOUNT_USD,

'0' as TYPE

FROM

arbitrum.defi.ez_dex_swaps

WHERE

TOKEN_IN IN (SELECT DISTINCT TOKEN_IN FROM TOKEN_LIST WHERE SYMBOL_IN LIKE '%ETH')

),

raw_data AS (

SELECT * FROM eth_trade_out

UNION ALL

SELECT * FROM eth_trade_in