State over time

Query parameters

Returns

Status codes

Notes

• The join across the OHLCV bar store and the indicator and boolean state tables that would otherwise take N history calls and a hand-rolled merge. Those two stores genuinely disagree — state has rows on non-trading days, intraday bars can lag behind state — so the endpoint owns the alignment policy: a missing cell is null, never a silently dropped row, and _meta reports per-column sources plus per-ticker coverage so a gap is always visible.
• Column names resolve by source, invisibly at the call site: open/high/low/close/volume/vwap/trades (or o/h/l/c/v/vw/n) read licensed OHLCV bars; every signal on the schema page reads the state tables; your own custom signals compile per-row and behave exactly like built-ins.
• With no columns the default set matches the deprecated Ticker history — a bare /v2/series?ticker=AAPL IS ticker history in its canonical spelling.
• 1m / 1h / 1d are stored tiers. 1w is a real weekly resample: each signal samples the week's last observation, bars aggregate (open of first bar, max high, min low, close of last, summed volume and trades, volume-weighted vwap — null for a zero-volume week), rows keyed by the week's Monday.
• 1q serves quarterly fundamentals (eps, eps_estimate, eps_surprise, eps_surprise_pct, revenue, gross_profit, free_cash_flow) on the fiscal grid — rows keyed by calendar quarter (2026-Q2) with each ticker's exact fiscal_period and reported, the date the quarter was announced (null when unknown). reported is the axis a point-in-time backtest filters on: the quarter's numbers were not knowable before it. Quarterly columns cannot mix with daily ones in one request — the grids are not joinable.
• transitions_only=true filters rows down to the state-change edges of the boolean signals — computed by the same shared rule that fires webhooks, so the two cannot disagree — with non-boolean signals riding along as context (the price at the flip). Numeric-threshold flips ("when did rsi_14 cross 70") are an as-of question, not a transitions one.
• For charting, Bars is its own family on purpose: sub-hour intervals (1s–30m), fetch-on-miss coverage, and the compact array shape live there. Series is the analytical read; bars is the chart read.
• Both GET and POST are supported — POST takes the same parameters in a JSON body and accepts real arrays for tickers/columns.
• All-time — series history is never windowed.
• At 1q, the two sources land at different times: eps arrives with the earnings announcement while statement signals (revenue, gross_profit, free_cash_flow) arrive with the filing. So the most recent quarter routinely carries an eps with revenue: null — a normal reporting lag, not a coverage gap. reported dates the announcement.
• ticker (singular) and tickers are both accepted; when both are present, ticker wins.
• Caps: 50 tickers, 25 columns, limit ≤ 1000, tickers × limit ≤ 25,000 rows per page. Over-cap tickers, columns, and tickers × limit are explicit 400s; an over-cap limit alone is clamped to 1000 (house convention — limit=10000 means "max").
• On a mixed bars+state daily request, spine rows on non-trading days (weekends/holidays) are dropped and counted in _meta.non_trading_days_dropped — they could never carry OHLCV and would read as gaps. transitions_only requests are exempt: their output is already sparse, so carry rows are never dropped and a flip recorded on one keeps its original date no matter which columns ride along (bar columns are null on such a row and count in _meta.coverage.*.missing_bar_cells). Before 2026-08-10, adding a bar column re-dated such flips to the next trading day.
• Ticker history and Signal history return the same data for one ticker / one signal in their original envelopes — kept stable for existing integrations. New integrations should read series.

More examples

curl "https://api.tickerbot.io/v2/series?ticker=AAPL&columns=above_sma_200,close&transitions_only=true&from=2026-02-18" \
  -H "Authorization: Bearer YOUR_KEY"

{
  "as_of": "2026-08-11T23:23:33.317Z",
  "interval": "1d",
  "tickers": ["AAPL"],
  "columns": ["above_sma_200", "close"],
  "count": 2,
  "next_cursor": null,
  "_meta": {
    "sources": { "above_sma_200": "state", "close": "bars" },
    "coverage": { "AAPL": { "rows": 2, "missing_bar_cells": 0 } },
    "transitions_only": true,
    "transition_drivers": ["above_sma_200"]
  },
  "series": {
    "AAPL": [
      { "t": "2026-03-30", "above_sma_200": false, "close": 246.63, "transitions": { "above_sma_200": "exit" } },
      { "t": "2026-03-31", "above_sma_200": true,  "close": 253.79, "transitions": { "above_sma_200": "enter" } }
    ]
  }
}

curl "https://api.tickerbot.io/v2/series?ticker=AAPL&columns=eps,revenue&interval=1q&limit=2" \
  -H "Authorization: Bearer YOUR_KEY"

{
  "as_of": "2026-08-11T23:23:33.317Z",
  "interval": "1q",
  "tickers": ["AAPL"],
  "columns": ["eps", "revenue"],
  "count": 2,
  "next_cursor": "eyJiZWZvcmVfdHMiOiIyMDI2LVExIn0",
  "_meta": {
    "sources": { "eps": "earnings", "revenue": "statements" },
    "coverage": { "AAPL": { "rows": 2 } }
  },
  "series": {
    "AAPL": [
      { "t": "2026-Q1", "fiscal_period": "2026-03-31", "reported": "2026-04-30", "eps": 2.01, "revenue": 111184000000 },
      { "t": "2026-Q2", "fiscal_period": "2026-06-30", "reported": "2026-07-30", "eps": 1.91, "revenue": null }
    ]
  }
}