DAY | CHAIN | SWAP_FEES_USD | CUMULATIVE_SWAP_FEES_USD | |
|---|---|---|---|---|
1 | 2025-05-31 00:00:00.000 | BTC | 3502.087410567 | 79918489.5954385 |
2 | 2025-05-31 00:00:00.000 | LTC | 62.221455744 | 79918489.5954385 |
3 | 2025-05-31 00:00:00.000 | GAIA | 22.62853553 | 79918489.5954385 |
4 | 2025-05-31 00:00:00.000 | THOR | 1.570755638 | 79918489.5954385 |
5 | 2025-05-31 00:00:00.000 | DOGE | 228.29728881 | 79918489.5954385 |
6 | 2025-05-31 00:00:00.000 | BCH | 226.400685655 | 79918489.5954385 |
7 | 2025-05-31 00:00:00.000 | ETH | 6245.404487366 | 79918489.5954385 |
8 | 2025-05-31 00:00:00.000 | AVAX | 243.558725464 | 79918489.5954385 |
9 | 2025-05-31 00:00:00.000 | BSC | 232.6155262 | 79918489.5954385 |
10 | 2025-05-31 00:00:00.000 | BASE | 47.782795229 | 79918489.5954385 |
11 | 2025-05-30 00:00:00.000 | ETH | 36645.051108411 | 79907677.0277722 |
12 | 2025-05-30 00:00:00.000 | DOGE | 1463.826043438 | 79907677.0277722 |
13 | 2025-05-30 00:00:00.000 | LTC | 725.095640154 | 79907677.0277722 |
14 | 2025-05-30 00:00:00.000 | THOR | 203.550836013 | 79907677.0277722 |
15 | 2025-05-30 00:00:00.000 | BCH | 3050.748777971 | 79907677.0277722 |
16 | 2025-05-30 00:00:00.000 | BSC | 2643.18984369 | 79907677.0277722 |
17 | 2025-05-30 00:00:00.000 | AVAX | 3718.11817387 | 79907677.0277722 |
18 | 2025-05-30 00:00:00.000 | BASE | 466.688782165 | 79907677.0277722 |
19 | 2025-05-30 00:00:00.000 | GAIA | 238.536983364 | 79907677.0277722 |
20 | 2025-05-30 00:00:00.000 | BTC | 19709.145822426 | 79907677.0277722 |
pietrektSwap Fees By Chain
Updated 21 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 21 hours agoAuto-refreshes every 24 hours
...
10967
702KB
9s