SELECT

BLOCK_TIMESTAMP,

DATE_TRUNC('DAY', BLOCK_TIMESTAMP) AS DATE,

TOKEN_IN AS TOKEN

FROM

base.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

base.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

),

tb3 AS (

SELECT

DATE_TRUNC('MONTH', a.DATE) AS MONTHLY,

COUNT(DISTINCT TOKEN) AS TOKENS_SWAPPED,

'Total tokens' AS Type

FROM tb1 a