token_in_swaps AS (

SELECT

'Ethereum' AS blockchain,

token_in AS token_traded,

block_timestamp

FROM ethereum.defi.ez_dex_swaps

WHERE platform ILIKE '%uniswap%'

UNION ALL

SELECT

'Base' AS blockchain,

token_in AS token_traded,

block_timestamp

FROM base.defi.ez_dex_swaps

WHERE platform ILIKE '%uniswap%'

UNION ALL

SELECT

'Optimism' AS blockchain,

token_in AS token_traded,

block_timestamp

FROM optimism.defi.ez_dex_swaps

WHERE platform ILIKE '%uniswap%'

UNION ALL

SELECT

'BSC' AS blockchain,

token_in AS token_traded,

block_timestamp

FROM bsc.defi.ez_dex_swaps

WHERE platform ILIKE '%uniswap%'