Query Playground
Write SQL directly against our ClickHouse database. Query Kalshi markets, Polymarket orderbooks, on-chain trades, and more—all from your browser.
Direct database access
A full-featured SQL IDE in your browser, connected to our ClickHouse warehouse of prediction market data.
Full SQL Access
Write native SQL queries against our ClickHouse database. Monaco editor with syntax highlighting, autocomplete, and multi-tab support.
Kalshi Data
Query kalshi_markets, kalshi_events, and kalshi_trades tables. Access market metadata, event hierarchies, and individual trade records.
Polymarket Data
Access polymarket_markets, order book messages, wallet events, and on-chain trade data from the CTF exchange contracts.
On-Chain Trade Data
Indexed exchange_orders_matched events from Polymarket's CTF contracts. Every fill, every block, with full transaction context.
Interactive Results
AG Grid-powered result tables with sorting, filtering, and CSV export. Explore millions of rows without leaving the browser.
Data Explorer
Browse tables organized by venue. View schemas, sample data, and table statistics. Click any table to start querying instantly.
Available tables
kalshi_markets & kalshi_events
Market metadata, event hierarchies, categories, and settlement status.
kalshi_trades
Individual trade records with price, size, timestamp, and taker side.
polymarket_markets & book_messages
Market info plus real-time orderbook snapshots and updates.
exchange_orders_matcheds
On-chain trade events from Polymarket's CTF exchange contracts.
Ready to explore?
Get access to the Query Playground and start analyzing prediction market data today.