# latest_news_at

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

A timestamp with time zone signal column on the Tickerbot computed state table (23,230+ ticker rows) — computed by the platform, queryable by bare name across the API. Values are NULL on rows the signal doesn't apply to.

- Group: News
- Category: News
- Type: timestamp with time zone
- Update cadence: 15 min
- Intervals: 1d
- Universe: all tickers
- History: recent only (forward-only from first computation)
- Nullable: yes

## Query it

Every applicable form factor, grouped by endpoint family. Response payloads are real captures, sampled 2026-10-06 and trimmed; your run's values and dates will differ.

### The whole market, filtered on it — `/v2/scan` (https://tickerbot.io/docs/endpoints/scan.md)

#### Live — the whole market, ranked by this column

```bash
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):

```json
{
 "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

```bash
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):

```json
{
 "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` (https://tickerbot.io/docs/endpoints/series.md)

#### History — the column on an aligned time grid

```bash
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):

```json
{
 "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
   }
  ]
 }
}
```

## Related signals (News)

- [highly_relevant_news_count](https://tickerbot.io/docs/signals/highly_relevant_news_count.md)
- [news_sentiment_volatility](https://tickerbot.io/docs/signals/news_sentiment_volatility.md)
- [news_volume](https://tickerbot.io/docs/signals/news_volume.md)
- [news_volume_weighted_sentiment](https://tickerbot.io/docs/signals/news_volume_weighted_sentiment.md)
- [recent_news_count](https://tickerbot.io/docs/signals/recent_news_count.md)

---

Full catalog: https://tickerbot.io/docs/signals/catalog.md · Schema: https://tickerbot.io/docs/schema.md · HTML: https://tickerbot.io/docs/signals/latest_news_at/