Month | Avg Daily Users(Month) | Monthly Users | AvgDU - MAU Ratio(%) | |
|---|---|---|---|---|
1 | 2024-11-01 00:00:00.000 | 2.012384 | 3 | 67.0794666667 |
2 | 2024-12-01 00:00:00.000 | 156.940281 | 1589 | 9.8766696665 |
3 | 2025-01-01 00:00:00.000 | 726.259721 | 9213 | 7.8829883968 |
4 | 2025-02-01 00:00:00.000 | 346.496066 | 4968 | 6.9745584944 |
5 | 2025-03-01 00:00:00.000 | 309.099703 | 3793 | 8.1492144213 |
6 | 2025-04-01 00:00:00.000 | 624 | 624 | 100 |
i_danSwellChain: Daily - Monthly Users
Updated 2025-04-01
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
›
⌄
WITH user_activity AS (
SELECT
from_address
, DATE_TRUNC('day', block_timestamp) AS activity_day
, DATE_TRUNC('month', block_timestamp) AS activity_month
FROM swell.core.fact_transactions
WHERE from_address != '0xdeaddeaddeaddeaddeaddeaddeaddeaddead0001'
AND from_address != '0x339d413ccefd986b1b3647a9cfa9cbbe70a30749'
),
dau AS (
SELECT
activity_day
, COUNT(DISTINCT from_address) AS daily_active_users
FROM user_activity
GROUP BY 1
)
SELECT
DATE_TRUNC('month', u.activity_day) AS "Month"
, AVG(daily_active_users) AS "Avg Daily Users(Month)"
, COUNT(DISTINCT from_address) AS "Monthly Users"
, ("Avg Daily Users(Month)" / "Monthly Users") * 100 AS "AvgDU - MAU Ratio(%)"
FROM user_activity u
JOIN dau d ON d.activity_day = u.activity_day
GROUP BY 1
ORDER BY 1
Last run: about 2 months ago
6
322B
1s