SQL access over HTTPS
Send SELECT queries through a REST endpoint and receive structured JSON for analytics, reporting, and research apps.
OptionData
Get 50% off on all plans for the first year – contact sales for a promotional code.
Historical Options Data API
Historical Options Data API with SQL
Query U.S. options history over REST with ClickHouse SQL. Pull trades, Greeks, implied volatility, premium, open interest, and volume for backtests, market studies, dashboards, and research workflows without downloading bulk files.
historical options data APIoptions trading datastock options data APIoptions database
Backtest-ready options fields
Analyze option trades with Greeks, IV, premium, side context, symbol, expiration, strike, and contract metadata.
Guarded query execution
The portal applies SELECT-only checks, table allowlists, and server-side guardrails for safer customer queries.
Best for
- Historical options-flow backtests
- Signal research and model training
- Market microstructure analysis
- Custom analytics dashboards
Common API questions
Can I query historical options data with SQL?
Yes. The historical API accepts guarded ClickHouse SELECT queries over REST and returns JSON results for your own research stack.
Do historical responses include Greeks and implied volatility?
Yes. Historical option trade rows include common analytics fields such as Greeks, IV, premium, volume, and contract metadata when available.
Is this a file download API?
No. The historical API is request-based. You query the warehouse directly instead of downloading and maintaining static files.