Tickerbot — The stock market, in SQL

POSThttps://api.tickerbot.io/v2/scan

Time-travel form of [POST /v2/scan](/docs/endpoints/scan/live). Pass "asof": "YYYY-MM-DD" (or full ISO) in the body and the server evaluates your q against the daily-state snapshot of every ticker on that day. Same SQL grammar, same response envelope as live; the _meta.resolution: "daily" marker and _meta.frozen_fields list signal that the universe was reconstructed from historical state. The same endpoint also accepts GET with parameters in the query string — handy for short queries and quick interactive testing.

Plan access

Included on every plan.

Rate limit

Hobby 600/min · Pro 6,000/min · Scale 60,000/min.

Asof depth

Replayable on every plan.

Body parameters

qstringrequired

SQL WHERE expression. Same grammar as live scan. Max 4000 chars. See the schema for columns + flags you can compose.

asofstringrequired

Target date as `YYYY-MM-DD` or full ISO timestamp. The server evaluates the WHERE against the close-of-day snapshot for this date.

universestring

Slug of a system or caller-owned universe. Scopes the scan to those tickers as of the same date.

orderstringdefault day_change_pct

Column to sort by. Same column whitelist as live scan.

dirstringdefault desc

Sort direction.

fieldsstring

Comma-separated list of extra columns to include in each result row. Default columns are always present.

limitintegerdefault 50

Page size. Max 100.

cursorstring

Opaque cursor from the previous response. Pass the prior `next_cursor` to get the next page.

Status codes

200

Page of matching rows at asof with as_of, query, count, next_cursor, and results. _meta.resolution: "daily" and _meta.frozen_fields describe the historical envelope.

400

Missing/malformed asof, malformed q, unknown column, invalid order/dir/fields, or invalid cursor.

404

Referenced universe does not exist.

curl -X POST "https://api.tickerbot.io/v2/sandbox/scan" \
  -H "Content-Type: application/json" \
  -d '{
    "q": "gap_up AND small_cap",
    "asof": "2026-06-16",
    "order": "day_change_pct",
    "dir": "desc",
    "fields": "rsi_14,relative_volume",
    "limit": 50
  }'

Try it

POSThttps://api.tickerbot.io/v2/sandbox/scan?q=gap_up+AND+small_cap&asof=2026-06-16&order=day_change_pct&dir=desc&fields=rsi_14%2Crelative_volume&limit=50

Sandbox demo — 50 rows, 1-year history. Sign up for the full response.

{
  "as_of": "2024-01-22",
  "query": { "q": "gap_up AND small_cap", "asof": "2024-01-22", "limit": 3, "order": "day_change_pct", "dir": "desc", "fields": [], "full": false, "universe": null },
  "count": 3,
  "next_cursor": "eyJhZnRlcl9vcmRlcl92YWx1ZSI6MC4wODksImFmdGVyX3RpY2tlciI6IkRKVCJ9",
  "_meta": {
    "resolution": "daily",
    "frozen_fields": ["name", "sector", "industry", "asset_type", "exchange"]
  },
  "results": [
    { "ticker": "SMCI", "name": "Super Micro Computer, Inc.", "asset_type": "CS", "price":  37.42, "day_change_pct": 0.187, "gap_pct": 0.094, "relative_volume": 5.2, "market_cap": 1980000000 },
    { "ticker": "SOUN", "name": "SoundHound AI, Inc.",        "asset_type": "CS", "price":   4.81, "day_change_pct": 0.142, "gap_pct": 0.061, "relative_volume": 4.8, "market_cap":  840000000 },
    { "ticker": "BBAI", "name": "BigBear.ai Holdings",         "asset_type": "CS", "price":   6.12, "day_change_pct": 0.118, "gap_pct": 0.054, "relative_volume": 3.2, "market_cap":  890000000 }
  ]
}