m3jiPrice Movement Impact on Liquidity
    Updated 2024-10-22
    SELECT
    DAY,
    AVG(Rune_PRICE_USD) AS avg_RUNE_price,
    SUM(RUNE_LIQUIDITY) AS total_liquidity
    FROM
    thorchain.defi.fact_daily_pool_stats
    WHERE
    DAY BETWEEN '2024-01-01'
    AND CURRENT_DATE
    GROUP BY
    DAY
    ORDER BY
    DAY DESC;