DAILY | OLD_USERS | ALL_USERS | NEW_USERS | PERCENT_NEW_USERS | PERCENT_OLD_USERS | |
|---|---|---|---|---|---|---|
1 | 2025-01-01 00:00:00.000 | 7672 | 10858 | 3186 | 29.342420335 | 70.657579665 |
2 | 2025-01-02 00:00:00.000 | 8092 | 10093 | 2001 | 19.825621718 | 80.174378282 |
3 | 2025-01-03 00:00:00.000 | 7250 | 9070 | 1820 | 20.06615215 | 79.93384785 |
4 | 2025-01-04 00:00:00.000 | 6077 | 8184 | 2107 | 25.745356794 | 74.254643206 |
5 | 2025-01-05 00:00:00.000 | 5178 | 7268 | 2090 | 28.756191524 | 71.243808476 |
6 | 2025-01-06 00:00:00.000 | 4675 | 6553 | 1878 | 28.658629635 | 71.341370365 |
7 | 2025-01-07 00:00:00.000 | 4896 | 8413 | 3517 | 41.80435041 | 58.19564959 |
8 | 2025-01-08 00:00:00.000 | 6105 | 8519 | 2414 | 28.336659232 | 71.663340768 |
9 | 2025-01-09 00:00:00.000 | 4950 | 6118 | 1168 | 19.091206277 | 80.908793723 |
10 | 2025-01-10 00:00:00.000 | 5294 | 6196 | 902 | 14.557779212 | 85.442220788 |
11 | 2025-01-11 00:00:00.000 | 3928 | 7388 | 3460 | 46.832701678 | 53.167298322 |
12 | 2025-01-12 00:00:00.000 | 4209 | 5792 | 1583 | 27.330801105 | 72.669198895 |
13 | 2025-01-13 00:00:00.000 | 4493 | 5147 | 654 | 12.706430931 | 87.293569069 |
14 | 2025-01-14 00:00:00.000 | 4316 | 5021 | 705 | 14.041027684 | 85.958972316 |
15 | 2025-01-15 00:00:00.000 | 4923 | 5733 | 810 | 14.128728414 | 85.871271586 |
16 | 2025-01-16 00:00:00.000 | 4215 | 9917 | 5702 | 57.497226984 | 42.502773016 |
17 | 2025-01-17 00:00:00.000 | 3384 | 4203 | 819 | 19.48608137 | 80.51391863 |
18 | 2025-01-18 00:00:00.000 | 3406 | 5328 | 1922 | 36.073573574 | 63.926426426 |
19 | 2025-01-19 00:00:00.000 | 3598 | 5350 | 1752 | 32.747663551 | 67.252336449 |
20 | 2025-01-20 00:00:00.000 | 3709 | 5505 | 1796 | 32.624886467 | 67.375113533 |
elsinaDaily new users vs old users
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
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with price as (
select
date_trunc('day', hour) as date,
upper(symbol) as symbol,
avg(price) as price_usd
from aptos.price.ez_prices_hourly
group by 1, 2
),
base as (
SELECT
block_timestamp,
tx_hash,
swapper,
platform,
token_in,
token_out,
symbol_in,
symbol_out,
amount_in * tin.price_usd as amount_in_usd,
amount_out * tout.price_usd as amount_out_usd
from
aptos.defi.ez_dex_swaps
left join price tin on upper(tin.symbol) = upper(symbol_in) and tin.date = block_timestamp::date
left join price tout on upper(tout.symbol) = upper(symbol_out) and tout.date = block_timestamp::date
),
first_tx_of_each_users AS (
SELECT
swapper,
MIN(block_timestamp) AS min_date
FROM
base
GROUP BY
Last run: 4 days ago
...
159
11KB
6s