WEEK_START | ACTIVE_ADDRESSES | CUMULATIVE_ACTIVE_ADDRESSES | |
|---|---|---|---|
1 | 2022-10-10 00:00:00.000 | 2 | 2 |
2 | 2022-10-17 00:00:00.000 | 5525 | 5527 |
3 | 2022-10-24 00:00:00.000 | 4016 | 9543 |
4 | 2022-10-31 00:00:00.000 | 3096 | 12639 |
5 | 2022-11-07 00:00:00.000 | 2372 | 15011 |
6 | 2022-11-14 00:00:00.000 | 1484 | 16495 |
7 | 2022-11-21 00:00:00.000 | 1439 | 17934 |
8 | 2022-11-28 00:00:00.000 | 1437 | 19371 |
9 | 2022-12-05 00:00:00.000 | 1374 | 20745 |
10 | 2022-12-12 00:00:00.000 | 1463 | 22208 |
11 | 2022-12-19 00:00:00.000 | 1004 | 23212 |
12 | 2022-12-26 00:00:00.000 | 797 | 24009 |
13 | 2023-01-02 00:00:00.000 | 929 | 24938 |
14 | 2023-01-09 00:00:00.000 | 1319 | 26257 |
15 | 2023-01-16 00:00:00.000 | 1554 | 27811 |
16 | 2023-01-23 00:00:00.000 | 1569 | 29380 |
17 | 2023-01-30 00:00:00.000 | 1343 | 30723 |
18 | 2023-02-06 00:00:00.000 | 1201 | 31924 |
19 | 2023-02-13 00:00:00.000 | 1631 | 33555 |
20 | 2023-02-20 00:00:00.000 | 1373 | 34928 |
datavortexActive Wallets
Updated 2025-03-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
›
⌄
WITH total_addresses AS (
SELECT
DISTINCT owner_address
FROM
aptos.core.dim_aptos_names
WHERE
domain ILIKE 'petra'
),
active_wallets AS (
SELECT
DISTINCT t.account_address,
DATE_TRUNC('week', t.block_timestamp) AS week_start
FROM
total_addresses fa
LEFT JOIN
aptos.core.fact_transfers t
ON
fa.owner_address = t.account_address
WHERE
t.account_address IS NOT NULL
)
SELECT
week_start,
COUNT(DISTINCT account_address) AS active_addresses,
SUM(COUNT(DISTINCT account_address)) OVER (ORDER BY week_start) AS cumulative_active_addresses
FROM
active_wallets
GROUP BY
week_start
ORDER BY
week_start;
Last run: about 2 months agoAuto-refreshes every 12 hours
...
126
5KB
38s