freemartianUser Growth
Updated 2025-01-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
WITH first_tx AS(
SELECT
from_address AS user,
min(BLOCK_TIMESTAMP) AS first_time
FROM ink.core.fact_transactions
GROUP BY 1
)
SELECT
first_time::date AS day,
count(user) AS users,
SUM(users) OVER (ORDER BY day ASC) AS cum_users
FROM first_tx
GROUP BY 1
Auto-refreshes every 1 hour
QueryRunArchived: QueryRun has been archived