SELECT

BLOCK_TIMESTAMP,

DATE_TRUNC('DAY', BLOCK_TIMESTAMP) AS DATE,

TOKEN_IN AS TOKEN

FROM

optimism.defi.ez_dex_swaps

WHERE

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

UNION ALL

SELECT

BLOCK_TIMESTAMP,

DATE_TRUNC('DAY', BLOCK_TIMESTAMP) AS DATE,

TOKEN_OUT AS TOKEN

FROM

optimism.defi.ez_dex_swaps

WHERE

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

),

tb2 AS (

SELECT

TOKEN,

MIN(DATE) AS FIRST_TX

FROM tb1

GROUP BY 1

),

tb4 AS (

SELECT

DATE_TRUNC('MONTH', a.FIRST_TX) AS MONTH,

COUNT(DISTINCT a.TOKEN) AS NEW_TOKEN

FROM

tb2 a