DATE | NEW_USERS | TOTAL_USERS | |
|---|---|---|---|
1 | 2024-09-27 00:00:00.000 | 302 | 1987 |
2 | 2024-10-12 00:00:00.000 | 366 | 6690 |
3 | 2024-10-02 00:00:00.000 | 294 | 3631 |
4 | 2025-02-01 00:00:00.000 | 8241 | 723380 |
5 | 2025-02-28 00:00:00.000 | 5802 | 892479 |
6 | 2025-03-11 00:00:00.000 | 4203 | 944035 |
7 | 2024-09-10 00:00:00.000 | 17 | 492 |
8 | 2025-01-08 00:00:00.000 | 14266 | 461989 |
9 | 2025-01-15 00:00:00.000 | 10237 | 547295 |
10 | 2025-01-24 00:00:00.000 | 9272 | 647715 |
11 | 2024-09-21 00:00:00.000 | 123 | 771 |
12 | 2024-12-12 00:00:00.000 | 1875 | 187261 |
13 | 2025-02-20 00:00:00.000 | 4480 | 847104 |
14 | 2024-10-30 00:00:00.000 | 640 | 95224 |
15 | 2024-10-09 00:00:00.000 | 282 | 5575 |
16 | 2024-12-26 00:00:00.000 | 14369 | 272478 |
17 | 2024-09-14 00:00:00.000 | 7 | 561 |
18 | 2024-10-26 00:00:00.000 | 502 | 92902 |
19 | 2024-12-24 00:00:00.000 | 21003 | 241154 |
20 | 2024-12-29 00:00:00.000 | 17281 | 317610 |
Pine Analyticsdaily-sapphire
Updated 2025-03-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
select
date,
count(*) as new_users,
sum(new_users) over (order by date) as total_users
from (
select
signers[0] as wallet,
min(date(block_timestamp)) as date
from eclipse.core.fact_transactions
group by 1
)
group by 1
Last run: about 1 month ago
...
207
8KB
166s