m3jiLiquidity Dynamics
    Updated 2024-10-22
    SELECT
    DAY,
    SUM(ADD_ASSET_LIQUIDITY_USD) AS total_add_liquidity,
    SUM(WITHDRAW_ASSET_LIQUIDITY_USD) AS total_withdraw_liquidity,
    SUM(ADD_RUNE_LIQUIDITY_USD) AS total_rune_add_liquidity,
    SUM(WITHDRAW_RUNE_LIQUIDITY_USD) AS total_rune_withdraw_liquidity,
    SUM(
    ADD_ASSET_LIQUIDITY_USD - WITHDRAW_ASSET_LIQUIDITY_USD
    ) AS net_asset_liquidity,
    SUM(
    ADD_RUNE_LIQUIDITY_USD - WITHDRAW_RUNE_LIQUIDITY_USD
    ) AS net_rune_liquidity
    FROM
    thorchain.defi.fact_daily_pool_stats
    WHERE
    DAY BETWEEN '2024-01-01'
    AND CURRENT_DATE
    GROUP BY
    DAY
    ORDER BY
    DAY DESC;
    Auto-refreshes every 24 hours
    QueryRunArchived: QueryRun has been archived