DAY | USERS | CUM_USERS | |
|---|---|---|---|
1 | 2024-12-12 00:00:00.000 | 10 | 33 |
2 | 2025-01-08 00:00:00.000 | 1836 | 58090 |
3 | 2024-12-29 00:00:00.000 | 3522 | 34898 |
4 | 2024-12-24 00:00:00.000 | 3464 | 19519 |
5 | 2024-12-23 00:00:00.000 | 1986 | 16055 |
6 | 2025-01-14 00:00:00.000 | 370 | 66164 |
7 | 2024-12-07 00:00:00.000 | 1 | 2 |
8 | 2024-12-26 00:00:00.000 | 3762 | 26361 |
9 | 2025-01-01 00:00:00.000 | 2097 | 43664 |
10 | 2025-01-05 00:00:00.000 | 2308 | 52345 |
11 | 2024-12-31 00:00:00.000 | 3856 | 41567 |
12 | 2024-12-22 00:00:00.000 | 1305 | 14069 |
13 | 2025-01-03 00:00:00.000 | 2046 | 47588 |
14 | 2024-12-10 00:00:00.000 | 5 | 13 |
15 | 2024-12-11 00:00:00.000 | 10 | 23 |
16 | 2024-12-25 00:00:00.000 | 3080 | 22599 |
17 | 2024-12-19 00:00:00.000 | 5299 | 10159 |
18 | 2024-12-21 00:00:00.000 | 1167 | 12764 |
19 | 2025-01-04 00:00:00.000 | 2449 | 50037 |
20 | 2025-01-02 00:00:00.000 | 1878 | 45542 |
freemartianUser Growth
Updated 2025-01-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
WITH first_tx AS(
SELECT
from_address AS user,
min(BLOCK_TIMESTAMP) AS first_time
FROM ink.core.fact_transactions
GROUP BY 1
)
SELECT
first_time::date AS day,
count(user) AS users,
SUM(users) OVER (ORDER BY day ASC) AS cum_users
FROM first_tx
GROUP BY 1
Last run: 2 months agoAuto-refreshes every 1 hour
38
1KB
3s