GROUP_WEEK | ACTIVITY_WEEK | RETAINED_USERS | TOTAL_USERS | RETENTION_RATE | CHURN_RATE | |
|---|---|---|---|---|---|---|
1 | 5 | 6 | 1 | 3 | 33.33 | 66.67 |
2 | 5 | 8 | 1 | 3 | 33.33 | 66.67 |
3 | 5 | 9 | 1 | 3 | 33.33 | 66.67 |
4 | 5 | 10 | 1 | 3 | 33.33 | 66.67 |
5 | 5 | 11 | 2 | 3 | 66.67 | 33.33 |
6 | 5 | 13 | 1 | 3 | 33.33 | 66.67 |
7 | 5 | 15 | 1 | 3 | 33.33 | 66.67 |
8 | 5 | 16 | 2 | 3 | 66.67 | 33.33 |
9 | 5 | 17 | 1 | 3 | 33.33 | 66.67 |
10 | 5 | 18 | 2 | 3 | 66.67 | 33.33 |
11 | 5 | 20 | 1 | 3 | 33.33 | 66.67 |
12 | 5 | 23 | 1 | 3 | 33.33 | 66.67 |
13 | 5 | 24 | 1 | 3 | 33.33 | 66.67 |
14 | 5 | 26 | 1 | 3 | 33.33 | 66.67 |
15 | 5 | 27 | 1 | 3 | 33.33 | 66.67 |
16 | 5 | 28 | 1 | 3 | 33.33 | 66.67 |
17 | 5 | 29 | 1 | 3 | 33.33 | 66.67 |
18 | 5 | 30 | 1 | 3 | 33.33 | 66.67 |
19 | 5 | 32 | 1 | 3 | 33.33 | 66.67 |
20 | 5 | 33 | 1 | 3 | 33.33 | 66.67 |
i_danpowerful-violet
Updated 2025-01-21
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
›
⌄
--SELECT
-- program_name
-- , count(*)
--FROM crosschain.olas.ez_olas_staking
--GROUP BY 1
WITH first_stake AS (
SELECT
origin_from_address
, MIN(block_timestamp) AS first_stake_date
FROM
crosschain.olas.ez_olas_staking
GROUP BY
1
)--,
--subsequent_stakes AS (
SELECT
s.origin_from_address
, s.block_timestamp
FROM
crosschain.olas.ez_olas_staking s
JOIN
first_stake f ON s.origin_from_address = f.origin_from_address
WHERE
s.block_timestamp > f.first_stake_date
),
groups AS (
SELECT
origin_from_address
, EXTRACT(week FROM first_stake_date) AS group_week
FROM
Last run: 2 months ago
...
177
3KB
54s