Tickerbot — The stock market, in SQL

WSSwss://api.tickerbot.io/v2/stream

Hold a socket open and get each subscribed ticker's freshly-computed row the moment the minute data-refresh turns it over. An update frame carries the same record as GET /v2/tickers/{ticker}. Per-minute during US market hours (4 AM–8 PM ET), equities and ETFs; the feed is quiet when the market is closed.

Plan access

Hobby streams up to 10 tickers, Pro up to 100, Scale up to 1,000. Not on Free.

Auth

API key. Send Authorization: Bearer at the handshake, or a first-message auth frame.

Cadence

One update per subscribed ticker per minute turnover. Not a raw trade tape.

Subscribe parameters

tickersstring[]required

Symbols to subscribe on a subscribe frame. Up to 200 per frame; send more frames to add more, capped by your plan.

fieldsstring[] | 'all' | 'default'

Columns in each update. Omit for the default minute set; "all" sends every live column; an array selects specific columns (unknown ones are dropped and listed in the ack).

Server messages

authedframe

Key accepted. Carries your resolved plan.

subscribedframe

Acks a subscribe. Returns count (distinct tickers on the key), plus rejected (over cap) and dropped_fields when present.

updateframe

One ticker's new row: { ticker, as_of, data }. One per subscribed ticker per minute turnover.

unsubscribedframe

Acks an unsubscribe frame.

pongframe

Reply to a ping frame.

Errors

auth_requirederror

First message was not a valid auth frame and no Bearer header was sent. The socket closes.

unauthenticatederror

Malformed, unknown, or revoked API key.

bad_requesterror

tickers missing or empty, or more than 200 symbols in one subscribe frame.

subscription_limiterror

You are subscribed to N of M tickers on your plan. Unsubscribe some or upgrade to add more. Over-cap tickers come back in the subscribed ack's rejected list.

import WebSocket from 'ws'

const ws = new WebSocket('wss://api.tickerbot.io/v2/stream', {
  headers: { Authorization: 'Bearer tb_live_YOUR_KEY' },
})

ws.on('open', () => {
  ws.send(JSON.stringify({ type: 'subscribe', tickers: ['AAPL', 'NVDA'] }))
})
ws.on('message', (buf) => console.log(JSON.parse(buf.toString())))

Try it

The stream needs an authenticated key. Sign in and paste a key to open a live socket, or get a free key. tickerbot.io/dashboard.

Sample frame

{
  "type": "update",
  "ticker": "AAPL",
  "as_of": "2026-07-17T14:32:00.000Z",
  "data": {
    "price": 234.56,
    "day_change_pct": 1.01,
    "volume_today": 45123456,
    "above_sma_200": true
  }
}