The stock market, in SQL
A computed table of every ticker × every signal: 14,602+ US tickers plus rates, FX and crypto, 421+ signal columns, refreshed every minute. Query it live, as of any past moment, or as a webhook subscription.
The schema is the API
One unified set of columns powers every endpoint.
Every ticker column — numerics like price and rsi_14, classifications like sector, pre-thresholded flags like gap_up and golden_cross — is queryable from SQL, returnable in a payload, and pullable as a time series.
Know the schema and you know the API.
Three scopes — one ticker, one signal’s matches, the whole market. Each readable live or as of any past moment (as-of), and watchable for state changes (Webhooks). Over time, the same columns become Series; what happened along the way is Events.
The endpoints
Grouped by the question they answer. One schema underneath all of them; each is documented in detail under Endpoints.
| Bucket | Path | What it answers |
|---|---|---|
| Tickers | https://api.tickerbot.io/ | One ticker, one moment: its current state, time-travel via ?asof=, and ETF composition. Or paginate/scope the whole universe. |
| Signals | https://api.tickerbot.io/ | What signals exist and who matches one right now (or at a past moment with asof) — built-in and your custom ones, one catalog. |
| Scan | https://api.tickerbot.io/ | Many tickers, one moment. Pass a SQL WHERE clause, get every matching ticker — now, or at a past instant with asof. group_by turns it into market-breadth rollups. |
| Series | https://api.tickerbot.io/ | Ticker state over time on one aligned grid: any columns for any tickers — at 1m / 1h / 1d / 1w / 1q. OHLCV bars keep their own chart feed. |
| Events | https://api.tickerbot.io/ | Discrete things that happened, cross-ticker: dividends, splits, insider transactions, analyst actions — plus opt-in signal firings and news — one timeline, queryable by payload. |
| News | https://api.tickerbot.io/ | SQL query over the news archive. Article rows or rollups by ticker, day, source, or sentiment. |
| Custom signals | https://api.tickerbot.io/ | Named boolean predicates you author and reference like a built-in signal — reusable in any q. |
| Universes | https://api.tickerbot.io/ | Named ticker lists you reference from any query endpoint with ?universe=<slug>. |
| Webhooks | https://api.tickerbot.io/ | A trigger plus a delivery. POST /v2/webhooks (or a /subscribe shortcut) and we push your endpoint when a scan, signal, or event fires. The registry lists and manages them. |
| Websockets | https://api.tickerbot.io/ | Hold a websocket open and receive each subscribed ticker’s freshly-computed row on every refresh. |
What this API doesn’t do
Honest scope boundaries. Pair us with the right tool for the job.
- No order execution. We tell you when the conditions you care about are met. Routing the order is your broker’s job.
- No SLAs at launch. Best-effort uptime today; contact us if you need an SLA.