PLATFORM | TOTAL_TX_FEE_USD | |
|---|---|---|
1 | dragonswap-v3 | 2448.295051942 |
2 | klayswap-v3 | 1437.423641644 |
3 | capybara | 542.264699002 |
4 | neopin | 297.585983422 |
5 | klayswap-v2 | 134.590896193 |
6 | kaiaswap | 62.288879837 |
7 | dragonswap-v2 | 50.28865163 |
datavortexTotal Swap Fees Per Platform
Updated 2025-05-20
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
›
⌄
WITH avg_klay_price AS (
SELECT
DATE_TRUNC('day', hour) AS price_date,
AVG(price) AS avg_price_klay
FROM
kaia.price.ez_prices_hourly
WHERE
symbol = 'KLAY'
AND hour > CURRENT_TIMESTAMP - INTERVAL '30 days'
GROUP BY
DATE_TRUNC('day', hour)
),
fees_with_prices AS (
SELECT
s.tx_hash,
s.platform,
ft.tx_fee,
akp.avg_price_klay
FROM
kaia.defi.ez_dex_swaps s
JOIN kaia.core.fact_transactions ft ON s.tx_hash = ft.tx_hash
LEFT JOIN avg_klay_price akp ON DATE_TRUNC('day', s.block_timestamp) = akp.price_date
WHERE
s.block_timestamp > CURRENT_TIMESTAMP - INTERVAL '30 days'
)
SELECT
fwp.platform,
SUM(fwp.tx_fee * fwp.avg_price_klay) AS total_tx_fee_usd
FROM
fees_with_prices fwp
GROUP BY
fwp.platform
ORDER BY
total_tx_fee_usd DESC;
Last run: 13 days ago
7
203B
73s