PLATFORM | VOLUME_RANGE | TOTAL_USERS | |
|---|---|---|---|
1 | capybara | 1-500 | 6792 |
2 | capybara | 10k-30k | 17 |
3 | capybara | 1k-5k | 78 |
4 | capybara | 30k-50k | 7 |
5 | capybara | 501-1k | 39 |
6 | capybara | 50k+ | 7641 |
7 | capybara | 5k-10k | 19 |
8 | dragonswap-v2 | 1-500 | 1011 |
9 | dragonswap-v2 | 10k-30k | 1 |
10 | dragonswap-v2 | 1k-5k | 1 |
11 | dragonswap-v2 | 501-1k | 5 |
12 | dragonswap-v2 | 50k+ | 2696 |
13 | dragonswap-v2 | 5k-10k | 1 |
14 | dragonswap-v3 | 1-500 | 30432 |
15 | dragonswap-v3 | 10k-30k | 76 |
16 | dragonswap-v3 | 1k-5k | 248 |
17 | dragonswap-v3 | 30k-50k | 9 |
18 | dragonswap-v3 | 501-1k | 249 |
19 | dragonswap-v3 | 50k+ | 8623 |
20 | dragonswap-v3 | 5k-10k | 75 |
datavortexUser category
Updated 2025-05-20
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_volume AS (
SELECT
platform,
origin_from_address AS user,
SUM(amount_in_usd) AS total_volume_per_user
FROM
kaia.defi.ez_dex_swaps
WHERE
block_timestamp > CURRENT_TIMESTAMP - INTERVAL '30 days'
GROUP BY
platform, origin_from_address
),
volume_groups AS (
SELECT
platform,
CASE
WHEN total_volume_per_user <= 100 THEN '1-100'
WHEN total_volume_per_user <= 500 THEN '101-500'
WHEN total_volume_per_user <= 1000 THEN '501-1000'
WHEN total_volume_per_user <= 5000 THEN '1001-5000'
WHEN total_volume_per_user <= 10000 THEN '5001-10000'
WHEN total_volume_per_user <= 50000 THEN '10001-50000'
ELSE '50001+'
END AS volume_range,
COUNT(DISTINCT user) AS total_users
FROM
user_volume
GROUP BY
platform, volume_range
)
SELECT
platform,
volume_range,
Last run: 13 days ago
39
1KB
10s