TRANSACTION_DAY | TOTAL_SWAP_FEES_IN_APT | TOTAL_SWAP_FEES_IN_USD | TOTAL_NUMBER_OF_SWAPS | AVG_FEE_PER_SWAP_IN_APT | AVG_FEE_PER_SWAP_IN_USD | |
|---|---|---|---|---|---|---|
1 | 2025-05-01 00:00:00.000 | 68.313162 | 367.52481156 | 432709 | 0.00015787 | 0.0008 |
2 | 2025-05-02 00:00:00.000 | 71.256615 | 383.3605887 | 414915 | 0.00017174 | 0.0009 |
3 | 2025-05-03 00:00:00.000 | 64.916385 | 349.2501513 | 272324 | 0.00023838 | 0.0013 |
4 | 2025-05-04 00:00:00.000 | 54.546529 | 293.46032602 | 351138 | 0.00015534 | 0.0008 |
5 | 2025-05-05 00:00:00.000 | 70.774123 | 380.76478174 | 408870 | 0.0001731 | 0.0009 |
6 | 2025-05-06 00:00:00.000 | 101.119898 | 544.02505124 | 509410 | 0.0001985 | 0.0011 |
7 | 2025-05-07 00:00:00.000 | 76.942785 | 413.9521833 | 498768 | 0.00015427 | 0.0008 |
8 | 2025-05-08 00:00:00.000 | 146.830766 | 789.94952108 | 905500 | 0.00016215 | 0.0009 |
9 | 2025-05-09 00:00:00.000 | 136.890604 | 736.47144952 | 608483 | 0.00022497 | 0.0012 |
10 | 2025-05-10 00:00:00.000 | 203.757663 | 1096.21622694 | 761517 | 0.00026757 | 0.0014 |
11 | 2025-05-11 00:00:00.000 | 347.369375 | 1868.8472375 | 963782 | 0.00036042 | 0.0019 |
12 | 2025-05-12 00:00:00.000 | 67.694623 | 364.19707174 | 228190 | 0.00029666 | 0.0016 |
datavortexTotal Daily Swaps
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 SwapFees AS (
SELECT
DATE_TRUNC('day', t.block_timestamp) AS transaction_day,
SUM((t.gas_used * t.gas_unit_price) / 1e8) AS fee_in_apt,
COUNT(s.tx_hash) AS number_of_swaps
FROM
aptos.core.fact_transactions t
JOIN aptos.defi.ez_dex_swaps s ON t.tx_hash = s.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
transaction_day
),
APTPrice AS (
SELECT
MEDIAN(price) AS apt_price
FROM
aptos.price.ez_prices_hourly
WHERE
symbol = 'APT'
AND hour >= DATE_TRUNC('month', CURRENT_DATE)
AND hour < DATE_TRUNC('month', CURRENT_DATE) + INTERVAL '1 MONTH'
)
SELECT
sf.transaction_day,
SUM(sf.fee_in_apt) AS total_swap_fees_in_apt,
SUM(sf.fee_in_apt) * (
SELECT
ap.apt_price
FROM
APTPrice ap
) AS total_swap_fees_in_usd,
Last run: 10 days ago
12
914B
20s