No Data to Display
fantasySolana Activation
Updated 2025-04-08
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
›
⌄
WITH user_tx AS(
SELECT
signer,
first_tx_date,
COUNT(*) AS total_tx,
DATEDIFF(day, first_tx_date, last_tx_date) AS active_days
FROM
solana.core.ez_signers
GROUP BY
signer,
first_tx_date,
last_tx_date
)
SELECT
DATE_TRUNC('month', first_tx_date) AS cohort_month,
COUNT(DISTINCT signer) AS activated_users
FROM
user_tx
WHERE
total_tx >= 1
AND active_days <= 7
GROUP BY
cohort_month
ORDER BY
cohort_month
Last run: about 2 months ago
0
2B
59s