WEEK | WEEKLY_ACTIVE_USERS | WEEK_OVER_WEEK_CHANGE | |
|---|---|---|---|
1 | 2025-03-03 00:00:00.000 | 13 | -3 |
2 | 2025-02-24 00:00:00.000 | 16 | -60 |
3 | 2025-02-17 00:00:00.000 | 76 | 45 |
4 | 2025-02-10 00:00:00.000 | 31 | 2 |
5 | 2025-02-03 00:00:00.000 | 29 | 4 |
6 | 2025-01-27 00:00:00.000 | 25 | -15 |
7 | 2025-01-20 00:00:00.000 | 40 | 19 |
8 | 2025-01-13 00:00:00.000 | 21 | -9 |
9 | 2025-01-06 00:00:00.000 | 30 | -8 |
10 | 2024-12-30 00:00:00.000 | 38 | 18 |
11 | 2024-12-23 00:00:00.000 | 20 |
bz-0780nba-topshot weekly active users
Updated 2025-03-07
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
›
⌄
WITH weekly_users AS (
SELECT
DATE_TRUNC('week', t.block_timestamp) as week,
COUNT(DISTINCT a.actors) as weekly_active_users
FROM flow.core.fact_transactions t
JOIN flow.core.ez_transaction_actors a
ON t.tx_id = a.tx_id
WHERE t.block_timestamp >= DATEADD('week', -10, CURRENT_DATE())
AND t.block_timestamp < CURRENT_DATE()
AND (
-- FastBreak, TopShot, and PackNFT contracts
t.script LIKE '%A.0b2a3299cc857e29.FastBreakV1%'
OR t.script LIKE '%A.0b2a3299cc857e29.TopShot%'
OR t.script LIKE '%A.0b2a3299cc857e29.PackNFT%'
-- Market contracts
OR t.script LIKE '%A.c1e4f4f4c4257510.TopShotMarketV3%'
OR t.script LIKE '%A.c1e4f4f4c4257510.Market%'
)
AND t.tx_succeeded = TRUE
GROUP BY 1
ORDER BY 1 DESC
)
SELECT
week,
weekly_active_users,
weekly_active_users - LAG(weekly_active_users) OVER (ORDER BY week) as week_over_week_change
FROM weekly_users
ORDER BY week DESC;
Last run: about 2 months ago
11
377B
16s