DATE | ACTIVE_USERS | N_NEW_USER | CUM_USERS | RECURRING_USER | NEW_USER_PERCENT | RECURRING_USER_PERCENT | Avg Active Users | AVARAGE_7_ACTIVE_USERS | Avg New User | AVARAGE_7_NEW_USER | |
|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2025-03-19 00:00:00.000 | 107827 | 770 | 108948 | 107057 | 0.714107 | 99.285893 | 118027.897436 | 111837.857 | 1396.769231 | 1679.285 |
2 | 2025-03-18 00:00:00.000 | 106706 | 653 | 108178 | 106053 | 0.611962 | 99.388038 | 118160.376623 | 113194.142 | 1404.909091 | 1691.571 |
3 | 2025-03-17 00:00:00.000 | 108391 | 906 | 107525 | 107485 | 0.835863 | 99.164137 | 118311.092105 | 114765.571 | 1414.802632 | 1781.285 |
4 | 2025-03-16 00:00:00.000 | 116270 | 5184 | 106619 | 111086 | 4.458588 | 95.541412 | 118443.36 | 116109.857 | 1421.586667 | 1949 |
5 | 2025-03-15 00:00:00.000 | 113321 | 1774 | 101435 | 111547 | 1.565464 | 98.434536 | 118472.72973 | 116172.857 | 1370.743243 | 1468 |
6 | 2025-03-14 00:00:00.000 | 113989 | 1257 | 99661 | 112732 | 1.102738 | 98.897262 | 118543.30137 | 116712.714 | 1365.219178 | 1366.857 |
7 | 2025-03-13 00:00:00.000 | 116361 | 1211 | 98404 | 115150 | 1.040727 | 98.959273 | 118606.555556 | 117233.714 | 1366.722222 | 1318.857 |
8 | 2025-03-12 00:00:00.000 | 117321 | 856 | 97193 | 116465 | 0.729622 | 99.270378 | 118638.183099 | 117616.857 | 1368.915493 | 1380.142 |
9 | 2025-03-11 00:00:00.000 | 117706 | 1281 | 96337 | 116425 | 1.088305 | 98.911695 | 118657 | 116846.571 | 1376.242857 | 1344.714 |
10 | 2025-03-10 00:00:00.000 | 117801 | 2080 | 95056 | 115721 | 1.76569 | 98.23431 | 118670.782609 | 116940.285 | 1377.623188 | 1274.571 |
11 | 2025-03-09 00:00:00.000 | 116711 | 1817 | 92976 | 114894 | 1.556837 | 98.443163 | 118683.573529 | 117132.142 | 1367.294118 | 1132.571 |
12 | 2025-03-08 00:00:00.000 | 117100 | 1066 | 91159 | 116034 | 0.910333 | 99.089667 | 118713.014925 | 117402.714 | 1360.58209 | 954.428 |
13 | 2025-03-07 00:00:00.000 | 117636 | 921 | 90093 | 116715 | 0.782924 | 99.217076 | 118737.454545 | 117161.714 | 1365.045455 | 916 |
14 | 2025-03-06 00:00:00.000 | 119043 | 1640 | 89172 | 117403 | 1.377653 | 98.622347 | 118754.4 | 117310.571 | 1371.876923 | 891.857 |
15 | 2025-03-05 00:00:00.000 | 111929 | 608 | 87532 | 111321 | 0.543201 | 99.456799 | 118749.890625 | 117254 | 1367.6875 | 809.857 |
16 | 2025-03-04 00:00:00.000 | 118362 | 790 | 86924 | 117572 | 0.667444 | 99.332556 | 118858.15873 | 118648 | 1379.746032 | 800.857 |
17 | 2025-03-03 00:00:00.000 | 119144 | 1086 | 86134 | 118058 | 0.911502 | 99.088498 | 118866.16129 | 119162.428 | 1389.258065 | 783.428 |
18 | 2025-03-02 00:00:00.000 | 118605 | 570 | 85048 | 118035 | 0.480587 | 99.519413 | 118861.606557 | 119448.428 | 1394.229508 | 830.714 |
19 | 2025-03-01 00:00:00.000 | 115413 | 797 | 84478 | 114616 | 0.690563 | 99.309437 | 118865.883333 | 119538.714 | 1407.966667 | 913.714 |
20 | 2025-02-28 00:00:00.000 | 118678 | 752 | 83681 | 117926 | 0.633647 | 99.366353 | 118924.40678 | 119748.285 | 1418.322034 | 926.142 |
0xHaM-dNew and Returning Users
Updated 2025-03-20
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
›
⌄
-- forked from New and Returning Users @ https://flipsidecrypto.xyz/studio/queries/58e86777-a238-4332-abe9-7f336120c2af
WITH eventTb AS (
SELECT
BLOCK_TIMESTAMP,
TX_HASH,
FROM_ADDRESS as user
FROM ronin.core.fact_transactions
WHERE TO_ADDRESS in (
'0x9d3936dbd9a794ee31ef9f13814233d435bd806c'
,'0x32950db2a7164ae833121501c797d79e7b79d74c'
,'0x05b0bb3c1c320b280501b86706c3551995bc8571'
,'0x3e0674b1ddc84b0cfd9d773bb2ce23fe8f445de3'
)
)
, active_users_u as (
SELECT
date_trunc('day', block_timestamp) as date,
count(DISTINCT user) as active_users
FROM eventTb
GROUP BY date
)
, new as (
SELECT
date_trunc('day', first_tx) as date,
count(DISTINCT user) as new_user
FROM (
SELECT
user,
min(block_timestamp) as first_tx
FROM eventTb
GROUP BY 1
)
GROUP BY 1
)
Last run: 23 days ago
78
9KB
5s