datavortexweekly traders
Updated 2024-11-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
WITH weekly_active_users AS (
SELECT
DATE_TRUNC('week', block_timestamp) AS week,
COUNT(DISTINCT tx_signer) AS "Weekly Active Users"
FROM near.core.fact_transactions
WHERE block_timestamp >= '2024-01-01'
AND block_timestamp < '2025-01-01'
GROUP BY week
)
SELECT
week,
"Weekly Active Users",
SUM("Weekly Active Users") OVER (ORDER BY week) AS "Cumulative Users"
FROM weekly_active_users
ORDER BY week;
QueryRunArchived: QueryRun has been archived