WITH
uniswap_swaps AS (
SELECT
block_timestamp,
block_timestamp::date AS date,
tx_hash,
token_in,
symbol_in,
token_out,
symbol_out
FROM
arbitrum.defi.ez_dex_swaps
WHERE
platform IN ('uniswap-v2', 'uniswap-v3')
),
traded_tokens AS (
SELECT
DISTINCT token_in AS token_contract
FROM
uniswap_swaps
UNION
SELECT
DISTINCT token_out AS token_contract
FROM
uniswap_swaps
)
SELECT
count(*)
FROM
traded_tokens