SELECT

BLOCK_TIMESTAMP,

TX_HASH,

TOKEN_IN,

TOKEN_OUT

FROM polygon.defi.ez_dex_swaps

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

),

Tb2 AS (

SELECT

DATE_TRUNC('MONTH', BLOCK_TIMESTAMP) AS MONTH,

TOKEN_IN AS TOKEN

FROM Tb1

UNION ALL

SELECT

DATE_TRUNC('MONTH', BLOCK_TIMESTAMP) AS MONTH,

TOKEN_OUT AS TOKEN

FROM Tb1

),

Tb3 AS (

SELECT

MONTH,

COUNT(DISTINCT TOKEN) AS UNIQUE_TOKENS,

SUM(COUNT(DISTINCT TOKEN)) OVER (ORDER BY MONTH) AS CUMULATIVE_TOKENS,

LAG(COUNT(DISTINCT TOKEN), 1) OVER (ORDER BY MONTH) AS PREV_MONTH_TOKENS,

COUNT(DISTINCT TOKEN) - LAG(COUNT(DISTINCT TOKEN), 1) OVER (ORDER BY MONTH) AS TOKEN_DIFF

FROM Tb2

GROUP BY MONTH

SELECT

MONTH,

UNIQUE_TOKENS,