DAILY | OLD_USERS | NEW_USERS | PERCENT_NEW_USERS | PERCENT_OLD_USERS | |
|---|---|---|---|---|---|
1 | 2024-12-17 00:00:00.000 | 21 | 1427 | 98.549723757 | 1.450276243 |
2 | 2024-12-18 00:00:00.000 | 838 | 3374 | 80.104463438 | 19.895536562 |
3 | 2024-12-19 00:00:00.000 | 1222 | 5299 | 81.260542862 | 18.739457138 |
4 | 2024-12-20 00:00:00.000 | 1324 | 1438 | 52.063721941 | 47.936278059 |
5 | 2024-12-21 00:00:00.000 | 957 | 1167 | 54.943502825 | 45.056497175 |
6 | 2024-12-22 00:00:00.000 | 839 | 1305 | 60.867537313 | 39.132462687 |
7 | 2024-12-23 00:00:00.000 | 1071 | 1986 | 64.965652601 | 35.034347399 |
8 | 2024-12-24 00:00:00.000 | 1436 | 3464 | 70.693877551 | 29.306122449 |
9 | 2024-12-25 00:00:00.000 | 1505 | 3080 | 67.175572519 | 32.824427481 |
10 | 2024-12-26 00:00:00.000 | 2084 | 3762 | 64.351693466 | 35.648306534 |
11 | 2024-12-27 00:00:00.000 | 1892 | 2253 | 54.35464415 | 45.64535585 |
12 | 2024-12-28 00:00:00.000 | 2124 | 2762 | 56.528857962 | 43.471142038 |
13 | 2024-12-29 00:00:00.000 | 2321 | 3522 | 60.277254835 | 39.722745165 |
14 | 2024-12-30 00:00:00.000 | 2861 | 2813 | 49.577017977 | 50.422982023 |
15 | 2024-12-31 00:00:00.000 | 3439 | 3856 | 52.858122001 | 47.141877999 |
16 | 2025-01-01 00:00:00.000 | 2858 | 2097 | 42.320887992 | 57.679112008 |
17 | 2025-01-02 00:00:00.000 | 2602 | 1878 | 41.919642857 | 58.080357143 |
18 | 2025-01-03 00:00:00.000 | 2986 | 2046 | 40.659777424 | 59.340222576 |
19 | 2025-01-04 00:00:00.000 | 3337 | 2449 | 42.326304874 | 57.673695126 |
20 | 2025-01-05 00:00:00.000 | 3285 | 2308 | 41.265868049 | 58.734131951 |
elsina2024-10-05: Daily new users vs old users
Updated 2025-04-06
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
33
34
35
36
›
⌄
WITH users AS (
SELECT
from_address,
MIN(block_timestamp) AS min_date
FROM
ink.core.fact_transactions
GROUP BY
from_address
),
new_users AS (
SELECT
date_trunc('day', min_date) AS date,
COUNT(DISTINCT from_address) AS new_user_count
FROM
users
GROUP BY
date
),
old_users AS (
SELECT
date_trunc('day', block_timestamp) AS date,
COUNT(DISTINCT from_address) AS old_user_count
FROM
ink.core.fact_transactions
WHERE
from_address IN (
SELECT from_address
FROM users
WHERE min_date < date_trunc('day', block_timestamp)
)
GROUP BY
date
)
Last run: 2 months ago
...
110
7KB
3s