DATE | SECTOR | USERS | AVG_DAILY_USERS | TRANSACTIONS | AVG_DAILY_TRANSACTIONS | |
|---|---|---|---|---|---|---|
1 | 2024-12-09 00:00:00.000 | nft | 3 | 3 | 10 | 0.333333 |
2 | 2024-12-09 00:00:00.000 | token | 4 | 4 | 12 | 0.4 |
3 | 2024-12-16 00:00:00.000 | bridge | 144 | 144 | 179 | 5.966667 |
4 | 2024-12-16 00:00:00.000 | dex | 68 | 68 | 81 | 2.7 |
5 | 2024-12-16 00:00:00.000 | nft | 3041 | 3041 | 6321 | 210.7 |
6 | 2024-12-16 00:00:00.000 | token | 3759 | 3759 | 13326 | 444.2 |
7 | 2024-12-23 00:00:00.000 | bridge | 2763 | 2763 | 3440 | 114.666667 |
8 | 2024-12-23 00:00:00.000 | dex | 96 | 96 | 104 | 3.466667 |
9 | 2024-12-23 00:00:00.000 | nft | 12827 | 12827 | 17549 | 584.966667 |
10 | 2024-12-23 00:00:00.000 | token | 4121 | 4121 | 22563 | 752.1 |
11 | 2024-12-30 00:00:00.000 | bridge | 4654 | 4654 | 5631 | 187.7 |
12 | 2024-12-30 00:00:00.000 | dex | 54 | 54 | 59 | 1.966667 |
13 | 2024-12-30 00:00:00.000 | nft | 8690 | 8690 | 12150 | 405 |
14 | 2024-12-30 00:00:00.000 | token | 7628 | 7628 | 32561 | 1085.366667 |
15 | 2025-01-06 00:00:00.000 | bridge | 2973 | 2973 | 3800 | 126.666667 |
16 | 2025-01-06 00:00:00.000 | dex | 39 | 39 | 53 | 1.766667 |
17 | 2025-01-06 00:00:00.000 | nft | 4362 | 4362 | 6365 | 212.166667 |
18 | 2025-01-06 00:00:00.000 | token | 28145 | 28145 | 76965 | 2565.5 |
19 | 2025-01-13 00:00:00.000 | bridge | 24463 | 24463 | 36389 | 1212.966667 |
20 | 2025-01-13 00:00:00.000 | dex | 87 | 87 | 129 | 4.3 |
Haisenbergink-weekly-active-users
Updated 2025-04-06
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
›
⌄
-- forked from monthly-active-users- @ https://flipsidecrypto.xyz/studio/queries/82a5b347-4fc9-4126-9dfd-6d427966c062
WITH daily_metrics AS (
SELECT
date_trunc('week', block_timestamp) as date,
label_type as sector,
COUNT(DISTINCT from_address) as daily_users,
COUNT(DISTINCT tx_hash) as daily_transactions
FROM
ink.core.fact_transactions s
LEFT JOIN ink.core.dim_labels a
ON s.to_address = a.address
WHERE block_timestamp :: date <= current_date - 1
GROUP BY 1, 2
)
SELECT
date,
sector,
SUM(daily_users) as users,
AVG(daily_users) as avg_daily_users,
SUM(daily_transactions) as transactions,
SUM(daily_transactions)/30 as avg_daily_transactions
FROM daily_metrics
WHERE sector IS NOT NULL
GROUP BY
1, 2
ORDER BY
1, 2
Last run: 2 months ago
66
4KB
3s