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

Scale and above. Hobby/Pro return 403 news_tier_required for the archive — the live `news_volume` and `news_volume_weighted_sentiment` columns on the ticker object remain available on every plan.

Rate limit

Hobby 600/min · Pro 2,000/min · Scale 10,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.

403

news_tier_required — archive access requires Scale or above. Live news_volume / news_volume_weighted_sentiment columns on the ticker table remain available on lower plans.

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"
    }
  ]
}