PLATFORM | new users last 30D | new users previous 30D | user change last 30D | |
---|---|---|---|---|
1 | capybara | 12202 | 8187 | 49.0% 🟢 |
2 | dragonswap-v2 | 3287 | 2037 | 61.4% 🟢 |
3 | dragonswap-v3 | 35639 | 26170 | 36.2% 🟢 |
4 | kaiaswap | 308 | 280 | 10.0% 🟢 |
5 | klayswap-v2 | 883 | 946 | - 6.7% 🔴 |
6 | klayswap-v3 | 20357 | 18634 | 9.2% 🟢 |
7 | neopin | 12723 | 8969 | 41.9% 🟢 |
datavortexactual-tan
Updated 9 days ago
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_swaps AS (
SELECT
platform,
origin_from_address,
MIN(block_timestamp) AS first_swap_time
FROM
kaia.defi.ez_dex_swaps
GROUP BY
platform,
origin_from_address
),
new_users_last_30 AS (
SELECT
platform,
COUNT(DISTINCT origin_from_address) AS new_users_count_30d
FROM
user_first_swaps
WHERE
first_swap_time > CURRENT_TIMESTAMP - INTERVAL '30 days'
GROUP BY
platform
),
new_users_previous_30 AS (
SELECT
platform,
COUNT(DISTINCT origin_from_address) AS new_users_count_previous_30d
FROM
user_first_swaps
WHERE
first_swap_time > CURRENT_TIMESTAMP - INTERVAL '60 days'
AND first_swap_time <= CURRENT_TIMESTAMP - INTERVAL '30 days'
GROUP BY
platform
)
SELECT
n1.platform,
Last run: 9 days ago
7
269B
12s