PLATFORM_COUNT | SWAPPERS | |
|---|---|---|
1 | 1 | 9769 |
2 | 2 | 2725 |
3 | 3 | 1147 |
4 | 4 | 628 |
5 | 6 | 290 |
6 | 5 | 288 |
7 | 7 | 28 |
8 | 8 | 6 |
aureasarsanedestraders 2
Updated 6 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with
swappers as (
SELECT
SWAPPER,
COUNT(DISTINCT PLATFORM) AS platform_count
FROM
aptos.defi.ez_dex_swaps
WHERE
BLOCK_TIMESTAMP >= DATEADD(day, -{{days}}, CURRENT_DATE)
GROUP BY
SWAPPER
ORDER BY
platform_count DESC
)
SELECT
platform_count,
count(distinct swapper) as swappers
from swappers
group by platform_count
order by swappers desc
Last run: 6 days ago
8
65B
1s