[ SUPANODE ]by hightower
// polymarket · indexer

Polymarket Historical Data Indexer

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

[ view pricing ]join group
Polymarket · indexer● live
order-fill rows
~1.82B
since
2022
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.82B rows (polymarket_order_filled_v3)
Market metadata
~12.1M rows, 140 columns (raw_market_meta)
Event metadata
~2.48M rows, 92 columns (raw_event_meta)
History
fills from 2022-11-21
Refresh
continuous updates
Interfaces
ClickHouse SQL + custom REST
Database name
polymarket
Free trial
up to 24h, no card
see the full product overview →
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.82B on-chain order-fill events from the CTF Exchange, back to November 2022), raw_market_meta (12.1M rows across 140 columns - questions, outcomes, CLOB token ids, resolution status, prices, liquidity, volume), and raw_event_meta (2.48M rows across 92 columns, grouping related markets). Because USDC and token amounts share 6 decimals, their ratio is the executed probability - the fill history is also the price history. 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 24 hours is available before committing.

Get Polymarket Historical Data Indexer.

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

[ talk to us ]◀ Polymarket services