View as markdown
Concepts › Signals › Price › Highs & lows

last_20d_high_date

Date the trailing-20-day high was set.

Watch this signal live on real tickers: Open in Explore →

At a glance

Typedate
GroupPrice
CategoryHighs & lows
Update cadencepost-close daily
Intervals1m/1h/1d
Universeall tickers
Historyfull · since 2003
Nullableyes — NULL where not applicable

Rolling-window highs and lows (5-day, 20-day, 52-week), their dates and distances, and the at/approaching/breaking signals those levels own.

Query it

Every applicable form factor, grouped by endpoint family. Swap YOUR_KEY for the value from /dashboard/keys. Response payloads are real captures, sampled 2026-08-18 and trimmed — your run's values and dates will differ.

Use scan /v2/scan

The whole market through a WHERE clause — this signal composed freely with any other column. Docs →

Live — the whole market, ranked by this column
curl -G "https://api.tickerbot.io/v2/scan" \
  --data-urlencode "q=last_20d_high_date IS NOT NULL" \
  -d "order=last_20d_high_date" -d "columns=last_20d_high_date" \
  -H "Authorization: Bearer YOUR_KEY"
Response (sampled 2026-08-18, trimmed)
{
 "as_of": "2026-08-18T00:24:21.023Z",
 "query": {
  "q": "last_20d_high_date IS NOT NULL",
  "limit": 2,
  "order": "last_20d_high_date",
  "dir": "desc",
  "fields": [
   "last_20d_high_date"
  ],
  "full": false,
  "universe": null,
  "asset_class": null
 },
 "count": 2,
 "results": [
  {
   "ticker": "AAAA",
   "name": "Amplius Aggressive Asset Allocation ETF",
   "asset_class": "stocks",
   "asset_type": "ETF",
   "price": 30.97,
   "day_change_pct": 0.0001,
   "gap_pct": 0.0004,
   "relative_volume": null,
   "market_cap": null,
   "last_20d_high_date": "2026-08-17T00:00:00.000Z"
  },
  {
   "ticker": "AACO",
   "name": "Abony Acquisition Corp. I Class A Ordinary Share",
   "asset_class": "stocks",
   "asset_type": "CS",
   "price": 9.966,
   "day_change_pct": 0.0006,
   "gap_pct": null,
   "relative_volume": null,
   "market_cap": 312362203,
   "last_20d_high_date": "2026-08-17T00:00:00.000Z"
  }
 ]
}
As-of — the same scan at a past date
curl -G "https://api.tickerbot.io/v2/scan" \
  --data-urlencode "q=last_20d_high_date IS NOT NULL" \
  -d "order=last_20d_high_date" -d "columns=last_20d_high_date" \
  -d "asof=2026-05-20" \
  -H "Authorization: Bearer YOUR_KEY"
Response (sampled 2026-08-18, trimmed)
{
 "as_of": "2026-05-20",
 "query": {
  "q": "last_20d_high_date IS NOT NULL",
  "asof": "2026-05-20",
  "interval": "auto",
  "limit": 2,
  "order": "last_20d_high_date",
  "dir": "desc",
  "fields": [
   "last_20d_high_date"
  ],
  "full": false,
  "universe": null,
  "asset_class": null
 },
 "count": 2,
 "results": [
  {
   "ticker": "AACI",
   "name": "Armada Acquisition Corp. III Class A Ordinary Share",
   "asset_class": "stocks",
   "asset_type": "CS",
   "price": 9.95,
   "day_change_pct": 0.30140825193294013,
   "gap_pct": 0.7046299936492628,
   "relative_volume": 0.5709102291664829,
   "market_cap": null,
   "last_20d_high_date": "2026-05-20T00:00:00.000Z"
  },
  {
   "ticker": "AAT",
   "name": "AMERICAN ASSETS TRUST, INC.",
   "asset_class": "stocks",
   "asset_type": "CS",
   "price": 21.76,
   "day_change_pct": 2.3037141513869392,
   "gap_pct": -0.37611659614479687,
   "relative_volume": 1.277156847967895,
   "market_cap": 1669601650,
   "last_20d_high_date": "2026-05-20T00:00:00.000Z"
  }
 ]
}

Use series /v2/series

Its history over time, on one aligned grid. Docs →

History — the column on an aligned time grid
curl "https://api.tickerbot.io/v2/series?tickers=AAPL,MSFT&columns=close,last_20d_high_date" \
  -H "Authorization: Bearer YOUR_KEY"
Response (sampled 2026-08-18, trimmed)
{
 "as_of": "2026-08-18T00:24:23.008Z",
 "interval": "1d",
 "tickers": [
  "AAPL",
  "MSFT"
 ],
 "columns": [
  "close",
  "last_20d_high_date"
 ],
 "count": 6,
 "series": {
  "AAPL": [
   {
    "t": "2026-08-12",
    "close": 302.25,
    "last_20d_high_date": "2026-07-29T00:00:00.000Z"
   },
   {
    "t": "2026-08-13",
    "close": 305.26,
    "last_20d_high_date": "2026-07-29T00:00:00.000Z"
   },
   {
    "t": "2026-08-14",
    "close": 305.93,
    "last_20d_high_date": "2026-07-29T00:00:00.000Z"
   }
  ],
  "MSFT": [
   {
    "t": "2026-08-12",
    "close": 492.43,
    "last_20d_high_date": "2026-08-10T00:00:00.000Z"
   },
   {
    "t": "2026-08-13",
    "close": 496.88,
    "last_20d_high_date": "2026-08-10T00:00:00.000Z"
   },
   {
    "t": "2026-08-14",
    "close": 495.4,
    "last_20d_high_date": "2026-08-10T00:00:00.000Z"
   }
  ]
 }
}

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

Related signals — Highs & lows