FEE_CATEGORY | AVG_MONTHLY_ACTIVE_USERS | AVG_MONTHLY_CHURNED_USERS | AVG_MONTHLY_CHURN_RATE_PERCENT | TOTAL_ACTIVE_USERS | TOTAL_CHURNED_USERS | OVERALL_CHURN_RATE_PERCENT | AVG_MONTHLY_NEW_USERS | TOTAL_NEW_USERS | |
|---|---|---|---|---|---|---|---|---|---|
1 | No Fee | 513198.6 | 191227.7 | 37.15 | 5131986 | 1912277 | 37.26 | 285480.9 | 2854809 |
2 | 0.15% Fee | 667401.43 | 249591.57 | 36.84 | 4671810 | 1747141 | 37.4 | 287477.14 | 2012340 |
3 | 0.25% Fee | 819673.5 | 472966.2 | 56.81 | 8196735 | 4729662 | 57.7 | 352662.4 | 3526624 |
mondovtotal user data
Updated 2025-01-26
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
34
35
36
›
⌄
WITH user_first_activity AS (
SELECT
origin_from_address AS user,
MIN(DATE_TRUNC('month', block_timestamp)) AS first_activity_month,
CASE
WHEN MIN(block_timestamp) < '2023-10-17' THEN 'No Fee'
WHEN MIN(block_timestamp) >= '2023-10-17' AND MIN(block_timestamp) < '2024-04-10' THEN '0.15% Fee'
ELSE '0.25% Fee'
END AS first_fee_category
FROM ethereum.defi.ez_dex_swaps
WHERE lower(platform) LIKE 'uniswap%'
AND block_timestamp >= '2023-01-01'
GROUP BY 1
),
monthly_activity AS (
SELECT
DATE_TRUNC('month', block_timestamp) AS activity_month,
origin_from_address AS user,
COUNT(*) AS monthly_transactions,
CASE
WHEN block_timestamp < '2023-10-17' THEN 'No Fee'
WHEN block_timestamp >= '2023-10-17' AND block_timestamp < '2024-04-10' THEN '0.15% Fee'
ELSE '0.25% Fee'
END AS fee_category
FROM ethereum.defi.ez_dex_swaps
WHERE lower(platform) LIKE 'uniswap%'
AND block_timestamp >= '2023-01-01'
GROUP BY 1, 2, 4
),
user_last_activity AS (
SELECT
user,
MAX(activity_month) AS last_activity_month
FROM monthly_activity
GROUP BY 1
),
Last run: 3 months ago
3
230B
27s