SELECT

TX_HASH,

SYMBOL_IN AS TOKEN_IN,

SYMBOL_OUT AS TOKEN_OUT,

'Ethereum' AS CHAIN

FROM ethereum.defi.ez_dex_swaps

WHERE PLATFORM IN ('uniswap-v2', 'uniswap-v3')

UNION ALL

SELECT

TX_HASH,

SYMBOL_IN AS TOKEN_IN,

SYMBOL_OUT AS TOKEN_OUT,

'Base' AS CHAIN

FROM base.defi.ez_dex_swaps

WHERE PLATFORM IN ('uniswap-v2', 'uniswap-v3')

UNION ALL

SELECT

TX_HASH,

SYMBOL_IN AS TOKEN_IN,

SYMBOL_OUT AS TOKEN_OUT,

'Arbitrum' AS CHAIN

FROM arbitrum.defi.ez_dex_swaps

WHERE PLATFORM IN ('uniswap-v2', 'uniswap-v3')

UNION ALL

SELECT

TX_HASH,

SYMBOL_IN AS TOKEN_IN,

SYMBOL_OUT AS TOKEN_OUT,

'Polygon' AS CHAIN