DATE_TIME | CLASSIFY | TOTAL_USERS | |
---|---|---|---|
1 | 2023-08-28 00:00:00.000 | new user | 8536 |
2 | 2023-08-28 00:00:00.000 | regular user | 6493 |
3 | 2023-09-04 00:00:00.000 | regular user | 5792 |
4 | 2023-09-04 00:00:00.000 | new user | 4072 |
5 | 2023-09-11 00:00:00.000 | regular user | 5321 |
6 | 2023-09-11 00:00:00.000 | new user | 3553 |
7 | 2023-09-18 00:00:00.000 | new user | 3688 |
8 | 2023-09-18 00:00:00.000 | regular user | 5331 |
9 | 2023-09-25 00:00:00.000 | new user | 5074 |
10 | 2023-09-25 00:00:00.000 | regular user | 6782 |
11 | 2023-10-02 00:00:00.000 | regular user | 7906 |
12 | 2023-10-02 00:00:00.000 | new user | 6500 |
13 | 2023-10-09 00:00:00.000 | regular user | 6884 |
14 | 2023-10-09 00:00:00.000 | new user | 5071 |
15 | 2023-10-16 00:00:00.000 | new user | 6244 |
16 | 2023-10-16 00:00:00.000 | regular user | 7963 |
17 | 2023-10-23 00:00:00.000 | new user | 4329 |
18 | 2023-10-23 00:00:00.000 | regular user | 6311 |
19 | 2023-10-30 00:00:00.000 | regular user | 5829 |
20 | 2023-10-30 00:00:00.000 | new user | 3953 |
freeman_7New users
Updated 2024-12-31
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
›
⌄
with slipstream as (
select
date_trunc({{period}}, block_timestamp) as date_time,
origin_from_address as address,
row_number() over(
partition by address
order by
block_timestamp
) as nu
from
base.defi.ez_dex_swaps
where
platform in ('aerodrome', 'aerodrome-slipstream')
)
SELECT
date_time,
CASE
when nu = 1 then 'new user'
else 'regular user'
end as classify,
count(distinct address) as total_users
from
slipstream
group by
1,
2
order by
1 asc
Last run: 3 months ago
...
142
6KB
18s