DATE | USERS | NEW_USERS | |
|---|---|---|---|
1 | 2019-06-24 00:00:00.000 | 495 | 495 |
2 | 2019-07-01 00:00:00.000 | 3012 | 2822 |
3 | 2019-07-08 00:00:00.000 | 5637 | 3598 |
4 | 2019-07-15 00:00:00.000 | 10594 | 7224 |
5 | 2019-07-22 00:00:00.000 | 10064 | 4531 |
6 | 2019-07-29 00:00:00.000 | 12516 | 5061 |
7 | 2019-08-05 00:00:00.000 | 15924 | 7826 |
8 | 2019-08-12 00:00:00.000 | 11911 | 5472 |
9 | 2019-08-19 00:00:00.000 | 254576 | 248833 |
10 | 2019-08-26 00:00:00.000 | 37031 | 30590 |
11 | 2019-09-02 00:00:00.000 | 127586 | 119556 |
12 | 2019-09-09 00:00:00.000 | 89279 | 79097 |
13 | 2019-09-16 00:00:00.000 | 16828 | 7563 |
14 | 2019-09-23 00:00:00.000 | 115328 | 106988 |
15 | 2019-09-30 00:00:00.000 | 21266 | 9979 |
16 | 2019-10-07 00:00:00.000 | 56530 | 45406 |
17 | 2019-10-14 00:00:00.000 | 100378 | 84805 |
18 | 2019-10-21 00:00:00.000 | 123980 | 98528 |
19 | 2019-10-28 00:00:00.000 | 311018 | 289926 |
20 | 2019-11-04 00:00:00.000 | 574322 | 545989 |
mamad-5XN3k3Klaytn 3
Updated 10 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
24
25
26
27
28
29
30
31
32
33
34
›
⌄
with new_usert as (
select
date_trunc('week',first_date) as date,
count (distinct user) as new_users
from(
select
distinct from_address as user,
min(block_Timestamp) as first_date
from kaia.core.fact_transactions
group by 1)
group by 1
),
usert as (
select
date_trunc('week',block_Timestamp) as date,
count(distinct from_address) as users
from kaia.core.fact_transactions
group by 1)
select
date,
users,
new_users
from usert
left join new_usert using (date)
where date < current_date
order by 1 asc
Last run: 10 days ago
...
304
12KB
126s