DAILY | OLD_USERS | NEW_USERS | PERCENT_NEW_USERS | PERCENT_OLD_USERS | |
|---|---|---|---|---|---|
1 | 2025-01-01 00:00:00.000 | 7565 | 3185 | 29.627906977 | 70.372093023 |
2 | 2025-01-02 00:00:00.000 | 7975 | 2002 | 20.06615215 | 79.93384785 |
3 | 2025-01-03 00:00:00.000 | 7097 | 1818 | 20.392596747 | 79.607403253 |
4 | 2025-01-04 00:00:00.000 | 6057 | 2105 | 25.790247488 | 74.209752512 |
5 | 2025-01-05 00:00:00.000 | 5043 | 2089 | 29.290521593 | 70.709478407 |
6 | 2025-01-06 00:00:00.000 | 4551 | 1875 | 29.178338002 | 70.821661998 |
7 | 2025-01-07 00:00:00.000 | 4816 | 3509 | 42.15015015 | 57.84984985 |
8 | 2025-01-08 00:00:00.000 | 6035 | 2411 | 28.546057305 | 71.453942695 |
9 | 2025-01-09 00:00:00.000 | 4803 | 1162 | 19.48030176 | 80.51969824 |
10 | 2025-01-10 00:00:00.000 | 5072 | 901 | 15.084547129 | 84.915452871 |
11 | 2025-01-11 00:00:00.000 | 3699 | 3458 | 48.316333659 | 51.683666341 |
12 | 2025-01-12 00:00:00.000 | 3973 | 1581 | 28.465970472 | 71.534029528 |
13 | 2025-01-13 00:00:00.000 | 4247 | 645 | 13.184791496 | 86.815208504 |
14 | 2025-01-14 00:00:00.000 | 4078 | 700 | 14.650481373 | 85.349518627 |
15 | 2025-01-15 00:00:00.000 | 4686 | 810 | 14.737991266 | 85.262008734 |
16 | 2025-01-16 00:00:00.000 | 4183 | 5699 | 57.670512042 | 42.329487958 |
17 | 2025-01-17 00:00:00.000 | 3179 | 816 | 20.425531915 | 79.574468085 |
18 | 2025-01-18 00:00:00.000 | 3165 | 1920 | 37.758112094 | 62.241887906 |
19 | 2025-01-19 00:00:00.000 | 3123 | 1518 | 32.708468003 | 67.291531997 |
elsinaDaily new users vs old users
Updated 2025-01-19
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 users as (
SELECT
swapper,
min(block_timestamp) as min_date
from
aptos.defi.ez_dex_swaps
group by
swapper
),
new_users as (
select
date_trunc('day', min_date) as date,
count(distinct swapper) as new_user_count
from
users
where
date >= '2025-01-01'
group by
date
),
old_users as (
select
date_trunc('day', block_timestamp) as date,
count(distinct
case
when swapper in (select swapper from users where date_trunc('day', min_date) = date_trunc('day', block_timestamp))
then null
else swapper
end
) as old_user_count,
count(distinct swapper) as total_user_count
from
aptos.defi.ez_dex_swaps
Last run: 3 months ago
19
1KB
4s