DAILY | OLD_USERS | NEW_USERS | PERCENT_NEW_USERS | PERCENT_OLD_USERS | |
|---|---|---|---|---|---|
1 | 2025-01-01 00:00:00.000 | 21 | 13 | 38.235294118 | 61.764705882 |
2 | 2025-01-02 00:00:00.000 | 22 | 7 | 24.137931034 | 75.862068966 |
3 | 2025-01-03 00:00:00.000 | 21 | 5 | 19.230769231 | 80.769230769 |
4 | 2025-01-04 00:00:00.000 | 22 | 13 | 37.142857143 | 62.857142857 |
5 | 2025-01-05 00:00:00.000 | 25 | 18 | 41.860465116 | 58.139534884 |
6 | 2025-01-06 00:00:00.000 | 31 | 14 | 31.111111111 | 68.888888889 |
7 | 2025-01-07 00:00:00.000 | 35 | 12 | 25.531914894 | 74.468085106 |
8 | 2025-01-08 00:00:00.000 | 38 | 7 | 15.555555556 | 84.444444444 |
9 | 2025-01-09 00:00:00.000 | 37 | 12 | 24.489795918 | 75.510204082 |
10 | 2025-01-10 00:00:00.000 | 30 | 11 | 26.829268293 | 73.170731707 |
11 | 2025-01-11 00:00:00.000 | 34 | 10 | 22.727272727 | 77.272727273 |
12 | 2025-01-12 00:00:00.000 | 34 | 14 | 29.166666667 | 70.833333333 |
13 | 2025-01-13 00:00:00.000 | 44 | 12 | 21.428571429 | 78.571428571 |
14 | 2025-01-14 00:00:00.000 | 71 | 7 | 8.974358974 | 91.025641026 |
15 | 2025-01-15 00:00:00.000 | 48 | 6 | 11.111111111 | 88.888888889 |
16 | 2025-01-16 00:00:00.000 | 52 | 8 | 13.333333333 | 86.666666667 |
17 | 2025-01-17 00:00:00.000 | 40 | 10 | 20 | 80 |
18 | 2025-01-18 00:00:00.000 | 38 | 0 | 0 | 0 |
19 | 2025-01-19 00:00:00.000 | 50 | 2 | 3.846153846 | 96.153846154 |
20 | 2025-01-20 00:00:00.000 | 44 | 6 | 12 | 88 |
elsina2024-10-05: Daily new users vs old users
Updated 2025-02-07
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
origin_from_address,
MIN(block_timestamp) AS min_date
FROM
swell.core.ez_decoded_event_logs
where
event_name = 'Deposit'
GROUP BY
origin_from_address
),
new_users AS (
SELECT
date_trunc('day', min_date) AS date,
COUNT(DISTINCT origin_from_address) AS new_user_count
FROM
users
GROUP BY
date
),
old_users AS (
SELECT
date_trunc('day', block_timestamp) AS date,
COUNT(DISTINCT origin_from_address) AS old_user_count
FROM
swell.core.ez_decoded_event_logs
WHERE
origin_from_address IN (
SELECT origin_from_address
FROM users
WHERE min_date < date_trunc('day', block_timestamp)
)
GROUP BY
date
Last run: about 2 months ago
38
2KB
1s