datavortexcreated
    Updated 2025-01-10
    SELECT
    DATE_TRUNC('week', inserted_timestamp) AS week_start,
    COUNT(DISTINCT owner_address) AS created_address,
    SUM(COUNT(DISTINCT owner_address)) OVER (
    ORDER BY
    DATE_TRUNC('week', inserted_timestamp)
    ) AS cumulative_created_address
    FROM
    aptos.core.dim_aptos_names
    WHERE domain ILIKE 'petra'
    GROUP BY
    week_start
    ORDER BY
    week_start;

    QueryRunArchived: QueryRun has been archived