WITH

token_in_swaps AS (

SELECT

token_in AS token_traded,

block_timestamp

FROM base.defi.ez_dex_swaps

WHERE platform ILIKE '%uniswap%'

AND DATE_TRUNC('year', block_timestamp) BETWEEN '2021-01-01' AND '2024-12-31'

),

token_out_swaps AS (

SELECT

token_out AS token_traded,

block_timestamp

FROM base.defi.ez_dex_swaps

WHERE platform ILIKE '%uniswap%'

AND DATE_TRUNC('year', block_timestamp) BETWEEN '2021-01-01' AND '2024-12-31'

),

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