TOKEN_PAIR | SWAPS | SWAPPERS | VOLUME_USD | AVERAGE_AMOUNT_USD | |
|---|---|---|---|---|---|
1 | APT -> USDC | 2629807 | 332567 | 457082302.909418 | 172.782834795 |
2 | USDC -> APT | 2324696 | 312627 | 454378279.354236 | 193.978638855 |
3 | Cake -> APT | 602594 | 107122 | 48451158.1163987 | 79.063915596 |
4 | APT -> Cake | 755375 | 126725 | 48019344.1050035 | 62.885386616 |
5 | USDC -> WETH | 325624 | 48927 | 45149397.523368 | 136.2124808 |
6 | WETH -> USDC | 430320 | 90126 | 44905329.9454904 | 102.76030844 |
7 | GUI -> APT | 223886 | 32582 | 42234018.7184123 | 161.62048523 |
8 | APT -> GUI | 294062 | 31570 | 42155264.5062777 | 125.970854033 |
9 | Cake -> USDC | 275272 | 37434 | 14575180.7095218 | 49.983472941 |
10 | USDC -> Cake | 274805 | 44947 | 14332148.6983905 | 49.122739419 |
Afonso_DiazTop token pairs
Updated 2025-05-10
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
main as (
select
tx_hash,
block_timestamp,
swapper,
symbol_in,
symbol_out,
token_in,
token_out,
iff(amount_in_usd < 1e7, amount_in_usd, amount_out_usd) as amount_usd
from
aptos.defi.ez_dex_swaps
where
amount_usd < 1e7
and platform = 'pancake'
)
select
symbol_in || ' -> ' || symbol_out as token_pair,
count(distinct tx_hash) as swaps,
count(distinct swapper) as swappers,
sum(amount_usd) as volume_usd,
avg(amount_usd) as average_amount_usd
from
main
where
token_pair is not null
and amount_usd > 0
group by 1
order by volume_usd desc
limit 10
Last run: 30 days ago
10
600B
9s