TRADING_PAIR_GROUP | TOTAL_SWAP_VOLUME | TOTAL_SWAPS | TOTAL_SWAPPERS | |
|---|---|---|---|---|
1 | APT -> amAPT | 1592872341.46766 | 1273074 | 67981 |
2 | APT -> USDC | 1576364821.37061 | 11856321 | 852191 |
3 | APT -> thAPT | 1057070744.19252 | 1254641 | 36127 |
4 | Others | 419743712.279259 | 9354557 | 1659975 |
5 | APT -> USDT | 231476698.883873 | 3069656 | 472582 |
6 | APT -> doodoo | 161697029.422523 | 758395 | 68396 |
7 | APT -> CELL | 103727531.186925 | 876725 | 327076 |
8 | APT -> MOOMOO | 51129062.8942505 | 332963 | 52200 |
9 | APT -> stAPT | 50319049.940613 | 914441 | 107143 |
10 | APT -> Cake | 48097154.9342503 | 844258 | 135187 |
11 | APT -> aBTC | 45131199.2006227 | 202725 | 8403 |
zyroqApt dex3
Updated 2025-05-12
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 data AS (
SELECT
block_timestamp,
tx_hash,
platform,
swapper,
COALESCE(NULLIF(symbol_in, ''), 'Unknown') AS symbol_in, -- Handle empty or NULL values
COALESCE(NULLIF(symbol_out, ''), 'Unknown') AS symbol_out, -- Handle empty or NULL values
COALESCE(AMOUNT_IN_USD, AMOUNT_OUT_USD) AS amount
FROM
aptos.defi.ez_dex_swaps
WHERE
token_in = '0x1::aptos_coin::AptosCoin'
OR
token_out = '0x1::aptos_coin::AptosCoin'
AND BLOCK_TIMESTAMP > CURRENT_DATE - INTERVAL '1 days'
),
trading_pairs AS (
SELECT
symbol_in || ' -> ' || symbol_out AS trading_pair,
SUM(amount) AS total_swap_volume,
COUNT(DISTINCT tx_hash) AS total_swaps,
COUNT(DISTINCT swapper) AS total_swappers
FROM
data
GROUP BY
trading_pair
),
ranked_pairs AS (
SELECT
trading_pair,
total_swap_volume,
total_swaps,
total_swappers,
RANK() OVER (ORDER BY total_swap_volume DESC) AS rank
FROM
Last run: 18 days ago
11
520B
8s