The stock market, in SQL.

A computed table of every ticker × every signal. Pull the live state. Pull any past day. Or subscribe — we push the moment state changes.

Free plan. Every ticker, every signal, real-time data, all-time history.

Live133K+ calls served
NVDA 1124.30 +2.41% · breakoutTSLA 248.20 -0.85%AAPL 187.42 +1.80% · above_sma_50PLTR 24.18 +6.21% · breakoutX:BTCUSD 79000.00 +0.00%AMD 198.40 +1.62%RIOT 14.22 +8.41% · gap_upHOOD 24.10 +4.41%MSFT 428.50 +0.32%AVGO 1842.00 +1.94%MARA 22.10 +5.74% · low_volume_regimeCOIN 234.80 +3.10%NVDA 1124.30 +2.41% · breakoutTSLA 248.20 -0.85%AAPL 187.42 +1.80% · above_sma_50PLTR 24.18 +6.21% · breakoutX:BTCUSD 79000.00 +0.00%AMD 198.40 +1.62%RIOT 14.22 +8.41% · gap_upHOOD 24.10 +4.41%MSFT 428.50 +0.32%AVGO 1842.00 +1.94%MARA 22.10 +5.74% · low_volume_regimeCOIN 234.80 +3.10%

the table

The market was always a table. We compute every cell.

Every ticker a row. Every signal a column. Live to the minute.

tickerabove_opening_rangeabove_sma_10above_sma_20above_sma_200above_sma_50above_vwapabove_vwap_minuteafternoon_drift_upat_bollinger_lowerat_bollinger_upperatr_14atr_percentbelow_opening_rangebollinger_lowerbollinger_middlebollinger_pct_bbollinger_squeezebollinger_upperbollinger_widthconsolidating_15mconsolidationdeath_crossdeath_regimeema_12ema_21ema_26ema_9expanded_hourly_rangegolden_crossgolden_regimeheld_above_vwap_30mheld_below_vwap_30mhourly_reversal_bearishhourly_reversal_bullishin_downtrendin_opening_rangein_uptrendlast_hour_rallylast_hour_selloffmacd_above_signalmacd_below_signalmacd_histogrammacd_linemacd_signalmicrospike_downmicrospike_upmomentum_exhaustion_downmomentum_exhaustion_upmomentum_strong_downmomentum_strong_upmorning_strengthnarrow_hourly_rangeopening_drive_downopening_drive_uppct_from_52w_highpct_from_52w_lowpct_from_sma_10pct_from_sma_100pct_from_sma_20pct_from_sma_200pct_from_sma_50pct_from_vwapposition_in_52w_rangepre_close_drift_downpre_close_drift_uppre_earnings_driftprice_down_3pctprice_up_3pctpullbackrange_break_15m_downrange_break_15m_uprange_expansionrapid_move_down_5mrapid_move_up_5mrepeated_test_of_highrepeated_test_of_lowrsi_14rsi_overboughtrsi_oversoldsma_10sma_10_crossed_above_50_todaysma_10_crossed_below_50_todaysma_100sma_20sma_200sma_50sticky_breakoutthree_down_hoursthree_up_hourstrend_longtrend_mediumtrend_reversal_bearish_todaytrend_reversal_bullish_todaytrend_shortvwapvwap_cross_downvwap_cross_upvwap_lower_bandvwap_upper_band
AAPL
MSFT
NVDA
GOOGL
AMZN
META
TSLA

the api

Three key endpoints.

Pull a ticker /v2/tickers/{T}. Pull a signal /v2/signals/{X}. Run a scan /v2/scan. Live, any past day, or pushed the moment state changes.

LIVE · GET /v2/tickers/AAPL
GET /v2/tickers/AAPL
PAST DAY · GET /v2/tickers/AAPL
GET /v2/tickers/AAPL?asof=2024-01-22
PUSHED · POST /v2/tickers/AAPL/subscribe
POST /v2/tickers/AAPL/subscribe
{ "condition": "rsi_oversold AND high_volume_alert" }
response
200·live
{
  "ticker": "AAPL",
  "data": {
    "name": "Apple Inc.",
    "price": 298.74, "day_change_pct": 1.53,
    "market_cap": 4329832548800,
    "rsi_14": 73.21, "above_sma_50": true,
    "golden_cross": false,
    "at_52w_high": false,
    ...
  }
}

where Tickerbot fits

Replaces the stack below your broker.

Everyone else hands you OHLCV bars. We hand you the table — computed market state that’s live, historical, and webhook-ready. Use it as your market data API, technical indicators API, signals API, stock screener API, stock alerts API, or algorithmic trading data layer. Replaces Polygon/Massive, Alpha Vantage, Finnhub, Twelve Data, Databento, Yahoo Finance, and your Postgres warehouse.

LayerBuild it yourselfTickerbot
Market dataPolygon, Alpha Vantage, Finnhub + ingestBuilt in
Signal computeCustom code, or a quant hire413+ signals computed
Query interfacePostgres warehouse + glueSQL across every endpoint
HistoryPoint-in-time indexing + backfill?asof= on every read
Push deliveryBuild webhook infrastructureSigned, retried, idempotent

For agents

Plug Tickerbot into Claude, ChatGPT, and any MCP runtime.

Computed market state an agent can read. Events it can subscribe to. Its context goes to the decision, not the raw data.

Install Tickerbot in Claude, ChatGPT, and your IDE →

get started

Get a key. Run a scan.

Free plan. Every ticker, every signal, real-time data, all-time history.