datavortexcreated
Updated 2025-01-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
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