FEE_CATEGORY | SWAP_CATEGORY | AVG_MONTHLY_USERS | |
|---|---|---|---|
1 | No Fee | 1 swap | 223548.4 |
2 | No Fee | 2-5 swaps | 178037.8 |
3 | No Fee | 6-20 swaps | 74365 |
4 | No Fee | 21-100 swaps | 30467.5 |
5 | No Fee | 101-500 swaps | 6165.6 |
6 | No Fee | 500+ swaps | 614.3 |
7 | 0.15% | 1 swap | 298755.571429 |
8 | 0.15% | 2-5 swaps | 240474 |
9 | 0.15% | 6-20 swaps | 94705.285714 |
10 | 0.15% | 21-100 swaps | 28958.142857 |
11 | 0.15% | 101-500 swaps | 4035.571429 |
12 | 0.15% | 500+ swaps | 472.857143 |
13 | 0.25% | 1 swap | 395633 |
14 | 0.25% | 2-5 swaps | 283421.2 |
15 | 0.25% | 6-20 swaps | 101224.6 |
16 | 0.25% | 21-100 swaps | 32552.6 |
17 | 0.25% | 101-500 swaps | 6108.5 |
18 | 0.25% | 500+ swaps | 733.6 |
mondovnumber of swaps categories
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 monthly_data AS (
SELECT
date_trunc('month', block_timestamp) as month,
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%'
ELSE '0.25%'
END AS fee_category,
origin_from_address,
COUNT(DISTINCT tx_hash) as num_swaps
FROM ethereum.defi.ez_dex_swaps
WHERE lower(platform) LIKE 'uniswap%'
AND block_timestamp >= '2023-01-01'
GROUP BY 1, 2, 3
),
user_categories AS (
SELECT
month,
fee_category,
CASE
WHEN num_swaps = 1 THEN '1 swap'
WHEN num_swaps >= 2 AND num_swaps <= 5 THEN '2-5 swaps'
WHEN num_swaps >= 6 AND num_swaps <= 20 THEN '6-20 swaps'
WHEN num_swaps >= 21 AND num_swaps <= 100 THEN '21-100 swaps'
WHEN num_swaps >= 101 AND num_swaps <= 500 THEN '101-500 swaps'
ELSE '500+ swaps'
END AS swap_category,
COUNT(DISTINCT origin_from_address) as users
FROM monthly_data
GROUP BY 1, 2, 3
)
SELECT
fee_category,
swap_category,
AVG(users) as avg_monthly_users
FROM user_categories
Last run: 3 months ago
18
582B
99s