- FixedHistory dates crypto, FX and rate daily bars on their own day. Each
close(and the other OHLCV names) was dated one day early, so a window starting on a date returned a row from the day before, and a mix with stored signals could put a Friday bar on a weekend day. - FixedAn as-of Get a ticker lists only the signals it serves in
_meta.sources.<grain>.contributed. On a blended read it also named stored columns that are not published signals. - FixedA Query events cursor keeps the read it started. A
kind=signalwalk withqlost itsgrainon page 2 and read another grain; aticker,select,joinorgrainadded beside a cursor that did not carry one now answers 400 naming it, where it narrowed or reshaped the walk. - FixedA request body that is not valid JSON answers 400
bad_requestwith arequest_id. It answered 400internal, the code for a retryable server error. - FixedQuery news echoes
tickerandtickersas sent:nullwhen no list was sent, both keys always. Auniverseread echoed its members there. - FixedDeleting a built-in signal answers 404 read-only even when one of your custom signals uses it; it answered 409 and offered
?force=true. - FixedHistory
select=*serves an OHLCV name or a custom signal sent beside it (*,close,volume). They were checked and then left out. - FixedIntraday Bars for a range before 1970 answer 200
no_data, not a 503 that never clears. - Fixed
grain=auto, the default, is accepted on a live Scan, Get a signal and Get a ticker (it was a 400 there). - FixedMore cursors resume when only the spelling changed:
sort_by=market_capandorder=market_capacross pages;tickerandtickerson Series;asset_classandexchangein another case or order on List tickers; every webhookstatusnamed;selectnames in another case on History, Series, Get a ticker and Get a signal. - FixedClearer errors: an
@>value that is not JSON names the signal compared and no longer suggests a match that is out of date;@>on a signal that is not an object says what@>takes; a Query newsordernaming a function used inselectis the unknown-name 400; the subscribe and PATCH refusals on an event webhook name the event fields to check;selectbesidecolumnson a webhook PATCH says what each one does. - FixedQuery events
fromaftertois compared on the ET day when every kind reads a bare date as the ET day (analyst, news, estimate revisions), as Query news compares it. - FixedEvery webhook object carries its health fields:
last_errorandlast_eval_error_atarenull,consecutive_failuresis 0,failing_sinceisnullandlast_success_atiscreated_atuntil something happens. A new webhook left them out. - FixedA request that cannot get a database connection within 10 seconds answers 503
unavailablewith Retry-After, as the errors page says. Under load it could wait with no answer for minutes. - ChangedWithout
limit, aselect=*page on History holds 252 points (one ticker gets 252, 5 tickers get 50), not up to 1,000: five tickers of every signal was a 10 MB page. An explicitlimitup to the 1,000-point cap is unchanged. - FixedMCP tool inputs with one value from a fixed set are case-blind (
dir,channel,cadence, …), as the API reads them.
Reference
Changelog
Notable changes to the API, newest first. A breaking change is listed with the date it takes effect; Deprecations lists every change still to come.
Releases
- FixedBars returns 1m, 5m, 15m and 30m bars for a symbol's earlier holder, as it does 1s, 1h and 1d. For dates when another company held the symbol (
SPWRin 2022 is SunPower), these intervals answeredcoverage: no_datawith no bars.
- AddedEvery field that takes a fixed set of values says what each one means, in a table under the field: webhook
status,disabled_reason,cadence,channelanddir; deliveryevent,statusandchannel; universekind; the article'soverall_sentiment_label; and the Query events payload fields with a fixed set, such asinsideraction(every SEC Form 4 code),analystactionandprice_target_action,filingformandfiscal_period. - AddedList event kinds gives those payload fields a
valueslist, eachvaluewith itsdescription. - AddedAgents get the same tables: each .md page and llms-full.txt has a values table for every enum param and field; OpenAPI carries each value's meaning in the description and in
x-enumDescriptions; MCP tool inputs name each value and what it means.
- FixedBars
session=regularends at 13:00 ET on NYSE half days, such as the day after Thanksgiving and Christmas Eve. It used 16:00 ET every day, so bars from 13:00 ET on a half day, after the close, were returned as regular-session bars.
- FixedWebhooks with
cadencenyse_openare checked at the 9:30 AM ET open, on NYSE trading days only. From March 1 to the second Sunday of March and from the first Sunday of November to November 30 they were checked an hour early, at 8:30 AM ET, against pre-market data; they were also checked on market holidays. The value is unchanged.
- Fixed
fromaftertois a400on Query events and Query news, as on History, Bars and deliveries; it returned an empty200. - ChangedA param you did not send is echoed as
nullinquery: Query events and Query news now send the keys they left out. - Fixed
/v2/statusas_ofis the time the response was assembled; the health check it reports is the newchecked_at. - ChangedThe ticker sector read and an undeclared param:
/v2/tickers/{ticker}/sectorsand/v2/etf/{ticker}/sectorsechoqueryand answer an undeclared param with400 unknown_parameter, as every documented read does. - AddedList signals takes
intervalas the older name ofgrain, as every other endpoint does. List event kinds givesinsiderahistory_start. - FixedClearer errors:
next_cursorandsort_bysay to usecursorandorder; History's point cap quotes thelimityou sent; aconditionthat repeats the signal name says to drop it; Run a scan withoutqgives an example; Subscribe to events says whyfrom,to,order,dirandcadencedo not apply;select=*on an alert has one message on every subscribe. - FixedMCP: an argument a tool does not take reaches the API, so its error carries a
request_id; comma lists accept spaces and any case, list params accept an array, a required param accepts its older name, and error results carry_advisories. - DeprecatedTo 2027-01-12: on Get a signal,
query.selectfor an unsentselectchanges from[]tonull; on a comma-list Get a ticker,_meta.{symbol}.history_revised_atbecomes the timestamp itself. See Deprecations.
- Fixed
- ChangedAn unknown
universeon a read answers200with no results and its id innot_found, on Run a scan, Get a signal, Query events and Query news (it was404 universe_not_found). Unknown names in Query eventssignalare listed innot_foundinstead of failing the read. - FixedSubscribes and webhook updates refuse unknown tickers, universes and devices with a
400naming them, never a404(universe_not_foundanddevice_not_foundare now400). See Errors. - FixedCursors compare values as the API reads them: on page 2, a list sent as an array or as
a, b,dir=DESCfor the defaultdesc,ticker=aaplforAAPL,grain=1Dfor1d,order=valueorsort_by=defaulton Get a signal, andkind=customon List universes continue the walk instead of answering400. Text inq,conditionandsearchis compared as written. Bars cursors are unchanged. See Pagination. - Fixed
sort_bybesideorderon Get a signal:sort_by=market_cap&order=market_capis accepted; any other pair, such assort_by=default&order=default, answers400 bad_requestnaming both. - FixedQuery events
kind=signalpaging always moves on. A page that could not read its stretch of history in time returned no results and the samenext_cursor, so paging could repeat it. Each such page now tries a shorter stretch, and after three in a row the read answers503 unavailablewithRetry-After. Aqorjoin=stateread with nofromnow pages through history the same way instead of reading it in one pass. Rows served are unchanged. - Fixed
- FixedDates before 1900 are a
400naming the param (any date param, any route); they returned500. An unknown signal besideselect=*, and an unknown signal inselecton a Get a tickerasofread, are a400. Bars takes 12-digit epoch milliseconds (before 2001). A timestamp with a UTC offset gets a400asking forZ, and a blank Barsinterval=is ignored. - DeprecatedTo 2027-01-12: a
cursorreturned before 2026-11-12 answers400 bad_requestfrom that date. See Deprecations.
- FixedA cursor resumes only the read that returned it. Send
next_cursorback with the same params as the first page (limitmay change). A page whose params differ is a400naming the param; it used to return another read's rows. Cursors issued before this change keep working. Bars is unchanged: its cursor is a bar time, a position. See Pagination. - FixedA date that does not exist is a
400.2026-02-30, month 13 orT25:00answered500on Get a ticker, History, Bars, Run a scan, Get a signal, Query events and Query news, and Bars read Feb 30 as Mar 2. Every date param now answers one sentence naming the param, the value and the format: "from: 2026-13-45 is not a calendar date. Use YYYY-MM-DD or YYYY-MM-DDTHH:MM:SSZ." - Added
select=*on Get a ticker, Get a signal and History returns every signal, as on Run a scan and Query events; on an as-of read or History, every signal the grain stores. A Historyselect=*page holds up to 1,000 points (tickers ×limit). - AddedList tickers, List signals and List universes echo your request as
query, as every other read does. - Added
not_foundon Query events and Query news. Withticker, both list the symbols you named that we do not track, as List tickers does, so a typo no longer reads as "no events". - FixedSignal events with
qorjoin=stateover a long window no longer time out. Akind=signalread withfroma month or more back reads the window in steps and returns within seconds; a page that stops early carries anext_cursorto continue. See Query events. - ChangedTwo names of one param in one request are a
400, with one message, for examplefieldswithcolumnson Get a ticker, orsort_bywithorderon Get a signal: "Send one ofselect,fields,columns; they are the same param." Two older names together used to resolve silently. Each older name alone works as before.tickerandtickerswith the same symbols are accepted everywhere, including Query events and Query news. - FixedThe docs "Try it" sandbox rejects what the API rejects: an unknown param, a value outside its list, or two names of one param answer the same
400there as with a key. - ChangedErrors say what to send instead:
symbolson List tickers points toticker,searchon Query events toq,/v2/ticker/NVDAto/v2/tickers/NVDA. A list over 50 symbols and an unusable cursor each answer one message naming the fix, and anunknown_parameter400 lists only the params of the method you called. When a queryintervaldisagrees with the Bars path, the400names both widths. On custom signals,expressionpoints toexpr, updating or deleting a built-in signal says it is built-in and read-only, andcompile_failedcarries amessage. - FixedAn
Idempotency-Keyreused with a different body answers422 idempotency_key_reusedinstead of replaying the first response (Errors). A key sent asnullcounts as not sent. Only a2xxis stored now: after a4xx(a409, a429, a400you then corrected), a retry with the same key runs again; it replayed the error for 24 hours. - FixedSubscribe to events and Subscribe to news check
ticker: no tracked ticker is a404, some untracked is a400naming them, and on Update a webhook either is a400naming them (a404there reads as "webhook not found"); such a webhook could never fire. A comma list in the Subscribe to a ticker path is a400that gives the Subscribe to a scanqfor it. The crypto/FX400on Subscribe to events points at what works. - FixedUpdate a webhook: sending a ticker webhook's
qback as read is a no-op (it wrapped the rule in its ticker scope again);columnsandfieldsare accepted and mean what they mean on the subscribe that made the webhook, signals added to the default row (selectis exactly what each match carries); and a destination field for another channel (target_urlwithchannel: "in_app") is a400here and on every subscribe, where it used to be dropped. - FixedA webhook made with
columnsorfieldsreadsselect: null, with those signals underfields(Get a webhook).selectlisted them, but each match carries the default row as well, and sending thatselectback to Update a webhook cut the delivery to those signals. - Fixed
- AddedWebhook deliveries echo every filter of their webhook:
webhook.firedaddsuniverse,events.firedaddstickeranduniverse,news.firedaddsmin_relevance. A test fire sends a value of each signal's type (text, an ISO timestamp), not0, and a failed one hasnext_attempt_at: null: it is never retried. - FixedStream tickers: a frame key that names another param (
columns,signals,symbols,asof) or an unknown signal inselectanswers an error frame naming it and what to send instead; it used to be ignored or dropped. - RemovedStream tickers: the subscribe ack no longer sends
dropped_signalsordropped_fields. Aselectnaming any signal the stream does not carry is now an error frame and subscribes nothing; it used to subscribe the other signals and list the unknown ones in those keys. Remove the unknown signal fromselect.dropped_fieldshad been listed on Deprecations until 2027-01-12. - FixedGet ETF holdings sends
totalon every page, andPOST /v2/webhooks/{webhook}/enablehas a usableLinkheader. - FixedMCP: every tool's output schema declares
_advisories, so a validating client accepts a result carrying a quota or deprecation warning, a blank-valued unknown argument gets theunknown_parameter400 REST gives, and a call by a deprecated tool name carries_advisories.deprecatedwith its sunset date and the tool to call. Deprecations lists the MCP tools retired on 2026-11-10 with their successors. - DeprecatedTo 2027-01-12 (Deprecations): a param a path takes only on another method (
GET /v2/universes?tickers=) becomes a400 unknown_parameter; any other unknown stream frame key becomes an error frame; event and news webhooks stop carryingcadence,last_match_set,next_eval_atandlast_evaluated_at, and no webhook carrieslast_predicate_value;select=ticker_dataon news becomes a400namingmentions; on a comma list Barscountcounts bars, and unknown symbols in a Bars or History list appear only innot_found; one ETF's Holdings read drops the top-levelcount, and Holdings dropstruncated.
- ChangedMCP tools are named for their docs page:
tickerbot_query_events(Query events) andtickerbot_query_news(Query news). The old namestickerbot_list_eventsandtickerbot_search_newskeep working until 2027-01-12; see Deprecations. The OpenAPIoperationIds follow:query_eventsandquery_news.
- Removed
- Fixed
select=*on Query news returns every article field plusmentions(and the mention's fields on a per-mention row).select=*on agroup_byrollup is a400, andordertakes an article field or aselectalias; any other name is a400. - FixedA cursor continues only the read that made it. On Query news, send the first page's params with every page (
limitmay change): a page with different params, or the cursor alone, is a400naming the param. On Query events, atickerlist,qorselecttoo long for the cursor must be sent again with it, and is a400naming it when it is missing or different; a long ticker list used to fall away from page 3 on and return every ticker. - ChangedA
group_byrollup withoutlimitreturns every group up to 1,000 on Query events and Query news (it was 50). A rollup does not page, so the default is its maximum. List mode still defaults to 50. - AddedQuery events takes
select=*in list mode: every field, the wholepayload, and withjoin=stateevery signal the read's grain stores. - FixedEvery subscribe endpoint answers
400forchannel: "webhook"withouttarget_url, as Update a webhook does; it created a dashboard-only webhook. Subscribe to a scan and Subscribe to a ticker answer400 unknown_parameterfor a name they do not take, as the other subscribe endpoints do (tickeron Subscribe to a scan says to put it inq). - AddedA custom signal works in
orderon Run a scan, Get a signal, Subscribe to a scan, Subscribe to a signal and Update a webhook, as a built-in yes/no signal does. - FixedPaging a scan sorted by a yes/no signal moves past the first page; page 2 repeated page 1.
- Added
@>matches inside an object signal:leadership @> '[{"name":"John Ternus"}]'finds the companies he leads. A value that is not JSON is a400naming it (it was a500). See SQL. - FixedA test fire has the shape of a real fire: it is built by the same code, so a sample match carries the keys a real match carries, an event webhook applies its
select, and a news sample keepsidandmentions. A news webhook's test fire sendsnews.fired. - Added
events.fireddeliveries carrykind(the kinds the webhook watches) besidekinds. The Webhooks page documents every delivery body field by field. - Fixed
- FixedGet a ticker with
asofand a pinnedgrainanswers400 interval_unavailablefor a signal inselectthat grain does not store, as Run a scan and Get a signal do; it left the signal out. Withoutselect,_meta.signals_not_stored_at_grainnames the signals that grain leaves out. - Fixed
- ChangedResponse key order follows one rule: History and Get a signal send
queryright afteras_of, and Get a signal sendssignalandcatalogafterresults. List event kinds gives newshistory_startas2015-01-01. Error messages say "signal" and "built-in universe". - DeprecatedTo 2027-01-12: History's error for a signal the grain does not store changes from
bad_requesttograin_unavailable; Query events echoesfromandtoas sent,query.kindnames the six default kinds where it saysall, and withjoin=state_meta.grainnames the finest grain served (withblended) where it saysauto; the scanqueryecho sendsselectandgroup_byas lists; a universe400body dropsokandreason; and List deliveriesfrom/totakeYYYY-MM-DDor a…Ztimestamp only. See Deprecations.
- Fixed
querylists the params in their documented order on History, Query news and Query events, as on every other read. The keys and values are unchanged. - Changed
/docs/schema.jsonuses the List signals vocabulary. Onesignalslist (a yes/no signal istype: boolean, withboolean_kindandfiring),refreshfor how often each updates, andgrains, keyed by stored grain, each{ history, since, coverage }({}is current value only).barslists itsgrains. - ChangedList signals
typetakesobjectfor a JSON object;jsonbkeeps working. - ChangedList tickers rows carry
country,currency_nameanddelisted_utconly. Thelisting_country,currencyanddelisted_atkeys, sent since 2026-11-10, are gone. - FixedTest fire a webhook sends a news webhook a
news.fireddelivery with one sample article in the shape it really receives (it sent awebhook.firedsample before).
- ChangedA param sent under its name and an older name at once is a
400 bad_requeston every endpoint and MCP tool, for exampleselectwithfields,asofwithas_oforfromwithsince: send one. One of the two used to be dropped without a word. Each older name alone works as before (Deprecations).
- FixedAlerts no longer match delisted tickers. A scan, ticker or signal webhook checks the tickers Run a scan and Get a signal return, active ones only. It also matched delisted tickers, whose signals stopped updating the day they stopped trading, so a delivery could name one. A delisted ticker that was in a webhook's match set leaves it at the next check, which sends nothing.
- FixedA new alert fires only when a ticker starts matching, as Subscribe to a scan, Subscribe to a ticker and Subscribe to a signal say. Its first check records what already matches without firing; it used to send one delivery listing every current match. Event and news webhooks already fired only on what lands after you subscribe.
- ChangedAn MCP tool answers an argument it does not take with the error REST gives:
unknown_parameterwith the parameters the endpoint accepts, and the same hints (whereontickerbot_scansays to useq). It used to leave the argument out and run the call without it. The older names REST accepts still work. - FixedEvery MCP tool's
structuredContentpasses its ownoutputSchema. A tool that still sends fields leaving on 2027-01-12 (Deprecations) has anoutputSchemathat allows them until then; 20 tools failed their schema before.
- AddedList tickers answers
not_foundwithticker: the symbols you named that we do not track, in request order, the same key and meaning as Get a ticker. A tracked symbol that another filter or the page leaves out is not in it. - ChangedEvery List signals filter takes a fixed set of values, listed with a description each on its page:
group,categoryandasset_classjoinkind,type,refreshandgrain. A value outside the set is a400that lists the valid ones; it used to return an empty list. - FixedMCP tools take every older parameter name REST takes, for example
tickersontickerbot_list_tickers,fieldsandcolumnsontickerbot_scan,intervalontickerbot_get_history, with the same meaning as on REST. An argument a tool does not know is still left out and named in theX-Tickerbot-MCP-Droppedheader. - FixedRun a scan with
group_bysendstruncatedon every response (falsewhen the list is whole), andquery.selectis a list, as on a row scan. - FixedA webhook made with
fieldsorcolumnsshows those signals inselect; it showednull. Bars: the400forintervalin the query names the ticker you sent. Query news: eachmentionsentry liststicker,relevance,sentiment_score,sentimentin that order. Update a webhook: a newkindthat the storedqdoes not fit is a400naming the field the new kind lacks. - DeprecatedTo 2027-01-12, on List signals:
taxonomy, with each group'sderivation. Each signal carries itsgroupandcategorywith their labels, and the List signals page describes every group and category.
- Changed
searchranks its matches on List signals, List tickers and List universes. An exact name (symbol, universe id) comes first, then names that start with the term, then names that contain it, then descriptions (a ticker's company name) that have it as a whole word, then descriptions that contain it.search=rsinow starts withrsi_14. The same rows come back, in the usual order within each rank, and paging a search never repeats or skips.
- AddedGet a ticker's holdings pages with
cursor.next_cursorcomes back besidedataand inside each ETF's object, andcursorcontinues from the last holding (heaviest first, then by symbol). On a comma list one cursor carries each ETF's own position.totalandtruncatedstay, now on every page that more holdings follow, so the whole of a large ETF is reachable before the per-ETF maximum drops to 1,000 on 2027-01-12. - Added
queryon Bars, Get a ticker, Get a ticker's coverage and Get a ticker's holdings: your request echoed with its effective values, the shape History, Query events and Query news use (tickeris always a list). The Bars comma list addsnot_found, the symbols we do not track. - AddedSubscribe to a signal takes
orderanddir, as Subscribe to a scan and Get a signal do: they sort each delivery's match lists (defaultmarket_cap,desc). Update a webhook edits them on a signal webhook. - AddedNew
_metanames beside the old ones:signal_grains(Get a ticker),grain_scopeandminute_only_signals_fell_back_to_daily(Run a scan, Get a signal) andsignals_not_stored_at_grain(Run a scan). Theinterval_unavailableerror message speaks ofgrain. - ChangedPagination states the time-window rule once: a bare date covers that whole day (the market day on market data, the UTC day on webhook deliveries) and a timestamp
tois exclusive. Everyfromandtosays so. - ChangedThe docs show the current shape only. Returns tables and the
_metareference no longer list the older keys sent beside their replacements; Deprecations lists every one.countis described the same way everywhere: the items in the response's main list. - DeprecatedTo 2027-01-12: a timestamp
tobecomes exclusive on Bars, History and List deliveries, and the error codeinterval_unavailablebecomesgrain_unavailable, with the same status and message (Deprecations).
- AddedList universes takes
kind(builtin,customor both as a comma list;ownerkeeps working) andsearch(id, name and description). Every universe carrieskindbesidesystem. - FixedList universes:
limitandcursorpage the whole list, built-ins first. The built-ins used to come back in full on the first page whateverlimitsaid. - AddedUpdate a webhook edits the trigger: the filters of the subscribe that made it (
q,universe,select,order,diron a scan webhook;conditionon a signal webhook;kindandtickeron an event webhook;searchandmin_relevanceon a news webhook), checked exactly as that subscribe checks them, and the channel (channel,discord_url,device_id). A changed trigger fires only on what is new: what already matches it, or already happened, does not fire. - FixedUpdate a webhook:
enabled: trueturns a disabled webhook back on, with the same checks as re-enable. It answered a 400 pointing elsewhere. - ChangedList webhooks:
statustakes one or a comma list. List deliveries documents every field of a delivery and sends each on every row (redelivery_ofisnullandtestisfalseunless set). Test fire answers the delivery row, withlast_status_codeandlast_error, plusdeliveredandelapsed_ms. - ChangedStream tickers: the subscribe frame takes
ticker(one symbol or a list;tickerskeeps working) andselect("*"for every signal;fieldskeeps working). The ack addsdropped_signals,renamed_signalsandunsupported(crypto, FX and rate symbols). - FixedStream tickers: a symbol we do not track comes back in
not_foundand takes no slot of your cap. It used to ack as subscribed, take a slot and never update. - ChangedOne value or a comma list on four more filters:
asset_typeandexchangeon List tickers,kindon List signals (builtin,customis both) andstatuson List deliveries. - ChangedResend a delivery answers the new delivery's row, every field List deliveries and the test fire send. The five fields it answered before are among them, unchanged.
- DeprecatedTo 2027-01-12, page maxima follow one rule: market-wide results page at 100 rows, data for tickers you name at 1,000 points, account lists at 100, and batches stay at 50 tickers (Pagination). So the
limitmaximum drops to 100 on List events and Query news in list mode (from 1,000), on List signals (from 500) and on Get a signal (from 200). A larger value is clamped to the new max, as today, andnext_cursorpages the rest. Agroup_byrollup on List events or Query news keeps up to 1,000 groups and setstruncated: truepast them. List tickers and holdings were announced above. - DeprecatedTo 2027-01-12:
POST /v2/webhooks/{webhook}/enable(sendenabled: trueto Update a webhook) and the MCP tooltickerbot_enable_webhook(calltickerbot_update_webhookwithenabled: true); crypto, FX and rate symbols in the stream ack'sinvalid(readunsupported). From that date List universes withoutkindlists built-in and yours; sendkind=customto keep today's list.
- AddedQuery news reads each ticker an article mentions.
ticker,relevance,sentiment_scoreandsentiment(the fields Query events serves forkind=news) work inq,select,orderandgroup_by, one result per article per mention:q=ticker = 'NVDA' AND sentiment_score < -0.3is the articles negative about NVDA,group_by=tickerrolls up per ticker.tk, the older name ofticker, keeps working. Every article row carriesmentions(each ticker with its relevance and sentiment) andurl. - ChangedQuery news:
tickertakes one symbol or a comma list (up to 50;tickerskeeps working), and thequeryecho carriestickeras a list. A guessed sentiment parameter (sentiment,min_sentiment,sentiment_score_gte, …) answers a 400 naming theqthat does it. - AddedSubscribe to news,
POST /v2/news/subscribe: a webhook on new articles matching Query news's filters (search,ticker,universe,min_relevance,q). Each article fires once, delivered as the Query news row (or yourselect) with itsmentions, underevent: "news.fired". A subscription names at least one ofsearch,ticker,universeorq. - FixedQuery news pages whatever
selectleaves out. Aselectwithout theorderfield returnednext_cursor: nullon a full page; it now pages, and per-mention rows page without skipping an article's other mentions. - DeprecatedTo 2027-01-12, on the News family:
GETandPOST /v2/news/scan(use/v2/news, the same read) and theticker_datafield (readmentions).
- AddedEvery event has a stable
id,<kind>:<key>, on Query events and in every event-webhook delivery. It is built from the event's own key (an analyst action's vendor id, a filing's accession number, a dividend's ticker, ex-date, type and amount, …), so the same event has the same id on every read: use it to drop duplicates. It can be named inqandselect. - AddedList event kinds,
GET /v2/events/kinds: every kind with its fields (the namesq,selectandgroup_bytake when you ask for that kind alone), its filters, what itstsmeans, its id rule, and whether it is in the default stream and can be subscribed to. - AddedQuery events:
selectwithoutgroup_bypicks what each result carries, at the top level:id,ticker,tsandkindalways, thenpayload, the payload fields of the one kind named, and withjoin=statethe ticker's signals.dir=ascreads oldest first and pages forward;order=tsis accepted on a list and changes nothing. - Added
kind=signalreads custom signals and a list of signals.signaltakes one name or a comma list of up to 5, built-in or your own; a custom signal's flips are computed when you ask, from its yes/no value at each stored row, by the same rule as a built-in. News events carrypayload.relevance(0 to 1, how much the article is about that ticker), usable inq:relevance >= 0.8. - ChangedQuery events speaks
grainandticker.grainnames the grain (intervalkeeps working),tickertakes one symbol or a comma list (tickerskeeps working), andsymbol/symbolsanswer a 400 pointing toticker. Thequeryecho addsticker(a list),from,to,grainanddirbeside the older keys;_metaaddsgrainbesidestate_interval; signal payloads addgrainbesideinterval. List tickers documents its filter astickertoo;tickersstays accepted. - ChangedSubscribe to events takes one
qover the event's fields (with one kind, its payload fields by bare name) and the ticker's signals at fire time, as Query events does withjoin=state; a signal wins a name clash with a payload field (priceon insider,cikon filing; the event's own value ispayload->>'price'), as on Query events.selectpicks what each delivered event carries.kindandtickerare the documented names (kinds,tickersandevent_qkeep working; anevent_qis ANDed withq).estimate_revisioncan be subscribed to. The event webhook object addskindandticker, and itsqshows the whole filter, the AND of both halves on a webhook made with the older two. - AddedSubscribe to a signal is back,
POST /v2/signals/{signal}/subscribe, removed on 2026-11-10. It mirrors Get a signal:conditionin its grammar (none for a yes/no or custom signal),universe,selectand the delivery fields. - FixedVendor strings in event payloads are trimmed. An analyst name came back as
"Matthew Swanson ". - DeprecatedTo 2027-01-12, on the Events family: the
firmandactionparams (useq:firm ILIKE 'Morgan Stanley',action = 'downgrades') andmin_relevance(useq=relevance >= 0.8). Each is still accepted until then. See Deprecations.
- ChangedOne rule names the payload key of every response. Market rows you filter or search come back as
results: Run a scan (grouped too), List tickers, Get a signal, Query events and Query news. A list of things is named for them, keyed by symbol when the path names several tickers:bars,series(keyed by symbol always),signals,kinds,universes,webhooks,deliveries. One ticker's or ETF's record isdata: Get a ticker, coverage and holdings. One object fetched by id comes back at the top level. - AddedHoldings and coverage answer
data(their top-level fields are sent beside it), and both take a comma list of up to 50 withquery,countandnot_found, as Get a ticker does. - FixedPaging several tickers on History never skips or repeats a row.
next_cursoris one opaque token carrying each ticker's own position; pass it back ascursor. History's one shared position could skip a crypto bar between pages when stocks and crypto were paged together. Bars keeps itsnext_cursor(the oldest bar's time, a map of those per symbol on a list) until 2027-01-12, when a list's becomes one opaque token; Bars'cursortakes either form. - FixedHistory names the symbols it does not track. A comma list carries
not_found, and a read where no symbol is tracked is a404; an untracked symbol used to come back as an empty array, the same as a ticker with no rows in the window. History also echoes the request asquery. - AddedList tickers filters by
tickerandactive.ticker(one symbol or a comma list of up to 50) returns just those identity records, andactive=true|falsekeeps trading or delisted tickers. - Changed
select,grainandas_ofacross the Tickers family. Get a ticker takesselectto return just the signals you name (the full row stays the default) andgrainfor an as-of read; History takesselectandgrainforcolumnsandinterval, which keep working;as_ofis accepted whereverasofis. Subscribe to a ticker takesselectas the scan door does. Bars answersintervalsent as a query param with a 400: the bar width goes in the path (/v2/tickers/AAPL/bars/1d). Bars documentstoto end at a time;beforekeeps working. The coveragedataobject uses the new names: spans1d/1h/1m(the minute-tier roster moves intospans["1m"]),measured_signalswithsignalandgrain, andlive_row.signals/null_signals. - DeprecatedTo 2027-01-12, on the Tickers family: on History,
_meta.sourcesand thetransitions_onlyparam (useGET /v2/events?kind=signal); on Bars, a comma list'snext_cursorbecomes one opaque string at the cut-off (the per-symbol map goes); thelimitmaximum drops to 100 on List tickers (from 1,000) and to 1,000 on holdings (from 5,000; a larger value is clamped, as today); the top-level fields of the holdings read;order/diron Subscribe to a ticker (they do nothing with one ticker). Each is still sent or accepted until then. See Deprecations.
- Added
selectonPOST /v2/scanis the one projection param, as in SQL. Omitted, each result carries the default row plus every signal you used inqandorder(a custom signal as its own value). A list returns exactly those items,tickeralways included, and takes expressions withAS(price / sma_50 AS dist).*returns every signal. Aselectof aggregates alone (count(*), avg(rsi_14)) returns one summary row with nogroup_by; withgroup_by, each item must be an aggregate or a group key, and a 400 names the one that is neither.columns,fieldsandfullkeep working as before; the docs now showselectonly. - AddedEach grouped-scan row always carries its group keys (a custom
selectused to drop them).countis the rows in the page; for a total, scan withselect=count(*). - Changed
grainnames the grain of an as-of scan;intervalkeeps working.intervalnow means bar width, on bars only.as_ofis accepted as a spelling ofasof. As-of_metaaddsgrain,grain_requested,grain_reason,grains_present,frozen_signalsanddeprecated_signalsbeside the older keys, andnull_coverageaddssignalsbesidecolumns, on every read that sends them. Thequeryecho lists the params in their documented order with each one's effective value. GET /v2/scan stays a permanent alias of POST. - AddedA likely-but-wrong parameter name says what to use. On a scan,
where,query,filterandfilterspoint toq,order_bytoorder,next_cursortocursor,tickerstoq: ticker IN (…), andsignalsorcolumns=alltoselect=*. A cursor on a grouped scan says cursors apply to row scans. - ChangedAlerts deliver what a scan returns. Each delivered match carries the scan default row plus the signals the rule uses, or exactly the alert's
select, onPOST /v2/scan/subscribe. The webhook object addsselectanduniversebesidefieldsanduniverse_id, andorder/dirshow the sort in effect (market_cap/descunless you chose one) instead ofnull. A subscribe door answersasof,grain,group_by,having,limitandcursorwith a 400 that says an alert is live and per ticker, andchannel: "slack"with a 400 saying Slack delivery was retired (it was a501). - AddedList signals filters, searches and pages the whole catalog.
group,category,type,grain(stored history at that grain),asset_classandrefresheach take one value or a comma list and combine with AND;searchmatches the name and description;selectpicks the fields of each row.limitandcursornow page the whole list (your custom signals, then the built-ins A→Z) rather than only your custom signals; a call with nolimitstill returns everything. - AddedCatalog rows add
grains,asof_support,boolean_kindandrefreshbeside the fields they replace.grainsis keyed by stored grain, each{ history, since, coverage }({}means current value only).refreshsays how often a signal updates in plain keys (1m_4am_8pm_et,15m,1h,daily_after_close, …). Custom signals carrytype: boolean: they are always yes/no. The same row iscatalogon Get a signal. - AddedGet a signal takes
select,order,dirandgrain, and echoesquery.selectadds signals besidevalueon each match. Withoutorder, a yes/no signal lists tickers A→Z and any other signal sorts by its value in the direction the condition implies (<ascending,>descending; it was always descending).sort_bykeeps working (market_capisorder=market_cap&dir=desc),intervalkeeps working asgrain, and_metaaddsnull_coverageas on scan. - ChangedCreating or updating a custom signal returns the row at the top level, as webhooks and universes do. The update and delete paths are documented as
/v2/signals/{signal}; the URL is unchanged. - DeprecatedTo 2027-01-12, on the signals family:
include_active_sinceand theactive_since/days_livefields (useGET /v2/events?kind=signal&signal=X&transition=enter); the catalog'ssource; typejsonb(becomesobject); and a List signals call with nolimitreturning everything (after the cut-off it pages at a default limit). - DeprecatedTo 2027-01-12: the webhook object's
rule_id, which is alwaysnull. It is still sent until then. See Deprecations.
- ChangedEverything that needs a ticker now lives under it. History is
GET /v2/tickers/{ticker}/history(up to 50 tickers as a comma list in the path, on one aligned grid), bars areGET /v2/tickers/{ticker}/bars/{interval}and an ETF's holdings areGET /v2/tickers/{ticker}/holdings. The older spellings/v2/series,/v2/bars/{ticker}/{interval}and/v2/etf/{ticker}/holdingskeep working, permanently, with the same responses; they now carry aLinkheader naming the new path. The MCP tooltickerbot_get_seriesis nowtickerbot_get_history; calling the old name returns an error that names the new one. - Added
GET /v2/tickers/{ticker}/holdingscarries the ETF's sector mix too, assectors[].GET /v2/tickers/{ticker}/sectorsand/v2/etf/{ticker}/sectorskeep serving the sector mix alone, and the MCP tooltickerbot_get_etf_sectorsis folded intotickerbot_get_etf_holdings. - Added
GET /v2/signals/{signal}says what the signal is. Every response carriescatalog, the same objectGET /v2/signalslists for it. A non-yes/no signal read withoutconditionnow answers200with the catalog entry and anoteon adding a bound, where it used to answer400. - ChangedQuery events lists every kind under its
kindparam, with its own filters and a link to its payload: earnings, filings, dividends, splits, insider transactions, analyst actions, news, estimate revisions and signal firings.GET /v2/eventsitself is unchanged. - DeprecatedCreating a webhook with
POST /v2/webhooksis deprecated, with a cut-off of 2027-01-12. Create alerts withPOST /v2/scan/subscribe,POST /v2/tickers/{ticker}/subscribeorPOST /v2/events/subscribe: the same webhook object, with the fields oftriggerat the top of the body. Listing, updating and deleting stay on/v2/webhooks.GET /v2/analyst/eventsmoves to the same cut-off. See Deprecations. - RemovedSix old routes answer
410naming their replacement:GET /v2/tickers/{ticker}/history/{interval},GET /v2/signals/{signal}/{ticker}/history/{interval},GET /v2/tickers/{ticker}/events,GET /v2/signals/{signal}/{ticker}/events,POST /v2/signals/{signal}/subscribe(a signal alert isPOST /v2/scan/subscribewithqset to the signal) andPOST /v2/scan/explain.GET /v2/tickers/{ticker}/history?asof=was a second spelling ofGET /v2/tickers/{ticker}?asof=; that path is now the history read.
- Changed
at_52w_high,at_52w_low,at_20d_highandat_20d_lowdefinitions now name their window: the 52-week or 20-day high/low as of the previous session's close. That ishigh_52w_eod(and the other three) during the session, and the previous row'shigh_52win daily history. After the evening update the_eodcolumns include the day just closed, soprice >= high_52w_eodread outside the session no longer matches the flag; the flags themselves are unchanged. - Changed
premarket_change_pctandpremarket_priceare defined: the latest pre-market trade (04:00-09:30 ET), and its percent change from the previous regular-session close. Null before the session's first pre-market trade. Live and history follow the same rule.
- AddedThe latest split on the ticker row:
last_split_dateandlast_split_ratio. The ratio issplit_to / split_from, so4is a 4-for-1 and0.125a 1-for-8 reverse split.AAPLreads 2020-08-31 and4,NVDA2024-06-10 and10. They match the latest/v2/events?kind=splitrow. Null when no split is on record. - AddedInsider trading on the ticker row: the latest open-market trade and 90-day totals.
last_insider_trade_date,last_insider_trade_action(buyorsell) andlast_insider_trade_value(USD) describe the most recent day with an open-market purchase or sale (Form 4 codePorS; grants, option exercises and tax withholding do not count); a day with both counts as the side with the larger value.insider_buy_value_90d,insider_sell_value_90d,insider_net_value_90d(USD) andinsider_buyers_90d(distinct insiders buying) cover trades dated in the last 90 days.AAPLreads a sale of $823,720.64 on 2026-10-27 and net selling of $18.7M over 90 days. Null for a stock with no coded insider filings, as for the insider flags. Tryinsider_buyers_90d >= 2 AND insider_net_value_90d > 0. - AddedAll nine are in daily history from 2003-09-10, so they work in as-of scans and
/v2/series.
- FixedThe webhook docs and dashboard say what
realtimedoes. It is checked each time the data refreshes: about once a minute from 4 AM to 8 PM ET for stocks and ETFs, every minute around the clock for crypto and FX, and as each event lands for event webhooks; it fires when a ticker starts matching. The form had said it "fires the moment your query matches".hourlyis checked once an hour andnyse_openonce a day at the 9:30 AM ET open. The values are unchanged. - FixedCode examples with a quoted string paste into a shell. On the example queries page and in the Try it panel, a
qsuch assector = 'Technology'printed a curl whose quotes ended the shell string; the quote is now escaped, as on every other example.
- Fixed
/v2/events?join=statepinned tointerval=1manswers in seconds. One ticker over ten days took longer than the 30-second limit and returned503; hourly reads underautotook close to 30 seconds. Results are unchanged.
- AddedEvery bar from
GET /v2/barscarriesvwandn.vwis the bar's volume-weighted average price andnits trade count, on every interval from1sto1mo. A rolled-up bar (5mto30m,2h,4h,1w,1mo) sums the trade counts of the bars inside it and weights their average prices by volume; withadjusted=false,vwis un-adjusted like the other prices. Both arenullwhere the trades behind a bar were not recorded./v2/seriesalready served the same figures asvwapandtrades.
- Changed
dividend_yieldis null for companies that pay no dividend. It read0for them, live and in history, including companies that stopped paying. A yield of 0 claimed a dividend of nothing; null says there is none. A screen ondividend_yield = 0no longer matches non-payers: usedividend_yield IS NULL. Screens likedividend_yield > 0.03and thehigh_dividend_yieldflag return the same tickers as before. - Fixed
- Fixed
/v2/seriesrefusestickerandtickerswith different values.?ticker=NVDA&tickers=AMDused to return NVDA alone and drop AMD without saying so; it now returns400naming both. Send every symbol intickers. The same value in both is still accepted.
- ChangedA live-only column on an as-of scan says so. Minute and premarket columns (
min_low,above_premarket_highand the like) have no history, soPOST /v2/scanwithasofcan't read them. The 400 used to call them unknown and guess a neighbour (above_premarket_high→ "Did you mean above_yesterday_high?", a different signal); it now readsmin_low is live only, with no history, so it can't be used with asof. Remove it, or drop asof to read today's values.A name asked for in more than one place (q,fields,order) is listed once. - Changed"Did you mean" suggests fewer wrong names. A suggestion no longer swaps a name for its opposite (
52_week_high→52_week_low), no longer guesses short names by spelling (gap→vwap; it now offersgap_up/gap_pct), and a word match must share the most specific word of what you typed. Same400 invalid_queryenvelope. - ChangedAn unfinished comparison is named.
q=rsi_14 >used to return the raw database textsyntax error at or near ")", pointing at a parenthesis the API adds; it now readsrsi_14 > needs a value to compare to, for example rsi_14 > 10.Other syntax errors readq is not a valid where clause near ….
- Added
instrument_scopeon every signal inGET /v2/signalsand/docs/schema.json.companymeans the signal has values on operating companies and is null on ETFs and funds (fundamentals,sector, analyst targets, insider fields);fundmeans ETFs only (theetf_*fund facts);allmeans both. Use it to pick the columns that apply before screening a list of ETFs or a list of companies.
- Fixed
approaching_52w_highandapproaching_52w_lowmean the same thing in history as they do live. Live, a ticker is approaching its 52-week high when its price is within 5% of the high as of the previous close and not at it, it is trending up (above its 20-day and 50-day averages, or up on 3 of the last 5 days), and its volume is above the 10-day average. Daily history used the 5% band alone against a window that included the day itself, so it flagged days the live row never would (on 2026-11-05, over 100 tickers on below-average volume). Daily history is recomputed with the live rule; if you backtested on these flags, re-run it.
- Fixed
profitable,value_stockandhigh_marginfollow the figures they are defined on. They were set before the night's last update to net income, P/E and profit margin, so on companies that report once a year (most foreign listings) they described the earlier figures:TSM,ASMLandNVSreadprofitablefalse with net income in the tens of billions. They now follownet_income_loss,pe_ratioandprofit_margin_ttmlive, and daily history is corrected where the stored flag contradicted the same day's figures. - Fixed
earnings_publishedandearnings_approachingfollowdays_to_earnings. They were computed from the previous day's count, so a company that had just reported read published with 90 days to its next report, and one three days out read neither. Daily history is corrected where they disagreed with the storeddays_to_earnings. - FixedPrice-target history matches the consensus target. From 2025-03-31, daily
analyst_target_upside_pct,above_price_targetandbelow_price_targetwere built from single analysts' targets rather than the storedanalyst_consensus_target_price:TSLAon 2025-06-02 read 45.9% upside at a price above its consensus target. They are now recomputed from each day's price and consensus target. - FixedA scan that divides by zero returns a 400 that says how to fix it. A
qsuch as(session_open - previous_close) / previous_close >= 0.03returned a 500 when any row in scope held 0 in the divisor. It now returnsinvalid_querynaming the fix: wrap the divisor inNULLIF(previous_close, 0). - Fixed
pending_ipois false on stocks that trade. The IPO calendar keeps old entries for names that listed long ago, so 21 trading stocks readpending_ipotrue. A symbol with a daily bar is no longer pending, live and in daily history.
- Fixed
asset_classesinGET /v2/signalslists crypto, FX and rates wherever a signal has values for them. 149 signals, the indicators, flags and price fields among them, had said stocks only although crypto, FX and rate rows carry them (rsi_14,golden_crossandsma_50on all three). A signal whose only value on a class is a placeholder, such as zero volume averages on rate rows, is not listed for it. - Fixed
change_1w_pct,change_1m_pct,change_3m_pct,change_6m_pct,change_1y_pctandchange_ytd_pctreport a post-close cadence. They are computed after each close and hold through the next session;GET /v2/signalshad listed them as updating every minute. Thefrom_*distance fields do update every minute. - FixedTwelve flag definitions state the rule they use.
at_52w_highreadsprice >= high_52w_eod(the 52-week high as of the previous close),in_uptrendreadsprice > sma_50 AND sma_50 > sma_200,macd_above_signalreadsmacd_line > macd_signal, and likewise for the 20-day, Bollinger and earnings-week flags.
- FixedTwelve signals mean the same thing in history as they do live. Daily history computed
at_52w_high,at_52w_low,at_20d_high,at_20d_low,at_bollinger_upper,at_bollinger_lower,bollinger_squeeze,in_uptrend,in_downtrendandearnings_next_weekwith different rules from the live row, so as-of reads and backtests tested a different signal:in_uptrendmeant above the 20-, 50- and 200-day averages in history andprice > sma_50 AND sma_50 > sma_200live,bollinger_squeezeused a width under 0.10 instead of 0.04, andearnings_next_weekmeant a report within 7 days instead of 8 to 14. Every writer now uses the live rule, and daily history is being recomputed with it.macd_above_signalandmacd_below_signalnow followmacd_lineandmacd_signalevery minute; they changed only overnight, so during the session they could contradict them. If you backtested on these signals, re-run it.
- ChangedFourteen signals moved to the category that describes them.
GET /v2/signalsreports a newcategoryfor:price_asofandprice_source(nowtrades_quotes),float_effective_date(share_structure),sticky_breakout(highs_lows),momentum_up,momentum_down,momentum_strong_up,momentum_strong_downandpre_earnings_drift(performance),momentum_exhaustion_upandmomentum_exhaustion_down(oscillators),min_vwapandprev_day_vwap(bars), andfiscal_year_end_month(company). Theanalystgroup is labelled Analysts. Category is a description of the signal; no query changes. - FixedSignal definitions use the columns you can query. Sixteen definitions in
GET /v2/signalsand on each signal's page were written with internal names (close,close_prev,open_0930); they now readprice > sma_50,price > previous_close,(session_open - previous_close) / previous_close >= 0.03, so you can paste them intoq.at_supportandat_resistancestate the 14-period ATR they use,dividend_yieldsays it reads 0 for companies that pay none, and 22 fields that had no summary (the insider 90-day values, the fiscal-year fields, revenue breakdowns,leadership) have one.
- Added
history_by_intervalon every signal inGET /v2/signalsand/docs/schema.json. A signal can be stored at several intervals with different depth:above_sma_50is stored daily and hourly from 2003-11-18 and every minute from 2003-09-10 for the most liquid names.history_by_intervalgiveshistory,history_sinceandticker_scopefor each stored interval, keyed likeresolutions({}for a current-only column).historyandhistory_sincekeep their meaning, the daily figures. Theasoffield on each signal describes a read with a dateasof;resolutionslists the intervals a read with a timestampasofcan use. - FixedSignals stored only hourly and every minute list their intervals.
in_opening_range,above_opening_rangeandbelow_opening_rangereturnedresolutions: []and no history inGET /v2/signals; they now list["1m", "1h"], andhistoryandhistory_sincegive their hourly figures. In/docs/schema.json, signals of theflagsblock now carryhistory,history_sinceandhistory_by_intervallikefields.
- FixedAn as-of scan accepts the same functions a live scan does.
round(),sqrt(),extract(),current_dateandnow()inqreturned 400 "Unknown column" whenasofwas set. They now run, andnow()andcurrent_datemean theasofmoment (a bare date is that day's 4 PM ET close), solast_earnings_date >= now() - interval '7 days'withasof: "2026-10-01"returns the companies that reported in the week before October 1.
- Fixed
expires_aton webhook deliveries is epoch seconds.GET /v2/webhooks/{id}/deliveriesserved it as an object ({"_seconds": 1799665276, "_nanoseconds": 0}) while every other time on the row is epoch seconds; it now reads1799665276, the moment the row leaves the 90-day delivery history.
- FixedBank
cash_on_handis the SEC cash total: cash and due from banks plus interest-bearing deposits at other banks and the Fed. It held only cash and due from banks, a small part of a bank's cash (JPMas of 2026-09-30 reads $309.8 billion; it read $24.7 billion). Daily history is rewritten from 2009, each value taking effect on its SEC filing date.cash_ratiois now null for banks, which report no current liabilities. If you stored bank cash history, re-pull it.
- FixedWarrants and rights no longer show an EPS. They carried the issuing company's
diluted_eps_ttmbeside their own price, which made it read hundreds of times that price (CDROW-428.55 at $0.07) and is not earnings per warrant.diluted_eps_ttmanddividend_payout_ratioare now empty on every warrant and right, live and in daily history, asmarket_capalready is.
- ChangedSignal events are the flips of the stored state, so they match
/v2/series./v2/events?kind=signalreturns the moments a signal changed between two consecutive stored rows at one grain, the same rows as/v2/series?transitions_only=trueat thatinterval. It returned every span edge from five generations of the firing log, overlapping, so a daily signal such asabove_sma_200showed open/close flips on most trading days, rows with no price from older definitions, and on AAPL an exit on 2026-09-29 with nothing after it while the stock stayed above its 200-day average. AAPL now shows one exit on 2026-03-30 and one enter on 2026-03-31 since March, as/v2/seriesdoes. Re-read any signal history you stored from this endpoint. - Added
intervalonkind=signalpicks the grain:1m,1hor1d. The default is the coarsest grain the signal is stored at (above_sma_200andgolden_crossread daily flips,consolidating_15mminute flips); a grain the signal is not stored at is a400 interval_unavailablenaming its grains. Every flip carriesintervalin its payload. Daily flips are stamped at the session close of their date (16:00 ET; 23:59 UTC for crypto, FX and rates). A few live detectors with no stored state (vwap_cross_up,volume_burst_3x, …) keep their minute-exact log, reported as1m. - ChangedA bare date on signal events and signal spans is the home-market day. On
/v2/events?kind=signal, aYYYY-MM-DDinfromortois the ET day for stocks and ETFs and the UTC day for crypto, FX and rates, row by row when no ticker is named; on/v2/signals/{signal}/{ticker}/eventsit is the ET day. It meant the UTC day, so in winter the 19:00-20:00 ET hour landed on the next date. Summer dates return the same rows as before. - Fixed
kind=signal&ticker=AAPL&from=2026-10-30&to=2026-10-30&limit=500answers in under a second. It ran past the 30-second limit. A read withoutfromnow walks back in windows and may return a short page with anext_cursor; keep paging.
- Fixed
relative_volumeuses one baseline live and on past dates: today's volume over the mean daily volume of the 10 sessions before today. Live divided by a 10-day average that included today's volume so far, and daily history by a 30-day average, so a live scan and an as-of scan disagreed (AAPLon 2026-10-30 read 1.75 in history; it now reads 1.64). Intraday, today's volume is the volume so far. Daily history was rewritten on 2026-11-04.
- Fixed52-week highs and lows use the same window live and as-of: the 365 calendar days ending on the session. Daily history took the last 252 trading days, so a scan as of a past date could count a bar from 366 or more days back (
AAPLas of 2026-09-10 readlow_52w225.95 from 2025-09-10; it now reads 226.65 from 2025-09-11), and a stock that trades on few days could reach back more than a year. The live row ran one day wider. A stock listed less than a year ago still uses every bar since it listed.high_52w,low_52w, their dates,days_since_52w_high/low,from_52w_high_pct,from_52w_low_pct,position_in_52w_range_pctand theat_52w_*/approaching_52w_*booleans are rewritten across daily history (3.4 million days).position_in_52w_range_pctis 50 when the high equals the low; history had it null.
- Fixed
bollinger_widthas of a past date is a fraction of the middle band, as it is live. History held the band span in price units (bollinger_upper - bollinger_lower), soAAPLas of 2026-10-30 read17.605while live read0.0507, and an as-of scan such asbollinger_width < 0.06never matched. Every date now holds(bollinger_upper - bollinger_lower) / bollinger_middle, the documented formula. If you stored or thresholded historicalbollinger_width, re-pull it.
- FixedTrailing EPS in daily history is back, on a correct share count. v2.69.8 emptied 708,638 history days whose
diluted_eps_ttmread over 20 times the share price. Most of them were not reverse splits: history divided trailing net income by the share count copied from the quarterly statement, and many fourth-quarter statements carry a negative or tiny figure (Coca-Cola's 2011 Q4 read -6 million shares, soKOread -1,439 on 2012-02-21). Days before 2026-06-29 now divide by the statement's diluted share count only where it agrees with market cap over price, and by market cap over price otherwise, which puts every day on today's split basis; a day needs four quarters of net income.KOon 2012-02-21 reads 2.82 andJPMon 2015-02-19 reads 5.93. Days that sat on a share count from before a later split are corrected too (SBUXin 2012 read 1.67, now 0.85).revenue_per_share_ttmanddividend_payout_ratioare recomputed with it. Current values are unchanged: a reported EPS over 20 times the price is still not served.
- Added
fiscal_year_end_monthon the ticker row (GET /v2/tickers/{ticker}): the month the company's fiscal year ends,1to12, from its SEC filings.AAPLreads9,MSFT6,WMT1. Unlikefy_period_end, it is present before a company's first annual report and follows a change of fiscal year end. A 52/53-week year that ends in the first days of a month counts as the month before (TGT, year ending 2026-01-31 or 02-01, reads1). Refreshed nightly for new filers and in full every Saturday.
- Fixed
/v2/eventswith a crypto, FX or rate symbol and an equities-only kind answers400naming the asset class.ticker=X:BTCUSDreturned an empty200for dividends, splits and the other corporate kinds, which read as "nothing happened"; it now says the symbol is crypto or FX and points tokind=signal, as/v2/newsalready did. Event webhooks on those kinds refuse the same symbols at create. - Fixed
kind=signalserves crypto and FX symbols intickerstoo, and a single-ticker read is fast whatever the ticker.tickers=X:BTCUSD&kind=signalreturned400, andticker=X:BTCUSD&kind=signalwithout a date range could run past the 30-second limit.
- FixedA query that runs past the 30-second limit answers
503 unavailablewithRetry-Afteron every endpoint. Several routes, among them/v2/events?kind=signalwith a largelimit, answered500 internalinstead, and some put the raw database code inerror. A500now means a fault on our side; a503means retry the same request.
- Fixed
/v2/newswithfromandtoon the same date returns that day. A baretowas read as the start of that day, sofrom=2026-11-02&to=2026-11-02returned nothing and every baretoleft out the date it named. It now runs through the end of the day. - ChangedA bare date on news, analyst and estimate-revision events is the ET calendar day. On
/v2/newsand on/v2/eventswithkind=news,analystorestimate_revision, aYYYY-MM-DDinfromortonow means 00:00 to 24:00 ET. It meant the UTC day, so items published from 20:00 ET (19:00 ET in winter) to midnight landed on the next date; they now land on the date they were published in New York, all year. Timestamps are unchanged, and dated kinds (dividends, splits, earnings, insider) already used market dates. - Fixed
/v2/seriesrequests that mix stocks with crypto or FX use each ticker's own day. With a bare date at1mor1h, a stock in the same request asX:BTCUSDnow gets its ET day (through the 19:59 ET bar) and the crypto symbol its UTC day, as a stock alone has since v2.69.11.
- AddedComputed signals carry their formula.
GET /v2/signalsreturnsdefinitionon 49 computed numeric signals (moving averages, RSI, MACD, ATR, Bollinger bands, stochastics, ADX/DI, distances from moving averages, multi-period changes, average volumes, gap, short-term highs and lows), as it already did for booleans. Each signal's docs page shows it in its Facts table, along with the asset classes it covers.
- FixedA bare date on an intraday read covers that whole trading day. On
/v2/bars(1sthrough4h) and/v2/series(1m,1h), aYYYY-MM-DDinfrom,toorasoffor a stock or ETF now means the ET calendar day. It meant the UTC day, which matched the 04:00-20:00 ET session only while daylight saving was on: since 2026-11-01,from=2026-11-02&to=2026-11-02stopped at the 18:59 ET bar, and a read of 2026-11-03 started with the 19:00 ET hour of 11-02. Reads of summer dates return the same bars as before. Crypto and FX keep the UTC day, as do1dand longer intervals.
- FixedIntraday bars hold final prices. Minute bars from 2026-10-07 (and
5m/15m/30mbuilt from them) and hourly bars from 2026-07-13 (and2h/4h) held the preliminary same-day version of each bar, which rounds prices and includes minutes whose only trades were odd lots. They now hold the final bars, and the same repair covers earlier minute bars back to 2026-06-16 for less-traded symbols fetched on request. Each morning the previous session's minute and hourly bars are replaced with the final version, so bars for a session can change once overnight, and occasionally again up to three trading days later. If you stored intraday bars from these dates, re-pull them.
- FixedAnnual and quarterly statements on
interval=1yandinterval=1qshow figures as first reported. A fiscal year that a later 10-K restated carried the restated figures under its originalreporteddate, so a read as of that date saw numbers that were not yet public:MSFTfiscal 2016 readnet_income20,539M dated 2016-07-28, while the 10-K filed that day said 16,798M (the 20,539M came from its 2018 restatement). Each year now carries its original report's figures, from SEC filings. A line the original report did not state on the same basis is null for that year rather than restated (most oftenebitda). Quarterly rows follow the same rule (MSFT fiscal 2017 Q1operating_income6,715M restated, 5,225M as filed); a fiscal fourth quarter is the annual report's year minus the first three quarters as first reported, and ratios built on a restated quarter are null. The dailyrevenue_fy,net_income_fyandeps_diluted_fyhistory follows the annual figures. If you backtested on annual fundamentals, re-run it.
- FixedForeign companies' fundamentals are in US dollars or empty, never in their home currency. Some foreign filers carried their home-currency revenue as if it were dollars (SK hynix
revenue_ttmread 189 trillion, its won revenue; Telkom Indonesia 147 trillion rupiah; VinFast 67 trillion dong). Foreign common stock that reports to the SEC in another currency (Royal Bank of Canada, Canadian National, Enbridge and others) now takes its company totals from its annual SEC filings, converted at the Federal Reserve's New York noon rates as the listed ADRs have since v2.56.6, anddiluted_eps_ttmis that filing's diluted EPS per share, converted the same way (CNI5.42).reporting_currencynames the original currency andfundamentals_basisreadsannualon these rows. Where the Federal Reserve publishes no rate for the currency (Argentine peso, Chilean peso, Colombian peso, rupiah, tenge, dong and others), or a listed ADR files no financial figures with the SEC (SK hynix, Grupo Cibest, ICICI Bank), the company totals and the ratios built on them are empty rather than wrong. Daily history is included. - Fixed
diluted_eps_ttmis empty where it was impossibly large. On 217 small stocks the trailing EPS ran across reverse splits the vendor never adjusted, so it read many times the share price (WOK-51,993 at $1.16,DCX405,249 at $1.16). Those values are no longer served, anddividend_payout_ratio, which divides by them, is empty with them. Daily history had the same defect on 2,921 stocks from 2010 on (KOread 1.57 million in some years); those 708,638 days are empty too.
- Changed
consolidating_15mcompares the last 15 minutes with the 30-minute ATR. It is true when the high-low range of the last 15 minute bars is under 2.5 times the average true range of the last 30. It used to require a range under 1/30 of the spread of the last 30 closes, which almost never happens on a traded stock: it was false on every minute ofAAPL,MSFT,SPY,JPM,XOMandINTCchecked, and fired mostly on illiquid symbols with flat bars. Minute history back to 2003 and its events on/v2/events?kind=signalwere recomputed. If you used this flag, re-run it.
- Added
interval=1qon/v2/seriesserves the full financial statements. The income statement, balance sheet and cash flow columns ofinterval=1yare now quarterly columns too, under the same names and definitions:net_income,operating_income,ebitda,total_assets,total_equity,operating_cash_flow,capital_expendituresand 32 more. Income and cash flow columns cover the quarter, balance sheet columns are at quarter end, andfree_cash_flowis operating cash flow minus capital expenditures, as at1y. Per-share columns stay annual; quarterly EPS iseps.MSFT's four fiscal 2026 quarters add up to its annualrevenue(331,839M) andnet_income(133,749M).
- FixedIntraday history of 16 flags is filled in. The minute and hourly history never stored
consolidating_15m,range_break_15m_up,range_break_15m_down,repeated_test_of_high,repeated_test_of_low,pre_close_drift_upandpre_close_drift_down(minute),morning_strength,afternoon_drift_up,last_hour_rally,last_hour_selloff,hourly_reversal_bullishandhourly_reversal_bearish(hourly), orgolden_regime,death_regimeandearnings_today(both), sointerval=1mandinterval=1hreads, as-of scans andjoin=statereturned null (or, for the hour flags, false) for them: hourly rows for the hour flags, minute rows from 2026-07-14 to 2026-10-07, hourly regimes from 2026-06-15 to 2026-10-07. History is recomputed from minute bars with the v2.56.1 definitions back to 2003-09-10 (regimes from 2004-06-25, the first date with 200 sessions of daily closes). An hourly row of a stock with no minute bars that session keeps the hour flags null. - FixedOlder
repeated_test_of_high,repeated_test_of_lowandpre_close_drift_*history follows the corrected definitions. Minute history before 2026-06-15 still held values from the definitions v2.56.1 replaced, so the repeated-test flags read true on most stocks for most of the day. Every minute row before 2026-10-07 14:52 UTC is recomputed; backtests over these flags should be re-run. - Fixed
earnings_todayis false, not null, in intraday history for symbols with no earnings reports. Funds and other symbols without an earnings history read null on minute and hourly rows while live and daily reads said false (SPY on 2026-10-02). They now read false everywhere.
- FixedOlder hourly and minute history reads its percent fields in percent-points, stamped at the end of each bar. Rows written before mid-July 2026 held eleven percent fields 100 times too large:
change_1d_pct,gap_pct,from_open_pct,from_vwap_pct,from_52w_high_pct,from_52w_low_pctandfrom_sma_10/20/50/100/200_pct(AAPL at 2024-06-12 18:00Z readchange_1d_pct499.16; it now reads 4.99). The same rows were stamped at the start of their bar, so a read as of an instant could see up to one bar ahead; each now sits at the end of its bar, so an as-of read only sees prices printed by then. History from 2003 is corrected on/v2/series,/v2/scanandGET /v2/tickers/{ticker}?asof=. If you backtested on intraday history, re-run it.
- FixedMissing quarters are back on
GET /v2/series?interval=1q. Quarters the vendor did not serve on the day a stock's history was first loaded never came back:COSThad no rows for the quarters ended 2024-05-12 and 2025-02-16 and no revenue on 2024-09-01. 8,943 quarters were reloaded from the vendor, and 1,299 the vendor does not have were filled from the companies' SEC filings (ILMN's quarters ended 2017-04-02, 2017-07-02 and 2017-10-01: revenue 598M, 662M and 714M), each dated by the filing that first reported it. - FixedQuarters that held a full year of income now hold the quarter. For 69 stocks, a fiscal year's last quarter carried the whole year's revenue and income:
ILMN's quarter ended 2017-12-31 read revenue 3,371M and now reads 778M, andCAKE's ended 2024-12-31 read 4,459M and now reads 921M. Figures come from the companies' SEC filings; where none was filed, the quarter is empty. - ChangedDaily
revenue_ttmisnullon days when no four consecutive filed quarters are on record. It used to add up the four newest quarters on record even when one was missing, so it summed five quarters and read too high:Con 2021-05-10, with no quarter ended 2020-12-31 on record, now readsnull. The same holds forgross_profit_ttm,profit_margin_ttm,operating_margin_ttm,return_on_equity_ttmandreturn_on_assets_ttm;revenue_growth_yoy_pct,revenue_growth_yoy_quarterly_pctandearnings_growth_yoy_pctarenullwhen the year-ago quarter is missing. Daily history before 2026-06-29 was recomputed on the repaired quarters above. If you stored these columns before 2026-10-19, read them again.
- FixedOpening-range flags on hourly and minute rows follow the opening range.
in_opening_range,above_opening_rangeandbelow_opening_rangecompare a row'spricewith the high and low of the 09:30-09:44 ET minute bars. Oninterval=1hthey were wrong or empty on rows back to 2025, because the range came from the vendor's provisional bars or the rows had been moved by an hour:AAPLat 2026-08-20T15:00Z readbelow_opening_rangeat 317.14 against a range of 316.67-320.28, and now readsin_opening_range. Oninterval=1mthe rows written live from 2026-10-06 were wrong or empty on up to half of a day's minutes. Hourly history and minute history from 2026-10-06 were recomputed from the vendor's final bars, and each session is now recomputed the next morning. - FixedIntraday signal events match the minute series. For
in_opening_range,above_opening_range,below_opening_range,consolidating_15m,range_break_15m_up,range_break_15m_down,repeated_test_of_high,repeated_test_of_low,pre_close_drift_upandpre_close_drift_down, the events on/v2/events?kind=signaland/v2/signals/{signal}/{ticker}/eventswere a log written live and disagreed with the same flag oninterval=1mon about a third of minutes; some spans stayed open for weeks (MSFTrepeated_test_of_highfrom early October). An event is now each run of minutes where the flag is true on the minute series, starting and ending on whole minutes and never crossing a session. History was rebuilt for the stocks and days that already had these events, and each session is rebuilt the next morning. If you stored these events, read them again.
- FixedFundamentals of a stock our earnings and profile vendor stopped covering no longer freeze at their last value. Since 2026-10-10 the vendor serves nothing for
BXP,DOCandGETY, among others, and theirdiluted_eps_ttm,beta, margins andlast_reported_epskept their 2026-10-09 values with nothing saying so. After 14 straight nights without an answer,diluted_eps_ttm,revenue_ttm,gross_profit_ttm,profit_margin_ttm,operating_margin_ttmandlast_reported_epscome from the company's filed income statements, and the vendor's other fields (beta,forward_pe,book_value, the estimate and surprise fields) are empty. A figure the filings do not report reliably stays empty (DOCgross_profit_ttm). - ChangedFor these stocks,
last_reported_epsanddiluted_eps_ttmare GAAP diluted EPS. The vendor reported funds from operations for REITs, which reads higher:BXPlast_reported_epsreads 0.43 where it read 1.78.
- ChangedWebhook deliveries retry for about a day, and a webhook is disabled only after 72 hours with no successful delivery. Each delivery now retries 7 times over about 22 hours (30s, 2m, 10m, 1h, 3h, 6h, 12h). A webhook used to be disabled after 5 deliveries in a row ran out of retries; it now stays active until nothing has reached your endpoint for 72 hours, and we email you the first time a delivery fails for good, before that happens.
consecutive_failuresstill counts but no longer disables. Additive: no field is removed or renamed. - Added
POST /v2/webhooks/{id}/deliveries/{delivery_id}/redeliverresends a past delivery with its original body, to the webhook's current target. The resend carries the original delivery id inX-Tickerbot-Delivery-Id, so a receiver that dedupes on that header recognizes it. New on the webhook:last_success_at(when a delivery last reached your endpoint) andfailing_since(when the current failure streak began;nullwhile deliveries succeed).
- Fixed
GET /v2/newsrollups whoseselectnamesvolumesort byvolumeagain. v2.68.1 made a customselectsort by its last column, which also moved calls likeselect=tk, COUNT(*) AS volume, AVG(overall_sentiment_score) AS soffvolume. Aselectthat namesvolumesorts by it, as before v2.68.1; one that does not sorts by its last column.
- FixedThe news signal docs describe what is computed.
news_volumewas described as a count of the last 24 hours' articles; it is that count divided by the ticker's median daily count over the prior 30 days (1.0 = a typical day).news_volume_weighted_sentimentwas described with atanh(news_volume / 15)scale; the scale istanh(max(0, news_volume − 1) / 1.5), so a normal or quiet day reads 0. Values are unchanged. - FixedThe schema docs for
news_articlenow give the shape ofticker_data(per-companyrel,sent_score,sent_label) andtopics, and the/v2/newspage says how to get all 16 columns and whennext_cursoris null for a customselect.
- Fixed
GET /v2/newsrollups with a customselectsort by its last column. Agroup_bycall whoseselecthad novolumecolumn failed with400unlessorderwas passed, because the default sort was alwaysvolume. It now defaults to the lastselectitem's alias (as/v2/scanand/v2/eventsdo); when that item has no alias, the400asks fororder. - Fixed
cardinality()is allowed in queries.cardinality(tickers)counts the companies an article tags (e.g.q=cardinality(tickers) = 1for single-company articles). It applies on/v2/scan,/v2/newsand/v2/events.
- Added
min_relevanceonGET /v2/newsandGET /v2/events?kind=news. An article is tagged with every company it mentions, and each tag carries a relevance score from 0 to 1 (ticker_data.<TICKER>.rel). Passmin_relevance=0.8to keep only articles about the ticker you asked for and drop passing mentions. On/v2/newsit applies to theticker/tickers/universescope; on/v2/eventsit requireskind=newsalone. Omitted, both return what they returned before. - Fixed
/v2/events?kind=newscarries each ticker's own sentiment.payload.sentiment_scoreandpayload.sentimentheld the article's overall sentiment on every tagged ticker's row, while the docs described them as per-ticker. They now hold the article's sentiment toward that row's ticker (ticker_data.<TICKER>.sent_score/sent_label), null on articles that carry a label only. - FixedThe
/v2/eventsdocs saidtickerwins when bothtickerandtickersare passed. The API answers400for that combination, and the docs now say so.
- Fixed
/openapi.yamlloads in strict YAML parsers again, and declares the fields ofpredecessors[]andprior_symbols[]. Five column descriptions carried mis-encoded characters (−,–,—,≥) that made PyYAML reject the file; they read correctly now there and in/docs/schema.json. The ticker row schema now lists each earlier holder'sname,cik,composite_figi,tenure_startandtenure_end, and each earlier ticker'sticker,tenure_startandtenure_end; the MCP ticker and scan tools declare the same identity fields. Responses are unchanged.
- ChangedThe 2026-10-31 sunset moves to 2026-12-15. The six deprecated reads keep serving unchanged until then, and their
Sunsetheader now readsTue, 15 Dec 2026:GET /v2/tickers/{ticker}/history/{interval},GET /v2/tickers/{ticker}/history?asof=,GET /v2/signals/{signal}/{ticker}/history/{interval},GET /v2/tickers/{ticker}/events,GET /v2/analyst/eventsandGET /v2/signals/{signal}/{ticker}/events.minute_tieronGET /v2/tickers/{ticker}/coveragemoves to the same date. The replacements are unchanged; see Deprecations.
- AddedOpenAPI describes every response.
/openapi.yamlnow carries a200schema for every operation, built from the same field lists as the docs pages, nested fields and the per-kind event payloads included. A field has a type where we have confirmed it against live responses, and every typed field also allowsnull; the rest are listed with their description and no type, so a client generated from the spec never rejects a real response. - FixedMCP output schemas match what the tools return. Each tool's
outputSchemadescribed list fields such asresultsas arrays of strings, and typed fields that can benull(next_cursoron the last page) withoutnull, so a client that validates results against the schema would reject most of them. The schemas now carry the nested fields, typed where confirmed. Tool inputs and results are unchanged.
- FixedBars
next_cursorisnullon the last page.GET /v2/bars/{ticker}/{interval}setnext_cursorwhenever a page heldlimitbars, so a page that already held the last bars of afrom/towindow, or of the whole history, sent you to an empty page:AAPL1dfrom 2020-08-28 to 2020-09-02 withlimit=4returned all four sessions and a cursor. A cursor is now set only when at least one more bar remains, on single-symbol, bulk andasof+limitreads, as on every other paged endpoint. The bars returned are unchanged.
- FixedThe insider buy and sell signals read open-market trades.
insider_c_suite_buywas true when a top officer or director received a stock grant,insider_c_suite_sellwas never true, andinsider_cluster_buycounted grants. They now read SEC Form 4 open-market purchases and sales: buy and sell look back 7 days, and cluster buy needs two or more insiders buying within 14 days. Daily history back to 2003 was rebuilt the same way; AAPL had 1,080 buy days and now has 53. If you stored these signals before 2026-10-17, read them again. - ChangedThese three signals are
nullfor a stock with no transaction-coded insider filings on record, where they used to befalse. A filter likeNOT insider_c_suite_sellnow leaves those stocks out; useinsider_c_suite_sell IS NOT TRUEto keep them.
- FixedQuarterly rows are dated by the filing that first reported them. On
GET /v2/series?interval=1q, a fiscal year's last quarter carried the date of the next year's annual report, which repeats it, soreportedread about a year late and anasofread could not see that quarter for a year. AAPL's quarter ended 2022-09-24 now readsreported2022-10-28 (it read 2023-11-03), andinterval=1q&asof=2023-01-15ends with that quarter. Dates come from each company's SEC filings. - FixedQuarters of 53-week fiscal years are no longer dropped. A quarter ending in the first week of a calendar quarter (AAPL's ended 2023-07-01) shared a grid slot with the next one and one of the two was lost. Each quarter is now placed by its end date less 7 days, so AAPL
2023-Q2is the quarter ended 2023-07-01 (revenue 81,797M). - FixedDaily
revenue_ttmhistory takes in a new quarter on the day it was filed. Because of the late dates above, history added a fiscal year's last quarter 50 days after the period ended, not on its filing date: AAPL read 387,542M from 2022-10-28 to 2022-11-10 and now reads 394,328M from 2022-10-28, the day its 10-K was filed. The other columns built from the same quarters moved with it:gross_profit_ttm,profit_margin_ttm,operating_margin_ttm,return_on_equity_ttm,return_on_assets_ttmand the three growth columns.revenue_ttmis the sum of revenue over the four most recent fiscal quarters filed by that day, and equals the sum of those four rows oninterval=1q. - FixedSecond, minute and hourly bars from before a split are split-adjusted. Bars stored before a stock split stayed on the old basis, while daily bars were right:
VCIG's last 1m bar on 2026-07-30 read 0.3493, the unadjusted price, against a 5.2395 daily close after its 1-for-15 reverse split on 2026-08-24, andadjusted=falsedivided it a second time. It now reads 5.2395. Stored bars were re-adjusted for every stock that split, and a new split now re-adjusts that stock's1s,1mand1hbars the night it executes, so the5mto4hroll-ups follow. Bars you stored for these stocks before 2026-10-18 will not match a fresh read. - FixedSignal history moves onto the new share basis when a stock splits. Daily, hourly and minute signal values from before a split (
price, moving averages, VWAP, 52-week and 20-day highs and lows, volume averages and the other per-share and share-count columns) stayed on the old basis after the bars were adjusted:RUSHAon 2026-07-31 read apriceof 79.79 against a 53.19 close after its 3-for-2 split on 2026-09-01, andAPHhourly history before its 2-for-1 split on 2026-09-03 read twice the true price. Daily history was rebased for every stock with a split, and hourly and minute history for the 316 stocks that split between 2026-07-01 and 2026-10-12. A new split now rebases that stock's history the evening it executes. Scans,/v2/seriesandasofreads across a split date no longer jump by the split ratio. If you stored signal history for one of these stocks before 2026-10-12, read it again. - FixedPer-share history is on the current share basis for stocks that split after their statements were last updated. For 262 stocks, daily history before the split kept the old share count, so
diluted_eps_ttm,revenue_per_share_ttm,market_cap,pe_ratioanddividend_payout_ratiowere off by the split ratio:KLACon 2026-06-10, two days before its 10-for-1 split, read ape_ratioof 6.64,diluted_eps_ttmof 32.00 andmarket_capof $28.1B. It now reads 60.23, 3.55 and $281.3B, in line with the days after the split. History was rewritten on 2026-10-09. If you stored these fields for one of these stocks before that date, read them again. - FixedA date range on a symbol that passed between companies returns one company, the same on
/v2/seriesand the bars endpoint. Afrom/torange now means the company that held the symbol onto; when nobody held it that day, the last company that held it inside the range; with noto, today's holder. Series used to resolve ontoor, without it, onfrom, and returned no rows whentofell after the earlier company left:NLTXfrom 2008-01-01 to 2011-12-31 was empty and now returns Nile Therapeutics' 694 sessions. The bars endpoint always served today's holder, soBNYfor the first days of 2010 was the bank there and the BlackRock fund on series; both now return the fund (14.48 on 2010-01-04). A series read ofBNYwith onlyfrom=2005-01-03now returns the bank, as it did withfrom=2003-09-10. Reads withoutfrom/to, andasofreads, are unchanged. - FixedAn as-of read in the two weeks after a symbol changed hands names the company whose price it shows. An as-of read serves the latest daily row up to 14 days old, and in that window right after a handover it named today's company over the earlier company's last price:
WMon 2008-09-29 said Waste Management at Washington Mutual's 0.1604, andNYXon 2013-11-15 said NYIAX at NYSE Euronext's 45.29. The name,cikand tenure now come from the company that held the symbol on the served row's date, onGET /v2/tickers/{ticker}?asof=and/v2/scan. Past that window the read is still404. - FixedThree daily highs and lows cut by the daily-bar check are restored. The check that replaces a vendor daily high or low no minute bar reached (v2.52.4) judged the newest session the same evening, on the vendor's provisional minute bars, which can miss a real extreme.
JAGXon 2026-10-06 read a high of 7.187 and now reads 7.27;AMROon 2026-10-16 read a low of 3.95 and now reads 3.87.RUBIon 2026-09-17 was judged against minute bars already adjusted for its 3-for-2 split and read a high of 0.9599; it now reads 1.4399.atr_pctand the other indicators built on these bars are recomputed. A session's daily bar is now checked the next trading day, once the vendor's minute bars are final.
- Added
available_atandavailable_at_sourceon earnings events and oninterval=1qseries rows.available_atis when the market could first trade on the report: 9:30 AM ET on the report date for a pre-market release, else 9:30 AM ET of the next session; statements from the first session after filing.available_at_sourcesays what decided it (report_time,filing_dateorassumed). An event'stsis unchanged: it is still the report date. See When a report counts as public. - Changed
GET /v2/series?interval=1q&asof=shows a quarter only from itsavailable_at. It used to show a quarter from midnight UTC of its report date, so a post-market report was visible hours before it came out:ticker=AAPL&asof=2026-07-30T21:00:00Zreturned the June quarter, which Apple reported after that day's close. It now returns 2026-Q1 until 2026-07-31T13:30:00Z. A bare date still means that day's 4 PM ET close. - ChangedDaily earnings history was rewritten by availability. On every
interval=1drow,last_earnings_date,last_fiscal_quarter_end,last_reported_eps,last_eps_estimate,last_estimated_eps,last_earnings_surprise,last_earnings_surprise_pctandearnings_report_timenow come from the newest report public by that day's close, all from the same report. Before, a post-market report showed on its own report day, and for days after some reports the row mixed one report's date with another's numbers (AAPL on 2026-07-31 read the July 30 date with the April EPS). Re-pull these columns if you stored them before 2026-10-17.
- AddedEvery as-of read says when each ticker's history was last rewritten.
_meta.history_revised_atmaps each ticker in the response to the last time a job rewrote its stored history (split re-adjustments, corrections, re-keyed renames), ornullif none since tracking began on 2026-08-26. If the stamp is newer than your last pull of a ticker, re-pull that ticker; the rest are unchanged. It is on/v2/series,/v2/bars(every read, with or withoutasof),GET /v2/tickers/{ticker}?asof=(single and batch),/v2/scanand/v2/signals/{signal}withasof, and/v2/events?join=state. The newest session is provisional until the next morning's settled-close patch, which is not counted as a rewrite. See_metareference.
- Changed
ex_dividend_dateis the nearest announced ex-dividend date, or the most recent one once it passes with none announced. This holds on the ticker row and on every daily history row, as of that row's date. It used to be the furthest-out announced ex-date, so a fund that publishes a year of payout dates showed a date up to a year away (SHYG on 2025-09-15 read 2026-10-01; it now reads 2025-10-01). - FixedDaily history no longer shows an ex-dividend date before it was announced. Some dividends in the vendor data carry an announcement date years too early, and history trusted it:
MAINread 2021-10-28 on every day from 2002 to 2021. An announcement dated more than 1,100 days before its ex-date is now treated as known from the ex-date, andMAINon 2010-02-01 reads 2010-01-19.
- FixedA symbol that passed between companies names the earlier company on dates before the handover. Where today's holder had been recorded as holding a symbol from the start of our history, an as-of read before the takeover named today's company over the earlier company's prices:
WMon 2007-09-14 said Waste Management at Washington Mutual's 35.53. Each earlier holder now has its own record, soWMbefore 2008-09-27 is Washington Mutual,BUDbefore 2008-11-18 is Anheuser-Busch andNYXbefore 2013-11-13 is NYSE Euronext.symbol_reusedandpredecessors[]list them,tenure_starton today's holder is its first day after the handover, and a series read of today's holder no longer includes the earlier company's prices. Splits belong to the company that went through them, soUPSTno longer carries a 2012 split from before Upstart listed. - FixedDaily prices of delisted stocks are adjusted for their splits. These stocks had no split records, so a reverse split showed as a jump on the split day (
SSHread 0.295 then 8.19 across its 1-for-30 reverse split on 2017-01-13; it now reads 8.85 then 8.19). Split records were loaded for every stock with a split inside its stored history, and daily prices that disagreed with the split-adjusted series by more than 2% were re-adjusted. Bars you stored for these stocks before 2026-10-07 will not match a fresh read.
- Fixed
from_open_pct,from_vwap_pctandchange_ytd_pctof a symbol's earlier holder are in percent-points. v2.63.1 corrected the other_pctcolumns on these as-of reads and left these three 100 times too small (RPT on 2009-06-01:from_open_pct0.0799 for a 9.01 open and 9.73 close). All three now match the prices on/v2/scan,/v2/seriesandGET /v2/tickers/{ticker}?asof=.
- FixedA sub-hour bars read of one date is answered for that date.
GET /v2/bars/{ticker}/{interval}remembered an empty load per symbol: once a window with nothing in it (a weekend, a date before the first session) came back empty, other dates of the same symbol answeredno_datafor up to 30 minutes. Each window is now judged on its own. - FixedConcurrent sub-hour reads of different windows for one symbol each get their bars. Two requests for the same symbol at once shared a single load even when they asked about different dates, and the second could come back empty with
no_data. A request now shares a load only when that load covers its window. - FixedA narrow sub-hour window loads its trading sessions whole. A first request for part of a past day (
from=…T15:00Z&to=…T16:00Z) stored only that hour, and a later request for the whole day was answered with the hour, labelledcovered. A first load now stores each finished 04:00–20:00 ET session it touches in full; the response is still bounded by the window you asked for.
- AddedA Shell in the dashboard Workbench. Type any API call and see the response:
tickers get NVDA,signals get above_sma_200 --sort_by market_cap,bars get AAPL 1d --limit 30, or a bareWHEREclause such asshort_float_pct > 20 AND earnings_this_week, which runs as a scan. Every command maps one-to-one onto a/v2request, its flags are the request's parameters, and each response comes with the curl that reproduces it from your code.helplists every command, and pasted/v2paths and curl commands run as-is. Under the Tickers, Signals, Scan and Webhooks tabs it opens with Inspect, which runs the request behind what the tab is showing. Calls typed in the Shell count toward the Free monthly quota, like calls made with a key. - ChangedTry-it runs count toward the Free monthly quota when you are signed in. Every call you compose now counts the same way, whether it comes from your code with a key, from MCP, or from a Try-it panel on these pages. Signed-out Try-it is unchanged: it runs on a per-IP budget of 30 calls an hour and 60 a day. Free-plan responses to a signed-in Try-it carry the
X-Quota-*headers, and a run past the quota returns the same402 monthly_quota_exceededyour code would get. - ChangedThe dashboard's tool tabs are capped at 10,000 calls a day per account. Tickers, Signals, Scan and Webhooks refresh on their own and do not count toward the monthly quota; the cap only stops a script from driving the dashboard instead of the API. Past it the dashboard returns
429 dashboard_daily_cap, resetting at 00:00 UTC. Programs use an API key.
- FixedPercent columns of a symbol's earlier holder are in percent-points. On an as-of read of a company that held a symbol before today's holder,
change_1d_pct,change_1w_pct,from_sma_20_pct,position_in_52w_range_pctand the other_pctcolumns came back 100 times too large on/v2/scan(RPT on 2009-06-01: 799 for a 7.99% day). They now match the company's closes. The same read onGET /v2/tickers/{ticker}?asof=now names those columns as every other read does (change_1d_pct, notday_change_pct). - Fixed
GET /v2/seriesserves an earlier holder's rows with the default columns, and atinterval=1w. A read withoutcolumns(ticker=BLD&asof=2003-09-15) returned400 invalid_query;interval=1wreturned no rows. Both now return the holder's rows.
- Added
kind=filingonGET /v2/events, and as a webhook trigger. One event per annual or quarterly report a company files with the SEC — 10-K, 20-F, 40-F, 10-Q — dated the filing day, withform,accession,period_end,fiscal_year,fiscal_period,available_at(9:30 AM ET of the next session, the instant point-in-time reads should key on),cikand the EDGARurl. Filings from 2011 on. It joins the default stream as the sixth corporate kind;POST /v2/events/subscribeand webhooktrigger.kindsaccept it, firing the morning after the filing lands. What is in the filing stays on Series (interval=1y/1q); this is that it happened.
- AddedRevenue breakdown history on the Series fiscal grids.
revenue_by_segment,revenue_by_geographyandrevenue_by_productare now columns atGET /v2/series?interval=1yandinterval=1q: one list per fiscal period, back to filings from 2011, in the same element shape as the ticker row's latest-period columns, besiderevenueand the other statement columns, withasof,from/toand cursor paging as on every Series read._meta.sourcesnames themfilings. - Removed
GET /v2/tickers/{ticker}/segments(v2.58.0) is gone; it served the same history in a second shape. Read the three columns on Series instead:/v2/series?ticker=AAPL&interval=1y&columns=revenue,revenue_by_segment.
- AddedAnnual financial statements:
GET /v2/series?interval=1y. One row per fiscal year from fiscal 2010 on, in the same shape asinterval=1q: income statement, balance sheet and cash flow columns (revenue,net_income,eps_diluted,operating_cash_flow,free_cash_flow,total_assetsand 40 more; the list is on Series). Each year carriesreported, the filing date of the original 10-K, 20-F or 40-F, andavailable_at, 9:30 AM ET of the next session: underasofa year appears only from then, so a backtest never sees a year before it was public.ticker=AAPL&interval=1y&columns=revenue,net_incomereturns fiscal 2025 revenue of $416.16B and net income of $112.01B.
- Added
revenue_by_segment,revenue_by_geographyandrevenue_by_producton the ticker row: the latest published revenue breakdown for each axis, as a list of{name, revenue, revenue_usd, share, period_end, fiscal_year, fiscal_period, currency}. Each is the newest fiscal period (annual or quarterly) whose members sum to the company's total revenue within 0.5%; null when no breakdown has been published for that axis. Select infieldsor test withjsonb_array_length(revenue_by_segment) > 0. Backed byGET /v2/tickers/{ticker}/segments(see v2.58.0) for the full history back to ~2011.
- ChangedUpdate cadence on every signal page now comes from the job that writes the signal. The catalog, the per-signal pages,
/docs/schema.jsonand/docs/refresh-cadenceread one derived label. The one-minute bucket islive_1m_4am_8pm_et, rendered "1 min · 4 AM–8 PM ET" (for a few hours on 2026-10-08 it was served aslive_1m_extended_hours): it waslive_1m_market_hours, rendered "1 min · mkt hrs", for 262 signals that are rewritten every minute from 4 AM to 8 PM ET, pre-market and after-hours included. A once-a-day signal shows its clock ("daily · 8 AM ET"). Signals that never change after listing (sector,industry,asset_class) showstatic. A field that crypto and FX carry too, such asprice, says so: "1 min · 4 AM–8 PM ET · crypto and FX 24/7". - FixedWrong cadences corrected.
golden_cross,death_cross,bollinger_squeeze, theearnings_*andestimate_*flags, the market-cap buckets and the other nightly flags were labelled as one-minute signals on the ticker row; they are post-close daily. Therecent_*analyst-action booleans were labelled every 15 minutes; they refresh hourly, 24/7.golden_regimeanddeath_regimewere labelled post-close daily; they are one-minute.earnings_todayis set daily at 4:01 AM ET. - Changed
/docs/refresh-cadence: the as_of paragraph now says thatas_ofminusprice_asofmeasures the row's age only on fair-value-priced rows; on a trade-, quote-, bar- or previous-close-priced row,price_asofis that source's own time.
- Fixed
full=trueworks on past-dated scans again. A scan withasofandfull=trueon the daily grain (a bare date, orinterval=1d) returned400 invalid_querynaming an internal column,__full_row__, instead of the whole row. It now returns every signal for each match, as documented. A misspelled signal inqunderfull=trueis still a 400 that names it, andfull=truewithinterval=1mor1his still400 interval_unavailable.
- FixedRenamed companies appear in past-dated scans before their rename. A scan leaves out a symbol before its listing date, and for 74 renamed companies the listing date on today's symbol is the rename day, so their whole earlier history was missing from as-of scans and signal lists while the single as-of read served it. Cara Therapeutics (
CARA, nowTVRD) was absent from every scan before 2025-04-16. Those rows now appear under the symbol the company traded as, withcurrent_tickernaming today's symbol.
- AddedRevenue by segment, geography and product line.
GET /v2/tickers/{ticker}/segmentsreturns a company's revenue split by business segment, by geography and by product or service line, for each fiscal year (10-K, 20-F, 40-F) or fiscal quarter (10-Q), read from the company's own SEC filings and named with its own labels. A breakdown is shown only when its lines add up to the company's total revenue within 0.5%; when they do not, the period says so and why, with no numbers. Amounts are in the reporting currency and in US dollars at the Federal Reserve's average exchange rate for the period. Withasof, you get only the periods that had been filed by then, for the company that held the symbol then. Loaded now: the latest annual and quarterly filing of every listed company over $2B market cap. Earlier periods (from 2011) and smaller companies will follow. See /docs/endpoints/tickers/segments.
- ChangedPast-dated scans list each company under the symbol it traded under that day. A company that changed its symbol used to appear in an as-of scan under today's symbol: a 2020 scan listed Facebook as
META, a 2004 scan listed Charles Schwab asSCHW.POST /v2/scanandGET /v2/signals/{signal}withasofnow returnFBandSCHfor those rows, so a scan row and the as-of read of the same symbol (GET /v2/tickers/FB?asof=2020-06-01) agree. Inq,tickermatches the symbol at the date, and auniversenaming the old symbol finds the company. Measured at mid-month dates from 2003 to 2026, 342 renamed symbols of 322 companies are affected, a median of 58 rows per date (29 in mid-2005, 121 in mid-2020, 185 in mid-2024). Live reads and scans withoutasofare unchanged. - Added
current_tickeron as-of rows. Every as-of scan and signal row, anddataonGET /v2/tickers/{ticker}?asof=, carriescurrent_ticker: the symbol the company's history is filed under today, which is the one/v2/seriesand the bars endpoint take. It equalstickerexcept on a renamed company's rows before the rename. On the single read,data.tickeris now the symbol at the date (META?asof=2020-06-01returnsFBthere), while the top-leveltickeris still the symbol you asked for.GET /v2/tickers/FB?asof=2020-06-01now serves Meta's stored row for that date, namingMETAin_meta.identity.stored_under.
- FixedForeign companies listed in the US report fundamentals in US dollars. For the 379 exchange-listed ADRs (TSM, BABA, SONY, NVO, ASML…), company totals now come from their annual SEC filings (20-F, 40-F or 10-K), converted to dollars at the Federal Reserve's New York noon rates: revenue and profit at the fiscal year's average rate, balance-sheet lines at the rate on the fiscal year's last day. Before, some of these columns carried the company's home-currency figure as if it were dollars (TSM
revenue_ttmread 4.4 trillion, its Taiwan-dollar revenue). Covered:revenue_ttm,gross_profit_ttm,revenues,net_income_loss,operating_income_loss,assets,liabilities,equity,cash_on_hand,cash_and_short_term_investments,long_term_debt, the margins and returns built from them, andprice_to_sales,pe_ratioandprice_to_bookfrom the market cap. These companies report once a year, so the_ttmfields carry the latest fiscal year. Per-share fields (diluted_eps_ttm,book_value,revenue_per_share_ttm) are blank on ADRs until we have a reliable count of ordinary shares per ADR. 335 of the 379 have SEC data in a currency we can convert; the rest stay blank. History follows the same rule, each fiscal year taking effect on the day its report was filed.
- FixedOnly a company's primary listing carries a market cap. Notes and baby bonds, warrants, rights, SPAC units, tangible equity units and operating-partnership units carried their own price times the issuing company's share count as
market_cap, along withenterprise_value,pe_ratioand the other valuation ratios built on it, and the cap-size flags. A Comcast note (CCZ) read $231.9B on 2024-01-22 and Ford notes near $100B. These fields are now null on those securities, live and in history, as they are for preferred shares since v2.52.5. Partnership, trust and LLC units that are the company's equity (for example MNR, TXO, PRT) keep their market cap.
- ChangedSecond-source news articles now carry a summary and a per-ticker sentiment label. On articles from the second news source (Motley Fool, Zacks, GlobeNewswire and others),
summaryis now the publisher's description, and each ticker'ssent_labelinticker_datais the vendor's call for that company:Bullish,BearishorNeutral. The label is categorical and unscored, sosent_scorestays null on these articles and the score-based metrics are unchanged.searchnow matches text in their summaries. Articles already stored were rewritten the same way. - AddedNews history from the second source goes back to 2016. Articles from the second source before 2026-08-30 are being loaded back to the vendor's start (2016-06-22; the feed is sparse before late 2020), and
recent_news_count/highly_relevant_news_counthistory is recomputed to include them.
- Fixed
session_openand the fields built on it use the real open. From 09:30 ET,session_open,from_open_pct,above_session_open,gap_filled_today,gap_upandgap_downread a pre-market trade as the open until the official opening price reached us, a median of 17 minutes after the bell. They now use the same open asgap_pct: the first regular-session minute's open, then the official open once it arrives, fixed for the rest of the day. Before 09:30 they are unchanged. Hourly and minute history is being rewritten to the same rule.
- Fixed
gap_pctis set by the open and stays set. The gap is the move from the previous close to today's open. Before 09:30 ET,gap_pctis the live gap: the current price against the previous close, updated every minute. From 09:30 ET it is the official open against the previous close, and it does not change for the rest of the day. It used to show a stale pre-market figure until a median of 17 minutes after the open (for example AAPL on 2026-10-07 read 0.10% until 09:46 ET; the gap was 1.00%). For about the first 15 minutes after the open, until the official opening price reaches us,gap_pctuses the first regular-session minute's open, then switches once to the official open. Hourly and minute history is being rewritten to the same rule.
- Fixed
repeated_test_of_highandrepeated_test_of_lowfollow their definition. They counted every minute that closed within 0.1% of the session high (or low), starting at 4 a.m., so they were true on most stocks for most of the day, often both at once. A test now counts once each time the price comes back within 0.1% of the regular-session high (or low) after moving away from it, during regular hours only; three tests make the flag true; once the price breaks through and holds beyond the old level for five minutes, the flag is false for the rest of the session. History is being recomputed. - FixedTime-of-day flags hold for the rest of the session.
morning_strength,afternoon_drift_up,last_hour_rally,last_hour_selloff,pre_close_drift_upandpre_close_drift_downwere true for a single minute, so a read at any other time never saw them. Each is now decided when its window ends —morning_strengthat 11:30 ET, the others at 16:00 ET — and stays set until the next session starts. They also fired up to 15 minutes late; they now run on our own clock.last_hour_rallyandlast_hour_selloffcompare the 16:00 close with the 15:00 close (±0.5%), as documented. History is being recomputed. - Fixed
hourly_reversal_bullishandhourly_reversal_bearishcompare whole hours. They compared two single minutes an hour apart. They now compare each completed regular-session hour (09:30–10:30, …, 15:30–16:00) with the hour before, and stay set through the following hour. History is being recomputed. - Fixed
earnings_todaynames today's reporters all day. It was set at 20:05 ET for the session that had just ended, so the next trading day showed the previous day's reporters until the evening. It is now set at 04:01 ET from the earnings calendar.
- ChangedOne
_metavocabulary on every as-of read. The shared keys —interval,interval_requested,interval_reason,blended,intervals_present,sources,frozen_fields,coverage_gap,identity,scope,deprecated_columnsand the deprecated aliasresolution— are now defined once, at /docs/asof#meta, and every as-of read emits them in that order before its own keys. No key was added, renamed or removed; the order of keys inside_metamay differ from before on scan, signals, series and eventsjoin=state. Each endpoint page now lists only the keys that are its own. - Added
_metaon bars.GET /v2/bars/{ticker}/{interval}declares an optional_metablock, present when the read has something to disclose, with the same shared keys.
- Fixed
as_ofon point-in-time series and bars.GET /v2/seriesandGET /v2/bars/{ticker}/{interval}withasofnow stampas_ofwith the instant you asked for, as every other as-of read does and as the envelope documents. They used to stamp the server clock. - FixedBars cursor pages under
asofstay bounded by the instant. Followingnext_cursorfrom an as-of bars page used to dropasof, so a cursor newer than the instant served bars after it, and a page on a symbol a different company held at the instant left that company's history. Both bounds now apply and the holder is carried across pages. - Added
_meta.frozen_fieldson grouped as-of scans.POST /v2/scanwithasofandgroup_bynow discloses the seven identity signals served from current state, as row-mode scans already did —group_by=sectorgroups by today's sector. - Changed
coverage_gapsays when it is still being measured. A whole-market scan or signal read pinned to1m/1hmeasures its coverage in the background; the first request at a new instant used to report no gap at all, which read as full coverage. It now returnscoverage_gapwithpending: true, null counts and a note; a repeat a few seconds later carries the count. - FixedPoint-in-time series no longer suggest
from. An intradayasofon the1h/1mgrid carried_meta.from_defaultedand a note to "passfrom", a parameter that read refuses with a 400. Both are gone underasof; the grid's look-back is documented on the parameter. - Fixed
last_availableon an as-of ticker 404 follows the instant rule.GET /v2/tickers/{ticker}?asof=<instant on day D>that finds no state named a last-available date that could be D itself; it is now at most D−1, the same rule every state read applies, and so is the retired-company state read behind it.
- FixedIntraday-only signals in the events replay.
join=stateon/v2/eventsaccepted only the daily table's signal names at every grain, so an hourly- or minute-only signal (morning_strength,top_gainer) was an "unknown column" even withinterval=1hor1mpinned. The names now follow the grain, as on scan: any signal stored at the pinned grain is valid, and underautoany daily or hourly signal is. A signal the chosen grain does not store is a400 interval_unavailablenaming the grains that carry it, including the pin to use for a minute-only signal underauto.
- AddedBulk bars page per symbol. A comma-list request to
/v2/bars/{tickers}/{interval}now returnsnext_cursorkeyed by symbol, likecoverage:limitcaps each symbol, a symbol with more bars in the window thanlimitcarries its own token, and a symbol served in full carriesnull. Before this, a bulk request for afrom/towindow wider thanlimitreturned the newestlimitbars per symbol with no cursor, so a client could not tell that a symbol had been cut. Continue a cut symbol with a single-symbol request passing its token ascursor. Additive: no existing field changed.
- FixedPre-split prices corrected on 141 stocks. When a split was recorded before its effective date, our daily bars were never re-adjusted on the real day, so prices before the split read at the wrong scale (APH and IESC at twice the true price, RUSHA, RUSHB, SF and XRX at 1.5 times). Daily bars for those stocks were re-adjusted on 2026-10-06 and match the vendor's adjusted prices. Our split records are now reconciled with the vendor every night: a split the vendor withdraws or re-dates is no longer applied, and
/v2/events?kind=splitno longer serves it. If you pulled daily bars for these stocks before 2026-10-06, pull them again. - FixedPre-market and after-hours history for symbols late in the alphabet. From about 2026-09-01 the five-minute extended-hours sweep stopped partway through the market, so symbols after roughly
MIUYF(MSFT, NVDA, TSLA and WMT among them) got nopremarket_price,premarket_change_pct,afterhours_priceorafterhours_change_pctin daily and hourly history. The sweep was fixed on 2026-10-06 and those days are being refilled.
- Added
price_sourceon the live ticker row (GET /v2/tickers/{ticker}, scanfields, the stream): where the row's price came from.fair_value,minute_bar,trade,quote,day_barorprevious_closeon stocks and ETFs;exchange_rateorminute_baron crypto, FX and metals;published_rateon rates. Refresh cadence has the table of sources, in the order we try them, with whatprice_asofreads for each. - Changed
price_asofis the time of the data behind the price. On a row priced from a trade, a quote or a one-minute bar, and on crypto and FX rows, it is that trade, quote or bar's own time. From 2026-10-06 16:08 UTC until this release those rows carried the time we fetched the price, so a price that had not moved for an hour read as current. A fair-value price keeps the time we fetched it, which is within the last minute. - ChangedWhen a stock's newest one-minute bar is newer than its last trade or quote,
priceis that bar's close.price_sourcereadsminute_baron those rows. - FixedOn crypto and FX rows, when the exchange-rate quote missed a minute,
pricecould keep the previous one-minute bar's close instead of moving to the newest bar. It now moves.
- FixedIn daily history, the sessions from 2026-08-03 to 2026-09-04 held the 9:00 PM ET live price instead of the settled close, so
price,change_1d_pct,session_high,session_lowand the indicators computed from them were off on most of those sessions (AAPL on 2026-09-04 read a change of −2.14% instead of −2.51%). Those sessions are being recomputed from the settled daily bars. Sessions from 2026-09-08 on already match the bars. - FixedIn daily history,
dividend_yielddivided a dividend stated on its own day's share count by a price stated on today's, so on any stock that later split the yield read too high by the split ratio (AAPL on 2018-06-29 read 6.31% instead of 1.58%), andhigh_dividend_yieldwas set on that value.dividend_payout_ratiohad the same mismatch against earnings per share (AAPL read 0.95 before its 2020 split and 0.24 after it). Both are being rewritten for every stock that split.dividendanddividend_ttmkeep the amount paid on that day's share count.
- FixedA renamed company no longer carries a previous company's history. Where a company took over a ticker another company had used before, stitching its history across the rename also moved the earlier company's rows onto today's symbol:
ELTX(Elicio, which traded asANGNfrom 2021) carried Angeion Corporation's 2003 to 2012ANGNhistory. 25 symbols were affected,ELTX,CPAYandSPRUamong them. Those rows are back under the old symbol with their own holder.tenure_starton the current symbol is the company's real first day (ELTX2021-02-05,CPAY2010-12-15), an as-of read before that day answers 404 on the current symbol, and the old symbol at that date returns the earlier company (ANGN?asof=2010-01-04is Angeion).FBno longer holds a second copy of Meta's 2012 to 2022 daily history, andprior_symbolsonMETAendsFBon 2022-06-09. If you pulled history for a renamed company before 2026-10-06, pull it again. - FixedSignal runs carry the minute they started and ended. From early August to 2026-10-04, runs of
above_sma_10,above_sma_20,above_sma_50andabove_sma_200on/v2/events?kind=signalstarted and ended at 20:00 UTC whatever minute the cross happened, because a nightly job replaced the minute-level runs with daily ones. It no longer does, and the minute-level runs for that period are restored for the roughly 1,240 tickers we hold minute history for (AAPL crossed above its 50-day average at 2026-09-25T16:04Z). Other tickers keep the 20:00 UTC times for that period. - Fixed
gap_upandgap_downin daily history follow the 3% rule. Until 2026-09-18 the nightly write of daily history flagged gaps from 0.5%, so an as-of read or/v2/seriesat1dshowedgap_upon a day that opened 1% higher (NVDA on 2026-09-04, a 1.16% gap). The write was corrected that day and daily history was rewritten from 2003 on: both flags agree withgap_pcton every daily row. The live row was not affected. - Fixed
volume_todayandday_dollar_volumein daily history hold the settled volume. The daily row was saved with the evening's provisional volume and never picked up the vendor's overnight revision, so an as-of read or/v2/seriesat1dreturned 63% to 90% of the day's final volume on liquid names while/v2/bars/{ticker}/1dwas right. Daily history from 2026-06-05 was rewritten from the settled bars on 2026-09-18, and the morning settlement step has carried volume since. - AddedTwelve signals have daily history.
earnings_beat_streak,earnings_next_week,recent_upgrade,recent_downgrade,insider_cluster_buyandinsider_c_suite_buyfrom 2003,above_price_targetandbelow_price_targetfrom 2016,high_betaandlow_betafrom 2004, andhigh_volume_alertandvolume_change_vs_avgfrom 2003. Each used to start on the day we first computed it:earnings_beat_streakon AAPL began in August 2026 and now reads 8 on 2015-01-06. Filled on 2026-09-18;history_sinceinGET /v2/signalsgives each start date. - Added
recent_news_count,highly_relevant_news_countandnews_sentiment_volatilityare on the ticker row and in daily history from 2015. Over the trailing 7 days: the articles that mention the ticker, those that score its relevance at 0.6 or higher, and the spread of sentiment across the relevant ones (null under three). Refreshed every 15 minutes. They returned on 2026-09-19; v2.2.0 had removed them. - FixedDuring the trading session on 2026-10-06,
price_asofon stocks priced from fair value read about 16 minutes old whilepricewas current, because v2.52.7 stamped it from a vendor time that lags the price. From 15:57 UTC that dayprice_asofon those rows is current again. A staleness check such asprice_asof < now() - interval '15 minutes'no longer flags actively traded names. - FixedOn crypto and FX rows,
priceandprice_asofno longer step back within a minute. Two updates wrote the row each minute, one from the minute bar and one from the fresher exchange-rate quote, so a caller pollingX:BTCUSDcould see the older price return. The quote now stays whenever it is the newer of the two. - FixedA
qthat compares a list signal with a quoted word, such asleadership = 'x', answers400 invalid_querywith the test to use instead (IS NOT NULLorjsonb_array_length(...) > 0). It used to answer500 internal.
- FixedA reported cash balance of exactly zero is now checked against the SEC filing. Our balance-sheet source sometimes reports zero cash for a company that filed real cash with the SEC (Devon Energy, DVN, read $0 for its June 2026 quarter; its 10-Q shows $950M). A zero is now kept only when the company's own SEC filing also shows zero for that quarter, as it does for Antero Resources; otherwise
cash_on_hand,cash_ratioandcash_and_short_term_investmentsare null for that quarter, on the ticker row and in daily history.
- FixedIn daily history,
dividend_dateheld the date the dividend was paid, while the live ticker row holds the ex-dividend date, so an as-of read and a live read of the same field disagreed (KO on 2026-06-10 read 2026-04-01, the pay date, instead of 2026-03-13, the ex-date). Daily history is being rewritten to the ex-date over the coming nights, matching the live row.
- AddedDaily history for analyst, estimate, short-volume and IPO fields. These ticker-row fields are now saved to daily history every night from 2026-10-06, so as-of reads and
/v2/seriesreturn them: the analyst consensus (rating counts, consensus target with its low and high, consensus rating and score), the latest analyst rating (last_rating_date,last_rating_action,last_rating_firm),recent_target_raiseandrecent_target_lower,last_eps_estimateandnext_eps_estimate,short_volume_ratioandshort_volume_spike,dilution_30dandbuyback_30d, andpending_ipo,ipo_dateandipo_in_7d. Earlier dates are being filled over the coming nights wherever we hold the past:last_eps_estimatefor every date, the latest analyst rating from October 2024, the analyst consensus from 30 March 2025, short volume from February 2024.historyandhistory_sinceinGET /v2/signalssay how far back each field goes. - Added
latest_news_at: the publish time of the newest news article that mentions the ticker. Daily history starts 2026-10-06. - Added
ex_dividend_dateis back on the ticker row: the ex-dividend date of the most recently declared dividend, which is the upcoming ex-date once a dividend has been declared. Its daily history is being rebuilt. - Changed
from_open_pct,from_vwap_pct,ratios_asofandwell_coveredare now served from daily history. They were recorded but held back for review. - AddedThe opening-range flags (
in_opening_range,above_opening_range,below_opening_range) are saved to minute history from 2026-10-06, as they already are to hourly history. They are not part of daily history.
- AddedPre-market and after-hours history back to 2003.
premarket_price,premarket_change_pct,afterhours_priceandafterhours_change_pctare in daily, hourly and minute history for every stock we hold minute bars for, from 2003-09-10 on, so as-of reads and/v2/seriesreturn them.premarket_priceis the opening price of the first trade between 04:00 and 09:29 ET, compared with the previous regular-session close;afterhours_priceis the closing price of the last trade between 16:00 and 19:59 ET, compared with that day's 16:00 close. - FixedDaily, hourly and minute history from 2026-09-21 to 2026-10-02 is missing
premarket_priceandafterhours_price(the percent changes are present), because the live update was erasing the prices before the day was saved. The cause is fixed (see v2.52.2) and those days are being refilled over the next two nights.
- ChangedA query that runs out of time now answers
503 unavailablewithRetry-After, not500 internal. Reads that run a database query (scan, series, ticker reads, events, news) stop after 30 seconds. Until now that stop came back as500 internalwith "Query failed.", which reads as a server bug. It now comes back as503 unavailablewith aRetry-Afterheader and a message saying the query ran past the limit; the same answer applies when the database cannot take a connection. The first read of a historical date is the slow one, so retrying the same request usually answers in seconds. Clients that already retry on 5xx need no change. - FixedA
qthat compares a number column with a quoted word, such asprice > 'DOCN', now answers400 invalid_querynaming the value and suggesting the comparison that was probably meant (ticker = 'DOCN'). It used to answer500 internal. - Added
leadershipon the ticker row: the company's current C-suite as a list of{name, title}(CEO, President, CFO, COO, CTO, other Chief officers, General Counsel), from the officers' SEC Forms 3, 4 and 5 and refreshed daily. It is empty for companies that file none, such as foreign private issuers and funds. Select it infieldsor test it inq(for examplejsonb_array_length(leadership) > 0); it cannot be used inorder.
- Added
total_debt: total debt from the latest reported balance sheet, in USD. It is short-term borrowings and the current portion of long-term debt, plus long-term debt including capital-lease obligations. Daily history back to 2009 is filling over the next few nights; each value takes effect on the date the company filed it, ascash_on_handdoes.
- Fixed
price_asofnow shows how old a fair-value price is. For stocks priced from the vendor's fair value,price_asofcarried the time we fetched the market snapshot, so every such row looked current to the second even when the stock had not traded or been requoted for hours. It now carries the vendor's own update time for that stock: a quiet name after hours reads the time of its last trade or quote. Reverted on 2026-10-06 (v2.53.3): a fair-value price carries the time we fetched it. - Fixed
price_asofis populated on crypto and FX rows (the time of the vendor's exchange-rate quote) and on rates rows (the date of the published observation). It was null on all of them.
- Added
GET /v2/tickers/{ticker}/coveragecarrieslive_row: how many published columns the ticker's current row has, how many are populated, and which are null. An OTC-traded ADR such asTCEHYlists its missing fundamentals there. - Changed
GET /v2/healthno longer returnslast_errorin itslogandstreamblocks. The route needs no key, and the text was raw server output. The error counts andlast_error_atare unchanged, so a monitor can still see that an error happened and when.
- FixedSignal runs no longer end on weekends. The nightly job that keeps signal runs current closed every long-running run on Saturdays (and market holidays) although the signal was still true, so
/v2/signals/{signal}/{ticker}/eventsand/v2/events?kind=signalshowed an exit that never happened: AAPL above its 200-day average since 2026-03-31 read as ending on 2026-09-19. Runs closed this way are being reopened. Webhooks were not affected; they evaluate the live row. - FixedPreferred shares no longer carry a market cap in daily history. It was computed with the issuer's common share count, so Bank of America's series L preferred read $9.57 trillion on 2024-01-22 and ranked above Apple in historical scans ordered by
market_cap.market_cap,enterprise_valueand the price-based valuation ratios are null on preferred shares in history, as they already are on the live row. - Fixed
delisted_utcis null on every active symbol. A new security listed on a reused symbol showed the previous holder's delisting date (PCPC, an ETF listed in September 2026, read 2022-12-15), so filtering out delisted names also removed 21 live securities.
- FixedA daily high or low that no trade reached is now corrected from the minute bars. Our vendor's daily aggregate occasionally carries a high or low that none of that day's minute bars reaches: NVDA on 2024-06-10 read a high of 195.95 where every minute bar tops out at 123.10, which lifted
atr_pctfrom about 3.8 to 8.1 for two weeks and set the 52-week high to 195.95 for a year. Such a high or low is now replaced by the regular-session high or low of the minute bars, at ingest and across stored history; the open and close are never changed, andatr_pct, the 52-week high and low and the other indicators built on daily bars are recomputed for the year after each corrected day. NVDA 2024-06-10 and MSFT 2005-10-27 are corrected now; the sweep of the rest of history runs over the next days.
- FixedDaily history recomputes a whole row when the closing price settles. Each morning we replace the previous session's provisional closing price with the settled one. Until now only
price,change_1d_pctand the volume fields followed; the moving averages,from_sma_*_pct, RSI, MACD, ATR, 52-week and 20-day highs and lows, the multi-period changes and the cross and regime flags kept the values computed from the provisional price. They are now recomputed in the same morning step, and sessions since 2026-09-05 are being recomputed over the next few nights. - FixedDaily history is being refilled on the nights a failed vendor request had blanked
diluted_eps_ttm,beta,book_valueand the other company-overview fields, orlast_reported_epsand the last earnings surprise. A blank is filled only where the values on both sides of it are identical and the gap is at most ten trading days, so no value is inferred across a change. Blanks whose neighbouring values differ stay blank.
- Fixed
high_52w_date,low_52w_date,last_20d_high_date,last_20d_low_date,days_since_52w_highanddays_since_52w_lowcarry values on the live row. They were null on most tickers, including AAPL, MSFT and TSLA, because the minute update only carried a date forward when the row already had one. - Fixed
premarket_priceandafterhours_pricehold the extended-hours prices on the live row. The minute update wrote null over them every minute, so they read null whilepremarket_change_pctwas populated. - Fixed
analyst_countonestimate_revisionevents is populated from the 2026-10-05 evening refresh on. It was null on every event because we read the wrong vendor field. Earlier events keep it null: the vendor keeps no history of analyst counts. - Fixed
long_term_debt(now including capital-lease obligations) andnet_cash_flow_continuingfill again from reported statements, starting with the next nightly fundamentals run. Both were null on every row. - Changed
wages,benefits_costs_expensesandincome_tax_expense_benefit_deferredare no longer listed on the ticker row. Our financial-statements source does not report these lines, so they were null on every row. - AddedOTC-traded ADRs. About 2,067 foreign companies that trade over the counter as ADRs, among them Tencent (
TCEHY), DiDi (DIDIY), Nestlé (NSRGY) and Roche (RHHBY), are rows like any other stock since 2026-09-29, withexchange=OTC Markets(MICOTCM). They are priced once a day from the previous session's close:price_asofis that close, andday_change,change_1d_pct,volume_todayand the session fields are null on them all day. Most fundamentals are null, because these companies do not file US financial statements.
- Fixed
dividend_payout_rationow agrees withdiluted_eps_ttmon every row. It was blank on 86 large caps that had both earnings and a dividend (Visa, Costco and Stryker among them) and out of date on others, because it was computed before that night's earnings update. It is recomputed whenever earnings per share changes. - FixedA failed nightly request to our fundamentals vendor no longer blanks the fields it would have refreshed. On any given night up to about 150 large caps lost
diluted_eps_ttm,beta,book_value,forward_peand the other company-overview fields, orlast_reported_epsand the last earnings surprise, until a later night's request succeeded. Those fields now keep their previous values, and the affected tickers were refreshed on 2026-10-05. Daily history for the nights in question still has the gaps.
- Added
cash_and_short_term_investments: cash and cash equivalents plus short-term investments, in USD, from the latest reported balance sheet, on the ticker row and in daily history. When a balance sheet reports no short-term investments the value equalscash_on_hand. History uses the same filing dates ascash_on_handand is being filled back to 2009 over the next few nights.
- FixedSub-hour bars stay current through the session for every symbol. The newest
1mbar onGET /v2/bars/{ticker}/{interval}is the last minute that has closed, and5m/15m/30mfollow it. For a stock or ETF whose bars are loaded on first request, the bars used to stop at that first request and stay there until the next trading day, on the latest-bars read and onasof,beforeandfrom/toreads reaching into the same day. Symbols that were already current trailed by up to ten minutes; they follow the last closed minute too. - FixedThe last bar of an
asofread on5m,15m,30m,2hand4hcarries its whole period. It was built from the first minute (or hour) of the bar only, so its high, low, close and volume differed from the same bar read withfrom/to: AAPL5matasof=2026-09-15T15:00:00Zreturned volume 72,352 for the 14:55 bar where the bar is 523,570.1m,1h,1d,1wand1mowere never affected. - FixedPaging bars with
next_cursororbefore, andasofat an instant off the interval's grid, answer in about 0.2 s. Each such call used to take 2 to 6 s. - FixedThe Get bars notes said there was no unadjusted option and no session filter. Both exist and are documented on the same page:
adjusted=falseandsession=regular.
- Fixed
cash_on_handis back, as cash and cash equivalents in USD. It comes from the latest reported balance sheet and does not include short-term investments. Daily history is being filled back to 2009 over the next few nights; in history each value takes effect on the day the company filed it with the SEC, and when only a later re-filing date is known, 90 days after the quarter ended, so a backtest never sees a figure before it was public. - Added
cash_ratio: cash and cash equivalents divided by current liabilities, from the same balance sheet, on the ticker row and in daily history (same filing dates). Null when current liabilities are not reported.
- AddedA second news source: Motley Fool, Zacks and GlobeNewswire articles.
/v2/newsnow also carries articles from a second news feed, refreshed every 15 minutes and filled back to 2026-08-30. On names covered mostly by press releases this adds the editorial layer: since 2026-08-30, TOST goes from 10 articles to 21 and ASTS from 51 to 75. A release both sources carry appears once. The response shape is unchanged. - ChangedThese articles carry no sentiment score:
overall_sentiment_score,overall_sentiment_label,summaryand each ticker'ssent_score/sent_labelinticker_dataare null on them. Their per-ticker relevance (rel) is 1 divided by the number of companies the article is about, so a single-company article counts towardhighly_relevant_news_countandnews_volume. Every article counts towardrecent_news_count;news_volume_weighted_sentimentandnews_sentiment_volatilityaverage only the articles that carry a score.
- Fixed
cash_on_handis null until it is re-sourced. The column carried the cash ratio (cash and equivalents divided by current liabilities) rounded down to a whole number, not a dollar amount, so most companies read 0. Treat any value you stored from it as invalid. It is now null on the ticker row and in daily history, and will return as cash and equivalents in USD from reported balance sheets, dated from each filing.
- Fixed
/v2/seriesserves a renamed company's whole history under its current symbol. An unboundedGET /v2/series?ticker=METAstarted on 2022-06-09, the day the symbol changed, while/v2/bars/META/1dand/v2/tickers/META/coverageserved the 2012 IPO onward: series floored each ticker at its tenancy on that one symbol, bars at the company's earliest tenancy across every symbol it has held. Both now use the same floor, soMETA,FISV,SCHW,HOG,VYX,TXNMand every other re-keyed rename read from their first day on series too. Reported by a customer building a backtester. - Fixed
prior_symbolsonGET /v2/tickers/{ticker}no longer lists other funds from the same trust. A ProShares ETF listedSKK,GGOV,ZBIOandOILUas its own earlier tickers because every ProShares fund files under one registrant. Identity across symbols iscomposite_figifirst; a registrantcikcounts only where it is not shared across several listed securities. - Fixed
GET /v2/tickers/{ticker}?asof=&interval=1don a date a previous holder owned the symbol answers with that holder (held_at_asof, its tenure window, its retired state) instead of404 interval_unavailable. The explicit-grain path returned its own 404 before the tenure resolution that theinterval=autopath already ran.
- Changed
interval=autoon as-of reads now blends grains instead of picking one. At an intradayasof, every signal comes from its freshest grain at or before the instant: minute, then hourly, then the last closed daily session. A scan or signal match set no longer drops to the daily close for every signal because one of them is daily-only, and no ticker is left out because a finer grain lacks it._meta.blended,_meta.intervals_presentand_meta.sourcessay what contributed;_meta.intervalis the finest grain present. Applies to/v2/scanand/v2/signals/{signal}(/v2/tickers/{ticker}already worked this way). On/v2/eventswithjoin=state,autoblends hourly and daily on rows and uses daily ongroup_by, and_meta.state_intervalreadsauto. To keep a single-grain cross-section, pininterval(1m,1hor1d): that read is unchanged, and it is also the fastest, since it reads one grain instead of three. A bare-dateasofis unchanged. - FixedPaging
/v2/scanby a numericordercolumn at the hourly or minute grain could repeat the last row of one page at the top of the next. The cursor now compares at the precision the response carried.
- FixedAn intraday
asofno longer sees that day's close. At a timestamp on day D, daily-grain values (indicators likersi_14andsma_50, fundamentals, and the daily price a scan falls back to) came from D's own daily row, which holds D's close: hours after the moment asked about. They now come from the last session that had closed, D-1, the rule barsasofalready used. Applies to/v2/tickers/{ticker},/v2/scan,/v2/signals/{signal},/v2/seriesat1d/1w, and/v2/eventswithjoin=state(an event on day D joins the state through D-1). A bareYYYY-MM-DDstill means that day's close. If you ran backtests on intradayasofreads, re-run them. - Fixed
next_cursoron as-of reads.GET /v2/serieswithasofreturnsnext_cursor: null: a point read is one row per ticker, all on one page. It used to return a cursor thatasofthen refused with a 400.GET /v2/bars/{ticker}/{interval}withasofandlimitnow accepts its ownnext_cursoralongsideasof, so following the cursor with the same parameters keeps paging back instead of returning 400.asofwithbeforeis still a 400.
- FixedAs-of scans serve the identity columns again.
sector,industry,asset_type,name,exchange,asset_classandticker_categorywork infields,q,orderandgroup_byonPOST /v2/scanwithasof. Since 2026-08-24 they were refused with 400 (not available at interval=1d, thenUnknown column). - Removed
momentumis no longer a signal. It left the catalog on 2026-09-09 and its history was dropped on 2026-09-18; a query that names it returns 400Unknown column momentum.momentum_up/momentum_downand themomentum_strong_*flags are unchanged.
- Fixed
/docs/schema.jsonnow says which columns/v2/seriesserves.available_at_intervalshad read["1d"]for every field, including the 75 current-only columns (identity, analyst consensus, estimates, themin_*session fields) that live on the ticker row and have no stored history, so a validator built on the file sent names series rejects. It now lists the stored tiers only (1m/1h/1d/1w), is empty for current-only columns, and each field carriesseries: true|false,historyandhistory_since. Abarsblock listsopen,high,low,close,volume,vwapandtrades, which series serves at every interval; they are not spec signals and had been absent. - ChangedThe as-of page no longer describes the forward-only vendor columns (
forward_pe,short_interest,days_to_cover,float_shares,institutions_pct,insiders_pct) as awaiting a backfill. Their vendors publish a current value only; they have been held since 2026-06-05 and a snapshot before that returnsnull.
- FixedEvery as-of ticker read now states which holder it resolved to.
GET /v2/tickers/{ticker}?asof=carriedheld_at_asof, the tenure window, the identifiers and_meta.identityonly when a different company held the symbol on that date. When today's holder also held it then, the row shipped the frozenname/asset_type/exchangeand nothing to show the date fell inside its tenure —SHLD?asof=2026-01-02named the Global X ETF with nocomposite_figi, notenure_startand no_meta.identity, which read as labelled with today's holder rather than resolved to it. Now every as-of read carriesheld_at_asof: true,tenure_start/tenure_end(start inclusive, end exclusive,nullwhile open),cik,composite_figi,share_class_figiand_meta.identitywithresolved_by: "ticker_tenure". Reads that resolve to a previous holder are unchanged. Additive: no field is removed or renamed.
- AddedTrailing dividend and payout ratio.
dividend_ttmis the dividends per share paid over the last twelve months — the most recent regular payments at the company's own frequency plus any specials, adjusted for splits — anddividend_payout_ratiois that overdiluted_eps_ttm(null when EPS is zero, negative or missing). On the ticker row and in daily history. - AddedWhen a company last reported.
last_earnings_dateandlast_fiscal_quarter_endgive the date of the most recent earnings report and the quarter it covered. - AddedProjected earnings dates. Where no published calendar date exists,
earnings_dateis projected from the company's own history (last year's report for the same quarter, same weekday) andearnings_date_projectedistrue. Backtested on 26,320 reports: 87% within a week, median error one day. - AddedETF fund facts.
etf_expense_ratio,etf_net_assets,etf_inception_date,etf_leveraged,etf_turnoverandetf_dividend_yieldon each ETF's ticker row, in the newfund_factscategory. - Added
ratios_asof— the date of the financial data behindpe_ratio,price_to_book,ev_to_ebitdaand the other valuation ratios. It was visible as the unpublished_ratios_dateuntil 2026-09-23; it is now published under this name. - Fixed
next_eps_estimate_low/_high,next_revenue_estimateand the revision counts now describe the same upcoming fiscal quarter asnext_eps_estimate. They had come from the fiscal-year estimate, so the range sat far above the point estimate (META 6.39 against 27.93–40.31). Companies whose calendar date was missing no longer carry the quarter they had already reported. - Fixed
currencyis populated on analyst events. It was null on events since 2026-05-12; the history is filled. - FixedNews coverage. The news feed had been missing articles its source indexed late — about 90% of the feed since late August, and two gaps in the spring. The missing days are refilled (400k+ articles) and
recent_news_countand the other news metrics are recomputed. - ChangedWhen a row's price is the previous session's close (no trade yet today),
price_asofis that close's time instead of null, andday_changeandabove_yesterday_closeare null instead of 0 / false.
- AddedEstimate revisions on the event timeline.
GET /v2/events?kind=estimate_revision(opt-in) returns each move in the consensus EPS estimate for a fiscal quarter or year:fiscal_date,horizon,old_estimate,new_estimate,change_pct,direction,analyst_count, all first-class inq. History starts 2026-08-22, when we began keeping every consensus change. The default stream is unchanged. See /docs/endpoints/events/query#estimate-revisions.
- FixedA sub-hour bars page is never answered from an incomplete store.
GET /v2/bars/{ticker}/{interval}loads bars for a symbol on its first sub-hour request and serves them from the store after that. Under load, a first request could come backcount: 0withcoverage: "not_in_minute_tier", orasofcould return a months-old bar labelledcovered, and a retry seconds later was right. Now a request waits for the load, concurrent requests for the same symbol share it, and if the bars still cannot be loaded the response is503 unavailablewithRetry-After— never an empty or stale 200. - Changed
coverageon bars iscoveredorno_data.not_in_minute_tieris no longer emitted: it named an internal precompute roster that has no bearing on what bars you can read. - ChangedA
from/towindow on a sub-hour interval fills the whole window on first load (up to a year), not only its last 31 days. - Deprecated
minute_tieronGET /v2/tickers/{ticker}/coverage— same internal roster; still returned unchanged until 2026-10-31, then removed. Sub-hour bars are available for every active symbol regardless of it.
- ChangedOne answer for a wrong column name, everywhere. Every place a column name enters the API —
/v2/scanq,fieldsandorder(live andasof),/v2/seriescolumns,/v2/signals/{signal}, custom signal expressions, and theq/columnsof a webhook or subscription — now checks the name against the published catalog the same way and says the same thing when it is wrong:400 invalid_query(404 unknown_signalon the signals path) withUnknown column <name>. It is not a published signal. Did you mean <closest published names>? Catalog: /v2/signals. Before, the wording depended on which check caught it first, and the as-of read saidnot available at interval=1dabout names that exist at no interval. - ChangedRenamed-only columns from the 2026-09-07 percent cutover are served under their old names.
atr_percent,free_float_percent,percent_insiders,percent_institutions,short_percent_of_floatandbollinger_pct_b— the six whose values did not change — resolve toatr_pct,free_float_pct,insiders_pct,institutions_pct,short_float_pctandbollinger_banywhere a column is named, and the response says so in_meta.deprecated_columns(requested,use,note). A rename that did not change a value should never have broken a job. The 22 rescaled columns (fraction → percent) stay a 400 with the rename sentence: serving those under the old name would hand back the wrong unit. A custom signal saved with an old name is stored with the new one. - ChangedA column the catalog does not publish is refused in a
/v2/scanpredicate as it already was infields— the same rule on both, not only on what comes back.
- ChangedContext refs in
qaccept any catalog symbol.<ticker>.<column>on/v2/scanand webhookqwas limited to 15 ETFs (SPY, QQQ, IWM, DIA and the SPDR sectors); it now takes any symbol/v2/tickersreturns — an equity (aapl.day_change_pct > 0), a rate (r:sofr.close > 4), a crypto or FX pair (x:btcusd.day_change_pct). The cap of five refs per query is gone; the 4,000-character limit onqis the only bound. Dotted symbols (BRK.B) cannot be qualifiers. - Added
400 unknown_context_tickernames a qualifier that is not in the catalog, checked before the query runs. A typo used to come back as a raw SQL error.400 context_ticker_ambiguouscovers a qualifier that case-folds to two symbols. - ChangedTicker ids may be up to 64 characters and contain underscores, ahead of the universe rows (
U:big_tech) landing in the catalog.
- Fixed
GET /v2/signals/{signal}and thesignaltrigger accept timestamp, date and string signals. Theconditiongrammar was numeric-only and every non-boolean signal was parsed as a number, so the 52 timestamp, date and string signals the catalog lists (price_asof,earnings_date,asset_class, …) returned 400 whatever you sent.conditionis now typed like the signal:<2026-09-22T19:00:00Zfor a timestamp,>=2026-10-01for a date,=ETFor!=ETFfor a string; numerics are unchanged. The 400 for a missing or mis-shaped condition names the signal's type and the shape it takes. Same grammar on the live read, the as-of read,POST /v2/signals/{signal}/subscribeandPOST /v2/webhookswith asignaltrigger. Relative windows ("older than 15 minutes") stay a/v2/scanquery.
- Added
price_asofon the live ticker row (GET /v2/tickers/{ticker}, scan columns, the stream): when the market data behind the row's price was produced, as an ISO timestamp.as_ofis when we answered;as_ofminusprice_asofis the age of the row's live signals. A row whoseprice_asofis old is priced from data that old; How price is set says what it is for each source, and theprice_asofpage has the scan that lists them. On the live row; the as-of reads disclose their row time in_meta.sources.price_asofis the time of whichever source produced the price. - RemovedThe ticker row returns only the columns the catalog lists.
GET /v2/tickers/{ticker}wasSELECT *and returned 46 columns/v2/signalsnever advertised. Gone from the live row: 22 internal fields (every_-prefixed name:_last_trade_timestamp,_repaint_state,_data_quality,_branding_icon_src,_min_timestamp, …) and 23 dead ones (bid,ask,bid_size,ask_size,market,ex_dividend_date,gap_pct_v2,breaking_above_20d_high,breaking_below_20d_low, the sevenguidance_*/last_guidance_*fields, and six unpublished financial-statement lines). The as-of read (?asof=) andfull=trueon/v2/scanhide the same two statuses on the history tables (for exampleaverage_volume,consolidating,macd_above_zero,volume_spike,definition_version).fieldson/v2/scannow rejects a name the catalog does not list with400 invalid_queryinstead of returning it. If you read_last_trade_timestampfor the market-data time,price_asofis the published replacement. Everything/v2/signalslists is unchanged, on every plan. - ChangedStream
updateframes:as_ofis now the time the frame was pushed, the same meaning as on every REST response. It was the minute-bar time, which read as two minutes staler than theprice_asofin the same frame. - Added
GET /v2/healthalso carries alogblock: console errors and warnings in the last five minutes and the last error line, so a fault in the API process is visible from a plain HTTP probe. - Fixed
_meta.null_coverageon a live/v2/scancounted a live-only column such asprice_asofas NULL on every row while the rows carried values (it measured the history copy of the table). It now measures the table the scan read.
- Fixed
/v2/streamdelivers again. From 2026-09-07 the stream sent noupdateframes to subscriptions withfields:"all", and from 2026-09-18 to none at all: a column named in the stream's field list no longer existed on the table (firstatr_percent, renamed toatr_pctby the percent cutover; then52_week_highand52_week_low, which the stream's own identifier check rejected), and because the stream reads one query for every subscriber, one bad name failed every push for everyone. Auth,subscribedacks andpongkept working, so a client saw a healthy connection that never spoke. Fixed: the field list is checked against the live table before each push and a stale name is dropped for the subscribers who asked for it instead of failing the tick; the identifier check is the shared one every other endpoint uses; and the stream now reads the live database, soprice_asofstreams with a value. If you subscribed in that window and saw nothing, nothing was wrong with your client. - Added
GET /v2/healthcarries astreamblock: connections, subscribed tickers, last delivery time andfanout_failures_10m, so a stalled stream is visible from a plain HTTP probe. The three fields the route already returned (rss_mb,event_loop_lag_ms,uptime_s) are now documented.
- RemovedDeprecated routes are no longer listed in
/openapi.yaml, the endpoint index (/docs/endpoints,/docs/endpoints.md) or/llms-full.txt. The five reads sunsetting on 2026-10-31 (GET /v2/tickers/{ticker}/history/{interval},GET /v2/tickers/{ticker}/events,GET /v2/signals/{signal}/{ticker}/history/{interval},GET /v2/signals/{signal}/{ticker}/events,GET /v2/analyst/events) were still in the spec withdeprecated: true, and new integrations kept being generated against them. They still serve, still carryDeprecation/Sunset/Linkheaders, and their docs pages stay up until the sunset; they are just not offered as current to a code generator, an agent or a reader of the index. An alias (an old spelling that serves forever, such as/v2/tickers/{ticker}/bars/{interval}) is documented only on the page of the route it aliases. Successors:/v2/seriesand/v2/events.
- ChangedAs-of reads name the company that held the symbol that day.
GET /v2/tickers/{ticker}?asof=used to serve a reused symbol's old prices under today's holder (SHLD?asof=2010-06-30returned Sears' 2010 tape labelled as the Global X Defense Tech ETF). Now, when a different company held the symbol at the requested date,name,cikandcomposite_figiare that company's,held_at_asofis true with its tenure window,_meta.identitynames it, and the current holder's classification fields (sector,industry,asset_type,exchange,asset_class,ticker_category) are null rather than wrong. Symbols held by one company throughout are unchanged.
- Added
issuer_countryandincorporation_countryon the ticker row (GET /v2/tickers/{ticker}, scan columns): where the company is run from and where it is legally incorporated, as ISO 3166-1 alpha-2 codes, from the issuer's SEC EDGAR filings.HUIZreadsissuer_country: cn,incorporation_country: ky;AAPLreadsusfor both.countryis unchanged: it is the listing locale and readsusfor every US-listed symbol, ADRs included. Both new fields are null for symbols with no SEC filer identifier (most ETFs, non-SEC filers). Refreshed nightly at 2 AM ET for new and changed filers, and in full every Saturday (the schedule since 2026-09-19).
- FixedCompany icons and logos now load.
branding_icon_urlandbranding_logo_urlon the ticker row used to be the image host's own URLs, which answer401to anyone without that host's API key — so to every customer the two fields were dead links. They now point atGET /v2/tickers/{ticker}/iconandGET /v2/tickers/{ticker}/logo, which serve the image bytes (PNG, JPEG, SVG or WebP, with the rightContent-Type) under your own Tickerbot key — the sameAuthorization: Bearerheader as every other call. Both fields staynullwhen the issuer has no image on file. Responses carry a year-longCache-Controland anETag; the image behind a URL never changes (a new image is a new nightly row value).
- ChangedParameter values are checked at the door. Every documented
enum,integerandbooleanon a public endpoint is now enforced before the handler runs: an out-of-vocabulary value (dir=up,interval=5m,kind=earnings,foo,asset_type=crypto) or a mis-shaped one (limit=abc,full=maybe) is a400 bad_requestnaming the parameter and the accepted values. Previously each handler decided for itself and a few fell through silently (a junk boolean read asfalse; an unknownasset_typematched nothing). Enum matching is case-insensitive; booleans accepttrue/false/1/0/yes/no. The docs enums, the MCP tool enums and the server now read one constant, so a value the docs list is a value the API takes. - Fixed
GET /v2/tickersdocumentedexchangeas a closed list that includedNYSE Arca,Cboe BZX,NYSE AmericanandOTC Link— values the endpoint has always rejected (letters only). It is an open filter: any exchange name or MIC code, as the description said. The list is gone. - FixedComma-list parameters are typed consistently as
string[]across every page (scancolumns/group_by/select/asset_class, analysttickers, webhookcolumns);actionandtransitionon/v2/eventsnow show their closed lists. - AddedMCP tools now declare what they return. Every tool on
api.tickerbot.io/mcp(and the npm server) carries anoutputSchema— the same key set and field descriptions as the endpoint's Returns table, derived from one declaration — andtools/callreturnsstructuredContentbeside the text block. The server negotiates the protocol version (2025-06-18, 2025-03-26 or 2024-11-05, whichever your client asks for) instead of pinning 2024-11-05; both additions are additive, so existing clients keep working unchanged. - FixedEvery endpoint documents exactly what it returns. The eleven write endpoints (create/update webhook, enable, test, the four subscribe doors, create/update universe, create/update custom signal) had no Returns section; they do now, from the live wire. Bars gained
adjustedandsessionon 2026-09-14 and the page never said so; scan, events and news aggregate mode returntruncated(and nonext_cursor); the as-of reads of a ticker or a signal carry_meta. Each Returns table is now held equal to the server's own declaration in CI, and the sandbox's live responses are checked against the same declaration, so a field cannot appear or disappear undocumented again.
- ChangedMCP: tool names now follow the docs rail — one name per endpoint, derived from the same source as the docs. Renamed:
tickerbot_list_signals_catalog→tickerbot_list_signals,tickerbot_get_signals_match→tickerbot_get_signal,tickerbot_get_ticker_bars→tickerbot_get_bars,tickerbot_get_ticker_holdings→tickerbot_get_etf_holdings,tickerbot_get_ticker_sectors→tickerbot_get_etf_sectors,tickerbot_patch_webhook→tickerbot_update_webhook. Folded:tickerbot_get_ticker_historyintotickerbot_get_ticker(passasof),tickerbot_list_system_universesintotickerbot_list_universes(passowner=system).tickerbot_scannow posts toPOST /v2/scan;tickerbot_search_newsreads the canonicalGET /v2/news. Every retired name answers with a tombstone naming its successor, as the 2026-08-07 retirements do. MCP clients refetch the catalog at session start, so no client config changes. - ChangedMCP: every tool description and parameter list is now the same text the endpoint docs show, plus a short agent-only note where a model needs one. Previously a second hand-written copy — it had drifted (the events tool omitted earnings; three tools kept names from before the bars and ETF path families).
- Changed
invalid_querymessages are written for the reader. Three mistakes in aqused to come back as raw database text. An unknown column (rsi_99 < 30) now readsUnknown column rsi_99. Did you mean rsi_14 or rsi_7? Catalog: /v2/signals. A numeric or text column standing alone where a condition is needed (rsi_14) readsrsi_14 is a number, not a condition. Compare it to a value, for example rsi_14 < 30.A true/false column compared to a number (high_volume_alert > 30) readshigh_volume_alert is true/false. Use it bare, or high_volume_alert = true, not compared to a number.Same on/v2/scan,/v2/events,/v2/series, and the dry-run that validates a webhook rule at creation. The envelope is unchanged: same 400, sameerror: invalid_query, samerequest_id; only the text moved. Every other message is exactly what it was.
- AddedTwo new path families, old paths kept forever.
GET /v2/bars/{tickers}/{interval}is the canonical spelling of the OHLCV feed (it was also the most-guessed wrong path on the API), andGET /v2/etf/{ticker}/holdings//sectorsthe canonical spelling of ETF composition./v2/tickers/{ticker}/bars/{interval},/holdingsand/sectorskeep serving as permanent aliases — same handler, same response, no deprecation headers, no sunset. The docs, OpenAPI and the MCP tools name the new paths. - AddedBars:
adjusted=falseandsession=regular.adjusted=falsereturns prices as they printed on the tape that day instead of split-adjusted (a broker fill from before a reverse split now lands on the chart); volume scales the other way.session=regularkeeps sub-hour bars in 09:30–16:00 ET only, which drops late-reported off-exchange prints that land in pre-market minutes;limitcounts after the filter. Both are read-time options, echoed in the response. From a customer report; the store is unchanged. - Added
merge_gap_secondsonGET /v2/events?kind=signal. Runs of a flag separated by at most N seconds collapse into one before the unpivot, so a flag with thousands of per-tick fragments yields oneenterand oneexitper real run (3600for hourly flags,86400for daily). Requiressignaland an explicittickerslist, filter mode only; a cursor pins it. - Deprecated
GET /v2/signals/{signal}/{ticker}/events(signal spans) — sunset 2026-10-31, with the rest of the TB-82 slate. It reads the same rowsGET /v2/events?kind=signal&signal=X&tickers=Yunpivots into enter/exit point-events, and gap merging moved there. Responses are unchanged until the sunset and carryDeprecation/Sunset/Linkheaders. The MCP tooltickerbot_list_signal_eventsis retired; a stale client calling it is told to usetickerbot_list_events. - ChangedDocs reorganised around one vocabulary per family: overview · catalog · state · subscribe. A state page carries both tenses — the live read, then the same call with
asofas its `section. Old page URLs redirect:tickers/symbols→tickers/catalog;tickers|signals|scan/liveand/asof→…/state;series/get→series/state;events/all→events/query;tickers/bars→bars/get;tickers/holdings|sectors→etf/…`. The sidebar folds each family into a disclosure row.
- Added
GET /v2/tickers/{ticker}takes a list. Put up to 50 comma-separated symbols in the path —GET /v2/tickers/AAPL,MSFT,NVDA— and the response carriesdatakeyed by symbol,requested,count, andnot_found(symbols we do not track, which never fail the request).?asof=works the same way on the list form and means what it means on the single form: the row, and the company that held the symbol, at that instant, with_metakeyed by symbol. One call for a holdings list. The single-symbol response is unchanged. - RemovedBREAKING —
GET /v2/tickersis now the symbol catalog and nothing else. It walks every tracked symbol (active and delisted) and returns identity rows only:ticker,name,asset_class,asset_type,exchange,exchange_mic,currency_name,country,cik,composite_figi,list_date,delisted_utc,active. Price, market cap and the day change are gone from the walk.searchnow ranks an exact ticker first, then ticker prefixes, then name matches, alphabetical within each rank (it used to sort by market cap). Five parameters are retired and return a400naming the replacement:Retired Use instead ?tickers=A,B,C(full rows)GET /v2/tickers/A,B,C?universe=<id>(full rows)POST /v2/scanwithuniverseandq=price > 0?asof=(who held the symbol)GET /v2/tickers/{ticker}?asof=— resolves the holder and returns its state?min_market_cap=POST /v2/scanwithq=market_cap > 1e10?sector=POST /v2/scanwithq=sector = 'Technology' - ChangedThe spec's
profilegroup is re-cut to match:identityis exactly the catalog row above,classificationkeepssector,industry,sic_code,sic_description,ticker_category, and a newcompanycategory holds the issuer profile (description,homepage_url, address, phone, branding,total_employees,round_lot,share_class_figi,ticker_root,inactive_at,inactive_reason). Every column is still on the state row; only its catalog tag moved. Why: the same wordasofmeant symbol tenure on/v2/tickers?tickers=and a state snapshot on/v2/tickers/{ticker}, and the same path returned an 8-column row or a 475-column row depending on a query flag. The catalog now answers only "what is this symbol"; the state route answers only "what is it doing".
- ChangedEvery percent-typed field returns percent numbers, not fractions: 0.043 → 4.3. One instant — Monday, September 7 at 9:00 AM ET — across REST, scan, webhook payloads, MCP, and the WebSocket stream; no mixed state, no grandfathering. Previously the same field could return a fraction on a live read and a percent number on a historical one, a silent 100x ambiguity. There is now one unit, percent, everywhere. Nearly every affected field is also renamed, so old code fails loudly instead of silently reading wrong numbers — and a request using an old name returns an error naming its replacement. The full mapping:
Old name New name Values day_change_pctchange_1d_pctfraction → percent (0.043 → 4.3) change_1wchange_1w_pctfraction → percent change_1mchange_1m_pctfraction → percent change_3mchange_3m_pctfraction → percent change_6mchange_6m_pctfraction → percent change_1ychange_1y_pctfraction → percent change_ytdchange_ytd_pctfraction → percent pct_from_sma_10from_sma_10_pctfraction → percent pct_from_sma_20from_sma_20_pctfraction → percent pct_from_sma_50from_sma_50_pctfraction → percent pct_from_sma_100from_sma_100_pctfraction → percent pct_from_sma_200from_sma_200_pctfraction → percent pct_from_52w_highfrom_52w_high_pctfraction → percent pct_from_52w_lowfrom_52w_low_pctfraction → percent position_in_52w_rangeposition_in_52w_range_pctfraction → percent pct_from_vwapfrom_vwap_pctfraction → percent from_open_pcfrom_open_pctfraction → percent premarket_change_pcpremarket_change_pctfraction → percent afterhours_change_pcafterhours_change_pctfraction → percent revenue_growth_yoyrevenue_growth_yoy_pctfraction → percent revenue_growth_yoy_quarterlyrevenue_growth_yoy_quarterly_pctfraction → percent earnings_growth_yoyearnings_growth_yoy_pctfraction → percent atr_percentatr_pctunchanged (already percent) free_float_percentfree_float_pctunchanged percent_insidersinsiders_pctunchanged percent_institutionsinstitutions_pctunchanged short_percent_of_floatshort_float_pctunchanged bollinger_pct_bbollinger_bunchanged (stays 0–1) - Changedgap_pct keeps its name and its value multiplies by 100 (0.03 → 3.0) — the one field that changes scale without changing name. If you filter or alert on it, update your thresholds at the cutover or your rules will effectively never (or always) fire.
- Removedgap — redundant beside gap_pct, which replaces it.
- ChangedThe sandbox is the API without a key.
/v2/sandbox/*now runs every endpoint exactly as/v2/*does: the 365-day as-of floor, the 50-row page clamp, the shorterqlimit, the 5-ticker cap on series/events, the latest-day-only bars scope, and the refused-parameter 400s (projections, aggregates, universes,sort_by, eventsq/join) are all gone. The only thing that differs without a key is the per-IP budget — 30 requests/hour and 60/day — which returns429 sandbox_limit.400 history_window_exceededand403 free_scopeare no longer emitted. The Run buttons in these docs return the same response a keyed call would. - AddedBars at
2h,4h,1w, and1mo./v2/tickers/{ticker}/bars/{interval}now serves eleven intervals from 1-second to monthly:2h/4hroll up the hourly store,1w/1moroll up daily bars into calendar weeks (Monday start) and months, witht= bucket start. Samelimit/before/from/to/asofcontrols as every other interval. (These four were previously drawn only by the dashboard chart through a private route, which is gone — the dashboard reads the public endpoint.)
- ChangedThe signal taxonomy has been rebuilt —
categoryvalues on/v2/signalsrows have changed. Every signal was re-filed bottom-up into 33 categories under 9 groups: grab-bag categories (indicators,edge_alerts,bands) were dissolved into real subjects; the indistinguishablehighs_lows/price_extremespair merged into onehighs_lows; the 96-fieldfundamentalsmonolith split by statement (income_statement,balance_sheet,cash_flow,margins_ratios,valuation,share_structure, plusshort_interest);analyst_ratingssplit intoconsensus_ratings,analyst_actions,price_targets,estimates; events split intoearnings,dividends,ipos,capital_changes,insider_activity.categoryhas always been output-only metadata — no query parameter accepts it — so no request breaks, but anything displaying or switching on the old strings should re-sync from the catalog. - AddedSignal rows carry their full taxonomy membership, and the response carries the tree. Each built-in row on
/v2/signalsnow includescategory_label,group, andgroup_labelbesidecategory(slugs are stable — switch on those; labels are display strings), and flag rows carrydefinition— the precise firing rule, previously available only in the staticschema.json. The response gains ataxonomyblock: the 9 groups in derivation order — record (Price, Volume), behavior (Price action), indicator (Technicals), then reported / calendar / reference / opinion / text — each with its definition and its categories' definitions, once per response rather than repeated per row. The same tree ships in/docs/schema.jsonfor offline/agent use.
- ChangedYour custom signals are
kind: "custom". Catalog rows, create/update responses, and the per-signal history route tagged user-authored signalskind: "expression"while everything else about them said custom — thecount_customcounter beside those very rows,_meta.sourceson series, error codes, and all prose. One word now means one thing:customis what a user-authored signal is (thekindvalue, counterpart ofbuiltin);expressionrefers only to the SQL text inexpr. If your client matches onkind === "expression", switch to"custom"; the?kind=expressionfilter value keeps working as a legacy alias, as?kind=customalways had in the other direction.
- FixedA ticker returns one company's history, not several. Prices were stored under whatever symbol they traded as, so a symbol that changed hands carried every occupant's history glued into one series:
Qreturned Qwest, Quintiles and Qnity as a continuous line, andSHLDreturned Sears attached to the Global X defence ETF that holds the symbol today. 1,074 symbols carried a prior company's prices; they no longer do, and every indicator derived from them has been recomputed. - FixedA company that changed its ticker keeps its history. The other face of the same bug:
METAbegan in 2021 and showed a collapse in mid-2022 that never happened, because Facebook's 2012–2022 history was still filed underFB. Renamed companies have been reunited with their own past —METAnow runs continuously from its 2012 IPO — across 136 symbol changes. - FixedDelisted companies are in the universe. The ticker universe was built from the currently-active list, so any company that died before we started tracking was absent entirely:
LEH,SIVBandSBNYreturned nothing. 6,147 delisted companies have been restored with their real delisting dates and full price history, which makes a backtest over a past universe survivorship-bias-free rather than silently limited to the survivors. - AddedTicker records carry their symbol's ownership history.
tenure_startandtenure_endgive the dates the company on the record has held the symbol;symbol_reusedistruewhen an earlier, unrelated company held it;predecessors[]lists those earlier holders withname,cikandcomposite_figi; andprior_symbols[]lists the same company's own earlier tickers. SoMETAreportsprior_symbols: [{ ticker: "FB", … }]andSHLDreports Sears Holdings as a predecessor. - Added
asofresolves which company a symbol meant.GET /v2/tickers?tickers=SHLD&asof=2010-06-30andGET /v2/tickers/SHLD?asof=2010-06-30both return Sears Holdings; without the parameter you get the company holding the symbol today.GET /v2/tickers/{ticker}/bars/{interval}?asof=returns that company's prices, not just its name. On/v2/seriesthere is noasof— it is the range endpoint, and thefrom/towindow you request selects the era, sofrom=2010-06-01&to=2010-06-30onSHLDreturns Sears' prices.asofkeeps its one documented meaning everywhere it exists: the state at that instant. - ChangedBars are no longer clamped at
list_date. History used to be cut at the symbol's listing date to avoid serving a previous occupant's prices. That cut too much: a share-class conversion reset Criteo's listing date to 2026 and hid thirteen years ofCRTO. The boundary is now the company's actual tenancy, so legitimate history that was hidden is served again.
- Fixed
beforeonGET /v2/tickers/{ticker}/eventsis exclusive again, as its docs have always said. The bound had been overshooting:before=2026-06-16returned the 16th, and a time-carrying bound returned up to two extra days (before=2026-08-09T12:00Zreturned events dated the 10th). The route converted your bound to a bare date before handing it to the events primitive, and when a date-only window bound came to mean "through the end of that day" (v2.23.0), that conversion silently gained a day. Your bound is now passed through as the exact instant you named — a bare date as its own midnight. If you were compensating by subtracting a day, remove that adjustment. Back-paging withnext_cursoris unaffected, and so istoon the successor route/v2/events, which was always correct.
- FixedAggregating over a payload field works. Naming a rollup key whose alias matched a payload field —
group_by=payload->>'firm' AS firmon/v2/events?kind=analyst, the flagship example on All events — returned400 invalid_query "syntax error at or near (". Single-kind payload fields are rewritten to theirpayload->>expression before the query is compiled, and that rewrite was also hitting the name afterAS, producing… AS ((payload->>'firm')). Aliases (and cast targets) are now left alone wherever the rewrite runs:/v2/eventspayload fields, and custom signals on/v2/scan,/v2/newsandjoin=state. The same fix lands an aliased key on/v2/scan, wheregroup_by=sector AS swassyntax error at or near "AS"— the alias reachedGROUP BY, where SQL does not allow one. - ChangedNo rollup column comes back as
?column?. An un-named group key orselectitem that Postgres declines to name —payload->>'firm',a || b— was keyed by the literal placeholder?column?in the JSON body. Such columns are now named: a payload read takes its key (payload->>'firm'→firm), a field you spelled bare keeps your word (group_by=firm→firm), and anything else falls back togroup_1,group_2. Columns Postgres already names — bare columns, casts of them, function calls likelower(source),COUNT(*) FILTER (…), andCASE— are untouched, so no existing key changes. Applies to/v2/events,/v2/scanand/v2/newsaggregate mode.order=can now name a derived key. - ChangedOn
/v2/events, the echoedqueryobject returnsq,select,group_byandhavingexactly as you sent them. It previously echoed the compiled SQL —group_by=firmcame back as["((payload->>'firm'))"]— which made a diff of sent-vs-returned look like the request had been rewritten./v2/scanhas echoed your spelling since v2.20.0; the two now match.
- Deprecated
GET /v2/tickers/{ticker}/history?asof=(the no-interval second spelling of the as-of read) now carriesDeprecation+Sunset: 2026-10-31+ successorLinkheaders, joining the four reads deprecated in v2.17.1 on the same sunset date. The canonical spelling,GET /v2/tickers/{ticker}?asof=, returns the byte-identical response — migration is a one-line URL swap, nothing else changes. On or after the sunset date the alias may return410 Gone. (v2.17.1 called this spelling "blessed" and kept it; that call was reversed — one capability, one URL.)
- ChangedNumeric fields are now JSON numbers everywhere. A handful of endpoints —
/v2/scan(live and as-of),/v2/tickers/{t},/v2/tickers/{t}/holdings,/v2/tickers/{t}/sectors, and webhook payload rows — returned numeric quantities as strings ("price": "307.1440","weight": "0.07760000") while the docs showed bare numbers ("price": 121.09) and other endpoints (series, bars, events) already emitted numbers. The whole surface now follows one convention: every numeric quantity is a JSON number; strings are reserved for text, identifiers (CIK, FIGI, cursors), and dates/timestamps. Values are numerically identical — only the type and insignificant trailing zeros change ("0.07760000"→0.0776). The sole exception: integers too large for a JSON double to hold exactly (beyond 2^53) keep their string form — today that is only the nanosecond-epoch columns_last_trade_timestamp,_last_quote_timestamp, and_snapshot_updated_nson the full ticker row, which were strings before and are unchanged. If your client declared the flipped fields as strings, loosen it to a number type; parsers that already calledparseFloat/float()are unaffected. This moves the API to its long-documented contract.
- Fixed
transitions_onlyon/v2/seriesdated the same flip differently depending on which other columns rode along: with a bar column (sayclose) incolumns, a flip recorded on a weekend/holiday carry row was re-dated to the next trading day by the non-trading-day drop; without one it kept its original date. Flips now always keep the date the state table recorded them — the drop no longer applies undertransitions_only(its output is already sparse, so there are no gap-looking rows to protect). Bar columns on such a row arenulland count in_meta.coverage.*.missing_bar_cells. - FixedOn
GET /v2/eventswithkind=signal, request validation now runs before the signal-log readiness check. A malformed query (group_byoverkind=signal, orq/join=statewithoutsignal=) sent while the log was unavailable answered503 kind_unavailable— documented as retryable — instead of its400, so a well-behaved client would retry a request that could never succeed. A503now guarantees the query itself is well-formed. - ChangedUnknown-path
404bodies now point somewhere. Every "no such endpoint" response carriesdocs_url(the API reference), and recognized near-misses of real routes additionally carrysuggestion— the route you probably meant — echoed in the message as "Did you mean …?".GET /v2/barssuggests/v2/tickers/{ticker}/bars/{interval};/v2/news/querysuggests/v2/news/scan;/v2/events/allsuggests/v2/events. Resource 404s (unknown ticker, webhook, delivery) are unchanged. If your client seessuggestion, switch routes — retrying the same path will 404 forever.
- Removed
/openapi-gpt.yaml(the ChatGPT custom-GPT Actions spec) retired: the GPT Store path was dropped 2026-06-12 (Actions support only shared-key auth), ChatGPT connects via the MCP server with per-user OAuth instead, and the spec had no remaining consumers. The full spec remains at/openapi.yaml; GPTs built from the old URL keep working (Actions snapshot schemas at import). - Added
toonGET /v2/webhooks/{id}/deliveries— the upper window bound, completingfrom. Same value grammar asfrom(epoch seconds, epoch milliseconds, or ISO datetime); a date-onlytomeans through the end of that UTC day, matching bars, series, spans, and events.fromaftertois a400. - Changed
sort_byonGET /v2/signals/{signal}now rejects unrecognized values with a400naming the two valid ones (default,market_cap). A typo likesort_by=marketcappreviously fell through silently to the default order, so results looked plausible while ignoring what you asked for. Notesort_byis deliberately a two-position switch — for ordering by arbitrary columns, use/v2/scanwithorder/dir. - ChangedPATCH
/v2/signals/{name}and PATCH/v2/universes/{id}now reject unknown body fields with a400listing what each accepts, matching webhook PATCH. Unknown keys were previously ignored, so a PATCH of only unknown fields returned200with an unchanged record — reading as success. - Fixed
fields(the documented alias ofcolumns) now works on/v2/series?interval=1q. The quarterly arm only readcolumns, so?interval=1q&fields=epswas a400while the same request withcolumns=epsworked. - FixedA malformed
from/toonGET /v2/signals/{name}/{ticker}/history/{interval}for a custom signal now returns a clean400naming the expected format, instead of a database cast error surfacing as a500.
- Added
from/totime windows onGET /v2/tickers/{t}/bars/{interval}andGET /v2/signals/{s}/{t}/events(signal spans). Same conventions as/v2/series:frominclusive, a bareYYYY-MM-DDtomeans through the end of that day, andcursorpages backward inside the window. On bars these params used to be silently ignored; on spans they were advertised and ignored — "golden crosses in June" returned all-time data. Contradictory combinations (from/towithasoforbefore) are a400, and a spans cursor now carries its window, so replaying it without resendingfrom/tostays in-window (resending conflicting values is a400). - ChangedA date-only
to/untilonGET /v2/events(and its per-kind views and/v2/analyst/events) now means through the end of that day, matching bars, series, and spans.to=2026-06-30previously bound at that day's midnight and silently excluded the whole named day on timestamp-grained kinds. Timestamp-bearing values keep their exact exclusive semantics. - Added
from(aliassince) onGET /v2/webhooks/{id}/deliveriesaccepts epoch milliseconds (13+ digits) alongside epoch seconds and ISO datetimes — bare digit values on bars/series/spans are milliseconds, so a value reused across surfaces no longer lands ~50,000 years out. - AddedNew error code
unknown_parameter(400): a query/body parameter name the endpoint does not accept is rejected, and the message lists every accepted name — ghost parameters (tickr=,condtion=) no longer succeed while meaning something else. Rolling out in warn mode first (unknown names are logged, requests pass through); enforcement follows. - ChangedMCP: four tools retired with graceful tombstones —
get_ticker_history_seriesandget_signal_history→tickerbot_get_series,get_ticker_events→tickerbot_list_eventswithticker=,list_analyst_events→tickerbot_list_eventswithkind=analyst. Calling a retired name returns an error naming the successor and the argument mapping instead of a bare "Unknown tool". Four tools added in the same pass:get_series,get_ticker_coverage,create_webhook,patch_webhook.list_eventsalso gains the structuredfirm/actionanalyst filters (case-insensitive firm match). - ChangedThe GPT Action spec (
/openapi-gpt.yaml) restoreslist_signal_events— the only span-shaped read;/v2/events?kind=signalreturns point edges, not spans — and dropsget_stream_usage(a dashboard concern), staying at 29 operations under ChatGPT's 30-op cap.
- Removed
POST /v2/scan/explain(and its GET form). The endpoint now returns410 Gone. Its job — telling you whether a query would run — is already done by the scan itself: an invalidqreturns the same400with the same message, and every scan response echoes the query it executed (query, plus_metaon as-of reads for the resolved interval). If you used explain as a pre-flight in CI or before subscribing, run the scan withlimit=1instead; subscribing also validates the query and creates nothing on failure.
- Added
intervalon as-of reads (/v2/scan,/v2/signals/{signal}):1m,1h,1d, orauto(the default, which is the previous behavior). State is stored at three grains and they do not carry the same columns, so a cross-section — which must resolve to ONE grain — had its grain decided implicitly by the projection list, the universe scope, and how far back the instant was. Asking for one1d-only column such asrsi_14re-dated every other column in the request. Withintervalset that is a400 interval_unavailablenaming the column and the grains that carry it. Same parameter name and values as/v2/seriesand/v2/tickers/{t}/bars. - Fixed
?asof=on/v2/tickers/{t}/bars/{interval}returned bars from the FUTURE relative to the requested moment. The read was bounded 24 hours past the instant, and because daily bars are stamped at the session date's midnight ET, a mid-session timestamp pulled in the NEXT session's close:?asof=2026-07-29T14:00:00Z(10:00 ET) returned close 333.43, which is the 07-30 close — the 07-29 close was 338.19. asof now returns the most recent bar whose period had CLOSED at or before the moment. A bareYYYY-MM-DDstill means that day's close and is unchanged. If you built a backtest on intradayasofbars, re-run it. - Fixed
GET /v2/tickers/{ticker}?asof=returned none of the columns its own_meta.frozen_fieldsadvertised —name,sector,industry,asset_type,exchange,asset_class,ticker_categorywere absent fromdataentirely, while the live read of the same endpoint returned them. They are now joined from the current ticker row, as/v2/scan?asof=already did. - Changed
_meta.interval(1m/1h/1d) replaces_meta.resolution(minute/hourly/daily) on every as-of response, and_meta.state_intervalreplaces_meta.state_resolutionon/v2/events?join=state. The old keys remain as deprecated aliases with their old values. This makesintervalthe single vocabulary for "which grain" across series, bars, as-of reads and the state join — it was previously spelled three different ways. Also new:_meta.interval_reason(always present, says which grain ran and why) and_meta.coverage_gapnow reports on the fallback path too, not only when the chosen grain was already fully covered. - FixedWhole-market intraday as-of reads were pinned to
1dby a coverage check with an absolute 25-ticker tolerance. Measured on 2026-07-31, hourly missed 30 of 13,732 tickers (0.22%) and failed by five — while the minute tier's 92% shortfall was judged by the same constant. The tickers involved are active SPAC warrants, units and rights that simply never print intraday, so no fixed count could be correct. The threshold is now a fraction of the universe, and the gap is disclosed either way. - FixedThe as-of grain for a given instant no longer depends on which date another caller asked about first. Coverage verdicts for every instant inside the last 7 days shared one cache entry, so the same request could return
1hor1ddepending on cache state. Verdicts are now per instant. - FixedDefault columns a grain does not store (for example
market_capat1m) are returned asnulland named in_meta.columns_not_stored_at_interval, instead of being dropped from the row. The response shape no longer changes with the grain. - FixedThe three
/v2/sandbox/*as-of routes (/tickers/{t},/tickers/{t}/history,/signals/{s}) now run the same handlers as the keyed endpoints. Their own implementations had no staleness floor, answeredas_ofwith the CURRENT time on a historical row, silently truncated an intradayasofto a date, and emitted no_meta. This also fixes the 500 on/v2/sandbox/tickers/{t}/history?asof=, which was an unbounded scan. - FixedA ticker whose most recent state sits exactly on the staleness boundary is no longer served by
/v2/scanand/v2/signalswhile 404ing on/v2/tickers. The coverage probes used an exclusive bound and the serving queries an inclusive one; all of them now share one definition. - Changed
?asof=on bars honors an explicitlimit(the last N closed bars) instead of silently overriding it, andasofcombined withbefore/cursoris now a400instead ofasofquietly winning. A malformedasofis a400rather than falling through to the live tail.
- Added
GET /v2/events?kind=signalnow takes theqgrammar andjoin=state— scoped with two new params,signal=<flag>andtransition=enter|exit.signal=is required forq/join=state(filter mode needs neither) — naming the signal binds the query to an index over the ~175M-row firing log, so "everygolden_crossenter across the market this week" returns in milliseconds instead of timing out.transition=is an ordinary optional filter.group_byoverkind=signalremains unsupported — an aggregate has nolimitto stop at, so its cost tracks how often the signal fires. See /docs/endpoints/events/query#signal-firings. - ChangedBreaking,
kind=signalonly: the payload fielddirectionis renamedtransition./v2/serieshas always called this exact primitive a transition (transitions: { above_sma_200: "enter" }) and both are computed by the same shared rule, sodirectionwas the lone dissenting name. Values are unchanged:enter/exit. - Fixed
kind=signalwithqorjoin=statecovering BOTH transitions no longer times out on high-frequency signals. Each edge branch now carries its own sort order, so the database merges two ordered streams and stops at yourlimitinstead of reading the whole window and sorting it.above_vwapover 7 days went from a 30-second timeout to 31 ms. - FixedEvent-trigger webhooks carrying
tickersreturned 500 (POST /v2/events/subscribe,POST /v2/webhooks) — a missing import left over from the shared-ticker-parser refactor.
- AddedRates, FX and crypto are now first-class on the ticker-scoped endpoints.
/v2/tickers/{t},/v2/tickers?tickers=,/v2/series, universes and ticker-scoped webhooks all accept prefixed symbols —R:SOFR,R:UST10Y,X:EURUSD,X:XAUUSD,X:BTCUSD. They were already returned by/v2/scan; now the whole surface agrees. Daily history runs deep: rates to 1990, spot metals to 1968, crypto to 2010. See Asset symbols for what each class carries. - AddedThe signal catalog reports per-field as-of behavior:
historized(the value at that instant),frozen(an identity column joined from the current row —sectoras of 2020 is today's sector), orunavailable. Previously the three were indistinguishable. - FixedAs-of scans no longer silently drop requested static columns.
?fields=ticker,sector&asof=…returned everything exceptsector, while_meta.frozen_fieldsadvertised it as available — filtering and grouping on those columns had always worked, only projection was broken. - FixedBars for instruments with no intraday range (interest rates) return
nullfor open/high/low/volume instead of0. A stored NULL was being coerced on serialization, which floored any min() computed over the response and drew a zero candle on charts. - FixedWell-formed non-equity symbols get an error naming their asset class instead of "Invalid ticker".
/v2/news,/v2/eventsand/v2/analystremain equities-only by definition — a rate pays no dividend — but they now say so./v2/eventsalso validates ticker format on the first page, not only on cursor pages. - RemovedBREAKING —
GET /v2/tickers?asset_type=cryptois rejected. It served a separate crypto table that stopped updating on 2026-06-18, so it had been returning weeks-stale prices. Crypto now lives in the main ticker list under itsX:symbols: use?tickers=X:BTCUSD,X:ETHUSDor scan for it.asset_typekeeps its real meaning — the instrument type within equities (CS,ETF,ADRC, …), which is a different axis from asset class.
- Added
columnsis now the one projection parameter name across the API — on/v2/scan(additive to the defaults),/v2/tickers/{t}/history(replaces the defaults),/v2/series, and webhook subscribe payload fields. The originalfieldsspelling is accepted forever. - Added
/v2/newsgains the events-style scoping sugar:ticker,tickers(≤50),universe, andfrom(inclusive) /to(strictly before) AND into the WHERE — andqbecomes optional once any of them is present.?ticker=NVDA&from=2026-07-01needs no SQL. - Added
from/toare now the canonical range names on/v2/eventsand/v2/analyst/eventstoo;since/untilaccepted forever. - AddedTicker subscribe (
POST /v2/tickers/{t}/subscribe) takesq— it was always the scan grammar wearing the namecondition;conditionaccepted forever. - AddedCross-ticker context refs (
spy.sma_50) now work identically on webhook subscribe and the docs sandbox, and signed-in users' custom signals inline on the sandbox — the same query is valid live, pushed, or sandboxed. - AddedNew error code
expanded_query_too_large: yourqis under the 4,000-char limit but expands past the 100,000-char execution bound after custom-signal inlining. Distinct frombad_requestso you can tell "too long" from "expands too much". Any q/v2/scanaccepts is now subscribable — the old subscribe-side 1,500-char post-expansion cap is gone. - AddedCursors everywhere they were missing: the tickers crypto list, 1q history, sandbox signals, and the admin tickets list now emit real
next_cursortokens. - ChangedDate params parse ONE strict ISO subset everywhere:
YYYY-MM-DDorYYYY-MM-DDTHH:MM[:SS[.sss]]Z./v2/eventsand/v2/analyst/eventspreviously accepted loose formats ("March 3 2024") that every neighboring endpoint rejected — those now 400. - ChangedFail-loudly pass: unknown keys in a webhook PATCH body are rejected instead of ignored (the trigger and channel are immutable by design — the error now says so); a
conditionsent with a boolean/custom signal subscribe 400s instead of being silently ignored; sending bothtickerandtickers400s on events read + subscribe (each side used to pick a different silent winner);/v2/streamnames malformed symbols in aninvalidarray instead of silently dropping them;/v2/eventscursor pages reject query-string filters that conflict with the cursor's pinned set; the docs sandbox 400s on unsupported params (tickers/scan/signals) instead of silently ignoring them, honorslimitup to its 50 cap, and gains the POST scan form. - ChangedBREAKING —
orderon/v2/newsand/v2/eventsnow takes a bare column name or SELECT alias only; SQL expressions inorderare rejected (alias the expression inselectand order by the alias). Expression order is also what broke news aggregate paging. - ChangedBREAKING — one aggregate cap set everywhere:
group_by≤ 1,000 chars and 1-6 keys,select≤ 2,000,having≤ 1,000, on scan, news, and events alike. - ChangedAnalyst events cursor pages now apply your filters on every page (page 2 of a
?ticker=AAPLwalk used to return other tickers). Resend the same filters alongside the cursor — see the pagination guide for the two cursor models. - ChangedDELETE returns
204 No Contentuniformly (custom signals joined universes/webhooks/devices). Device records use snake_case keys (device_name,created_at,last_seen;expo_push_tokenon register) — camelCase spellings accepted forever on input. - RemovedInternal identifiers (
userId/keyIdon webhooks,ownerType/ownerId/createdByKeyIdon universes) no longer appear in responses. They were bookkeeping, not contract — usesystem: trueto distinguish platform universes.
- ChangedAnonymous sandbox rate limits raised: 30 queries/hour (was 10) and 60/day (was 30) per IP. Signed-in callers were and remain exempt from the IP budget.
- AddedSandbox mirrors for the two new primitives:
GET /v2/sandbox/seriesandGET /v2/sandbox/events— the docs pages for/v2/seriesand/v2/eventsnow have Try-it. Sandbox clamps apply (5 tickers, 50 rows, 1-year window), and sandbox events is filter mode only:q, aggregates,join=state, and universes need an API key. - FixedSandbox
GET /v2/sandbox/tickers/{ticker}silently ignored?asof=and returned the live row. It now honors asof within the sandbox's 1-year window, same semantics as the authed read. - ChangedThe sandbox demos for two deprecated reads were retired: per-ticker events (it served a legacy archive, not what the real endpoint returns) and per-signal history. Their successor pages —
/v2/eventsand/v2/series— carry the live Try-it demos.
- DeprecatedFour legacy reads now carry
Deprecation+Sunset: 2026-10-31+ successorLinkheaders. Each has a strict superset:GET /v2/tickers/{t}/history/{interval}→/v2/series?ticker=,GET /v2/signals/{s}/{t}/history/{interval}→/v2/series?ticker=&columns=,GET /v2/tickers/{t}/events→/v2/events?ticker=,GET /v2/analyst/events→/v2/events?kind=analyst. Responses are byte-identical until the sunset date; after it the routes may return410 Gonewith a pointer at the successor. NOT deprecated:GET /v2/tickers/{t}/history?asof=(the blessed second spelling of the as-of read),/v2/news/scan(answers forever), the/subscribeshortcuts,/v2/tickers/{t}/bars, signal spans, and?condition=.
- Added
GET /v2/tickers/{ticker}/coverage— per-ticker data coverage: data spans per resolution (bars, daily, hourly, minute), minute-tier membership, and per-field measured backfill depth where the backfill engine has probed. Answers, before you query, whether "no rows" would mean "the signal never fired" or "no data at that depth". Available on every plan. See /docs/endpoints/tickers/coverage.
- Added
GET /v2/series— the canonical series read: up to 50 tickers × 25 columns on one shared, aligned time grid. OHLCV names, schema columns, and your custom signals mix freely incolumns; sources and per-ticker coverage are disclosed in_meta; a missing cell isnull, never a silently dropped row. A bare/v2/series?ticker=Xreturns the ticker-history default columns. See /docs/endpoints/series/get. - Added
transitions_only=trueon/v2/series: rows filter down to the state-change edges of boolean columns — built-in flags and custom signals both — with non-boolean columns riding along (the price at the flip). Computed by the same shared rule that fires webhooks. - Added
interval=1won/v2/series— real weekly resampling: state columns sample the week's last observation, OHLCV aggregates (first open, max high, min low, last close, summed volume), rows keyed by the ISO week's Monday./v2/signals/{s}/{t}/history/1wnow applies the same rule — previously1wreturned daily rows with no resampling. - Added
interval=1qon/v2/series— quarterly fundamentals (eps,eps_estimate,eps_surprise,eps_surprise_pct,revenue,gross_profit,free_cash_flow) on the fiscal grid, keyed by calendar quarter (2026-Q2) with each ticker's exactfiscal_periodper row. Quarterly columns can't mix with daily ones in one request. - AddedTwo opt-in kinds on
GET /v2/events:signal— boolean-flag firings as enter/exit point-events with the price at the edge (the span shape stays first-class at/v2/signals/{s}/{t}/events) — andnews, mirroring the article archive into the timeline. The default stream is unchanged: the four corporate kinds.kind=signalis filter-mode only:q, aggregates, andjoin=stateover the signal log are refused with a 400 rather than timing out. See /docs/endpoints/events/query#signal-firings. - Added
join=stateonGET /v2/events: ticker-state columns become legal inq/select/group_by/having, evaluated against each event's ticker as of the event's timestamp — point-in-time replay. "Downgrades on stocks above their 200-day" is one call. Daily resolution, echoed asstate_resolutionin the response'squeryobject. Available on every plan. - Added
q_truncated: trueon/v2/eventsresponses whoseqwas too long to ride inside the cursor — resendqalongsidecursorproactively instead of discovering it on a 400. - ChangedPer-call caps unified at 1,000 rows across the cursor-paged read surfaces. Custom-signal history previously allowed 5,000 rows on one page (an accident of routing — which cap you got depended on whether the name was custom); it now pages at 1,000 like everything else. Signal spans (
/v2/signals/{s}/{t}/events) deliberately keeps its 5,000 clamp — it has no cursor, so a lower cap would strand spans past it. - FixedThe dashboard mirror of the per-ticker event log served a divergent legacy implementation reading a different archive. It now serves exactly what
GET /v2/tickers/{ticker}/eventsserves. The public path is unchanged.
- ChangedEvent webhooks now support all four kinds —
insiderjoinsdividend,split, andanalystas subscribable. The insider archive gained the ingestion timestamp the fire-on-ingest trigger needs; only filings recorded after 2026-07-27 are eligible, so historical rows can never fire. The short-livedkind_not_subscribable(400) error is retired. - AddedAggregate scans:
group_by(with optionalselectandhaving) switches/v2/scanfrom ticker rows to rollups — market breadth by sector, counts of new highs, average RSI per group — on both the live andasofpaths. Same grammar as/v2/newsand/v2/eventsaggregation. - Added
GET /v2/events— one cross-ticker timeline over dividends, splits, insider transactions, and analyst actions, withkind/tickers/universe/since/untilfilters. It also speaks the same SQL grammar as/v2/scan—q/select/group_by/havingover(ticker, ts, kind, payload)— for filtered timelines and rollups (insider buys by sector, dividend counts per month). The per-ticker/v2/tickers/{t}/eventsand/v2/analyst/eventsremain as filtered views of the same data. - AddedEvent webhooks:
POST /v2/events/subscribe(orPOST /v2/webhookswithtrigger: {type: "event"}) fires when NEW events land — with an optional row-state filterq(the ticker's state) andevent_q, a filter on the event's own payload (e.g. only insider buys over $1M). Deliveries carryevent: "events.fired". Latency is ingest cadence: analyst ≤1h, corporate kinds daily. - Added
POST /v2/webhooksis now the canonical create: a webhook is atrigger(scan / ticker / signal / event) plus delivery fields. The per-resource/subscribeendpoints remain as permanent shorthand — every door creates the identical object. - Added
GET /v2/tickers/{ticker}/history/{interval}— true series history: up to 25 columns for one ticker, one flat row per step (1m/1h/1d), chronological, cursor-paged. The old/v2/tickers/{ticker}/history?asof=form (a point snapshot despite its name) keeps working forever and stays fully documented;GET /v2/tickers/{ticker}?asof=returns the identical response — existing integrations are unaffected. - Changed
asofis now one uniform capability: the same staleness rule on every endpoint — a row must be within the serving tier's window (14 days for daily) or the response is empty/404 withlast_available. Unlimited depth on every plan; history-series endpoints are unaffected and stay all-time. - AddedIdempotency keys on every create endpoint: send
Idempotency-Key: <unique string>and a retry within 24h replays the original response (Idempotency-Replayed: true) instead of creating a duplicate; concurrent duplicates get409 idempotency_in_flight. - Added
POST /v2/scan/explain— dry-run a scan without executing: validation, the compiled predicate after custom-signal expansion, resolved scope and asof tier, and the planner's cost/row estimate. Always responds 200; failures return{ valid: false, stage, error, message }. - AddedPreviously-undocumented surfaces are now in the reference:
PATCH /v2/webhooks/{id}, the/v2/devicesfamily (mobile push registration),GET /v2/stream/usage, and scan'sfull=true.
- ChangedThe Free plan now includes a monthly call quota of 10,000 calls per calendar month (UTC), resetting on the 1st. Every paid plan is unmetered — no monthly cap. Calls past the quota return
402 monthly_quota_exceededwith aresets_attimestamp; rejected requests (429s and quota 402s) never consume quota. Free-plan responses carryX-Quota-Limit,X-Quota-Remaining, andX-Quota-Resetheaders.
- ChangedCustom signals are no longer a paid feature and are no longer capped. Authoring and consuming them both work on every plan, including Free, with no count limit. The
custom_signals_tier_required(403) andcustom_signal_limit_reached(403) errors are retired; they can no longer occur. Accounts that were locked out of their own custom signals after a downgrade can use them again. - ChangedScale is now capped at 1,000 webhooks, where it was previously unlimited. Webhooks and websocket streaming now ladder identically: 0 / 10 / 100 / 1,000 across Free / Hobby / Pro / Scale. Unlimited webhooks are available on Enterprise.
- Added
GET /v2/stream/usagereturns your current websocket consumption —tickers,max_tickers,connections,max_connections. Streaming caps are pooled per ACCOUNT, not per API key: issuing additional keys does not grant additional capacity. - AddedTwo account-level ceilings are now documented:
too_many_universesandtoo_many_custom_signals(both 400). These are anti-abuse guards, not plan limits — they are identical on every plan and upgrading does not raise them.
- ChangedWebhook cadence is no longer plan-gated — any webhook can use any cadence, regardless of plan. The
cadence_above_plan_max(403) error is retired; it can no longer occur. - ChangedThe real-time cadence is now
realtime(the default). It is evaluated on every data refresh (~1×/min), so a match is delivered within seconds of the snapshot that first contains it — no per-minute batching.1mis a deprecated alias forrealtime: it is still accepted on create/update and is normalized torealtime, which is what responses now return.
- ChangedPlans restructured around a new $0 Free tier, now the default on signup. All data is available on every plan, including Free: full universe, every signal, real-time data, history,
asof, news, and analyst archives. Paid plans differ by rate limit, webhook count, and custom signal count. The 14-day trial is retired; cancelling returns an account to Free rather than revoking access.
- AddedRules are now validated at creation. Every subscribe endpoint dry-runs your query and rejects an unrunnable rule (unknown column, bad syntax) with
400 invalid_queryand the underlying message. - AddedOptional
fieldson/v2/tickers/{t}/subscribe,/v2/signals/{s}/subscribe, and/v2/scan/subscribe— a comma-separated list of extra columns to include in each fired payload's match rows, beyond the standard set (ticker,name,asset_type,price,day_change_pct,market_cap). Mirrorsfieldson/v2/scan; each must be a real column or the subscription is rejected at creation.
- Added
GET /v2/analyst/events— per-event analyst rating history from a ~14-year archive: upgrades, downgrades, initiations, and price-target changes, each with the firm, analyst, new and previous rating, and new and previous price target. Filter byticker/tickers(≤50),since/until,firm(case-insensitive), andaction; results are newest-first and page withcursor. At least one filter is required. Scale and above — the livelast_rating_*columns on/v2/tickersand therecent_*analyst flags on/v2/scanremain available on every plan. See /docs/endpoints/events/query#analyst. - Added
tickerbot_list_analyst_eventsMCP tool wraps the endpoint above, so agents can pull analyst rating history in chat.
- AddedWebhook delivery channels. Every subscribe endpoint (
/v2/tickers/{t}/subscribe,/v2/signals/{s}/subscribe,/v2/scan/subscribe) now takes achanneldiscriminator —webhook(signed POST totarget_url),discord(an embed posted to a Discord channel), orin_app(dashboard-only). Omit it and we infer:webhookwhentarget_urlis set,discordwhendiscord_urlis set, otherwisein_app. See the Delivery channels guide at /docs/endpoints/webhooks/channels. - AddedDiscord delivery. Pass
channel: "discord"plus adiscord_url(a Discord incoming-webhook URL) and each fire posts a formatted embed — subscription name, composed query, and the first dozen matching tickers with price and day change. No HMAC: the URL is the credential, so it is stored masked and stripped from list/get responses, which exposechannel_config_present: trueinstead.429s honor Discord'sRetry-After; other4xxs are permanent failures;5xx/network errors ride the standard retry ladder. - Changed
POST /v2/webhooks/{id}/testis channel-aware — for a Discord subscription it posts a real-shape test embed (titled with a[TEST]prefix) and returns the inline outcome, same as the HTTPS test fire. - ChangedThe delivery channel is fixed at create time.
PATCH /v2/webhooks/{id}still toggles awebhooksubscription between POST-to-URL and in-app, but cannot switch to or from Discord — delete and re-subscribe to change channel.
- ChangedSubscribing no longer auto-fires a
webhook.pingat your endpoint. One delivery shape —webhook.fired— so handler code only needs to handle one event, and the first payload your endpoint ever receives is identical to every future one. New webhooks ship instatus: "active"immediately. - Added
POST /v2/webhooks/{id}/testfires a real-shape POST to yourtarget_urlsynchronously and returns the inline HTTP outcome (delivered,http_status,elapsed_ms,error). For URL targets the body has the same field set and HMAC signature as a real fire —webhook.firedfor condition triggers,events.firedfor event triggers — with anX-Tickerbot-Test: trueheader as the only marker. Test fires are one-shot: failures are recorded aspermanent_failureand never enter the retry queue or trigger auto-disable on the parent webhook. - Added
test_urlfield on subscribe responses points at the test endpoint above. The dashboard also surfaces a "Send test fire" button on the post-create modal and on the webhook detail page. - Removed
webhook.pingevent type. Thepending_verificationstatus is no longer emitted on new webhooks.
- Added
GET /v2/tickers/{ticker}/bars/{interval}— OHLCV bars at1s,1m,5m,15m,30m,1h,1d. Single symbol or comma-separated bulk (response keyed by symbol). Paging viabefore+limit(withcursor/next_cursoras sugar);asofreturns a single point-in-time bar.1d/1hcover the full universe with full history; sub-hour covers the active universe and back-fills from the provider on first request. Available on every plan, all intervals. - Added
1s(1-second) interval on the bars endpoint, served on demand: from our store when present, otherwise passed through from the provider in the same call. Second data is not bulk-backfilled — it accumulates as requested. Best paired with a tightbefore+limitwindow.
- Added
POST /v2/tickers/{ticker}/subscribe,POST /v2/signals/{signal}/subscribe, andPOST /v2/scan/subscribe— subscribe to a webhook directly from the resource you want to watch. The new endpoints all return the same webhook record shape;/v2/webhooksbecomes a pure registry for listing, inspecting, deleting, and re-enabling subscriptions. - Removed
POST /v2/webhooks— replaced by the resource-level subscribe endpoints above. Existing webhooks created via the old path keep firing unchanged. - Removed
/v2/rules— saved-bundle layer retired. Inline theqdirectly on/v2/scanor on a subscribe endpoint; reference a universe via?universe=<slug>instead of bundling it. - Added
?asof=is now uniform across every read:/v2/tickers/{ticker}?asof=,/v2/signals/{signal}?asof=,/v2/scan?asof=. Returns the universe as it stood at the close of the requested day, sourced fromsignal_daily_state._meta.frozen_fieldslists columns that aren't historized (sector, industry, exchange, asset_type). - ChangedEvery paid plan now ships replayable history on every read, unlimited universes, and webhooks scaling by tier (Hobby 10 · Pro 100 · Scale unlimited). The Pro → Scale upgrade is content (news archive, custom signals).
- ChangedNews archive (
/v2/news/scan) moved to Scale and above (previously Pro). The livenews_volumeandnews_volume_weighted_sentimentcolumns on/v2/tickersand/v2/scanremain available on every paid plan. - ChangedCustom signals (
POST/PATCH/DELETE /v2/signals/{name}) moved to Scale and above. The unified/v2/signalscatalog remains readable on every plan. - ChangedWebhook visibility is account-scoped: every API key on the same account sees the same webhook registry. Rotating a key no longer strands subscriptions.
- ChangedFree trial no longer requires a credit card. New signups are placed on Hobby for 14 days; an API key is minted from the dashboard checklist with no Stripe interaction. Add a payment method anytime to keep going past the trial.
- Changed
/onboardingretired. The dashboard is now the unified post-signup landing — trial countdown, account-status banner, and onboarding checklist all live there. Stripe Checkout success and cancel URLs now point back to/dashboardand/dashboard/billing. - Added
402 trial_endederror code (wassubscription_required) returned by/v2/*when a no-card trial has expired. Body message links to/dashboard/billingto add a payment method.
- AddedCustom (expression) signals — name a SQL
WHERE-clause expression once, then reference it as a bare identifier in any predicate context (scanq, another custom signal'sexpr, webhook subscribe body). Compiles + inlines at create time; recursion is detected and capped at depth 5. CRUD:POST /v2/signals,GET /v2/signals(unified catalog of built-ins + your customs),PATCH/DELETE /v2/signals/{name}. Cascade-safe delete refuses with 409signal_referenced(carriesreferencing_signalsarray) — pass?force=trueto override. - Added
GET /v2/signals/{name}/{ticker}/events— occurrence records (start/end timestamps + start/end prices) for a single signal on a single ticker. State-style signals return windowed regions; event-style signals return point events. Drives the dashboard chart's flag-overlay rail. - ChangedHobby now includes full per-ticker history and historical scans (previously live-data only). Rate limit on Hobby raised from 60 to 600 req/min.
- ChangedThe demo ticker (AAPL) now bypasses the plan top-N scope filter on every plan, so the public docs and the per-signal reference page render without auth on every tier.
- Changed
GET/POST /v2/news/scanreplaces the original/v2/news+/v2/news/{id}pair. One SQL-style endpoint, two shapes — article rows by default, aggregate rollups whengroup_byis supplied. Auto-joinsUNNEST(tickers) AS tkwhenever any clause references thetkalias. "As-of" is just a WHERE filter ontime_published; no separate parameter. - ChangedNews archive access now requires Pro or above (was Hobby). The two live news columns on the ticker table (
news_volume,news_volume_weighted_sentiment) remain available on every paid plan via/v2/scanand/v2/tickers. - Added
/v2/sandbox/news/scan— unauthenticated, IP-rate-limited mirror of the scan endpoint, capped at 50 rows.
- Added
GET /v2/news— paginated, filterable news feed. Articles indexed back to 2015, refreshed every 15 minutes. Filterable bytickers,topics, time range,min_relevance,min_sentiment/max_sentiment. Hobby and above; per-call cap 50/200/1000 by plan. (Superseded the next day by/v2/news/scan.) - Added
GET /v2/news/{id}— fetch a single article by id. (Superseded the next day by/v2/news/scan.) - AddedTwo new fields on the ticker schema:
news_volume(24-hour rolling count of mentions at relevance ≥ 0.6) andnews_volume_weighted_sentiment(relevance-weighted average sentiment, attenuated by tanh(volume/15) so quiet tickers read near zero). Both refresh every 15 minutes. Queryable through/v2/scanand/v2/tickers. - RemovedThe four previously-stale news columns on
ticker(latest_news_at,recent_news_count,highly_relevant_news_count,news_sentiment_volatility) have been removed. They were never reliably populated; the new two-field design above supersedes them.
- RemovedFree tier removed. Every plan (Hobby, Pro, Scale) now starts with a 14-day free trial; cancel anytime.
- Added
/v2/universes— create and manage named ticker lists. System universestop_10andtop_100(rebalanced monthly by dollar volume) are available to every account. - Added
/v2/rules— save a{q, universe_id?, order, dir, fields}bundle and reference it from/v2/scan?rule=or/v2/webhooks. - Added
?universe=parameter on/v2/scan,/v2/signals/{signal}, and/v2/tickers— scope queries to a system or owned universe. - Added
?asof=on/v2/scan— folds the historical scan into the main scan endpoint./v2/scan/historyremains as a backwards-compatible alias. - AddedWebhook
cadencefield — pick1m(real-time, the default),hourly, ornyse_open. - AddedWebhook
rule_idbody field — subscribe to a saved rule instead of inliningq. - ChangedFree and Hobby plans now auto-scope ticker queries to the plan top-N (10 / 100). Response carries
_meta.scopedescribing what got applied. - ChangedNew pricing matrix: ticker scope, webhook cadence, max universes/rules/webhooks. See /pricing for the full grid.
- ChangedAPI base path moves from
/v1to/v2. v1 keeps working at its existing path for now; new integrations should use v2. - Added
/v2/signals/{signal}lists tickers where a signal matches. Numeric signals take a?condition=(e.g.>70); boolean flags are auto-detected. - Added
/v2/signals/{signal}/{ticker}/history/{interval}returns per-signal time-series at the requested resolution (1d/1h/1m). Daily history covers all-time; minute history is two years for top-200 tickers. - Added
/v2/scan/history?asof=snapshots the universe scan at any past date, as-of-that-day. Falls under the same SQL grammar as live/v2/scan. - Added
/v2/tickers/{ticker}/history?asof=returns the wide ticker row as it stood on a past date, with quarterly fundamentals (assets, equity, EPS…) joined in by filing date. - Added
/v2/tickers/{ticker}/eventsreturns a unified event log: splits, dividends, analyst rating changes, all sorted newest-first with cursor pagination. - Changedv2 uses scanner-native column names everywhere — the legacy v1 docs vocabulary (
day_change_pct,asset_type) is gone in favor ofday_change_pc,type. The full set is documented on the schema page. - ChangedWebhooks now live under
/v2/webhookswith the same shape as/v1/webhooks. Existing v1 webhooks keep firing unchanged.
- AddedFree tier: live API key with no card on file. 10 req/min, 7 days of signal history, all query endpoints; no webhooks.
- AddedScale tier ($199/mo): 1,000 req/min, 1-year history, up to 100 webhook subscriptions, Slack Connect support.
- ChangedPricing: Pro replaces Core at $79/mo (down from $99), 500 req/min, 6-month history. Hobby now includes up to 3 webhook subscriptions.
- Added
/v1/signals/{ticker}/{signal}enforces per-plan history depth. Requests withfromolder than the plan ceiling return400 history_window_exceededwithmax_history_days+earliest_allowed_fromin the response body. - ChangedSubscription cancellation falls back to Free instead of revoking API keys — your integration keeps working at Free-tier limits. Webhooks over the new tier limit are auto-disabled (config preserved); resubscribe to re-enable.
- Fixed
GET /v1/signals/{ticker}/{signal}route now registered (previously returned 404 despite being documented).
- AddedInitial public release of the Tickerbot API. Four endpoints under /v1: tickers, signals, scan, webhooks.
- Added
GET /v1/tickers/{ticker}and bulkGET /v1/tickers?tickers=...return the full curated ticker object. - Added
GET /v1/signals/{ticker}/{signal}returns time-series history: numeric bars, continuous-flag windows, or edge-flag triggers depending on the signal type. - Added
GET/POST /v1/scanaccepts a SQL WHERE clause and returns matching tickers. - Added
POST /v1/webhookscreates a SQL-driven webhook that POSTs to your URL once per minute when new tickers enter the match set. State-change deduplication, HMAC-SHA256 signed deliveries, 5-attempt retry. - Added50+ boolean flags + ~50 numeric/string columns documented on the schema page.
- AddedCoverage: ~12,000 US-listed equities and the top 100 cryptocurrencies by market cap.