Updated 2024-11-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
SELECT DISTINCT
blockchain,
CASE
WHEN POSITION('-' IN from_asset) > 0 THEN SPLIT_PART(from_asset, '-', 2)
WHEN POSITION('~' IN from_asset) > 0 THEN SPLIT_PART(from_asset, '~', 2)
WHEN POSITION('/' IN from_asset) > 0 THEN SPLIT_PART(from_asset, '/', 2)
ELSE from_asset
END AS from_asset_name,
CASE
WHEN POSITION('-' IN to_asset) > 0 THEN SPLIT_PART(to_asset, '-', 1)
WHEN POSITION('~' IN to_asset) > 0 THEN SPLIT_PART(to_asset, '~', 1)
WHEN POSITION('/' IN to_asset) > 0 THEN SPLIT_PART(to_asset, '/', 1)
ELSE to_asset
END AS to_asset_name
FROM
thorchain.defi.fact_swaps;
QueryRunArchived: QueryRun has been archived