TOTALSWAPVOLUMEUSD | AVGSWAPAMOUNTUSD | TOTALSWAPSCOUNT | SWAPPER | TOTALLIQFEERUNE | AVGLIQFEERUNE | TOTALLIQFEEUSD | AVGLIQFEEUSD | |
|---|---|---|---|---|---|---|---|---|
1 | 104857683287.434 | 2086.294668901 | 25997437 | 778665 | 28598081.1216167 | 0.5690000228 | 79924101.5809825 | 1.590205141 |
datavortexComplete Metric
Updated 2025-05-07
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
›
⌄
WITH SwapVolume AS (
SELECT
SUM(from_amount_usd) AS TotalSwapVolumeUsd,
AVG(from_amount_usd) AS AvgSwapAmountUsd
FROM thorchain.defi.fact_swaps
),
SwapCounts AS (
SELECT
COUNT(DISTINCT tx_id) AS TotalSwapsCount,
COUNT(DISTINCT from_address) AS Swapper
FROM thorchain.defi.fact_swaps
),
LiquidityFeeMetrics AS (
SELECT
SUM(liq_fee_rune) AS TotalLiqFeeRune,
AVG(liq_fee_rune) AS AvgLiqFeeRune,
SUM(liq_fee_rune_usd) AS TotalLiqFeeUsd,
AVG(liq_fee_rune_usd) AS AvgLiqFeeUsd
FROM thorchain.defi.fact_swaps
)
SELECT
sv.TotalSwapVolumeUsd,
sv.AvgSwapAmountUsd,
sc.TotalSwapsCount,
sc.Swapper,
lfm.TotalLiqFeeRune,
lfm.AvgLiqFeeRune,
lfm.TotalLiqFeeUsd,
lfm.AvgLiqFeeUsd
FROM
SwapVolume sv
CROSS JOIN SwapCounts sc
CROSS JOIN LiquidityFeeMetrics lfm;
Last run: 14 days ago
1
110B
7s