TRADING_PAIR_GROUP | TOTAL_SWAP_VOLUME | TOTAL_SWAPS | TOTAL_SWAPPERS | |
|---|---|---|---|---|
1 | APT -> amAPT | 1584633465.93928 | 1269240 | 67136 |
2 | APT -> USDC | 1527106268.94545 | 10768873 | 847653 |
3 | APT -> thAPT | 1055600661.82817 | 1252882 | 36037 |
4 | Others | 353747017.24509 | 7453761 | 1584570 |
5 | APT -> USDT | 226980522.772002 | 3039572 | 471955 |
6 | APT -> doodoo | 161674441.959996 | 757064 | 68242 |
7 | APT -> Unknown | 161379867.430293 | 2466181 | 357368 |
8 | APT -> MOOMOO | 51128807.5405558 | 332596 | 52145 |
9 | APT -> stAPT | 50056929.543669 | 897445 | 106150 |
10 | APT -> Cake | 47974443.7154174 | 837988 | 134500 |
11 | APT -> GUI | 43897049.7785928 | 448425 | 41286 |
zyroqApt dex3
Updated 3 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 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: 3 days ago
11
523B
17s