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

),

token_first_trade AS (

SELECT

token_traded,

MIN(block_timestamp) AS first_trade_date

FROM all_tokens

GROUP BY token_traded

),

tokens_by_month AS (

SELECT

DATE_TRUNC('month', at.block_timestamp) AS trade_month,