Multipartite(Auto-updating) To-ETH.USD non-aggregator cumulative liquidity fees after 2022-05-11
    Updated 2023-06-13
    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
    Run a query to Download Data