// polymarket · indexer

Polymarket Indexer

Complete prediction-market data — order fills, market and event metadata — in a SQL-queryable ClickHouse warehouse — skip indexing and just query.

Polymarket · indexer● live
order-fill rows
~1.35B
markets
~2.33M
01.WHAT'S INCLUDED// Polymarket · indexer
  • Direct ClickHouse SQL over full history
  • Order fills: maker/taker · side · amounts · fee · Polygon tx
  • Market metadata: questions · outcomes · prices · liquidity
  • Event metadata: titles · categories · tags · volume
  • Custom REST endpoints, quoted per scope
// factsSPEC
Order-fill events
~1.35B rows (polymarket_order_filled_v3)
Market metadata
~2.33M rows (raw_market_meta)
Event metadata
~42K rows (raw_event_meta)
Refresh
continuous updates
Interfaces
ClickHouse SQL + custom REST
Database name
polymarket
Free trial
up to 48h, no card
02.HOW IT WORKS// query it like a database
query.sqlclickhouse · polymarket
1SELECT wallet, SUM(size) AS vol
2FROM polymarket.fills
3WHERE ts > now() - INTERVAL 1 HOUR
4GROUP BY wallet
5ORDER BY vol DESC LIMIT 20
→ 200 OK · 82ms · joins, CTEs, window fns
// HOW TO QUERY
Connect with any ClickHouse client — DBeaver, DataGrip, psql, or the Python client — against the polymarket database, then write SQL with joins, CTEs, and window functions.
// INTERFACES
Direct ClickHouse SQL, or a custom REST endpoint shaped to a recurring query (quoted per scope).
// SCHEMA
Tables, column types, and example queries live in the indexer docs.
03.FAQ// 3 questions
What does the Supanode Polymarket indexer contain?

Complete prediction-market data across three core tables: polymarket_order_filled_v3 (~1.35B on-chain order-fill events from the CTF Exchange), raw_market_meta (~2.33M markets with questions, outcomes, resolution conditions, prices, liquidity, and volume), and raw_event_meta (~42K events grouping related markets). The dataset is continuously refreshed.

How do I query it?

Through direct ClickHouse SQL against the `polymarket` database, using clients like DBeaver, DataGrip, psql, or the Python client. Supanode can also deploy custom REST endpoints around recurring queries, quoted per scope.

How is the Polymarket indexer priced and provisioned?

A flat monthly subscription, crypto-only and prepaid, with unlimited queries within tier limits. Connection details — host, port, username, password — are provisioned per customer over Telegram. A free trial of up to 48 hours is available before committing.

Get Polymarket Indexer.

Set up over Telegram with an engineer — endpoint, allowlist, tuning.