-- Ethereum swaps

SELECT BLOCK_TIMESTAMP, TOKEN_IN AS TOKEN, 'Ethereum' AS CHAIN

FROM ethereum.defi.ez_dex_swaps

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

UNION ALL

SELECT BLOCK_TIMESTAMP, TOKEN_OUT AS TOKEN, 'Ethereum' AS CHAIN

FROM ethereum.defi.ez_dex_swaps

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

UNION ALL

-- Base swaps

SELECT BLOCK_TIMESTAMP, TOKEN_IN AS TOKEN, 'Base' AS CHAIN

FROM base.defi.ez_dex_swaps

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

UNION ALL

SELECT BLOCK_TIMESTAMP, TOKEN_OUT AS TOKEN, 'Base' AS CHAIN

FROM base.defi.ez_dex_swaps

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

UNION ALL

-- Arbitrum swaps

SELECT BLOCK_TIMESTAMP, TOKEN_IN AS TOKEN, 'Arbitrum' AS CHAIN

FROM arbitrum.defi.ez_dex_swaps

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

UNION ALL

SELECT BLOCK_TIMESTAMP, TOKEN_OUT AS TOKEN, 'Arbitrum' AS CHAIN

FROM arbitrum.defi.ez_dex_swaps