DAILY | OLD_USERS | NEW_USERS | PERCENT_NEW_USERS | PERCENT_OLD_USERS | |
|---|---|---|---|---|---|
1 | 2024-11-18 00:00:00.000 | 1 | 1 | 50 | 50 |
2 | 2024-11-19 00:00:00.000 | 1 | 3 | 75 | 25 |
3 | 2024-11-20 00:00:00.000 | 4 | 2347 | 99.829859634 | 0.1701403658 |
4 | 2024-11-21 00:00:00.000 | 566 | 2843 | 83.396890584 | 16.603109416 |
5 | 2024-11-22 00:00:00.000 | 762 | 2697 | 77.970511709 | 22.029488291 |
6 | 2024-11-23 00:00:00.000 | 959 | 2243 | 70.04996877 | 29.95003123 |
7 | 2024-11-24 00:00:00.000 | 941 | 2786 | 74.751811108 | 25.248188892 |
8 | 2024-11-25 00:00:00.000 | 1998 | 3407 | 63.034227567 | 36.965772433 |
9 | 2024-11-26 00:00:00.000 | 5195 | 6041 | 53.764684941 | 46.235315059 |
10 | 2024-11-27 00:00:00.000 | 8082 | 6661 | 45.180763752 | 54.819236248 |
11 | 2024-11-28 00:00:00.000 | 5035 | 9737 | 65.915245058 | 34.084754942 |
12 | 2024-11-29 00:00:00.000 | 3734 | 7990 | 68.150801774 | 31.849198226 |
13 | 2024-11-30 00:00:00.000 | 3698 | 8965 | 70.796809603 | 29.203190397 |
14 | 2024-12-01 00:00:00.000 | 3221 | 9692 | 75.05614497 | 24.94385503 |
15 | 2024-12-02 00:00:00.000 | 5885 | 9984 | 62.915117525 | 37.084882475 |
16 | 2024-12-03 00:00:00.000 | 70690 | 7605 | 9.713263938 | 90.286736062 |
17 | 2024-12-04 00:00:00.000 | 79534 | 10929 | 12.081182362 | 87.918817638 |
18 | 2024-12-05 00:00:00.000 | 89607 | 12692 | 12.406768395 | 87.593231605 |
19 | 2024-12-06 00:00:00.000 | 95189 | 507 | 0.5298027086 | 99.470197291 |
20 | 2024-12-07 00:00:00.000 | 76098 | 57 | 0.0748473508 | 99.925152649 |
elsinaDaily new users vs old users (Fablebone)
Updated 2025-02-21
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
ronin.core.fact_event_logs
where
contract_address in ('0x3825ff6b6ad0f460660547e5890425ee821bd02c', '0xd887014121ddbad4494093689997125dde30612a')
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
ronin.core.fact_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: 29 days ago
22
1KB
3s