1SELECT
2  COALESCE(category, 'Uncategorized') AS category,
3  COUNT(*) AS market_count,
4  SUM(liquiditynum) AS total_liquidity_usd,
5  AVG(liquiditynum) AS avg_liquidity_per_market,
6  MAX(liquiditynum) AS max_liquidity_market,
7  SUM(volumenum) AS total_volume_usd,
8  ROUND(
9    100.0 * SUM(liquiditynum) / (
10      SELECT
11        SUM(liquiditynum)
12      FROM
13        "@polymarket.gamma.markets"
14    ),
15    2
16  ) AS pct_of_total_liquidity
17FROM
18  "@polymarket.gamma.markets"
19WHERE
20  active = TRUE AND category != 'nan'
21GROUP BY
22  category
23ORDER BY
24  total_liquidity_usd DESC