feyikemiNew Tokens 5
    Updated 2025-01-23
    WITH tb1 AS (
    SELECT
    BLOCK_TIMESTAMP,
    DATE_TRUNC('DAY', BLOCK_TIMESTAMP) AS DATE,
    TOKEN_IN AS TOKEN
    FROM
    optimism.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
    optimism.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
    ),

    tb4 AS (
    SELECT
    DATE_TRUNC('MONTH', a.FIRST_TX) AS MONTH,
    COUNT(DISTINCT a.TOKEN) AS NEW_TOKEN
    FROM
    tb2 a
    Last run: 19 days ago
    MONTH
    NEW_TOKEN
    CUMUL_NEW_TOKENS
    1
    2024-05-01 00:00:00.000791302
    2
    2024-09-01 00:00:00.000411541
    3
    2021-12-01 00:00:00.0001248
    4
    2024-11-01 00:00:00.000341659
    5
    2021-11-01 00:00:00.0003636
    6
    2024-10-01 00:00:00.000841625
    7
    2024-07-01 00:00:00.000651462
    8
    2022-01-01 00:00:00.0001361
    9
    2022-02-01 00:00:00.000970
    10
    2023-05-01 00:00:00.00023322
    11
    2023-04-01 00:00:00.00018299
    12
    2022-03-01 00:00:00.0001383
    13
    2022-11-01 00:00:00.00011198
    14
    2024-08-01 00:00:00.000381500
    15
    2023-02-01 00:00:00.00034263
    16
    2022-04-01 00:00:00.0001194
    17
    2022-07-01 00:00:00.00013136
    18
    2022-05-01 00:00:00.00017111
    19
    2023-06-01 00:00:00.00025347
    20
    2023-07-01 00:00:00.00027374
    39
    1KB
    33s