Polymarket indexer
The Polymarket database combines decoded Polygon fill events with current event and market metadata.
| Table | Purpose |
|---|---|
polymarket_order_filled_v3 | Maker/taker fill legs, token and USDC amounts, fees, transaction and block context |
raw_event_meta | Event titles, slugs, dates, categories and source metadata |
raw_market_meta | Market questions, outcomes, token identifiers, status and resolution metadata |
Historical CLOB captures are separate from ClickHouse. The order-book example
discovers archive files, downloads one with a size cap, decompresses the raw
timestamp-plus-JSON format, anchors on a book snapshot, and applies subsequent
price_change levels.
OnchainDivers provides access to high-precision Polymarket order books, including full snapshots, price-level changes, and explicit best-bid/ask transitions for individual CLOB outcome tokens. Dedicated files for five-minute Bitcoin Up/Down markets preserve the rapid probability changes around resolution and can be joined directly to event and market metadata in ClickHouse.
The chart below is regenerated from those raw Polymarket records and the matching HyperLiquid BTC futures book during every strict documentation build. It shows how the Up and Down probabilities evolved alongside the underlying market, with no hard-coded event or CLOB token IDs.
See the complete reproducible cross-venue workflow.
Credentials and archive locations are supplied through .env; no deployment
address is included in this site.