datavortexweekly traders
    Updated 2024-11-17
    WITH weekly_active_users AS (
    SELECT
    DATE_TRUNC('week', block_timestamp) AS week,
    COUNT(DISTINCT tx_signer) AS "Weekly Active Users"
    FROM near.core.fact_transactions
    WHERE block_timestamp >= '2024-01-01'
    AND block_timestamp < '2025-01-01'
    GROUP BY week
    )
    SELECT
    week,
    "Weekly Active Users",
    SUM("Weekly Active Users") OVER (ORDER BY week) AS "Cumulative Users"
    FROM weekly_active_users
    ORDER BY week;

    QueryRunArchived: QueryRun has been archived