Tickerbot — The stock market, in SQL

GEThttps://api.tickerbot.io/v2/news/scan

One endpoint, two shapes. Without group_by, each result is one article (default columns: id, time_published, title, source, tickers, overall_sentiment_score, overall_sentiment_label). With group_by set, results are aggregate rollups — default SELECT becomes <group_by cols>, COUNT(*) AS volume. Use the tk alias (auto-UNNEST of tickers) to roll up per ticker without writing the join.

"As-of" is just a WHERE filter on time_published — there is no dedicated asof parameter.

Both GET and POST are supported; POST body takes the same parameter names for queries too long to fit in a URL.

Plan access

Available on every plan, alongside the live `news_volume` and `news_volume_weighted_sentiment` columns on the ticker object.

Rate limit

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

Per-call cap

Scale/Enterprise: 1000 rows. History back to 2015.

Query parameters

qstringrequired

WHERE clause over the news_article table. Max 4000 chars. See the schema for columns + flags you can compose.

selectstring

Comma-separated columns/expressions to return. Defaults to article columns (no `group_by`) or `<group_by cols>, COUNT(*) AS volume` (with `group_by`).

group_bystring

Comma-separated group keys. Switches the response to aggregate rows. Use `tk` to roll up per ticker.

havingstring

HAVING clause on the aggregate. Requires `group_by`.

orderstring

Sort column or alias. Defaults to `time_published` (article rows) or `volume` (aggregate rows).

dirstringdefault desc

Sort direction.

limitintegerdefault 50

Page size. Max 1000 on Scale/Enterprise.

cursorstring

Opaque pagination cursor from a prior response's `next_cursor`.

Status codes

200

Envelope with as_of, query, count, next_cursor, and results.

400

bad_request or invalid_query — missing/malformed q, unknown column, or invalid parameter.

curl "https://api.tickerbot.io/v2/news/scan?q=time_published%20%3E%3D%20NOW()%20-%20INTERVAL%20'7%20days'%20AND%20'NVDA'%20%3D%20ANY(tickers)&dir=desc&limit=50" \
  -H "Authorization: Bearer YOUR_KEY"

Try it

This endpoint requires an authenticated key. Sign in to run it from your dashboard, or get a free key. tickerbot.io/dashboard.

Sample response

{
  "as_of": "2026-05-14T11:41:01.000Z",
  "query": {
    "q": "time_published >= NOW() - INTERVAL '7 days' AND 'NVDA' = ANY(tickers) AND overall_sentiment_score < -0.2",
    "select": null,
    "group_by": null,
    "order": "time_published",
    "dir": "desc",
    "limit": 50
  },
  "count": 12,
  "next_cursor": null,
  "results": [
    {
      "id": 9821,
      "time_published": "2026-05-13T18:22:00.000Z",
      "title": "NVDA Slips on Margin Worries",
      "source": "Bloomberg",
      "tickers": ["NVDA"],
      "overall_sentiment_score": -0.34,
      "overall_sentiment_label": "Somewhat-Bearish"
    }
  ]
}