DATE | New Users | CUM_NEW_USERS | |
|---|---|---|---|
1 | 2021-12-20 00:00:00.000 | 14 | 14 |
2 | 2021-12-27 00:00:00.000 | 1 | 15 |
3 | 2022-01-03 00:00:00.000 | 28 | 43 |
4 | 2022-01-10 00:00:00.000 | 111 | 154 |
5 | 2022-01-17 00:00:00.000 | 21 | 175 |
6 | 2022-01-24 00:00:00.000 | 271 | 446 |
7 | 2022-01-31 00:00:00.000 | 60 | 506 |
8 | 2022-02-07 00:00:00.000 | 3 | 509 |
9 | 2022-02-14 00:00:00.000 | 24 | 533 |
10 | 2022-02-21 00:00:00.000 | 15 | 548 |
11 | 2022-02-28 00:00:00.000 | 4 | 552 |
12 | 2022-03-07 00:00:00.000 | 6 | 558 |
13 | 2022-03-14 00:00:00.000 | 52 | 610 |
14 | 2022-03-21 00:00:00.000 | 2 | 612 |
15 | 2022-03-28 00:00:00.000 | 2 | 614 |
16 | 2022-04-04 00:00:00.000 | 5 | 619 |
17 | 2022-04-11 00:00:00.000 | 1 | 620 |
18 | 2022-04-18 00:00:00.000 | 9 | 629 |
19 | 2022-04-25 00:00:00.000 | 2 | 631 |
20 | 2022-05-02 00:00:00.000 | 2 | 633 |
SalehAXL_T-N-D
Updated 4 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
with lst_all as (
select
tx_from
,min(block_timestamp)::date as min_date
from axelar.core.fact_transactions
group by 1
order by 1
)
select
date_trunc(week,min_date) as date
,count(DISTINCT tx_from) as "New Users"
,sum("New Users") over (order by date) as cum_new_users
from lst_all
group by 1
order by 1
Last run: 4 days ago
...
184
7KB
3s