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