← tickerbot.io
View as markdown
Concepts › Signals › News › News

latest_news_at

Publish time of the newest news article that mentions the ticker.

metadata
typetimestamp with time zone
cadence15 min
intervals1d
universeall tickers
historyrecent only (forward-only from first computation)
nullableyes — NULL where not applicable

Swap YOUR_KEY for a key from /dashboard/keys. Responses are real captures from 2026-10-06, trimmed.

The whole market, filtered on it /v2/scan

Live — the whole market, ranked by this column
curl -X POST "https://api.tickerbot.io/v2/scan" \
  -H "Content-Type: application/json" \
  -H "Authorization: Bearer YOUR_KEY" \
  -d '{ "q": "latest_news_at IS NOT NULL", "order": "latest_news_at", "columns": "latest_news_at" }'
Response (sampled 2026-10-06, trimmed)
{
 "as_of": "2026-10-06T12:44:23.666Z",
 "query": {
  "q": "latest_news_at IS NOT NULL",
  "limit": 2,
  "order": "latest_news_at",
  "dir": "desc",
  "fields": [
   "latest_news_at"
  ],
  "full": false,
  "universe": null,
  "asset_class": null
 },
 "count": 2,
 "results": [
  {
   "ticker": "GD",
   "name": "General Dynamics Corporation",
   "asset_class": "stocks",
   "asset_type": "CS",
   "price": 332.925,
   "change_1d_pct": 0.3632581695405716,
   "gap_pct": 0.4504,
   "relative_volume": 0.0003,
   "market_cap": 89308224497,
   "latest_news_at": "2026-10-06T12:20:58.000Z"
  },
  {
   "ticker": "GOOG",
   "name": "Alphabet Inc. Class C Capital Stock",
   "asset_class": "stocks",
   "asset_type": "CS",
   "price": 344.465,
   "change_1d_pct": 0.18468429165575748,
   "gap_pct": -0.1312,
   "relative_volume": 0.0484,
   "market_cap": 4162458319730,
   "latest_news_at": "2026-10-06T12:16:31.000Z"
  }
 ]
}
As-of — the same scan at a past date
curl -X POST "https://api.tickerbot.io/v2/scan" \
  -H "Content-Type: application/json" \
  -H "Authorization: Bearer YOUR_KEY" \
  -d '{ "q": "latest_news_at IS NOT NULL", "order": "latest_news_at", "columns": "latest_news_at", "asof": "2026-07-08" }'
Response (sampled 2026-10-06, trimmed)
{
 "as_of": "2026-07-08",
 "query": {
  "q": "latest_news_at IS NOT NULL",
  "asof": "2026-07-08",
  "interval": "auto",
  "limit": 2,
  "order": "latest_news_at",
  "dir": "desc",
  "fields": [
   "latest_news_at"
  ],
  "full": false,
  "universe": null,
  "asset_class": null
 },
 "count": 0,
 "results": []
}

Its history /v2/series

History — the column on an aligned time grid
curl "https://api.tickerbot.io/v2/series?tickers=AAPL,MSFT&columns=close,latest_news_at" \
  -H "Authorization: Bearer YOUR_KEY"
Response (sampled 2026-10-06, trimmed)
{
 "as_of": "2026-10-06T12:44:26.304Z",
 "interval": "1d",
 "tickers": [
  "AAPL",
  "MSFT"
 ],
 "columns": [
  "close",
  "latest_news_at"
 ],
 "count": 6,
 "series": {
  "AAPL": [
   {
    "t": "2026-10-01",
    "close": 330.32,
    "latest_news_at": null
   },
   {
    "t": "2026-10-02",
    "close": 333.69,
    "latest_news_at": null
   },
   {
    "t": "2026-10-05",
    "close": 332.89,
    "latest_news_at": null
   }
  ],
  "MSFT": [
   {
    "t": "2026-10-01",
    "close": 512.8,
    "latest_news_at": null
   },
   {
    "t": "2026-10-02",
    "close": 517.53,
    "latest_news_at": null
   },
   {
    "t": "2026-10-05",
    "close": 525.18,
    "latest_news_at": null
   }
  ]
 }
}

Same grammar on scan, series, and webhooks; state reads take ?asof= for point-in-time answers.

Related signals — News