WITH
dailies AS (
SELECT DISTINCT DATE(block_timestamp) AS date,
SPLIT(SPLIT(memo,':')[1],'-')[0] AS coin,
SUM(liq_fee_in_rune_e8) OVER(PARTITION BY date, coin) AS liq_fee_in_rune_e8
FROM thorchain.core.fact_swaps_events
WHERE (DATE(block_timestamp) > '2022-05-11')
AND (LEFT(coin, 7) = 'ETH.USD')
)
SELECT date, coin,
POWER(10,-8) * SUM(liq_fee_in_rune_e8) OVER(PARTITION BY coin ORDER BY date ASC) AS cumulative_liquidity_fees_in_rune
FROM dailies
ORDER BY date DESC