Date | New Users | Total Number of Users | |
|---|---|---|---|
1 | 2024-08-25 00:00:00.000 | 22 | 22 |
2 | 2024-08-26 00:00:00.000 | 28 | 50 |
3 | 2024-08-27 00:00:00.000 | 76 | 126 |
4 | 2024-08-28 00:00:00.000 | 53 | 179 |
5 | 2024-08-29 00:00:00.000 | 26 | 205 |
6 | 2024-08-30 00:00:00.000 | 27 | 232 |
7 | 2024-08-31 00:00:00.000 | 29 | 261 |
8 | 2024-09-01 00:00:00.000 | 22 | 283 |
9 | 2024-09-02 00:00:00.000 | 11 | 294 |
10 | 2024-09-03 00:00:00.000 | 121 | 415 |
11 | 2024-09-04 00:00:00.000 | 5 | 420 |
12 | 2024-09-05 00:00:00.000 | 6 | 426 |
13 | 2024-09-06 00:00:00.000 | 6 | 432 |
14 | 2024-09-07 00:00:00.000 | 8 | 440 |
15 | 2024-09-08 00:00:00.000 | 16 | 456 |
16 | 2024-09-09 00:00:00.000 | 19 | 475 |
17 | 2024-09-10 00:00:00.000 | 17 | 492 |
18 | 2024-09-11 00:00:00.000 | 21 | 513 |
19 | 2024-09-12 00:00:00.000 | 18 | 531 |
20 | 2024-09-13 00:00:00.000 | 22 | 553 |
Eman-RazUsers Growth Over Time
Updated 7 days ago
99
1
2
3
4
5
6
7
8
9
10
›
⌄
with tab1 as (select signers[0] as user, min(block_timestamp::date) as first_tx_date
from eclipse.core.fact_transactions
where succeeded='TRUE'
group by 1)
select date_trunc('{{Time_Frame}}',first_tx_date) as "Date", count(distinct user) as "New Users",
sum("New Users") over (order by "Date") as "Total Number of Users"
from tab1
group by 1
order by 1
Last run: 7 days ago
...
219
8KB
484s