TOKEN | TOTAL_VOLUME_IN_USD | TOTAL_NUMBER_OF_SWAPS | TOTAL_FEE_IN_APT | TOTAL_FEE_IN_USD | AVG_FEE_PER_SWAP_IN_APT | AVG_FEE_PER_SWAP_IN_USD | |
|---|---|---|---|---|---|---|---|
1 | APT | 38455440.2611129 | 1740093 | 327.062795 | 1982.0005377 | 0.00018796 | 0.0011 |
2 | USDC | 12272132.153454 | 2467733 | 588.471457 | 3566.13702942 | 0.00023847 | 0.0014 |
3 | USDT | 3172900.35768992 | 91790 | 55.373143 | 335.56124658 | 0.00060326 | 0.0037 |
4 | aBTC | 2368993.83682811 | 6361 | 1.246469 | 7.55360214 | 0.00019595 | 0.0012 |
5 | amAPT | 2104393.46457196 | 17881 | 8.631786 | 52.30862316 | 0.00048274 | 0.0029 |
datavortexAverage Fees Per Swap of Tokens
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 SwapVolumes AS (
SELECT
s.symbol_in AS token,
SUM(s.amount_in_usd) AS total_volume_in_usd,
COUNT(s.tx_hash) AS total_number_of_swaps
FROM
aptos.defi.ez_dex_swaps s
JOIN
aptos.core.fact_transactions t ON s.tx_hash = t.tx_hash
WHERE
t.success = TRUE
AND t.block_timestamp >= DATE_TRUNC('month', CURRENT_DATE)
AND t.block_timestamp < DATE_TRUNC('month', CURRENT_DATE) + INTERVAL '1 MONTH'
GROUP BY
s.symbol_in
),
TransactionFees AS (
SELECT
s.symbol_in AS token,
SUM((t.gas_used * t.gas_unit_price) / 1e8) AS total_fee_in_apt
FROM
aptos.defi.ez_dex_swaps s
JOIN
aptos.core.fact_transactions t ON s.tx_hash = t.tx_hash
WHERE
t.success = TRUE
AND t.block_timestamp >= DATE_TRUNC('month', CURRENT_DATE)
AND t.block_timestamp < DATE_TRUNC('month', CURRENT_DATE) + INTERVAL '1 MONTH'
GROUP BY
s.symbol_in
),
APTPrice AS (
SELECT
price AS apt_price
FROM
aptos.price.ez_prices_hourly
Last run: 13 days ago
5
366B
46s