zakkisyedSolana DAU/DNU
    Updated 2023-11-30
    WITH daily_users AS (
    SELECT
    DATE_TRUNC('day', block_timestamp) AS day_,
    s.value::STRING AS signer
    FROM
    solana.core.fact_transactions,
    LATERAL FLATTEN(input => signers) s
    WHERE
    block_timestamp < '2023-12-01'
    ),

    first_appearance AS (
    SELECT
    signer,
    MIN(day_) AS first_seen
    FROM
    daily_users
    GROUP BY
    signer
    ),

    nov_daily_active_users AS (
    SELECT
    day_,
    COUNT(DISTINCT signer) AS daily_active_users
    FROM
    daily_users
    WHERE
    day_ >= '2023-11-01' AND day_ < '2023-12-01'
    GROUP BY
    day_
    ),

    nov_daily_new_users AS (
    SELECT
    day_,
    Run a query to Download Data