blockchain AS Blockchain,

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,

COUNT(DISTINCT tx_id) AS SwapCount,

SUM(from_amount_usd + to_amount_usd) AS TotalSwapVolumeUsd

FROM

thorchain.defi.fact_swaps

GROUP BY

Blockchain, AssetName

ORDER BY

SwapCount DESC

LIMIT 10;