CASE

WHEN POSITION('-' IN from_asset) > 0 THEN SPLIT_PART(from_asset, '-', 1)

WHEN POSITION('~' IN from_asset) > 0 THEN SPLIT_PART(from_asset, '~', 1)

WHEN POSITION('/' IN from_asset) > 0 THEN SPLIT_PART(from_asset, '/', 1)

ELSE from_asset

END AS AssetName,

SUM(from_amount_usd) AS TotalSwapVolumeUsd,

AVG(swap_slip_bp) AS AvgSwapSlipBp

FROM

thorchain.defi.fact_swaps

GROUP BY

AssetName

ORDER BY

AvgSwapSlipBp DESC

LIMIT 10;