DAY | CHAIN | SWAP_FEES_USD | CUMULATIVE_SWAP_FEES_USD | |
|---|---|---|---|---|
1 | 2025-06-13 00:00:00.000 | AVAX | 310.234427972 | 80681820.7515798 |
2 | 2025-06-13 00:00:00.000 | LTC | 151.445280051 | 80681820.7515798 |
3 | 2025-06-13 00:00:00.000 | GAIA | 100.048689377 | 80681820.7515798 |
4 | 2025-06-13 00:00:00.000 | ETH | 12004.753105744 | 80681820.7515798 |
5 | 2025-06-13 00:00:00.000 | BASE | 34.387350864 | 80681820.7515798 |
6 | 2025-06-13 00:00:00.000 | BSC | 485.792114599 | 80681820.7515798 |
7 | 2025-06-13 00:00:00.000 | BCH | 468.433942246 | 80681820.7515798 |
8 | 2025-06-13 00:00:00.000 | XRP | 54.673788116 | 80681820.7515798 |
9 | 2025-06-13 00:00:00.000 | DOGE | 302.384643838 | 80681820.7515798 |
10 | 2025-06-13 00:00:00.000 | THOR | 80.532003582 | 80681820.7515798 |
11 | 2025-06-13 00:00:00.000 | BTC | 5241.505904816 | 80681820.7515798 |
12 | 2025-06-12 00:00:00.000 | BSC | 2321.914993553 | 80662586.5603286 |
13 | 2025-06-12 00:00:00.000 | BASE | 122.54728141 | 80662586.5603286 |
14 | 2025-06-12 00:00:00.000 | XRP | 125.783795942 | 80662586.5603286 |
15 | 2025-06-12 00:00:00.000 | DOGE | 1268.198149571 | 80662586.5603286 |
16 | 2025-06-12 00:00:00.000 | BTC | 27139.202319581 | 80662586.5603286 |
17 | 2025-06-12 00:00:00.000 | BCH | 4629.934864659 | 80662586.5603286 |
18 | 2025-06-12 00:00:00.000 | THOR | 220.778739306 | 80662586.5603286 |
19 | 2025-06-12 00:00:00.000 | AVAX | 2183.803464718 | 80662586.5603286 |
20 | 2025-06-12 00:00:00.000 | ETH | 50107.021551771 | 80662586.5603286 |
pietrektSwap Fees By Chain
Updated 5 hours ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
SELECT to_date(block_timestamp) as day,
CASE
WHEN SPLIT(pool_name, '.')[0] = 'BNB' THEN 'BSC'
ELSE SPLIT(pool_name, '.')[0]
END as chain,
sum(liq_fee_rune_usd) as swap_fees_usd,
SUM(swap_fees_usd) OVER (
ORDER BY
day
) AS cumulative_swap_fees_usd
FROM thorchain.defi.fact_swaps
WHERE day <> '2021-07-15' AND (tx_id NOT IN (SELECT DISTINCT tx_id FROM thorchain.defi.fact_refund_events))
GROUP BY
day, chain
ORDER BY
day DESC
Last run: about 5 hours agoAuto-refreshes every 24 hours
...
11106
711KB
12s