SELECT BLOCK_TIMESTAMP,TX_HASH,ORIGIN_FROM_ADDRESS AS USER,TOKEN_IN AS TOKEN_ADDRESS,SYMBOL_IN AS SYMBOL,'arbitrum' AS NETWORK FROM arbitrum.defi.ez_dex_swaps WHERE platform IN ('uniswap-v2','uniswap-v3')

UNION ALL

SELECT BLOCK_TIMESTAMP,TX_HASH,ORIGIN_FROM_ADDRESS AS USER,TOKEN_OUT AS TOKEN_ADDRESS,SYMBOL_OUT,'arbitrum' AS NETWORK FROM arbitrum.defi.ez_dex_swaps WHERE platform IN ('uniswap-v2','uniswap-v3')

UNION ALL

SELECT BLOCK_TIMESTAMP,TX_HASH,ORIGIN_FROM_ADDRESS AS USER,TOKEN_IN AS TOKEN_ADDRESS,SYMBOL_IN,'ethereum' AS NETWORK FROM ethereum.defi.ez_dex_swaps WHERE platform IN ('uniswap-v2','uniswap-v3')

UNION ALL

SELECT BLOCK_TIMESTAMP,TX_HASH,ORIGIN_FROM_ADDRESS AS USER,TOKEN_OUT AS TOKEN_ADDRESS,SYMBOL_OUT,'ethereum' AS NETWORK FROM ethereum.defi.ez_dex_swaps WHERE platform IN ('uniswap-v2','uniswap-v3')

UNION ALL

SELECT BLOCK_TIMESTAMP,TX_HASH,ORIGIN_FROM_ADDRESS AS USER,TOKEN_IN AS TOKEN_ADDRESS,SYMBOL_IN,'polygon' AS NETWORK FROM polygon.defi.ez_dex_swaps WHERE platform IN ('uniswap-v2','uniswap-v3')

UNION ALL

SELECT BLOCK_TIMESTAMP,TX_HASH,ORIGIN_FROM_ADDRESS AS USER,TOKEN_OUT AS TOKEN_ADDRESS,SYMBOL_OUT,'polygon' AS NETWORK FROM polygon.defi.ez_dex_swaps WHERE platform IN ('uniswap-v2','uniswap-v3')

UNION ALL

SELECT BLOCK_TIMESTAMP,TX_HASH,ORIGIN_FROM_ADDRESS AS USER,TOKEN_IN AS TOKEN_ADDRESS,SYMBOL_IN,'optimism' AS NETWORK FROM optimism.defi.ez_dex_swaps WHERE platform IN ('uniswap-v2','uniswap-v3')

UNION ALL

SELECT BLOCK_TIMESTAMP,TX_HASH,ORIGIN_FROM_ADDRESS AS USER,TOKEN_OUT AS TOKEN_ADDRESS,SYMBOL_OUT,'optimism' AS NETWORK FROM optimism.defi.ez_dex_swaps WHERE platform IN ('uniswap-v2','uniswap-v3')

UNION ALL

SELECT BLOCK_TIMESTAMP,TX_HASH,ORIGIN_FROM_ADDRESS AS USER,TOKEN_IN AS TOKEN_ADDRESS,SYMBOL_IN,'base' AS NETWORK FROM base.defi.ez_dex_swaps WHERE platform IN ('uniswap-v2','uniswap-v3')

UNION ALL

SELECT BLOCK_TIMESTAMP,TX_HASH,ORIGIN_FROM_ADDRESS AS USER,TOKEN_OUT AS TOKEN_ADDRESS,SYMBOL_OUT,'base' AS NETWORK FROM base.defi.ez_dex_swaps WHERE platform IN ('uniswap-v2','uniswap-v3')

SYMBOL,

MIN(BLOCK_TIMESTAMP) AS first_trade,

MAX(BLOCK_TIMESTAMP) AS last_trade,

ABS(DATEDIFF('DAY',MAX(BLOCK_TIMESTAMP), MIN(BLOCK_TIMESTAMP))) AS lifespan_days,

COUNT(DISTINCT tx_hash) AS TXNS