FIRST_DAY | NEW_USERS | TOTAL_USERS | SEVEN_DAY_NEW_USERS | THIRTY_DAY_NEW_USERS | |
|---|---|---|---|---|---|
1 | 2024-01-29 00:00:00.000 | 1 | 2393 | 11 | 106 |
2 | 2024-01-28 00:00:00.000 | 2 | 2392 | 11 | 106 |
3 | 2024-01-27 00:00:00.000 | 3 | 2390 | 12 | 112 |
4 | 2024-01-24 00:00:00.000 | 1 | 2387 | 11 | 124 |
5 | 2024-01-23 00:00:00.000 | 1 | 2386 | 11 | 128 |
6 | 2024-01-22 00:00:00.000 | 2 | 2385 | 14 | 146 |
7 | 2024-01-21 00:00:00.000 | 1 | 2383 | 14 | 206 |
8 | 2024-01-19 00:00:00.000 | 1 | 2382 | 15 | 297 |
9 | 2024-01-18 00:00:00.000 | 3 | 2381 | 16 | 434 |
10 | 2024-01-17 00:00:00.000 | 2 | 2378 | 15 | 435 |
11 | 2024-01-15 00:00:00.000 | 1 | 2376 | 16 | 447 |
12 | 2024-01-14 00:00:00.000 | 4 | 2375 | 18 | 449 |
13 | 2024-01-13 00:00:00.000 | 2 | 2371 | 19 | 447 |
14 | 2024-01-12 00:00:00.000 | 2 | 2369 | 26 | 449 |
15 | 2024-01-11 00:00:00.000 | 2 | 2367 | 33 | 452 |
16 | 2024-01-10 00:00:00.000 | 2 | 2365 | 41 | 460 |
17 | 2024-01-09 00:00:00.000 | 3 | 2363 | 42 | 464 |
18 | 2024-01-08 00:00:00.000 | 3 | 2360 | 42 | 464 |
19 | 2024-01-07 00:00:00.000 | 5 | 2357 | 45 | 463 |
20 | 2024-01-06 00:00:00.000 | 9 | 2352 | 41 | 464 |
jackguyss swaps 7
Updated 2024-01-30
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
›
⌄
WITH tab1 AS (
SELECT
SWAPPER,
count(DISTINCT date(block_timestamp)) as active_days,
count(DISTINCT TX_ID) as swaps,
min(date(block_timestamp)) as first_day
FROM sei.defi.fact_dex_swaps
WHERE platform LIKE 'seaswap'
GROUP BY 1
),
agg_new_users AS (
SELECT
first_day,
count(*) as new_users
FROM tab1
GROUP BY 1
),
cumulative_users AS (
SELECT
*,
sum(new_users) over (order by first_day) as total_users
FROM agg_new_users
)
SELECT
first_day,
new_users,
total_users,
sum(new_users) OVER (ORDER BY first_day ASC ROWS BETWEEN 6 PRECEDING AND CURRENT ROW) AS seven_day_new_users,
sum(new_users) OVER (ORDER BY first_day ASC ROWS BETWEEN 29 PRECEDING AND CURRENT ROW) AS thirty_day_new_users
FROM cumulative_users
ORDER BY first_day DESC
Last run: about 1 year agoAuto-refreshes every 6 hours
...
157
6KB
2s