The stock market API designed for agents.

We serve real-time and historical market data as one queryable table. Your agent turns any question into a query.

Free plan: 10,000 calls a month, no card required.

Live10M+ calls served

The market was always a table. We serve it as one.

Every ticker is a row. Every data point is a column.

	Price																																																										Volume																			Price action																																																												Technicals																																																																Fundamentals																																																																Events																																				Profile																																											Analyst ratings																																									News
ticker	price	min_close	min_high	min_low	min_open	prev_day_high	prev_day_low	prev_day_open	previous_close	price_asof	price_source	above_premarket_high	above_session_open	above_yesterday_close	above_yesterday_high	afterhours_price	at_session_high	at_session_low	below_premarket_low	below_yesterday_low	premarket_price	session_high	session_low	session_open	tested_session_high_recent	tested_session_low_recent	52_week_high	52_week_low	approaching_52w_high	approaching_52w_low	at_20d_high	at_20d_low	at_52w_high	at_52w_low	days_since_52w_high	days_since_52w_low	from_52w_high_pct	from_52w_low_pct	high_20d	high_20d_eod	high_52w	high_52w_date	high_52w_eod	high_5d	high_5d_eod	last_20d_high_date	last_20d_low_date	low_20d	low_20d_eod	low_52w	low_52w_date	low_52w_eod	low_5d	low_5d_eod	position_in_52w_range_pct	at_resistance	at_support	bounce_off_support	avg_volume_10d	avg_volume_30d	day_dollar_volume	min_day_accumulated_dollar_volume	min_day_accumulated_volume	min_dollar_volume	min_trade_count	min_volume	prev_day_volume	volume_today	high_volume_alert	illiquid	low_volume_regime	quiet_minute	relative_volume	volume_burst_3x	volume_burst_5x	volume_change_vs_avg	volume_trend_5d	afterhours_change_pct	change_1d_pct	change_1m_pct	change_1w_pct	change_1y_pct	change_3m_pct	change_6m_pct	change_ytd_pct	day_change	days_down	days_up	from_open_pct	premarket_change_pct	price_down_3pct	price_up_3pct	top_gainer	top_loser	gap_down	gap_down_extreme	gap_filled_today	gap_pct	gap_up	gap_up_extreme	afternoon_drift_up	last_hour_rally	last_hour_selloff	microspike_down	microspike_up	momentum_down	momentum_exhaustion_down	momentum_exhaustion_up	momentum_strong_down	momentum_strong_up	momentum_up	morning_strength	opening_drive_down	opening_drive_up	pre_close_drift_down	pre_close_drift_up	pre_earnings_drift	rapid_move_down_5m	rapid_move_up_5m	three_down_hours	three_up_hours	above_opening_range	below_opening_range	consolidating_15m	consolidation	expanded_hourly_range	hourly_reversal_bearish	hourly_reversal_bullish	in_opening_range	narrow_hourly_range	pullback	range_break_15m_down	range_break_15m_up	range_expansion	repeated_test_of_high	repeated_test_of_low	sticky_breakout	above_sma_10	above_sma_20	above_sma_200	above_sma_50	above_vwap	above_vwap_minute	day_vwap	death_cross	death_regime	ema_12	ema_21	ema_26	ema_9	from_sma_10_pct	from_sma_100_pct	from_sma_20_pct	from_sma_200_pct	from_sma_50_pct	from_vwap_pct	golden_cross	golden_regime	held_above_vwap_30m	held_below_vwap_30m	min_vwap	prev_day_vwap	sma_10	sma_10_crossed_above_50_today	sma_10_crossed_below_50_today	sma_100	sma_20	sma_200	sma_50	vwap	vwap_cross_down	vwap_cross_up	rsi_14	rsi_7	rsi_overbought	rsi_oversold	stochastic_d	stochastic_k	adx_14	in_downtrend	in_uptrend	macd_above_signal	macd_below_signal	macd_histogram	macd_line	macd_signal	minus_di	plus_di	trend_long	trend_medium	trend_reversal_bearish_today	trend_reversal_bullish_today	trend_short	at_bollinger_lower	at_bollinger_upper	atr_14	atr_pct	bollinger_b	bollinger_lower	bollinger_middle	bollinger_squeeze	bollinger_upper	bollinger_width	vwap_lower_band	vwap_upper_band	basic_earnings_per_share	cost_of_revenue	costs_and_expenses	diluted_eps_ttm	earnings_growth_yoy_pct	ebitda	eps	eps_diluted_fy	fy_period_end	gross_profit	gross_profit_ttm	income_loss_from_continuing_operations_after_tax	income_loss_from_continuing_operations_before_tax	income_tax_expense_benefit	net_income_fy	net_income_loss	net_income_loss_attributable_to_noncontrolling_interest	net_income_loss_attributable_to_parent	net_income_loss_available_to_common_stockholders_basic	nonoperating_income_loss	operating_expenses	operating_income_loss	research_and_development	revenue_by_geography	revenue_by_product	revenue_by_segment	revenue_fy	revenue_growth_yoy_pct	revenue_growth_yoy_quarterly_pct	revenue_per_share_ttm	revenue_ttm	revenues	selling_general_and_administrative_expenses	accounts_payable	assets	book_value	cash_and_short_term_investments	cash_on_hand	current_assets	current_liabilities	equity	equity_attributable_to_noncontrolling_interest	equity_attributable_to_parent	fixed_assets	inventory	liabilities	liabilities_and_equity	long_term_debt	noncurrent_assets	noncurrent_liabilities	other_current_assets	other_current_liabilities	other_noncurrent_assets	total_debt	free_cash_flow	net_cash_flow	net_cash_flow_continuing	net_cash_flow_from_financing_activities	net_cash_flow_from_financing_activities_continuing	net_cash_flow_from_investing_activities	net_cash_flow_from_investing_activities_continuing	net_cash_flow_from_operating_activities	net_cash_flow_from_operating_activities_continuing	cash_ratio	current_ratio	debt_to_equity	gross_margin	high_margin	operating_margin	operating_margin_ttm	profit_margin	profit_margin_ttm	profitable	quick_ratio	return_on_assets	return_on_assets_ttm	return_on_equity	return_on_equity_ttm	beta	cap_class	dividend_yield	enterprise_value	ev_to_ebitda	ev_to_sales	forward_pe	high_beta	high_dividend_yield	large_cap	low_beta	market_cap	mega_cap	micro_cap	mid_cap	nano_cap	pe_ratio	peg_ratio	price_to_book	price_to_cash_flow	price_to_free_cash_flow	price_to_sales	ratios_asof	small_cap	value_stock	basic_average_shares	diluted_average_shares	etf_holders	float_shares	free_float_pct	insiders_pct	institutions_pct	low_float	shares_outstanding	ultra_low_float	weighted_shares_outstanding	days_to_cover	high_short_interest	short_float_pct	short_interest	short_interest_settlement_date	short_volume_ratio	short_volume_spike	days_to_earnings	earnings_approaching	earnings_beat_streak	earnings_date	earnings_date_projected	earnings_fiscal_quarter	earnings_next_week	earnings_published	earnings_report_time	earnings_this_week	earnings_today	earnings_tomorrow	last_earnings_date	last_earnings_surprise	last_earnings_surprise_pct	last_fiscal_quarter_end	last_reported_eps	recently_reported_earnings	dividend	dividend_approaching	dividend_date	dividend_frequency	dividend_payout_ratio	dividend_ttm	ex_dividend_date	ipo_date	ipo_in_7d	pending_ipo	recently_ipoed	buyback_30d	dilution_30d	float_effective_date	split_recent	insider_c_suite_buy	insider_c_suite_sell	insider_cluster_buy	industry	sector	sic_code	sic_description	ticker_category	active	asset_class	asset_type	cik	composite_figi	country	currency_name	delisted_utc	exchange	exchange_mic	incorporation_country	issuer_country	list_date	name	address_address1	address_city	address_postal_code	address_state	branding_icon_url	branding_logo_url	description	fundamentals_basis	homepage_url	inactive_at	inactive_reason	leadership	phone_number	reporting_currency	round_lot	share_class_figi	ticker_root	total_employees	etf_dividend_yield	etf_expense_ratio	etf_inception_date	etf_leveraged	etf_net_assets	etf_turnover	analyst_consensus_rating	analyst_consensus_rating_value	analyst_count_buy	analyst_count_hold	analyst_count_sell	analyst_count_strong_buy	analyst_count_strong_sell	analyst_count_total	analyst_count_with_target	bearish_consensus	bullish_consensus	well_covered	last_rating_action	last_rating_date	last_rating_firm	recent_downgrade	recent_initiation	recent_target_lower	recent_target_raise	recent_upgrade	above_price_target	analyst_consensus_target_price	analyst_target_price_high	analyst_target_price_low	analyst_target_upside_pct	below_price_target	target_downside_above_10pct	target_upside_above_10pct	target_upside_above_25pct	eps_estimate_revision_down_30d	eps_estimate_revision_up_30d	estimate_revised_down	estimate_revised_up	high_earnings_estimate	last_eps_estimate	loss_estimate	next_eps_estimate	next_eps_estimate_high	next_eps_estimate_low	next_revenue_estimate	profitable_estimate	highly_relevant_news_count	latest_news_at	news_sentiment_volatility	news_volume	news_volume_weighted_sentiment	recent_news_count
AAPL	—	—	—	—	—	—	—	—	—	—	—					—					—	—	—	—											—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—				—	—	—	—	—	—	—	—	—	—					—			—	—	—	—	—	—	—	—	—	—	—	—	—	—	—								—																																														—			—	—	—	—	—	—	—	—	—	—					—	—	—			—	—	—	—	—			—	—			—	—	—					—	—	—	—	—	—	—			—			—	—	—	—	—		—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—		—	—	—	—		—	—	—	—	—	—	—	—	—	—	—	—					—					—	—	—	—	—	—	—			—	—	—	—	—	—	—		—		—	—		—	—	—	—		—		—	—		—			—				—	—	—	—	—		—		—	—	—	—	—	—						—					—	—	—	—	—		—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—		—	—	—	—	—	—	—	—	—	—	—				—	—	—							—	—	—	—					—	—				—		—	—	—	—		—	—	—	—	—	—
MSFT	—	—	—	—	—	—	—	—	—	—	—					—					—	—	—	—											—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—				—	—	—	—	—	—	—	—	—	—					—			—	—	—	—	—	—	—	—	—	—	—	—	—	—	—								—																																														—			—	—	—	—	—	—	—	—	—	—					—	—	—			—	—	—	—	—			—	—			—	—	—					—	—	—	—	—	—	—			—			—	—	—	—	—		—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—		—	—	—	—		—	—	—	—	—	—	—	—	—	—	—	—					—					—	—	—	—	—	—	—			—	—	—	—	—	—	—		—		—	—		—	—	—	—		—		—	—		—			—				—	—	—	—	—		—		—	—	—	—	—	—						—					—	—	—	—	—		—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—		—	—	—	—	—	—	—	—	—	—	—				—	—	—							—	—	—	—					—	—				—		—	—	—	—		—	—	—	—	—	—
NVDA	—	—	—	—	—	—	—	—	—	—	—					—					—	—	—	—											—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—				—	—	—	—	—	—	—	—	—	—					—			—	—	—	—	—	—	—	—	—	—	—	—	—	—	—								—																																														—			—	—	—	—	—	—	—	—	—	—					—	—	—			—	—	—	—	—			—	—			—	—	—					—	—	—	—	—	—	—			—			—	—	—	—	—		—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—		—	—	—	—		—	—	—	—	—	—	—	—	—	—	—	—					—					—	—	—	—	—	—	—			—	—	—	—	—	—	—		—		—	—		—	—	—	—		—		—	—		—			—				—	—	—	—	—		—		—	—	—	—	—	—						—					—	—	—	—	—		—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—		—	—	—	—	—	—	—	—	—	—	—				—	—	—							—	—	—	—					—	—				—		—	—	—	—		—	—	—	—	—	—
GOOGL	—	—	—	—	—	—	—	—	—	—	—					—					—	—	—	—											—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—				—	—	—	—	—	—	—	—	—	—					—			—	—	—	—	—	—	—	—	—	—	—	—	—	—	—								—																																														—			—	—	—	—	—	—	—	—	—	—					—	—	—			—	—	—	—	—			—	—			—	—	—					—	—	—	—	—	—	—			—			—	—	—	—	—		—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—		—	—	—	—		—	—	—	—	—	—	—	—	—	—	—	—					—					—	—	—	—	—	—	—			—	—	—	—	—	—	—		—		—	—		—	—	—	—		—		—	—		—			—				—	—	—	—	—		—		—	—	—	—	—	—						—					—	—	—	—	—		—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—		—	—	—	—	—	—	—	—	—	—	—				—	—	—							—	—	—	—					—	—				—		—	—	—	—		—	—	—	—	—	—
AMZN	—	—	—	—	—	—	—	—	—	—	—					—					—	—	—	—											—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—				—	—	—	—	—	—	—	—	—	—					—			—	—	—	—	—	—	—	—	—	—	—	—	—	—	—								—																																														—			—	—	—	—	—	—	—	—	—	—					—	—	—			—	—	—	—	—			—	—			—	—	—					—	—	—	—	—	—	—			—			—	—	—	—	—		—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—		—	—	—	—		—	—	—	—	—	—	—	—	—	—	—	—					—					—	—	—	—	—	—	—			—	—	—	—	—	—	—		—		—	—		—	—	—	—		—		—	—		—			—				—	—	—	—	—		—		—	—	—	—	—	—						—					—	—	—	—	—		—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—		—	—	—	—	—	—	—	—	—	—	—				—	—	—							—	—	—	—					—	—				—		—	—	—	—		—	—	—	—	—	—
META	—	—	—	—	—	—	—	—	—	—	—					—					—	—	—	—											—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—				—	—	—	—	—	—	—	—	—	—					—			—	—	—	—	—	—	—	—	—	—	—	—	—	—	—								—																																														—			—	—	—	—	—	—	—	—	—	—					—	—	—			—	—	—	—	—			—	—			—	—	—					—	—	—	—	—	—	—			—			—	—	—	—	—		—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—		—	—	—	—		—	—	—	—	—	—	—	—	—	—	—	—					—					—	—	—	—	—	—	—			—	—	—	—	—	—	—		—		—	—		—	—	—	—		—		—	—		—			—				—	—	—	—	—		—		—	—	—	—	—	—						—					—	—	—	—	—		—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—		—	—	—	—	—	—	—	—	—	—	—				—	—	—							—	—	—	—					—	—				—		—	—	—	—		—	—	—	—	—	—
TSLA	—	—	—	—	—	—	—	—	—	—	—					—					—	—	—	—											—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—				—	—	—	—	—	—	—	—	—	—					—			—	—	—	—	—	—	—	—	—	—	—	—	—	—	—								—																																														—			—	—	—	—	—	—	—	—	—	—					—	—	—			—	—	—	—	—			—	—			—	—	—					—	—	—	—	—	—	—			—			—	—	—	—	—		—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—		—	—	—	—		—	—	—	—	—	—	—	—	—	—	—	—					—					—	—	—	—	—	—	—			—	—	—	—	—	—	—		—		—	—		—	—	—	—		—		—	—		—			—				—	—	—	—	—		—		—	—	—	—	—	—						—					—	—	—	—	—		—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—	—		—	—	—	—	—	—	—	—	—	—	—				—	—	—							—	—	—	—					—	—				—		—	—	—	—		—	—	—	—	—	—

The table is the API.

/v2/tickers/ returns one ticker’s whole row. /v2/signals/ returns every ticker that matches one column. /v2/scan returns every ticker that matches a WHERE clause. Every read runs live or as of any date.

The question	The query
Is NVDA above its 200-day average?	`GET /v2/tickers/NVDA`
Which stocks are above their 200-day average?	`GET /v2/signals/above_sma_200`
Which of those just beat earnings?	`POST /v2/scan q=above_sma_200 AND last_earnings_surprise_pct > 0`
Which of those are large caps?	`POST /v2/scan q=… AND market_cap > 1e10`
Which were on Jan 22, 2024?	`POST /v2/scan q=… asof=2024-01-22`
Tell me when one joins the list.	`POST /v2/scan/subscribe q=…`

The power is in the columns.

Every ticker gets the same columns. Query any of them, in any combination.

Price· 58

Price levels and records: quotes, bars, session levels, rolling highs and lows, and the signals those levels own.

Volume· 19

How much traded: absolute quantities and averages, and activity relative to baseline.

Price action· 60

How price is moving, read straight off the price record: changes, gaps, momentum episodes, range structures.

Technicals· 68

Named technical indicators (SMA, EMA, VWAP, RSI, MACD, ADX, Bollinger, ATR) and every signal computed through one.

Fundamentals· 121

Company financials: statement lines as reported, the ratios and multiples built on them, share structure, and short positioning.

Events· 36

What happened or is scheduled to happen to the company: earnings, dividends, IPOs, share-capital changes, insider transactions.

Profile· 43

Who and what the security is: classification and identity data, looked up rather than computed.

Analyst ratings· 41

What analysts think: the consensus, each firm’s actions, price targets, and estimates.

News· 6

Signals derived from news coverage: article volume and sentiment.

Ask any question.

Anything you want to know about the market is a query over the table.

Which stocks beat earnings, are above their 200-day, and just had a price target raised?

last_earnings_surprise_pct > 0AND above_sma_200AND recent_target_raiseTry it →

Which large caps are 20% off their high but still growing revenue over 10%?

market_cap > 1e10AND from_52w_high_pct < -20AND revenue_growth_yoy_pct > 10Try it →

Which stocks are at a 52-week high with news behind it?

at_52w_highAND recent_news_count > 0Try it →

Which heavily shorted stocks report earnings this week?

short_float_pct > 20AND earnings_this_weekTry it →

Which large caps yield over 4% and still grew earnings last year?

dividend_yield > 0.04AND earnings_growth_yoy_pct > 0AND market_cap > 1e10Try it →

Which stocks had a golden cross after beating earnings twice in a row?

golden_crossAND earnings_beat_streak >= 2Try it →

Which tech stocks trade under 15 times earnings with positive news sentiment?

sector = 'Technology'AND pe_ratio < 15AND news_volume_weighted_sentiment > 0Try it →

Which ETFs charge under 0.1% and hold over $10B?

etf_expense_ratio < 0.1AND etf_net_assets > 1e10Try it →

Which large caps were below their 200-day at the October 2023 low, on Oct 27, 2023?

NOT above_sma_200AND market_cap > 1e10asof 2023-10-27Try it →

Build any trading tool.

Each one is a few calls to the table.

Stock screener

One SQL WHERE clause screens every ticker server-side.

Build guide →

Backtester

As-of scans give point-in-time candidate sets with no look-ahead or survivorship bias.

Build guide →

Alert bot

Write the condition in SQL, get a push when it fires.

Build guide →

Trading algorithm

Define the entry and exit condition in one SQL q, backtest it as of any past date, subscribe it as a webhook.

Build guide →

AI trading agent

Tickerbot ships as an MCP server: one install, and the whole table is one tool in Claude, Cursor, ChatGPT, or any MCP runtime.

Build guide →

Fintech app

One row per ticker with every signal, aligned series for the widgets, websocket push for freshness.

Build guide →

See how we compare.

Other stock market APIs serve one data type at a time, so any real question is a custom integration. With Tickerbot, your agent just queries the table.

The question	Anywhere else	Tickerbot
Is NVDA above its 200-day average?	A quote call, an indicator call, and the comparison.	Every question is one query.
Which stocks are above their 200-day average?	That for every ticker, rate-limited. Hours, not a step.
Which of those just beat earnings?	A second feed for earnings, and the join.
Which of those are large caps?	A third feed for market caps, and another join.
Which were on Jan 22, 2024?	Every ticker that traded that day, delisted ones included, stored before you asked.
Tell me when one joins the list.	All of that again, on a loop, forever.

10M+ calls served.

What people are saying.

“dude. whoah.”

President, ShopifyHarley Finkelstein

“Tickerbot is insane. It turns Claude into a quant.”

Quantitative Finance MScLounes Vennema

“Best value for hobbyists and advanced traders alike.”

AI Engineer, ImergeRon Reid

Get a key. Run a scan.

Read the docs →

Free plan: 10,000 calls a month, no card required.