PLATFORM | PATH | SWAPPERS | SWAPS | VOLUME | AVG_VOLUME | VOLUME_PER_SWAPPER | SWAPS_PER_SWAPPER | |
|---|---|---|---|---|---|---|---|---|
1 | cellana | Native USDC --> USDC | 1620 | 8450 | 1307024.4233867 | 154.677446555 | 806.805199621 | 5.216049 |
2 | cellana | Native USDC --> APT | 4981 | 41882 | 359238.849061501 | 8.577404352 | 72.121832777 | 8.408352 |
3 | cellana | APT --> Native USDC | 3479 | 42320 | 365216.942954425 | 8.629889956 | 104.977563367 | 12.164415 |
4 | cellana | USDC --> Native USDC | 1466 | 7255 | 1363507.02253337 | 187.940320129 | 930.086645657 | 4.94884 |
ellerydurwinTotaly
Updated 2025-02-24
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 tab1 AS (
SELECT
PLATFORM,
CASE
WHEN token_in = '0xbae207659db88bea0cbead6da0ed00aac12edcdda169e591cd41c94180b46f3b' THEN 'Native USDC'
ELSE SYMBOL_IN
END AS SYMBOL_IN,
CASE
WHEN token_out = '0xbae207659db88bea0cbead6da0ed00aac12edcdda169e591cd41c94180b46f3b' THEN 'Native USDC'
ELSE SYMBOL_OUT
END AS SYMBOL_OUT,
COUNT(DISTINCT swapper) AS swappers,
COUNT(tx_hash) AS swaps,
SUM(COALESCE(amount_out_usd, amount_in_usd)) AS volume,
AVG(COALESCE(amount_out_usd, amount_in_usd)) AS Avg_volume
FROM
aptos.defi.ez_dex_swaps
WHERE
block_timestamp::date < current_date
AND (
token_in = '0xbae207659db88bea0cbead6da0ed00aac12edcdda169e591cd41c94180b46f3b'
OR token_out = '0xbae207659db88bea0cbead6da0ed00aac12edcdda169e591cd41c94180b46f3b'
)
GROUP BY
PLATFORM,
CASE
WHEN token_in = '0xbae207659db88bea0cbead6da0ed00aac12edcdda169e591cd41c94180b46f3b' THEN 'Native USDC'
ELSE SYMBOL_IN
END,
CASE
WHEN token_out = '0xbae207659db88bea0cbead6da0ed00aac12edcdda169e591cd41c94180b46f3b' THEN 'Native USDC'
ELSE SYMBOL_OUT
END
HAVING
volume != 0
)
Last run: 17 days ago
4
391B
2s