tickerbot-io · Schema

TickerRow

A ticker row: the spec columns and flags (see /docs/schema) plus the identity fields. Which columns a read returns depends on the read (`columns`, `full`).

CompanyStock-MarketAPIReal-time-DataHistorical-DataFinancial-Agents

Properties

Name Type Description
ticker stringnull The symbol the row is for.
tenure_start stringnull The date this company began holding the symbol.
tenure_end object The date this company stopped holding the symbol (exclusive); `null` while the tenure is open.
held_at_asof object `true` on an as-of read: the row is the company that held the symbol at that instant.
symbol_reused booleannull `true` when an unrelated company held the symbol before.
predecessors arraynull The unrelated companies that held the symbol before, each with its own `cik` and `composite_figi`.
prior_symbols arraynull This company's earlier tickers: `META` lists `FB`.
current_ticker object On an as-of row: the company's symbol today, the one Series and bars take.
date object On an as-of row: the date of the stored row the read returned.
52_week_high booleannull Price printed a new 52-week high today.
52_week_low booleannull Price printed a new 52-week low today.
above_opening_range booleannull Price is trading above the first 15-minute opening-range high.
above_premarket_high booleannull Close above the pre-market session high.
above_price_target booleannull Current price is above the consensus analyst target.
above_session_open booleannull Close above today’s session-open price.
above_sma_10 booleannull Price is above the 10-day simple moving average.
above_sma_20 booleannull Price is above the 20-day simple moving average.
above_sma_200 booleannull Price is above the 200-day simple moving average.
above_sma_50 booleannull Price is above the 50-day simple moving average.
above_vwap booleannull Price is above today’s volume-weighted average price.
above_vwap_minute booleannull Current price above session VWAP.
above_yesterday_close booleannull Close above the prior session’s close.
above_yesterday_high booleannull Close above the prior session’s intraday high.
accounts_payable numbernull Trade payables to suppliers as of the quarter end.
active booleannull Ticker is actively traded — not delisted or halted.
address_address1 stringnull Company headquarters street address.
address_city stringnull Company headquarters city.
address_postal_code stringnull Company headquarters postal code.
address_state stringnull Company headquarters state or region.
adx_14 numbernull Average Directional Index (14-period): trend strength from 0 to 100.
afterhours_change_pct object Percent change between regular-session close and most recent after-hours print. Sparse — most equities don't trade in after-hours, and the column updates only when a print actually happens.
afterhours_price object Last after-hours price, if available.
afternoon_drift_up booleannull Afternoon session net up.
analyst_consensus_rating stringnull Consensus analyst rating across contributing firms. One of `strong buy`, `buy`, `hold`, `sell`, `strong sell`. NULL for tickers without analyst coverage.
analyst_consensus_rating_value numbernull Consensus rating as a numeric score on the standard 1–5 scale (1 = strong buy, 5 = strong sell). Lower is more bullish.
analyst_consensus_target_price numbernull Mean of contributing analysts' 12-month price targets.
analyst_count_buy numbernull Number of contributing firms rating the ticker as buy.
analyst_count_hold numbernull Number of contributing firms rating the ticker as hold (neutral).
analyst_count_sell numbernull Number of contributing firms rating the ticker as sell.
analyst_count_strong_buy numbernull Number of contributing firms rating the ticker as strong buy.
analyst_count_strong_sell numbernull Number of contributing firms rating the ticker as strong sell.
analyst_count_total numbernull Total number of contributing firms covering the ticker with any rating. Sum of the five `analyst_count_*` buckets. `well_covered` fires when this is at least 10.
analyst_count_with_target numbernull Number of contributing firms whose rating includes a published 12-month price target. Always ≤ `analyst_count_total`.
analyst_target_price_high numbernull Highest single-analyst 12-month price target across contributing firms.
analyst_target_price_low numbernull Lowest single-analyst 12-month price target across contributing firms.
analyst_target_upside_pct numbernull Implied upside from the current price to the consensus target, in percent. `(analyst_consensus_target_price - price) / price * 100`. Negative when price is above target. Recomputed every minute, 4 AM
approaching_52w_high booleannull Price is within 5% of the 52-week high.
approaching_52w_low booleannull Price is within 5% of the 52-week low.
asset_class stringnull Asset class of the ticker: stocks, rates, crypto, or fx.
asset_type stringnull Asset class. One of `equity`, `etf`, or `crypto`.
assets numbernull Total assets on the balance sheet as of the most recently reported quarter.
at_20d_high booleannull Price is at or above the 20-day high.
at_20d_low booleannull Price is at or below the 20-day low.
at_52w_high booleannull Price has traded within 0.5% of the 52-week high this session; once tagged, the boolean stays on for the rest of the session.
at_52w_low booleannull Price has traded within 0.5% of the 52-week low this session; once tagged, the boolean stays on for the rest of the session.
at_bollinger_lower booleannull Price has reached the lower Bollinger band.
at_bollinger_upper booleannull Price has reached the upper Bollinger band.
at_resistance booleannull Price is testing a detected resistance level.
at_session_high booleannull At today’s intraday session high (within tolerance).
at_session_low booleannull At today’s intraday session low (within tolerance).
at_support booleannull Price is testing a detected support level.
atr_14 numbernull 14-day Average True Range.
atr_pct numbernull ATR(14) as a percent of price. Useful as a volatility filter.
avg_volume_10d numbernull 10-day trailing average daily volume.
avg_volume_30d numbernull 30-day trailing average daily volume.
basic_average_shares numbernull Weighted-average basic shares outstanding for the quarter. Denominator for basic EPS.
basic_earnings_per_share numbernull Basic EPS for the most-recently reported quarter. Signed.
bearish_consensus booleannull Consensus analyst rating is `sell` or `strong sell`.
below_opening_range booleannull Price is trading below the first 15-minute opening-range low.
below_premarket_low booleannull Close below the pre-market session low.
below_price_target booleannull Current price is below the consensus analyst target.
below_yesterday_low booleannull Close below the prior session’s intraday low.
beta numbernull Trailing beta vs SPY. Null for issuers with insufficient price history.
bollinger_b numbernull Position within Bollinger bands. 0 = at lower band, 1 = at upper band, >1 = outside.
bollinger_lower numbernull Lower Bollinger band (20-period, 2σ).
bollinger_middle numbernull 20-day SMA — the centerline of the Bollinger band. `bollinger_upper` and `bollinger_lower` are already documented; this fills in the missing middle.
bollinger_squeeze booleannull Bollinger band width compressed to a multi-week low — volatility is contracted.
bollinger_upper numbernull Upper Bollinger band (20-period, 2σ).
bollinger_width numbernull `(bollinger_upper − bollinger_lower) / bollinger_middle`. Normalized width — measures volatility regime. Narrow widths often precede expansion (see the boolean `bollinger_squeeze`).
book_value numbernull Trailing-12m book value per share. Computed from `equity_attributable_to_parent / diluted_average_shares`.
bounce_off_support booleannull Bounced off a detected support level: price tagged the band within three sessions and closed up.
branding_icon_url stringnull URL of the company's square icon image, served by this API: request it with your API key (the same Authorization: Bearer header) and you get the image bytes (PNG or JPEG) with their Content-Type. Null
branding_logo_url stringnull URL of the company's logo image, served by this API: request it with your API key (the same Authorization: Bearer header) and you get the image bytes (SVG when available, else PNG) with their Content-
bullish_consensus booleannull Consensus analyst rating is `strong buy` or `buy`.
buyback_30d booleannull Shares outstanding fell more than 1% over the last 30 days.
cap_class stringnull Market-capitalization tier. One of `nano` (<$50M), `micro` ($50M–$300M), `small` ($300M–$2B), `mid` ($2B–$10B), `large` ($10B–$200B), `mega` (≥$200B), or `unknown` when `market_cap` is null. Updates d
cash_and_short_term_investments numbernull Cash and cash equivalents plus short-term investments from the latest reported balance sheet, in USD. When the balance sheet reports no short-term investments, it equals cash_on_hand. In history, date
cash_on_hand numbernull Cash and cash equivalents from the latest reported balance sheet, in USD. Short-term investments are not included. In history, each value takes effect on the day the company filed it with the SEC; whe
cash_ratio numbernull Cash and cash equivalents divided by current liabilities, from the latest reported balance sheet. Null when current liabilities are not reported. In history, dated from the filing, like cash_on_hand.
change_1d_pct numbernull Percent change vs `previous_close`, as a whole percent (0.5 = 0.5%, not a fraction). Signed. Percent scale on every read — live, `asof` by date and `asof` by timestamp — since the 2026-09-07 cutover (
change_1m_pct numbernull Percent change vs. close ~21 trading days ago. Daily; see `change_1w_pct` for note.
change_1w_pct numbernull Percent change in close vs. the close 5 trading days ago. Computed post-close; does NOT update intraday — use `from_open_pct` + `change_1d_pct` for intraday-aware change.
change_1y_pct numbernull Percent change vs. close ~252 trading days ago.
change_3m_pct numbernull Percent change vs. close ~63 trading days ago.
change_6m_pct numbernull Percent change vs. close ~126 trading days ago.
change_ytd_pct numbernull Percent change since the first trading day of the calendar year.
cik stringnull SEC Central Index Key — the company's identifier in EDGAR filings.
composite_figi stringnull Composite FIGI — Bloomberg's cross-exchange security identifier.
consolidating_15m booleannull Last 15 minutes traded in a tight range.
consolidation booleannull Price is range-bound — the last 5 sessions span less than 5%.
cost_of_revenue numbernull Cost of goods sold for the quarter.
costs_and_expenses numbernull Total costs and expenses reported on the income statement (COGS + opex).
country stringnull Listing locale from the reference vendor, not the issuer's home country. Every US-listed symbol, including ADRs, reports `us`. For where the company is run from and where it is incorporated, use `issu
currency_name stringnull Currency the prices are quoted in (`usd`, `eur`, `gbp`, etc.). Effectively always `usd` for US-listed equities.
current_assets numbernull Assets expected to be converted to cash or used up within 12 months.
current_liabilities numbernull Liabilities due within 12 months — accounts payable, short-term debt, accrued expenses.
current_ratio numbernull Current assets ÷ current liabilities. Short-term liquidity. >1 = able to cover short-term obligations from current assets.
day_change numbernull Absolute change vs `previous_close`.
day_dollar_volume numbernull Today’s cumulative dollar volume traded.
day_vwap numbernull Today’s session volume-weighted average price.
days_down numbernull Consecutive trading days closing lower than the prior close. Resets to 0 on an up day.
days_since_52w_high numbernull Trading days since the most recent 52-week high.
days_since_52w_low numbernull Trading days since the most recent 52-week low.
days_to_cover numbernull Short interest divided by 30-day average daily volume. Trader’s "how many days of normal trading to cover all shorts" measure.
days_to_earnings numbernull Calendar days until next earnings announcement. Negative after report.
days_up numbernull Consecutive trading days closing higher than the prior close. Resets to 0 on a down day.
death_cross booleannull 50-day SMA crossed below 200-day SMA today.
death_regime booleannull Long-term downtrend regime — 50-day SMA below 200-day SMA.
debt_to_equity numbernull Total debt divided by total shareholders' equity. Common leverage ratio; lower = less leveraged.
delisted_utc object
description stringnull Business description of the company.
diluted_average_shares numbernull Weighted-average diluted shares outstanding for the quarter. Denominator for diluted EPS.
diluted_eps_ttm numbernull Trailing-12m diluted EPS.
dilution_30d booleannull Shares outstanding rose more than 3% over the last 30 days.
dividend numbernull Most-recent dividend amount per share.
dividend_approaching booleannull The ex-dividend date falls within the next 7 days.
dividend_date stringnull Ex-dividend date of the most recent dividend: own the stock before this date to receive it. The live row and history carry the same date.
dividend_frequency numbernull Payment frequency: `quarterly`, `monthly`, `semiannual`, `annual`.
dividend_payout_ratio numbernull Trailing 12-month dividends per share divided by trailing diluted EPS (0.25 = a quarter of earnings paid out). Null when EPS is zero, negative or missing.
dividend_ttm numbernull Dividends per share paid over the trailing 12 months, specials included. Null when nothing went ex-dividend in that window.
dividend_yield numbernull Forward dividend yield as a fraction (0.025 = 2.5%). Null for non-payers.
earnings_approaching booleannull Earnings within 3 days.
earnings_beat_streak numbernull Consecutive quarters the company has beaten consensus EPS estimates. Resets to 0 on a miss.
earnings_date stringnull Next earnings announcement date. Where the company has not published one, the date is projected from its own reporting history and earnings_date_projected is true.
earnings_date_projected booleannull True when earnings_date is our projection from the company's own reporting history rather than a published calendar date.
earnings_fiscal_quarter stringnull End date of the fiscal quarter the next earnings report covers (e.g. 2026-10-31). Fiscal, not calendar: it follows the company's own fiscal year.
earnings_growth_yoy_pct numbernull Year-over-year EPS growth percent from the most recently reported quarter vs. the same quarter prior year. Signed; positive = growth.
earnings_next_week booleannull Earnings 8–14 days out — useful for the lead-up swing window.
earnings_published booleannull Earnings report date has passed (next earnings date is in the past).
earnings_report_time stringnull When in the trading day the next earnings will be reported. One of `BMO` (before market open), `AMC` (after market close), `DMH` (during market hours).
earnings_this_week booleannull Earnings announcement scheduled in the next 7 days.
earnings_today booleannull Earnings reported today.
earnings_tomorrow booleannull Earnings reported in 1 calendar day. Pair with `earnings_report_time` to know BMO vs. AMC.
ebitda numbernull Earnings before interest, taxes, depreciation, and amortization (TTM).
ema_12 numbernull 12-day EMA. Fast-side input of canonical MACD (`macd = ema_12 − ema_26`).
ema_21 numbernull 21-day EMA. Often paired with `ema_9` for short-trend bias; also serves as a dynamic-support reference.
ema_26 numbernull 26-day EMA. Slow-side input of canonical MACD (`macd = ema_12 − ema_26`).
ema_9 numbernull 9-day exponential moving average of close. Most-recent-weighted; reacts faster than the same-period SMA. Commonly paired with `ema_21` for short-trend bias.
enterprise_value numbernull Market cap + total debt − cash.
eps numbernull Earnings per share (trailing twelve months).
eps_diluted_fy numbernull diluted EPS, last reported fiscal year
eps_estimate_revision_down_30d numbernull Count of analysts who lowered their next-quarter EPS estimate in the last 30 days.
eps_estimate_revision_up_30d numbernull Count of analysts who raised their next-quarter EPS estimate in the last 30 days. A positive read on forward sentiment momentum.
equity numbernull Total shareholders' equity.
equity_attributable_to_noncontrolling_interest numbernull Equity attributable to minority shareholders of consolidated subsidiaries. Usually 0 for non-conglomerates.
equity_attributable_to_parent numbernull Equity attributable to the parent entity's shareholders (excludes minority interest).
estimate_revised_down booleannull At least one analyst lowered their next-quarter EPS estimate in the last 30 days.
estimate_revised_up booleannull At least one analyst raised their next-quarter EPS estimate in the last 30 days.
etf_dividend_yield object Dividend yield as reported by the fund, as a fraction. ETFs only.
etf_expense_ratio object Net expense ratio as a fraction (0.0009 = 0.09% a year). ETFs only.
etf_holders arraynull ETFs that hold this ticker, ordered by the ticker's weight within each (the reverse of ETF holdings). Filter with array operators in /v2/scan, e.g. `'SPY' = ANY(etf_holders)` to find SPY constituents.
etf_inception_date object Date the fund launched. ETFs only.
etf_leveraged object True for leveraged and inverse-leveraged funds. ETFs only.
etf_net_assets object Fund net assets (assets under management) in USD. ETFs only.
etf_turnover object Portfolio turnover as a fraction per year (0.03 = 3%). ETFs only.
ev_to_ebitda numbernull `enterprise_value` ÷ `ebitda`. Capital-structure-neutral profitability multiple.
ev_to_sales numbernull `enterprise_value` ÷ `revenue_ttm`. Capital-structure-neutral revenue multiple.
ex_dividend_date stringnull The nearest announced ex-dividend date; once it passes with no new one announced, the most recent one.
exchange stringnull Primary listing exchange, human-readable name — e.g. `NASDAQ`, `NYSE`, `NYSE Arca`, `Cboe BZX`, `NYSE American`, `OTC Markets`. See `exchange_mic` for the raw ISO 10383 code. Null for a small number o
exchange_mic stringnull Primary listing exchange as an ISO 10383 **MIC code**: `XNAS` = NASDAQ, `XNYS` = NYSE, `ARCX` = NYSE Arca, `BATS` = Cboe BZX, `XASE` = NYSE American. The `?exchange=` filter accepts either this code o
expanded_hourly_range booleannull This hour’s range is unusually wide.
fixed_assets numbernull Property, plant, and equipment (PP&E), net of accumulated depreciation.
float_effective_date stringnull As-of date for the current float-shares figure.
float_shares numbernull Public float (shares available to trade).
forward_pe numbernull Forward price-to-earnings ratio using next-12m consensus EPS. Lower = cheaper on forward basis.
free_cash_flow numbernull Operating cash flow minus capital expenditures. Cash the business generates above what it needs to maintain operations.
free_float_pct numbernull Percent of shares outstanding actually available for trading (excludes insider / restricted holdings).
from_52w_high_pct numbernull Percent distance from the 52-week high, as a whole percent. Signed: negative below the high (−27 = 27% under it), 0 at it, positive only on a new high before the window updates. Use the `at_52w_high`
from_52w_low_pct numbernull Percent distance above the 52-week low, as a whole percent (22 = 22% above it). Signed; ≥ 0 except at a new low before the window updates. Use the `at_52w_low` boolean to test lows.
from_open_pct numbernull Intraday: percent change from today’s session open to the latest snapshot price. Resets at session boundary.
from_sma_10_pct numbernull Percent difference between current close and `sma_10`. Positive = above MA, negative = below. Continuous version of the `above_sma_10` boolean.
from_sma_100_pct numbernull Percent difference between current close and `sma_100`. Daily-cadence because the slow MA changes slowly.
from_sma_20_pct numbernull Percent difference between current close and `sma_20`. Continuous version of the `above_sma_20` boolean.
from_sma_200_pct numbernull Percent distance from the 200-day SMA. Negative when price is below the average.
from_sma_50_pct numbernull Percent distance from the 50-day SMA. Negative when price is below the average.
from_vwap_pct numbernull Percent distance from today’s VWAP.
fundamentals_basis object 'annual' on rows whose fundamentals come from a listed ADR's yearly 20-F (SEC companyfacts) instead of the usual 10-K/10-Q flow; null otherwise. TTM fields on an 'annual' row carry the latest fiscal y
fy_period_end stringnull end date of the fiscal year the _fy columns describe
gap_down booleannull Today opened 3%+ below prior close.
gap_down_extreme booleannull Today opened 10%+ below prior close.
gap_filled_today booleannull Today’s opening gap was closed by an intraday move.
gap_pct numbernull Percent change of `session_open` vs `previous_close`. One value per session.
gap_up booleannull Today opened 3%+ above prior close.
gap_up_extreme booleannull Today opened 10%+ above prior close.
golden_cross booleannull 50-day SMA crossed above 200-day SMA today.
golden_regime booleannull Long-term uptrend regime — 50-day SMA above 200-day SMA.
gross_margin numbernull `gross_profit / revenues` for the quarter.
gross_profit numbernull `revenues − cost_of_revenue` for the quarter.
gross_profit_ttm numbernull Trailing-12m gross profit.
held_above_vwap_30m booleannull Price has stayed above session VWAP without dipping for at least 30 minutes.
held_below_vwap_30m booleannull Price has stayed below session VWAP without lifting for at least 30 minutes.
high_20d numbernull Highest trade in the trailing 20 trading days.
high_20d_eod numbernull Highest close over the last 20 trading sessions. Close-basis. For the intraday-wick variant use `at_20d_high`.
high_52w numbernull Highest trade in the trailing 52 weeks (live, includes today).
high_52w_date stringnull Date the trailing-52-week high was set. Useful for "fresh 52w highs in the last 30 days" scans.
high_52w_eod numbernull Highest close over the trailing 52 weeks. The `_eod` distinguishes from the canonical intraday `52_week_high` (which captures wicks).
high_5d numbernull Highest intraday high over the last 5 trading sessions, inclusive of the current session.
high_5d_eod numbernull Highest close over the last 5 trading sessions. Close-basis (no intraday wicks) — pair with `high_5d` to distinguish.
high_beta booleannull Beta above 2.0: moves much more than the market.
high_dividend_yield booleannull Dividend yield above 4%.
high_earnings_estimate booleannull Consensus next-quarter EPS estimate exceeds an absolute $1.00 per share threshold.
high_margin booleannull Trailing-twelve-month profit margin is above 20%.
high_short_interest booleannull More than 20% of the float is sold short.
high_volume_alert booleannull Volume is running well above its 10-day average. On the live row: this minute traded more than 5x a typical minute. In daily history: the day traded at least 2x its 10-day average.
highly_relevant_news_count numbernull How many articles in the last 7 days scored this name's relevance at 0.6 or higher.
homepage_url stringnull Company homepage URL.
hourly_reversal_bearish booleannull Higher high, lower close than the prior hour.
hourly_reversal_bullish booleannull Lower low, higher close than the prior hour.
illiquid booleannull Thinly traded — 10-day average volume is under 100k shares.
in_downtrend booleannull Stacked downtrend across short, medium, and long horizons.
in_opening_range booleannull Price is inside the first-hour high/low range.
in_uptrend booleannull Stacked uptrend across short, medium, and long horizons.
inactive_at object When the ticker was marked inactive.
inactive_reason object Why the ticker was marked inactive (e.g. delisted, stale data).
income_loss_from_continuing_operations_after_tax numbernull After-tax income from continuing operations for the quarter.
income_loss_from_continuing_operations_before_tax numbernull Pre-tax income from continuing operations for the quarter.
income_tax_expense_benefit numbernull Income tax expense (positive) or benefit (negative) for the quarter.
incorporation_country stringnull Where the issuer is legally incorporated: the ISO 3166-1 alpha-2 country code (lower-case) of its state or country of incorporation in its SEC filings; US states map to `us`. `ky` for Huize (Cayman-in
industry stringnull GICS industry within the sector.
insider_c_suite_buy booleannull A top officer (CEO, CFO, COO, President or Chair) or a director bought shares on the open market in the last 7 days.
insider_c_suite_sell booleannull A top officer (CEO, CFO, COO, President or Chair) or a director sold shares on the open market in the last 7 days.
insider_cluster_buy booleannull Two or more different insiders bought shares on the open market in the last 14 days.
insiders_pct numbernull Percent of shares held by company insiders (executives, directors, founders).
institutions_pct numbernull Percent of shares held by institutional investors (mutual funds, ETFs, pensions).
inventory numbernull Inventory on hand. NULL for service and financial companies that don't carry inventory.
ipo_date stringnull Date of the company's IPO, when known.
ipo_in_7d booleannull A firm IPO listing date falls within the next 7 days.
issuer_country stringnull Where the company is run from: the ISO 3166-1 alpha-2 country code (lower-case) of the issuer's business address in its SEC filings. `cn` for Huize (HUIZ), `us` for Apple. Null when the symbol has no
large_cap booleannull Market cap between $10B and $200B.
last_20d_high_date stringnull Date the trailing-20-day high was set.
last_20d_low_date stringnull Date the trailing-20-day low was set.
last_earnings_date stringnull Date of the company's most recent earnings report.
last_earnings_surprise numbernull `last_reported_eps − last_eps_estimate`. Signed; positive = beat.
last_earnings_surprise_pct numbernull Reported EPS versus the consensus estimate for the same quarter, as a percent of the estimate. Reported EPS can include one-time items that consensus excludes, so a large surprise is not always an ope
last_eps_estimate numbernull Consensus EPS estimate going into the most recent earnings announcement.
last_fiscal_quarter_end stringnull End date of the fiscal quarter covered by the most recent earnings report.
last_hour_rally booleannull Final hour of session net up.
last_hour_selloff booleannull Final hour of session net down.
last_rating_action stringnull Action taken in the most recent rating change. Common values: `upgrades`, `downgrades`, `initiates_coverage_on`, `maintains`, `reiterates`, `assumes`, `reinstates`, `suspends`.
last_rating_date stringnull Date of the most recent rating action across all firms covering the ticker.
last_rating_firm stringnull Name of the firm that issued the most recent rating action.
last_reported_eps numbernull EPS as reported in the most recent earnings announcement, including one-time items.
latest_news_at stringnull Publish time of the newest news article that mentions the ticker.
leadership arraynull Current C-suite: a list of {name, title} (CEO, President, CFO, COO, CTO, other Chief officers, General Counsel), from SEC Forms 3/4/5. Empty for companies that file none (foreign private issuers, fund
liabilities numbernull Total liabilities on the balance sheet.
liabilities_and_equity numbernull Total liabilities + total equity. Should equal `assets` (balance-sheet identity). Documented for completeness — useful as a sanity check rather than a scan target.
list_date stringnull Date the symbol was first listed on its exchange.
long_term_debt numbernull Long-term debt from the most recent reported balance sheet, including capital-lease obligations, in USD. Null when the issuer does not break it out from noncurrent liabilities.
loss_estimate booleannull Analyst consensus expects negative EPS for the upcoming report.
low_20d numbernull Lowest trade in the trailing 20 trading days.
low_20d_eod numbernull Lowest close over the last 20 trading sessions. Close-basis.
low_52w numbernull Lowest trade in the trailing 52 weeks (live, includes today).
low_52w_date stringnull Date the trailing-52-week low was set.
low_52w_eod numbernull Lowest close over the trailing 52 weeks.
low_5d numbernull Lowest intraday low over the last 5 trading sessions, inclusive of the current session.
low_5d_eod numbernull Lowest close over the last 5 trading sessions. Close-basis.
low_beta booleannull Beta below 0.5 — moves much less than the market.
low_float booleannull Public float under 50 million shares.
low_volume_regime booleannull In a sustained quiet stretch — the last 30 minutes traded at or below 30% of this name's usual volume for this time of day.
macd_above_signal booleannull MACD line is above its signal line.
macd_below_signal booleannull MACD line is below its signal line.
macd_histogram numbernull MACD line minus signal. Positive when bullish, negative when bearish.
macd_line numbernull MACD line (12-EMA minus 26-EMA).
macd_signal numbernull MACD signal line (9-EMA of MACD line).
market_cap numbernull Market capitalization. Updated daily; intraday change derived from `price` × `shares_outstanding`.
mega_cap booleannull Market cap above $200B.
micro_cap booleannull Market cap between $50M and $300M.
microspike_down booleannull Single 1-minute candle return ≤ −1%.
microspike_up booleannull Single 1-minute candle return ≥ +1%.
mid_cap booleannull Market cap between $2B and $10B.
min_close numbernull Current minute bar’s most-recent close (last print).
min_day_accumulated_dollar_volume numbernull Today’s cumulative dollar volume across the session so far.
min_day_accumulated_volume numbernull Today’s cumulative shares traded across the session so far (4 AM ET onward).
min_dollar_volume numbernull Current minute bar’s dollar volume (close × volume approximation).
min_high numbernull Current minute bar’s running high.
min_low numbernull Current minute bar’s running low.
min_open numbernull Current minute bar’s open. Updates every minute, 4 AM to 8 PM ET.
min_trade_count numbernull Current minute bar’s number of trades.
min_volume numbernull Current minute bar’s accumulated shares traded.
min_vwap numbernull Current minute bar’s volume-weighted average price.
minus_di numbernull -DI (14-period): the bearish directional-movement component of the ADX system.
momentum_down booleannull Sustained downward momentum on the daily bars.
momentum_exhaustion_down booleannull Downward momentum showing signs of exhaustion.
momentum_exhaustion_up booleannull Upward momentum showing signs of exhaustion.
momentum_strong_down booleannull Strong downward momentum across multiple measures.
momentum_strong_up booleannull Strong upward momentum across multiple measures.
momentum_up booleannull Sustained upward momentum on the daily bars.
morning_strength booleannull First two hours of session net positive.
name stringnull Company or asset display name.
nano_cap booleannull Market cap below $50M.
narrow_hourly_range booleannull This hour’s range is unusually narrow.
net_cash_flow numbernull Sum of operating + investing + financing cash flow — period change in cash.
net_cash_flow_continuing numbernull Total cash flow excluding discontinued operations. Rare line item — populated only for companies in active discontinued-ops winddown.
net_cash_flow_from_financing_activities numbernull Net cash from financing (debt, dividends, buybacks).
net_cash_flow_from_financing_activities_continuing numbernull Financing cash flow excluding discontinued operations.
net_cash_flow_from_investing_activities numbernull Net cash from investing activities (capex, acquisitions). Negative for net spend.
net_cash_flow_from_investing_activities_continuing numbernull Investing cash flow excluding discontinued operations.
net_cash_flow_from_operating_activities numbernull Net cash from operations for the quarter.
net_cash_flow_from_operating_activities_continuing numbernull Same as `net_cash_flow_from_operating_activities` but excludes discontinued operations.
net_income_fy numbernull net income attributable to the company, last reported fiscal year (USD)
net_income_loss numbernull Bottom-line net income/loss for the quarter. Signed.
net_income_loss_attributable_to_noncontrolling_interest numbernull Portion of net income attributable to minority owners of consolidated subsidiaries. Usually 0 for non-conglomerates.
net_income_loss_attributable_to_parent numbernull Net income attributable to the parent entity (excludes noncontrolling interest).
net_income_loss_available_to_common_stockholders_basic numbernull Net income available to common shareholders — numerator for basic EPS.
news_sentiment_volatility numbernull How much the news sentiment about this name has been swinging over the last 7 days.
news_volume numbernull Today's news flow compared with normal: articles about this name in the last 24 hours (relevance 0.6 or higher), divided by its median daily count over the prior 30 days (the median is never below 1).
news_volume_weighted_sentiment numbernull The sentiment of today's news, scaled by how unusual the volume is. It is the relevance-weighted average sentiment of the last 24 hours' scored articles (relevance 0.6 or higher), times `tanh(max(0, n
next_eps_estimate numbernull Wall Street consensus EPS estimate for the next reported quarter — weighted average across analyst contributors.
next_eps_estimate_high numbernull Highest single-analyst EPS estimate for the next reported quarter.
next_eps_estimate_low numbernull Lowest single-analyst EPS estimate for the next reported quarter.
next_revenue_estimate numbernull Wall Street consensus revenue estimate (USD, full dollars) for the next reported quarter.
noncurrent_assets numbernull Long-lived assets — property, plant, equipment, intangibles, long-term investments.
noncurrent_liabilities numbernull Liabilities due beyond 12 months — long-term debt, deferred taxes, pension obligations.
nonoperating_income_loss numbernull Non-operating income/loss (interest income, gains/losses on investments, etc.) for the quarter. Signed.
opening_drive_down booleannull First 5 minutes of session down < −0.5%.
opening_drive_up booleannull First 5 minutes of session up > +0.5%.
operating_expenses numbernull Sum of operating costs reported on the income statement for the quarter (excludes COGS).
operating_income_loss numbernull Operating income or loss for the quarter. Signed.
operating_margin numbernull `operating_income_loss / revenues` for the quarter.
operating_margin_ttm numbernull Trailing-12m operating margin.
other_current_assets numbernull Current assets not separately broken out (prepaid expenses, short-term receivables, etc.).
other_current_liabilities numbernull Current liabilities not separately broken out.
other_noncurrent_assets numbernull Non-current assets not separately broken out (intangibles, deferred tax assets, etc.).
pe_ratio numbernull Price-to-earnings ratio (trailing twelve months). Null for unprofitable issuers.
peg_ratio numbernull PE ratio divided by EPS growth rate. Sparsely populated — PEG is only computed for tickers with positive earnings growth and analyst coverage.
pending_ipo booleannull The ticker is in the IPO calendar but has not started trading.
phone_number stringnull Company contact phone number.
plus_di numbernull +DI (14-period): the bullish directional-movement component of the ADX system.
position_in_52w_range_pct numbernull Where the live price sits in the 52-week range, 0–100. 0 = at low, 100 = at high.
pre_close_drift_down booleannull Last 10 minutes before close net down.
pre_close_drift_up booleannull Last 10 minutes before close net up.
pre_earnings_drift booleannull Stock has moved ≥5% (absolute) over the trailing week with earnings within 7 days — a setup the literature shows often continues through the report.
premarket_change_pct numbernull Pre-market: percent change from the previous session close to the latest pre-market print. Resets at session boundary.
premarket_price numbernull Last premarket price, if available.
prev_day_high numbernull Previous trading day’s session high.
prev_day_low numbernull Previous trading day’s session low.
prev_day_open numbernull Previous trading day’s official open.
prev_day_volume numbernull Previous trading day’s total volume (raw shares).
prev_day_vwap numbernull Previous trading day’s session VWAP.
previous_close numbernull Official prior-session close.
price numbernull Current price: the newest source we hold for the ticker, in a fixed order; price_source says which one.
price_asof stringnull The time of the data behind the price.
price_down_3pct booleannull Intraday move of -3% or worse vs prior close.
price_source stringnull Where the row's price came from.
price_to_book numbernull Current price ÷ `book_value`. Common value-investing metric.
price_to_cash_flow numbernull Current price ÷ operating cash flow per share. Less manipulable than P/E.
price_to_free_cash_flow numbernull Current price ÷ `free_cash_flow` per share. Strictest cash-based valuation.
price_to_sales numbernull Current price ÷ `revenue_per_share_ttm`. Often used when companies have no earnings.
price_up_3pct booleannull Intraday move of 3%+ vs prior close.
profit_margin numbernull Net income ÷ revenue. Quarterly.
profit_margin_ttm numbernull Trailing-12m profit margin.
profitable booleannull Most-recently-reported quarter had positive net income.
profitable_estimate booleannull Analyst consensus expects positive EPS for the upcoming report.
pullback booleannull Pullback to the 20-day moving average within an uptrend.
quick_ratio numbernull (Current assets − inventory) ÷ current liabilities. Stricter liquidity — assumes inventory isn't quickly convertible.
quiet_minute booleannull A sustained quiet stretch — 10-minute volume average well below recent baseline.
range_break_15m_down booleannull Broke below the prior 15-minute low.
range_break_15m_up booleannull Broke above the prior 15-minute high.
range_expansion booleannull Today's true range > 2 × ATR(14) with volume — direction-agnostic regime-change tag.
rapid_move_down_5m booleannull Price down more than −0.5% in the last 5 minutes.
rapid_move_up_5m booleannull Price up more than +0.5% in the last 5 minutes.
ratios_asof stringnull Date of the financial data behind the valuation ratios (P/E, price-to-book, EV/EBITDA and the rest). Compare with price_asof to see how current a ratio is.
recent_downgrade booleannull At least one analyst downgraded the ticker in the last 7 days.
recent_initiation booleannull At least one analyst initiated coverage in the last 7 days.
recent_news_count numbernull How many articles mentioned this name in the last 7 days, at any relevance.
recent_target_lower booleannull At least one analyst lowered their price target in the last 7 days.
recent_target_raise booleannull At least one analyst raised their price target in the last 7 days.
recent_upgrade booleannull At least one analyst upgraded the ticker in the last 7 days.
recently_ipoed booleannull The company listed within the last 90 days.
recently_reported_earnings booleannull Reported earnings within the last 5 days.
relative_volume numbernull Ratio of today’s pace-adjusted volume to the 10-day average. 2.0 means 2× normal.
repeated_test_of_high booleannull Tested today’s session high three or more times — failed-breakout setup.
repeated_test_of_low booleannull Tested today’s session low three or more times — failed-breakdown setup.
reporting_currency object The currency this ticker's SEC fundamentals were originally reported in (e.g. 'TWD', 'CNY'). Every fundamentals figure on the row is converted to USD; this field discloses the original currency.
research_and_development numbernull R&D spend for the quarter. NULL for companies that don't report R&D as a line item.
return_on_assets numbernull Net income ÷ total assets. Quarterly figure.
return_on_assets_ttm numbernull Trailing-12m return on assets.
return_on_equity numbernull Net income ÷ shareholders' equity. Quarterly figure.
return_on_equity_ttm numbernull Trailing-12m return on equity.
revenue_by_geography arraynull Latest published revenue breakdown by geography: a list of {name, revenue, revenue_usd, share, period_end, fiscal_year, fiscal_period, currency} from the company's SEC filings. Null when no breakdown
revenue_by_product arraynull Latest published revenue breakdown by product or service line: a list of {name, revenue, revenue_usd, share, period_end, fiscal_year, fiscal_period, currency} from the company's SEC filings. Null when
revenue_by_segment arraynull Latest published revenue breakdown by business segment: a list of {name, revenue, revenue_usd, share, period_end, fiscal_year, fiscal_period, currency} from the company's SEC filings. Null when no bre
revenue_fy numbernull revenue, last reported fiscal year (USD)
revenue_growth_yoy_pct numbernull Year-over-year revenue growth: most-recent quarter vs same quarter prior year. Signed; positive = growth.
revenue_growth_yoy_quarterly_pct numbernull YoY quarterly revenue growth. Signed.
revenue_per_share_ttm numbernull Trailing-12m revenue divided by diluted shares outstanding. USD per share.
revenue_ttm numbernull Trailing-twelve-month revenue: the sum of the four most recent fiscal quarters filed by that day.
revenues numbernull Total revenue for the most-recently reported quarter, from filed income statements.
round_lot numbernull Standard trading lot size for the symbol.
rsi_14 numbernull Relative Strength Index, 14-period. Range 0–100.
rsi_7 numbernull Relative Strength Index over 7 periods - a faster, more sensitive RSI. Range 0-100.
rsi_overbought booleannull RSI(14) is in overbought territory.
rsi_oversold booleannull RSI(14) is in oversold territory.
sector stringnull GICS sector. One of: Technology, Healthcare, Financials, Consumer Discretionary, Consumer Staples, Energy, Industrials, Materials, Utilities, Real Estate, Communication Services.
selling_general_and_administrative_expenses numbernull SG&A for the quarter.
session_high numbernull Highest trade so far today.
session_low numbernull Lowest trade so far today.
session_open numbernull Today’s opening print.
share_class_figi stringnull Share-class FIGI — Bloomberg identifier for this specific share class.
shares_outstanding numbernull Total shares outstanding.
short_float_pct numbernull Short interest as a fraction of the free float. 0.10 = 10% of float is short.
short_interest numbernull Raw shares-shorted count as last reported (FINRA bi-monthly). Pair with `short_interest_settlement_date` (profile.ts) for the as-of date.
short_interest_settlement_date stringnull Settlement date of the most recent short-interest report.
short_volume_ratio numbernull Share of the day's volume executed as short sales (0–1).
short_volume_spike booleannull More than 60% of the day's volume was executed as short sales.
sic_code stringnull SIC code — the SEC's Standard Industrial Classification for the company's industry.
sic_description stringnull Plain-text label for the company's SIC industry code.
sma_10 numbernull 10-day simple moving average.
sma_10_crossed_above_50_today booleannull The 10-day SMA crossed above the 50-day SMA today — a short-term bullish cross.
sma_10_crossed_below_50_today booleannull The 10-day SMA crossed below the 50-day SMA today — a short-term bearish cross.
sma_100 numbernull 100-day simple moving average of close. Slower than `sma_50`, faster than `sma_200` — useful for intermediate-term trend.
sma_20 numbernull 20-day simple moving average.
sma_200 numbernull 200-day simple moving average.
sma_50 numbernull 50-day simple moving average.
small_cap booleannull Market cap between $300M and $2B.
split_recent booleannull A stock split occurred in the last 7 days or is scheduled within 14 days.
sticky_breakout booleannull Latches on when price makes a 52-week high and stays on until the nightly reset — a persistent breakout tag.
stochastic_d numbernull Stochastic oscillator %D: 3-period smoothing of %K.
stochastic_k numbernull Stochastic oscillator %K: where price sits within its recent high-low range, 0-100.
target_downside_above_10pct booleannull Current price is more than 10% above the consensus target — significant implied downside.
target_upside_above_10pct booleannull Consensus price target implies more than 10% upside from the current price.
target_upside_above_25pct booleannull Consensus price target implies more than 25% upside from the current price.
tested_session_high_recent booleannull Price touched today’s session high within the last 5 minutes.
tested_session_low_recent booleannull Price touched today’s session low within the last 5 minutes.
three_down_hours booleannull Three consecutive lower hourly closes.
three_up_hours booleannull Three consecutive higher hourly closes.
ticker_category object Sub-class within an asset class, e.g. treasury_curve or policy_rate.
ticker_root stringnull Root symbol — the base ticker without class or suffix modifiers.
top_gainer booleannull Among the session's top 20 gainers.
top_loser booleannull Among the session's top 20 losers.
total_debt numbernull Total debt from the latest reported balance sheet, in USD: short-term borrowings and the current portion of long-term debt, plus long-term debt including capital-lease obligations. In history, dated f
total_employees numbernull Number of full-time employees as last reported. Useful for size-based filters ("small-cap by employee count").
trend_long stringnull Long-term trend classification from `sma_200` slope. One of `uptrend`, `downtrend`, `sideways`.
trend_medium stringnull Medium-term trend classification from `sma_50` slope. One of `uptrend`, `downtrend`, `sideways`.
trend_reversal_bearish_today booleannull Trend flipped from up to down today.
trend_reversal_bullish_today booleannull Trend flipped from down to up today.
trend_short stringnull Short-term trend classification from short-MA slope. One of `uptrend`, `downtrend`, `sideways`.
ultra_low_float booleannull Float below 5M shares — extremely thin supply.
value_stock booleannull Trades at a value-style P/E.
volume_burst_3x booleannull Current minute volume ≥ 3× recent average.
volume_burst_5x booleannull Current minute volume ≥ 5× recent average.
volume_change_vs_avg numbernull Ratio of today’s pace-adjusted volume to its 10-day average. Numeric surface of the same denominator `relative_volume` uses.
volume_today numbernull Shares traded so far today.
volume_trend_5d stringnull Slope of daily volume regressed over the last 5 trading days. Positive = building, negative = drying.
vwap numbernull Daily volume-weighted average price from market open through the most recent print. Updates intraday with each new tick.
vwap_cross_down booleannull Crossed below session VWAP this minute.
vwap_cross_up booleannull Crossed above session VWAP this minute.
vwap_lower_band numbernull VWAP − 2 standard deviations. Dynamic support reference.
vwap_upper_band numbernull VWAP + 2 standard deviations of intraday price action. Dynamic resistance reference.
weighted_shares_outstanding numbernull Weighted shares outstanding from the latest 10-Q / 10-K. Used by `market_cap = price × weighted_shares_outstanding`.
well_covered booleannull Ten or more analyst firms cover the ticker.
View JSON Schema on GitHub

JSON Schema

tickerbot-io-ticker-row-schema.json Raw ↑ 
{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "$id": "https://artifacts.apis.io/tickerbot-io/json-schema/tickerbot-io-ticker-row-schema.json",
  "title": "TickerRow",
  "description": "A ticker row: the spec columns and flags (see /docs/schema) plus the identity fields. Which columns a read returns depends on the read (`columns`, `full`).",
  "x-generated": "2026-10-31",
  "x-method": "derived",
  "x-generator": "derive-json-schema.py",
  "x-source": "openapi/tickerbot-io-openapi.yaml#/components/schemas/TickerRow",
  "type": "object",
  "properties": {
    "ticker": {
      "type": [
        "string",
        "null"
      ],
      "description": "The symbol the row is for."
    },
    "tenure_start": {
      "type": [
        "string",
        "null"
      ],
      "description": "The date this company began holding the symbol."
    },
    "tenure_end": {
      "description": "The date this company stopped holding the symbol (exclusive); `null` while the tenure is open."
    },
    "held_at_asof": {
      "description": "`true` on an as-of read: the row is the company that held the symbol at that instant."
    },
    "symbol_reused": {
      "type": [
        "boolean",
        "null"
      ],
      "description": "`true` when an unrelated company held the symbol before."
    },
    "predecessors": {
      "type": [
        "array",
        "null"
      ],
      "description": "The unrelated companies that held the symbol before, each with its own `cik` and `composite_figi`.",
      "items": {
        "properties": {
          "name": {
            "description": "The earlier holder's name."
          },
          "cik": {
            "description": "The earlier holder's SEC CIK."
          },
          "composite_figi": {
            "description": "The earlier holder's composite FIGI; `null` where none is on record."
          },
          "tenure_start": {
            "description": "The date the earlier holder began holding the symbol."
          },
          "tenure_end": {
            "description": "The date the earlier holder stopped holding the symbol (exclusive)."
          }
        }
      }
    },
    "prior_symbols": {
      "type": [
        "array",
        "null"
      ],
      "description": "This company's earlier tickers: `META` lists `FB`.",
      "items": {
        "properties": {
          "ticker": {
            "description": "The earlier ticker."
          },
          "tenure_start": {
            "description": "The date the company began trading under it."
          },
          "tenure_end": {
            "description": "The date the company stopped trading under it (exclusive)."
          }
        }
      }
    },
    "current_ticker": {
      "description": "On an as-of row: the company's symbol today, the one Series and bars take."
    },
    "date": {
      "description": "On an as-of row: the date of the stored row the read returned."
    },
    "52_week_high": {
      "type": [
        "boolean",
        "null"
      ],
      "description": "Price printed a new 52-week high today."
    },
    "52_week_low": {
      "type": [
        "boolean",
        "null"
      ],
      "description": "Price printed a new 52-week low today."
    },
    "above_opening_range": {
      "type": [
        "boolean",
        "null"
      ],
      "description": "Price is trading above the first 15-minute opening-range high."
    },
    "above_premarket_high": {
      "type": [
        "boolean",
        "null"
      ],
      "description": "Close above the pre-market session high."
    },
    "above_price_target": {
      "type": [
        "boolean",
        "null"
      ],
      "description": "Current price is above the consensus analyst target."
    },
    "above_session_open": {
      "type": [
        "boolean",
        "null"
      ],
      "description": "Close above today’s session-open price."
    },
    "above_sma_10": {
      "type": [
        "boolean",
        "null"
      ],
      "description": "Price is above the 10-day simple moving average."
    },
    "above_sma_20": {
      "type": [
        "boolean",
        "null"
      ],
      "description": "Price is above the 20-day simple moving average."
    },
    "above_sma_200": {
      "type": [
        "boolean",
        "null"
      ],
      "description": "Price is above the 200-day simple moving average."
    },
    "above_sma_50": {
      "type": [
        "boolean",
        "null"
      ],
      "description": "Price is above the 50-day simple moving average."
    },
    "above_vwap": {
      "type": [
        "boolean",
        "null"
      ],
      "description": "Price is above today’s volume-weighted average price."
    },
    "above_vwap_minute": {
      "type": [
        "boolean",
        "null"
      ],
      "description": "Current price above session VWAP."
    },
    "above_yesterday_close": {
      "type": [
        "boolean",
        "null"
      ],
      "description": "Close above the prior session’s close."
    },
    "above_yesterday_high": {
      "type": [
        "boolean",
        "null"
      ],
      "description": "Close above the prior session’s intraday high."
    },
    "accounts_payable": {
      "type": [
        "number",
        "null"
      ],
      "description": "Trade payables to suppliers as of the quarter end."
    },
    "active": {
      "type": [
        "boolean",
        "null"
      ],
      "description": "Ticker is actively traded — not delisted or halted."
    },
    "address_address1": {
      "type": [
        "string",
        "null"
      ],
      "description": "Company headquarters street address."
    },
    "address_city": {
      "type": [
        "string",
        "null"
      ],
      "description": "Company headquarters city."
    },
    "address_postal_code": {
      "type": [
        "string",
        "null"
      ],
      "description": "Company headquarters postal code."
    },
    "address_state": {
      "type": [
        "string",
        "null"
      ],
      "description": "Company headquarters state or region."
    },
    "adx_14": {
      "type": [
        "number",
        "null"
      ],
      "description": "Average Directional Index (14-period): trend strength from 0 to 100."
    },
    "afterhours_change_pct": {
      "description": "Percent change between regular-session close and most recent after-hours print. Sparse — most equities don't trade in after-hours, and the column updates only when a print actually happens."
    },
    "afterhours_price": {
      "description": "Last after-hours price, if available."
    },
    "afternoon_drift_up": {
      "type": [
        "boolean",
        "null"
      ],
      "description": "Afternoon session net up."
    },
    "analyst_consensus_rating": {
      "type": [
        "string",
        "null"
      ],
      "description": "Consensus analyst rating across contributing firms. One of `strong buy`, `buy`, `hold`, `sell`, `strong sell`. NULL for tickers without analyst coverage."
    },
    "analyst_consensus_rating_value": {
      "type": [
        "number",
        "null"
      ],
      "description": "Consensus rating as a numeric score on the standard 1–5 scale (1 = strong buy, 5 = strong sell). Lower is more bullish."
    },
    "analyst_consensus_target_price": {
      "type": [
        "number",
        "null"
      ],
      "description": "Mean of contributing analysts' 12-month price targets."
    },
    "analyst_count_buy": {
      "type": [
        "number",
        "null"
      ],
      "description": "Number of contributing firms rating the ticker as buy."
    },
    "analyst_count_hold": {
      "type": [
        "number",
        "null"
      ],
      "description": "Number of contributing firms rating the ticker as hold (neutral)."
    },
    "analyst_count_sell": {
      "type": [
        "number",
        "null"
      ],
      "description": "Number of contributing firms rating the ticker as sell."
    },
    "analyst_count_strong_buy": {
      "type": [
        "number",
        "null"
      ],
      "description": "Number of contributing firms rating the ticker as strong buy."
    },
    "analyst_count_strong_sell": {
      "type": [
        "number",
        "null"
      ],
      "description": "Number of contributing firms rating the ticker as strong sell."
    },
    "analyst_count_total": {
      "type": [
        "number",
        "null"
      ],
      "description": "Total number of contributing firms covering the ticker with any rating. Sum of the five `analyst_count_*` buckets. `well_covered` fires when this is at least 10."
    },
    "analyst_count_with_target": {
      "type": [
        "number",
        "null"
      ],
      "description": "Number of contributing firms whose rating includes a published 12-month price target. Always ≤ `analyst_count_total`."
    },
    "analyst_target_price_high": {
      "type": [
        "number",
        "null"
      ],
      "description": "Highest single-analyst 12-month price target across contributing firms."
    },
    "analyst_target_price_low": {
      "type": [
        "number",
        "null"
      ],
      "description": "Lowest single-analyst 12-month price target across contributing firms."
    },
    "analyst_target_upside_pct": {
      "type": [
        "number",
        "null"
      ],
      "description": "Implied upside from the current price to the consensus target, in percent. `(analyst_consensus_target_price - price) / price * 100`. Negative when price is above target. Recomputed every minute, 4 AM to 8 PM ET."
    },
    "approaching_52w_high": {
      "type": [
        "boolean",
        "null"
      ],
      "description": "Price is within 5% of the 52-week high."
    },
    "approaching_52w_low": {
      "type": [
        "boolean",
        "null"
      ],
      "description": "Price is within 5% of the 52-week low."
    },
    "asset_class": {
      "type": [
        "string",
        "null"
      ],
      "description": "Asset class of the ticker: stocks, rates, crypto, or fx."
    },
    "asset_type": {
      "type": [
        "string",
        "null"
      ],
      "description": "Asset class. One of `equity`, `etf`, or `crypto`."
    },
    "assets": {
      "type": [
        "number",
        "null"
      ],
      "description": "Total assets on the balance sheet as of the most recently reported quarter."
    },
    "at_20d_high": {
      "type": [
        "boolean",
        "null"
      ],
      "description": "Price is at or above the 20-day high."
    },
    "at_20d_low": {
      "type": [
        "boolean",
        "null"
      ],
      "description": "Price is at or below the 20-day low."
    },
    "at_52w_high": {
      "type": [
        "boolean",
        "null"
      ],
      "description": "Price has traded within 0.5% of the 52-week high this session; once tagged, the boolean stays on for the rest of the session."
    },
    "at_52w_low": {
      "type": [
        "boolean",
        "null"
      ],
      "description": "Price has traded within 0.5% of the 52-week low this session; once tagged, the boolean stays on for the rest of the session."
    },
    "at_bollinger_lower": {
      "type": [
        "boolean",
        "null"
      ],
      "description": "Price has reached the lower Bollinger band."
    },
    "at_bollinger_upper": {
      "type": [
        "boolean",
        "null"
      ],
      "description": "Price has reached the upper Bollinger band."
    },
    "at_resistance": {
      "type": [
        "boolean",
        "null"
      ],
      "description": "Price is testing a detected resistance level."
    },
    "at_session_high": {
      "type": [
        "boolean",
        "null"
      ],
      "description": "At today’s intraday session high (within tolerance)."
    },
    "at_session_low": {
      "type": [
        "boolean",
        "null"
      ],
      "description": "At today’s intraday session low (within tolerance)."
    },
    "at_support": {
      "type": [
        "boolean",
        "null"
      ],
      "description": "Price is testing a detected support level."
    },
    "atr_14": {
      "type": [
        "number",
        "null"
      ],
      "description": "14-day Average True Range."
    },
    "atr_pct": {
      "type": [
        "number",
        "null"
      ],
      "description": "ATR(14) as a percent of price. Useful as a volatility filter."
    },
    "avg_volume_10d": {
      "type": [
        "number",
        "null"
      ],
      "description": "10-day trailing average daily volume."
    },
    "avg_volume_30d": {
      "type": [
        "number",
        "null"
      ],
      "description": "30-day trailing average daily volume."
    },
    "basic_average_shares": {
      "type": [
        "number",
        "null"
      ],
      "description": "Weighted-average basic shares outstanding for the quarter. Denominator for basic EPS."
    },
    "basic_earnings_per_share": {
      "type": [
        "number",
        "null"
      ],
      "description": "Basic EPS for the most-recently reported quarter. Signed."
    },
    "bearish_consensus": {
      "type": [
        "boolean",
        "null"
      ],
      "description": "Consensus analyst rating is `sell` or `strong sell`."
    },
    "below_opening_range": {
      "type": [
        "boolean",
        "null"
      ],
      "description": "Price is trading below the first 15-minute opening-range low."
    },
    "below_premarket_low": {
      "type": [
        "boolean",
        "null"
      ],
      "description": "Close below the pre-market session low."
    },
    "below_price_target": {
      "type": [
        "boolean",
        "null"
      ],
      "description": "Current price is below the consensus analyst target."
    },
    "below_yesterday_low": {
      "type": [
        "boolean",
        "null"
      ],
      "description": "Close below the prior session’s intraday low."
    },
    "beta": {
      "type": [
        "number",
        "null"
      ],
      "description": "Trailing beta vs SPY. Null for issuers with insufficient price history."
    },
    "bollinger_b": {
      "type": [
        "number",
        "null"
      ],
      "description": "Position within Bollinger bands. 0 = at lower band, 1 = at upper band, >1 = outside."
    },
    "bollinger_lower": {
      "type": [
        "number",
        "null"
      ],
      "description": "Lower Bollinger band (20-period, 2σ)."
    },
    "bollinger_middle": {
      "type": [
        "number",
        "null"
      ],
      "description": "20-day SMA — the centerline of the Bollinger band. `bollinger_upper` and `bollinger_lower` are already documented; this fills in the missing middle."
    },
    "bollinger_squeeze": {
      "type": [
        "boolean",
        "null"
      ],
      "description": "Bollinger band width compressed to a multi-week low — volatility is contracted."
    },
    "bollinger_upper": {
      "type": [
        "number",
        "null"
      ],
      "description": "Upper Bollinger band (20-period, 2σ)."
    },
    "bollinger_width": {
      "type": [
        "number",
        "null"
      ],
      "description": "`(bollinger_upper − bollinger_lower) / bollinger_middle`. Normalized width — measures volatility regime. Narrow widths often precede expansion (see the boolean `bollinger_squeeze`)."
    },
    "book_value": {
      "type": [
        "number",
        "null"
      ],
      "description": "Trailing-12m book value per share. Computed from `equity_attributable_to_parent / diluted_average_shares`."
    },
    "bounce_off_support": {
      "type": [
        "boolean",
        "null"
      ],
      "description": "Bounced off a detected support level: price tagged the band within three sessions and closed up."
    },
    "branding_icon_url": {
      "type": [
        "string",
        "null"
      ],
      "description": "URL of the company's square icon image, served by this API: request it with your API key (the same Authorization: Bearer header) and you get the image bytes (PNG or JPEG) with their Content-Type. Null when the issuer has no icon on file."
    },
    "branding_logo_url": {
      "type": [
        "string",
        "null"
      ],
      "description": "URL of the company's logo image, served by this API: request it with your API key (the same Authorization: Bearer header) and you get the image bytes (SVG when available, else PNG) with their Content-Type. Null when the issuer has no logo on file."
    },
    "bullish_consensus": {
      "type": [
        "boolean",
        "null"
      ],
      "description": "Consensus analyst rating is `strong buy` or `buy`."
    },
    "buyback_30d": {
      "type": [
        "boolean",
        "null"
      ],
      "description": "Shares outstanding fell more than 1% over the last 30 days."
    },
    "cap_class": {
      "type": [
        "string",
        "null"
      ],
      "description": "Market-capitalization tier. One of `nano` (<$50M), `micro` ($50M–$300M), `small` ($300M–$2B), `mid` ($2B–$10B), `large` ($10B–$200B), `mega` (≥$200B), or `unknown` when `market_cap` is null. Updates daily post-close as `market_cap` moves. Preferred over the legacy `nano_cap/micro_cap/small_cap/mid_cap/large_cap/mega_cap` boolean signals (which remain in sync as backward-compat shortcuts)."
    },
    "cash_and_short_term_investments": {
      "type": [
        "number",
        "null"
      ],
      "description": "Cash and cash equivalents plus short-term investments from the latest reported balance sheet, in USD. When the balance sheet reports no short-term investments, it equals cash_on_hand. In history, dated from the filing, like cash_on_hand."
    },
    "cash_on_hand": {
      "type": [
        "number",
        "null"
      ],
      "description": "Cash and cash equivalents from the latest reported balance sheet, in USD. Short-term investments are not included. In history, each value takes effect on the day the company filed it with the SEC; when only a later re-filing date is known, it takes effect 90 days after the quarter ended. When a balance sheet reports exactly zero cash, the value is kept only if the company's own SEC filing also shows zero for that quarter; otherwise it is null."
    },
    "cash_ratio": {
      "type": [
        "number",
        "null"
      ],
      "description": "Cash and cash equivalents divided by current liabilities, from the latest reported balance sheet. Null when current liabilities are not reported. In history, dated from the filing, like cash_on_hand."
    },
    "change_1d_pct": {
      "type": [
        "number",
        "null"
      ],
      "description": "Percent change vs `previous_close`, as a whole percent (0.5 = 0.5%, not a fraction). Signed. Percent scale on every read — live, `asof` by date and `asof` by timestamp — since the 2026-09-07 cutover (this signal was `day_change_pct` as a fraction before it)."
    },
    "change_1m_pct": {
      "type": [
        "number",
        "null"
      ],
      "description": "Percent change vs. close ~21 trading days ago. Daily; see `change_1w_pct` for note."
    },
    "change_1w_pct": {
      "type": [
        "number",
        "null"
      ],
      "description": "Percent change in close vs. the close 5 trading days ago. Computed post-close; does NOT update intraday — use `from_open_pct` + `change_1d_pct` for intraday-aware change."
    },
    "change_1y_pct": {
      "type": [
        "number",
        "null"
      ],
      "description": "Percent change vs. close ~252 trading days ago."
    },
    "change_3m_pct": {
      "type": [
        "number",
        "null"
      ],
      "description": "Percent change vs. close ~63 trading days ago."
    },
    "change_6m_pct": {
      "type": [
        "number",
        "null"
      ],
      "description": "Percent change vs. close ~126 trading days ago."
    },
    "change_ytd_pct": {
      "type": [
        "number",
        "null"
      ],
      "description": "Percent change since the first trading day of the calendar year."
    },
    "cik": {
      "type": [
        "string",
        "null"
      ],
      "description": "SEC Central Index Key — the company's identifier in EDGAR filings."
    },
    "composite_figi": {
      "type": [
        "string",
        "null"
      ],
      "description": "Composite FIGI — Bloomberg's cross-exchange security identifier."
    },
    "consolidating_15m": {
      "type": [
        "boolean",
        "null"
      ],
      "description": "Last 15 minutes traded in a tight range."
    },
    "consolidation": {
      "type": [
        "boolean",
        "null"
      ],
      "description": "Price is range-bound — the last 5 sessions span less than 5%."
    },
    "cost_of_revenue": {
      "type": [
        "number",
        "null"
      ],
      "description": "Cost of goods sold for the quarter."
    },
    "costs_and_expenses": {
      "type": [
        "number",
        "null"
      ],
      "description": "Total costs and expenses reported on the income statement (COGS + opex)."
    },
    "country": {
      "type": [
        "string",
        "null"
      ],
      "description": "Listing locale from the reference vendor, not the issuer's home country. Every US-listed symbol, including ADRs, reports `us`. For where the company is run from and where it is incorporated, use `issuer_country` and `incorporation_country`."
    },
    "currency_name": {
      "type": [
        "string",
        "null"
      ],
      "description": "Currency the prices are quoted in (`usd`, `eur`, `gbp`, etc.). Effectively always `usd` for US-listed equities."
    },
    "current_assets": {
      "type": [
        "number",
        "null"
      ],
      "description": "Assets expected to be converted to cash or used up within 12 months."
    },
    "current_liabilities": {
      "type": [
        "number",
        "null"
      ],
      "description": "Liabilities due within 12 months — accounts payable, short-term debt, accrued expenses."
    },
    "current_ratio": {
      "type": [
        "number",
        "null"
      ],
      "description": "Current assets ÷ current liabilities. Short-term liquidity. >1 = able to cover short-term obligations from current assets."
    },
    "day_change": {
      "type": [
        "number",
        "null"
      ],
      "description": "Absolute change vs `previous_close`."
    },
    "day_dollar_volume": {
      "type": [
        "number",
        "null"
      ],
      "description": "Today’s cumulative dollar volume traded."
    },
    "day_vwap": {
      "type": [
        "number",
        "null"
      ],
      "description": "Today’s session volume-weighted average price."
    },
    "days_down": {
      "type": [
        "number",
        "null"
      ],
      "description": "Consecutive trading days closing lower than the prior close. Resets to 0 on an up day."
    },
    "days_since_52w_high": {
      "type": [
        "number",
        "null"
      ],
      "description": "Trading days since the most recent 52-week high."
    },
    "days_since_52w_low": {
      "type": [
        "number",
        "null"
      ],
      "description": "Trading days since the most recent 52-week low."
    },
    "days_to_cover": {
      "type": [
        "number",
        "null"
      ],
      "description": "Short interest divided by 30-day average daily volume. Trader’s \"how many days of normal trading to cover all shorts\" measure."
    },
    "days_to_earnings": {
      "type": [
        "number",
        "null"
      ],
      "description": "Calendar days until next earnings announcement. Negative after report."
    },
    "days_up": {
      "type": [
        "number",
        "null"
      ],
      "description": "Consecutive trading days closing higher than the prior close. Resets to 0 on a down day."
    },
    "death_cross": {
      "type": [
        "boolean",
        "null"
      ],
      "description": "50-day SMA crossed below 200-day SMA today."
    },
    "death_regime": {
      "type": [
        "boolean",
        "null"
      ],
      "description": "Long-term downtrend regime — 50-day SMA below 200-day SMA."
    },
    "debt_to_equity": {
      "type": [
        "number",
        "null"
      ],
      "description": "Total debt divided by total shareholders' equity. Common leverage ratio; lower = less leveraged."
    },
    "delisted_utc": {},
    "description": {
      "type": [
        "string",
        "null"
      ],
      "description": "Business description of the company."
    },
    "diluted_average_shares": {
      "type": [
        "number",
        "null"
      ],
      "description": "Weighted-average diluted shares outstanding for the quarter. Denominator for diluted EPS."
    },
    "diluted_eps_ttm": {
      "type": [
        "number",
        "null"
      ],
      "description": "Trailing-12m diluted EPS."
    },
    "dilution_30d": {
      "type": [
        "boolean",
        "null"
      ],
      "description": "Shares outstanding rose more than 3% over the last 30 days."
    },
    "dividend": {
      "type": [
        "number",
        "null"
      ],
      "description": "Most-recent dividend amount per share."
    },
    "dividend_approaching": {
      "type": [
        "boolean",
        "null"
      ],
      "description": "The ex-dividend date falls within the next 7 days."
    },
    "dividend_date": {
      "type": [
        "string",
        "null"
      ],
      "description": "Ex-dividend date of the most recent dividend: own the stock before this date to receive it. The live row and history carry the same date."
    },
    "dividend_frequency": {
      "type": [
        "number",
        "null"
      ],
      "description": "Payment frequency: `quarterly`, `monthly`, `semiannual`, `annual`."
    },
    "dividend_payout_ratio": {
      "type": [
        "number",
        "null"
      ],
      "description": "Trailing 12-month dividends per share divided by trailing diluted EPS (0.25 = a quarter of earnings paid out). Null when EPS is zero, negative or missing."
    },
    "dividend_ttm": {
      "type": [
        "number",
        "null"
      ],
      "description": "Dividends per share paid over the trailing 12 months, specials included. Null when nothing went ex-dividend in that window."
    },
    "dividend_yield": {
      "type": [
        "number",
        "null"
      ],
      "description": "Forward dividend yield as a fraction (0.025 = 2.5%). Null for non-payers."
    },
    "earnings_approaching": {
      "type": [
        "boolean",
        "null"
      ],
      "description": "Earnings within 3 days."
    },
    "earnings_beat_streak": {
      "type": [
        "number",
        "null"
      ],
      "description": "Consecutive quarters the company has beaten consensus EPS estimates. Resets to 0 on a miss."
    },
    "earnings_date": {
      "type": [
        "string",
        "null"
      ],
      "description": "Next earnings announcement date. Where the company has not published one, the date is projected from its own reporting history and earnings_date_projected is true."
    },
    "earnings_date_projected": {
      "type": [
        "boolean",
        "null"
      ],
      "description": "True when earnings_date is our projection from the company's own reporting history rather than a published calendar date."
    },
    "earnings_fiscal_quarter": {
      "type": [
        "string",
        "null"
      ],
      "description": "End date of the fiscal quarter the next earnings report covers (e.g. 2026-10-31). Fiscal, not calendar: it follows the company's own fiscal year."
    },
    "earnings_growth_yoy_pct": {
      "type": [
        "number",
        "null"
      ],
      "description": "Year-over-year EPS growth percent from the most recently reported quarter vs. the same quarter prior year. Signed; positive = growth."
    },
    "earnings_next_week": {
      "type": [
        "boolean",
        "null"
      ],
      "description": "Earnings 8–14 days out — useful for the lead-up swing window."
    },
    "earnings_published": {
      "type": [
        "boolean",
        "null"
      ],
      "description": "Earnings report date has passed (next earnings date is in the past)."
    },
    "earnings_report_time": {
      "type": [
        "string",
        "null"
      ],
      "description": "When in the trading day the next earnings will be reported. One of `BMO` (before market open), `AMC` (after market close), `DMH` (during market hours)."
    },
    "earnings_this_week": {
      "type": [
        "boolean",
        "null"
      ],
      "description": "Earnings announcement scheduled in the next 7 days."
    },
    "earnings_today": {
      "type": [
        "boolean",
        "null"
      ],
      "description": "Earnings reported today."
    },
    "earnings_tomorrow": {
      "type": [
        "boolean",
        "null"
      ],
      "description": "Earnings reported in 1 calendar day. Pair with `earnings_report_time` to know BMO vs. AMC."
    },
    "ebitda": {
      "type": [
        "number",
        "null"
      ],
      "description": "Earnings before interest, taxes, depreciation, and amortization (TTM)."
    },
    "ema_12": {
      "type": [
        "number",
        "null"
      ],
      "description": "12-day EMA. Fast-side input of canonical MACD (`macd = ema_12 − ema_26`)."
    },
    "ema_21": {
      "type": [
        "number",
        "null"
      ],
      "description": "21-day EMA. Often paired with `ema_9` for short-trend bias; also serves as a dynamic-support reference."
    },
    "ema_26": {
      "type": [
        "number",
        "null"
      ],
      "description": "26-day EMA. Slow-side input of canonical MACD (`macd = ema_12 − ema_26`)."
    },
    "ema_9": {
      "type": [
        "number",
        "null"
      ],
      "description": "9-day exponential moving average of close. Most-recent-weighted; reacts faster than the same-period SMA. Commonly paired with `ema_21` for short-trend bias."
    },
    "enterprise_value": {
      "type": [
        "number",
        "null"
      ],
      "description": "Market cap + total debt − cash."
    },
    "eps": {
      "type": [
        "number",
        "null"
      ],
      "description": "Earnings per share (trailing twelve months)."
    },
    "eps_diluted_fy": {
      "type": [
        "number",
        "null"
      ],
      "description": "diluted EPS, last reported fiscal year"
    },
    "eps_estimate_revision_down_30d": {
      "type": [
        "number",
        "null"
      ],
      "description": "Count of analysts who lowered their next-quarter EPS estimate in the last 30 days."
    },
    "eps_estimate_revision_up_30d": {
      "type": [
        "number",
        "null"
      ],
      "description": "Count of analysts who raised their next-quarter EPS estimate in the last 30 days. A positive read on forward sentiment momentum."
    },
    "equity": {
      "type": [
        "number",
        "null"
      ],
      "description": "Total shareholders' equity."
    },
    "equity_attributable_to_noncontrolling_interest": {
      "type": [
        "number",
        "null"
      ],
      "description": "Equity attributable to minority shareholders of consolidated subsidiaries. Usually 0 for non-conglomerates."
    },
    "equity_attributable_to_parent": {
      "type": [
        "number",
        "null"
      ],
      "description": "Equity attributable to the parent entity's shareholders (excludes minority interest)."
    },
    "estimate_revised_down": {
      "type": [
        "boolean",
        "null"
      ],
      "description": "At least one analyst lowered their next-quarter EPS estimate in the last 30 days."
    },
    "estimate_revised_up": {
      "type": [
        "boolean",
        "null"
      ],
      "description": "At least one analyst raised their next-quarter EPS estimate in the last 30 days."
    },
    "etf_dividend_yield": {
      "description": "Dividend yield as reported by the fund, as a fraction. ETFs only."
    },
    "etf_expense_ratio": {
      "description": "Net expense ratio as a fraction (0.0009 = 0.09% a year). ETFs only."
    },
    "etf_holders": {
      "type": [
        "array",
        "null"
      ],
      "description": "ETFs that hold this ticker, ordered by the ticker's weight within each (the reverse of ETF holdings). Filter with array operators in /v2/scan, e.g. `'SPY' = ANY(etf_holders)` to find SPY constituents. Refreshed nightly post-close."
    },
    "etf_inception_date": {
      "description": "Date the fund launch

# --- truncated at 32 KB (87 KB total) ---
# Full source: https://artifacts.apis.io/tickerbot-io/json-schema/tickerbot-io-ticker-row-schema.json

Work with this as data

Every JSON Schema here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for schemas

4 MCP tools reach this
  • find_json_schemasBrowse and filter every JSON Schema in the catalog.
  • apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
  • resolveTurn a domain, URL or GitHub org into the provider it belongs to.
  • find_cohortsEvery scored population of providers in the catalog.
All 92 tools →

Call it yourself

curl for this page
This JSON Schema 
curl "https://apis.io/api/v1/json-schemas/tickerbot-io-ticker-row"
All schemas 
curl "https://apis.io/api/v1/json-schemas?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

GitHub Google LinkedIn

A second provider on the same verified email joins the account you already have.