token_in_swaps AS (

SELECT

token_in AS token_traded,

block_timestamp

FROM ethereum.defi.ez_dex_swaps

WHERE platform ILIKE '%uniswap%'

-- AND block_timestamp >= '2021-01-01'

),

token_out_swaps AS (

SELECT

token_out AS token_traded,

block_timestamp

FROM ethereum.defi.ez_dex_swaps

WHERE platform ILIKE '%uniswap%'

-- AND block_timestamp >= '2021-01-01'

),

all_tokens AS (

SELECT * FROM token_in_swaps

UNION ALL

SELECT * FROM token_out_swaps

),

trade_date AS (

SELECT

token_traded,

MIN(block_timestamp) AS first_trade_date,

MAX(block_timestamp) AS latest_trade_date

FROM all_tokens

GROUP BY token_traded

),

tokens_by_lifespan AS (

SELECT