DATE | NEW_DAUS | Total new DAUs | |
|---|---|---|---|
1 | 2023-05-22 00:00:00.000 | 50 | 50 |
2 | 2023-05-29 00:00:00.000 | 4 | 54 |
3 | 2023-06-05 00:00:00.000 | 4 | 58 |
4 | 2023-06-12 00:00:00.000 | 1 | 59 |
5 | 2023-06-26 00:00:00.000 | 5 | 64 |
6 | 2023-07-03 00:00:00.000 | 2 | 66 |
7 | 2023-07-10 00:00:00.000 | 3 | 69 |
8 | 2023-07-17 00:00:00.000 | 2 | 71 |
9 | 2023-07-24 00:00:00.000 | 7 | 78 |
10 | 2023-07-31 00:00:00.000 | 25 | 103 |
11 | 2023-08-07 00:00:00.000 | 35 | 138 |
12 | 2023-08-14 00:00:00.000 | 3214 | 3352 |
13 | 2023-08-21 00:00:00.000 | 970 | 4322 |
14 | 2023-08-28 00:00:00.000 | 262 | 4584 |
15 | 2023-09-04 00:00:00.000 | 445 | 5029 |
16 | 2023-09-11 00:00:00.000 | 126 | 5155 |
17 | 2023-09-18 00:00:00.000 | 702 | 5857 |
18 | 2023-09-25 00:00:00.000 | 35 | 5892 |
19 | 2023-10-02 00:00:00.000 | 95 | 5987 |
20 | 2023-10-09 00:00:00.000 | 21 | 6008 |
adriaparcerisasdau base 2 copy
Updated 2024-02-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
›
⌄
WITH
daus as (
SELECT
distinct tx_from as users,
trunc(block_timestamp,'week') as weeks,
count(distinct trunc(block_timestamp,'day')) as active_days
from sei.core.fact_transactions
group by 1,2
having active_days>=4
),
active_users as (
SELECT
distinct tx_from as user,
min(block_timestamp) as debut
from sei.core.fact_transactions
where tx_from in (select users from daus)
group by 1
)
select
trunc(debut,'week') as date,
count(distinct user) as new_DAUs,
sum(new_DAUs) over (order by date) as "Total new DAUs"
from active_users
group by 1
order by 1 asc
Last run: about 1 year ago
38
1KB
26s