SELECT

split(memo, ':')[4] as Address,

split(memo, ':')[5]::int as Fees

FROM thorchain.swap_events

WHERE Len(memo) - LEN(REPLACE(memo,':', '')) = 5

SELECT

Address,

SUM(

Fees *

CASE

WHEN from_asset = 'THOR.RUNE' THEN from_e8

WHEN to_asset = 'THOR.RUNE' THEN to_e8

ELSE NULL

END) / (1e8 * 10000) as Fee,

SUM

(CASE

WHEN from_asset = 'THOR.RUNE' THEN from_e8

WHEN to_asset = 'THOR.RUNE' THEN to_e8

ELSE NULL END) / 1e8 as Volume,

SUM(liq_fee_in_rune_e8 ) / 1e8 as Liquidity_Fees

FROM thorchain.swap_events

LEFT JOIN Split_memo

WHERE Len(memo) - LEN(REPLACE(memo,':', '')) = 5

GROUP BY Address

ORDER BY Fee desc