SELECT DISTINCT fact_swaps_events.block_timestamp, block_id,
SPLIT(SPLIT(memo,':')[1],'.')[0] AS chain,
SPLIT(memo,':')[6] AS aggregator,
SPLIT(memo,':')[7] AS target_asset_address,
CONCAT(chain, '_', UPPER(RIGHT(target_asset_address, 3))) AS target_asset,
POWER(10,-8) * SUM(liq_fee_in_rune_e8) OVER(PARTITION BY target_asset ORDER BY block_id ASC) AS cumulative_swapout_liquidity_fees_in_rune
FROM thorchain.core.fact_swaps_events INNER JOIN thorchain.core.dim_block
ON fact_swaps_events.dim_block_id = dim_block.dim_block_id
WHERE SPLIT(memo,':')[6] IS NOT NULL
ORDER BY block_id DESC