NakedCollector2024-03-15 11:39 AM
    WITH NewTokens AS (
    SELECT
    c.ADDRESS,
    c.NAME,
    c.SYMBOL,
    DATE(c.CREATED_BLOCK_TIMESTAMP) AS CREATED_BLOCK_DATE,
    DATEDIFF(
    day,
    DATE(c.CREATED_BLOCK_TIMESTAMP),
    CURRENT_DATE
    ) AS age_days
    FROM
    crosschain.core.dim_contracts c
    WHERE
    c.CREATED_BLOCK_TIMESTAMP > CURRENT_DATE - INTERVAL '{{param_JgGe}} DAYS'
    AND c.SYMBOL IS NOT NULL
    GROUP BY
    c.ADDRESS,
    c.NAME,
    c.SYMBOL,
    DATE(c.CREATED_BLOCK_TIMESTAMP)
    ),
    TokenActivity AS (
    SELECT
    s.TOKEN_OUT,
    SUM(s.AMOUNT_OUT_USD) AS volume_out_usd,
    COUNT(DISTINCT s.TX_HASH) AS tx_count
    FROM
    crosschain.defi.ez_dex_swaps s
    WHERE
    s.BLOCK_TIMESTAMP > CURRENT_DATE - INTERVAL '{{param_JgGe}} DAYS'
    GROUP BY
    s.TOKEN_OUT
    HAVING
    SUM(s.AMOUNT_OUT_USD) > 10000
    )
    Run a query to Download Data