WITH

token_in_swaps AS (

SELECT

token_in AS token_traded,

block_timestamp

FROM optimism.defi.ez_dex_swaps

WHERE platform ILIKE '%uniswap%'

),

token_out_swaps AS (

SELECT

token_out AS token_traded,

block_timestamp

FROM optimism.defi.ez_dex_swaps

WHERE platform ILIKE '%uniswap%'

),

all_tokens AS (

SELECT * FROM token_in_swaps

UNION ALL

SELECT * FROM token_out_swaps

),

tokens_by_year AS (

SELECT

DATE_TRUNC('year', block_timestamp) AS trade_year,

token_traded

FROM all_tokens

),

yearly_token_count AS (

SELECT

EXTRACT(YEAR FROM trade_year) AS trade_year,

COUNT(DISTINCT token_traded) AS unique_tokens_traded

FROM tokens_by_year