SELECT

LEAST(SYMBOL_IN, SYMBOL_OUT) AS SYMBOL_1,

GREATEST(SYMBOL_IN, SYMBOL_OUT) AS SYMBOL_2,

'Ethereum' AS CHAIN,

TX_HASH

FROM ethereum.defi.ez_dex_swaps

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

UNION ALL

SELECT

LEAST(SYMBOL_IN, SYMBOL_OUT) AS SYMBOL_1,

GREATEST(SYMBOL_IN, SYMBOL_OUT) AS SYMBOL_2,

'Base' AS CHAIN,

TX_HASH

FROM base.defi.ez_dex_swaps

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

UNION ALL

SELECT

LEAST(SYMBOL_IN, SYMBOL_OUT) AS SYMBOL_1,

GREATEST(SYMBOL_IN, SYMBOL_OUT) AS SYMBOL_2,

'Arbitrum' AS CHAIN,

TX_HASH

FROM arbitrum.defi.ez_dex_swaps

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

UNION ALL

SELECT

LEAST(SYMBOL_IN, SYMBOL_OUT) AS SYMBOL_1,

GREATEST(SYMBOL_IN, SYMBOL_OUT) AS SYMBOL_2,

'Polygon' AS CHAIN,

TX_HASH