DAY | New Wallets | Returning Wallets | Total Active Wallets | |
|---|---|---|---|---|
1 | 2025-03-28 00:00:00.000 | 67 | 0 | 67 |
2 | 2025-03-29 00:00:00.000 | 161 | 9 | 170 |
3 | 2025-03-30 00:00:00.000 | 161 | 9 | 170 |
4 | 2025-03-31 00:00:00.000 | 171 | 6 | 177 |
5 | 2025-04-01 00:00:00.000 | 188 | 8 | 196 |
6 | 2025-04-02 00:00:00.000 | 290 | 18 | 308 |
7 | 2025-04-03 00:00:00.000 | 315 | 23 | 338 |
8 | 2025-04-04 00:00:00.000 | 507 | 53 | 560 |
9 | 2025-04-05 00:00:00.000 | 501 | 42 | 543 |
10 | 2025-04-06 00:00:00.000 | 415 | 45 | 460 |
11 | 2025-04-07 00:00:00.000 | 506 | 88 | 594 |
12 | 2025-04-08 00:00:00.000 | 586 | 484 | 1070 |
13 | 2025-04-09 00:00:00.000 | 561 | 502 | 1063 |
14 | 2025-04-10 00:00:00.000 | 569 | 347 | 916 |
15 | 2025-04-11 00:00:00.000 | 541 | 372 | 913 |
16 | 2025-04-12 00:00:00.000 | 210 | 155 | 365 |
MasiDaily New Vs. Returning
Updated 2025-04-12
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
›
⌄
WITH tb1 AS (
SELECT
from_address,
MIN(block_timestamp::date) AS first_date
FROM mezo.testnet.fact_transactions
GROUP BY from_address
),
tb2 AS (
SELECT
from_address,
block_timestamp::date AS day
FROM mezo.testnet.fact_transactions
)
SELECT
da.day,
COUNT(DISTINCT CASE WHEN da.day = ft.first_date THEN da.from_address END) AS "New Wallets",
COUNT(DISTINCT CASE WHEN da.day > ft.first_date THEN da.from_address END) AS "Returning Wallets",
COUNT(DISTINCT da.from_address) AS "Total Active Wallets"
FROM tb2 da
JOIN tb1 ft
ON da.from_address = ft.from_address
GROUP BY da.day
ORDER BY da.day;
Last run: 12 days ago
16
625B
2s