m3jiTop Liquidity Pools
    Updated 2024-10-22
    SELECT
    POOL_NAME,
    SUM(ASSET_LIQUIDITY) + SUM(RUNE_LIQUIDITY) AS total_liquidity
    FROM
    thorchain.defi.fact_daily_pool_stats
    WHERE
    DAY BETWEEN '2024-01-01'
    AND CURRENT_DATE
    GROUP BY
    POOL_NAME
    ORDER BY
    total_liquidity DESC
    LIMIT
    10;
    -- Adjust limit as needed
    Auto-refreshes every 24 hours
    QueryRunArchived: QueryRun has been archived