# US stocks and ETFs, prices and SEC fundamentals since 2010

**Screen every US-listed stock and ETF on price trend, risk, balance sheet, SEC fundamentals and what its 10-Ks have said since 2010.** The search table joins everything onto one row per listing: price and technicals, the latest SEC income statement, cash flow and balance sheet, valuation, ten years of growth and payout history, filing activity, and what the latest 10-K says the company does, sel…

US stocks and ETFs, prices and SEC fundamentals since 2010 is an open, machine-readable dataset published on Mostly Right as immutable Parquet versions, with a documented column schema, a JSON query API and a direct download. Its first rows are free to read and it is open to AI agents.

## Facts

- Slug: `us-stocks-and-etfs-prices-and-sec-fundamentals-since-2010`
- Canonical page: https://mostlyright.md/datasets/us-stocks-and-etfs-prices-and-sec-fundamentals-since-2010
- Publisher: mostlyrightmd (https://mostlyright.md/publishers/mostlyrightmd)
- Published: 2026-11-01T17:10:06.879Z
- Tables: 43
- Formats: Apache Parquet (download), JSON (query and sample)
- Cost: the first 500 rows of each table are free to everyone; querying and downloading need a free account and count against a monthly free allowance unless the workspace is subscribed
- Metadata API: `GET https://mostlyright.md/api/v2/public/datasets/us-stocks-and-etfs-prices-and-sec-fundamentals-since-2010`
- Topics: us stocks, etfs, stock screener, sec edgar, xbrl fundamentals, stock prices, technical indicators, eodhd

## Table directory

Tables follow the publisher's curated order. Display labels do not change table identifiers.

Start here: Stock & ETF screener — table id: 336bc9d4-39a9-44f3-a758-8640fa3ee00d

### Explore

- Stock & ETF screener — table id: 336bc9d4-39a9-44f3-a758-8640fa3ee00d; published name: search_stocks; https://mostlyright.md/datasets/us-stocks-and-etfs-prices-and-sec-fundamentals-since-2010/tables?table=search-stocks — One row per listing, combining prices, financials and company information. Inputs refresh at different cadences.
### Prices

- Latest daily prices — table id: e51fc3a4-8db4-4f77-bd81-9f5ea0fc6fdf; published name: source_quotes_latest; https://mostlyright.md/datasets/us-stocks-and-etfs-prices-and-sec-fundamentals-since-2010/tables?table=source-quotes-latest — Latest end-of-day prices and indicators per security. Scheduled after US trading days.
- Daily price history — A–D — table id: 6ae30c00-b755-4fd3-804c-b0de2d8fb7c6; published name: series_prices_a_d; https://mostlyright.md/datasets/us-stocks-and-etfs-prices-and-sec-fundamentals-since-2010/tables?table=series-prices-a-d — Daily OHLC, adjusted close, volume and technical indicators since 2010. History rebuilds weekly on Saturdays.
- Daily price history — E–G — table id: e1e723fd-57dc-4c95-a528-0983c7d977eb; published name: series_prices_e_g; https://mostlyright.md/datasets/us-stocks-and-etfs-prices-and-sec-fundamentals-since-2010/tables?table=series-prices-e-g — Daily OHLC, adjusted close, volume and technical indicators since 2010. History rebuilds weekly on Saturdays.
- Daily price history — H–L — table id: 803b904b-50c6-45a2-ab6d-c9adef71c33b; published name: series_prices_h_l; https://mostlyright.md/datasets/us-stocks-and-etfs-prices-and-sec-fundamentals-since-2010/tables?table=series-prices-h-l — Daily OHLC, adjusted close, volume and technical indicators since 2010. History rebuilds weekly on Saturdays.
- Daily price history — M–R — table id: db9edfae-e961-48bc-b196-b21f3f3cd5b6; published name: series_prices_m_r; https://mostlyright.md/datasets/us-stocks-and-etfs-prices-and-sec-fundamentals-since-2010/tables?table=series-prices-m-r — Daily OHLC, adjusted close, volume and technical indicators since 2010. History rebuilds weekly on Saturdays.
- Daily price history — S–Z — table id: ebb9c98a-ba0e-4f89-8f32-483f0111c3f0; published name: series_prices_s_z; https://mostlyright.md/datasets/us-stocks-and-etfs-prices-and-sec-fundamentals-since-2010/tables?table=series-prices-s-z — Daily OHLC, adjusted close, volume and technical indicators since 2010. History rebuilds weekly on Saturdays.
### Financials

- Latest financial statements — table id: d5e99977-3883-44bd-9ef4-fc7f2c3198f5; published name: source_fundamentals_latest; https://mostlyright.md/datasets/us-stocks-and-etfs-prices-and-sec-fundamentals-since-2010/tables?table=source-fundamentals-latest — Latest SEC financial figures per filer. Scheduled weekly.
- Financial statement history — table id: a4b33778-7f06-423a-9ec0-26e174464e47; published name: series_fundamentals; https://mostlyright.md/datasets/us-stocks-and-etfs-prices-and-sec-fundamentals-since-2010/tables?table=series-fundamentals — SEC financial figures by company and fiscal period since 2010. Scheduled weekly.
### SEC reports

- Latest annual report profiles — table id: 200ba1b5-478f-4a44-8fde-8e8a00b9ecd0; published name: filings_10k; https://mostlyright.md/datasets/us-stocks-and-etfs-prices-and-sec-fundamentals-since-2010/tables?table=filings-10k — Extracted facts and model-assigned labels from each company’s latest 10-K. Snapshot; no scheduled refresh.
- Annual report history — table id: 070b2640-14ca-4f36-97db-a625184f1b81; published name: filings_10k_history; https://mostlyright.md/datasets/us-stocks-and-etfs-prices-and-sec-fundamentals-since-2010/tables?table=filings-10k-history — Extracted facts and labels from 10-K reports filed since 2010. Snapshot; no scheduled refresh.
- SEC filing index — table id: 95c503fd-e21e-4060-8376-d3f88a8006e7; published name: source_filings; https://mostlyright.md/datasets/us-stocks-and-etfs-prices-and-sec-fundamentals-since-2010/tables?table=source-filings — SEC filings with dates, forms and source links. Scheduled each weekday.
### Reference

- Security directory — table id: fdfaf2e4-6dc9-4812-bf2f-dba000eab8d8; published name: source_securities; https://mostlyright.md/datasets/us-stocks-and-etfs-prices-and-sec-fundamentals-since-2010/tables?table=source-securities — Stock and ETF listings, exchanges and SEC identifiers. Scheduled each weekday.
### Build intermediates

- Annual report profiles — 2010 (build stage) — table id: 9335c79b-27ae-4351-bf7c-580a57f728cb; published name: filings_10k_2010; https://mostlyright.md/datasets/us-stocks-and-etfs-prices-and-sec-fundamentals-since-2010/tables?table=filings-10k-2010 — Yearly intermediate used to assemble annual report history.
- Annual report profiles — 2011 (build stage) — table id: 6265f759-a231-44cc-959b-7d13664dcc71; published name: filings_10k_2011; https://mostlyright.md/datasets/us-stocks-and-etfs-prices-and-sec-fundamentals-since-2010/tables?table=filings-10k-2011 — Yearly intermediate used to assemble annual report history.
- Annual report profiles — 2012 (build stage) — table id: 55c2855d-f9e8-40dd-96f4-242d5e258ac8; published name: filings_10k_2012; https://mostlyright.md/datasets/us-stocks-and-etfs-prices-and-sec-fundamentals-since-2010/tables?table=filings-10k-2012 — Yearly intermediate used to assemble annual report history.
- Annual report profiles — 2013 (build stage) — table id: 13ca23b5-6f41-45d4-b344-688b28dfe89e; published name: filings_10k_2013; https://mostlyright.md/datasets/us-stocks-and-etfs-prices-and-sec-fundamentals-since-2010/tables?table=filings-10k-2013 — Yearly intermediate used to assemble annual report history.
- Annual report profiles — 2014 (build stage) — table id: 4222a6bf-57c4-48b1-bfce-c85669295b44; published name: filings_10k_2014; https://mostlyright.md/datasets/us-stocks-and-etfs-prices-and-sec-fundamentals-since-2010/tables?table=filings-10k-2014 — Yearly intermediate used to assemble annual report history.
- Annual report profiles — 2015 (build stage) — table id: 7070b548-840a-4a78-b383-b45edf35749e; published name: filings_10k_2015; https://mostlyright.md/datasets/us-stocks-and-etfs-prices-and-sec-fundamentals-since-2010/tables?table=filings-10k-2015 — Yearly intermediate used to assemble annual report history.
- Annual report profiles — 2016 (build stage) — table id: 57df9df1-718e-47b7-b9e6-6eebe15951fa; published name: filings_10k_2016; https://mostlyright.md/datasets/us-stocks-and-etfs-prices-and-sec-fundamentals-since-2010/tables?table=filings-10k-2016 — Yearly intermediate used to assemble annual report history.
- Annual report profiles — 2017 (build stage) — table id: 28ede304-b510-48e9-8f48-fed88da39de2; published name: filings_10k_2017; https://mostlyright.md/datasets/us-stocks-and-etfs-prices-and-sec-fundamentals-since-2010/tables?table=filings-10k-2017 — Yearly intermediate used to assemble annual report history.
- Annual report profiles — 2018 (build stage) — table id: 2b4a51bc-2fd4-40f9-bf74-5c65c577c4eb; published name: filings_10k_2018; https://mostlyright.md/datasets/us-stocks-and-etfs-prices-and-sec-fundamentals-since-2010/tables?table=filings-10k-2018 — Yearly intermediate used to assemble annual report history.
- Annual report profiles — 2019 (build stage) — table id: 5d5ec9ab-275f-4f50-87e1-6532cc8b5468; published name: filings_10k_2019; https://mostlyright.md/datasets/us-stocks-and-etfs-prices-and-sec-fundamentals-since-2010/tables?table=filings-10k-2019 — Yearly intermediate used to assemble annual report history.
- Annual report profiles — 2020 (build stage) — table id: 1bf76653-9df4-48d8-9bb2-25ae144d9f9a; published name: filings_10k_2020; https://mostlyright.md/datasets/us-stocks-and-etfs-prices-and-sec-fundamentals-since-2010/tables?table=filings-10k-2020 — Yearly intermediate used to assemble annual report history.
- Annual report profiles — 2021 (build stage) — table id: 4365e048-37fb-4208-8945-4f316f15466a; published name: filings_10k_2021; https://mostlyright.md/datasets/us-stocks-and-etfs-prices-and-sec-fundamentals-since-2010/tables?table=filings-10k-2021 — Yearly intermediate used to assemble annual report history.
- Annual report profiles — 2022 (build stage) — table id: f28ca944-d129-4c18-8d4f-b286b49536cd; published name: filings_10k_2022; https://mostlyright.md/datasets/us-stocks-and-etfs-prices-and-sec-fundamentals-since-2010/tables?table=filings-10k-2022 — Yearly intermediate used to assemble annual report history.
- Annual report profiles — 2023 (build stage) — table id: 14656c34-865b-4945-a9af-ec83e8d52b17; published name: filings_10k_2023; https://mostlyright.md/datasets/us-stocks-and-etfs-prices-and-sec-fundamentals-since-2010/tables?table=filings-10k-2023 — Yearly intermediate used to assemble annual report history.
- Annual report profiles — 2024 (build stage) — table id: 8c3a16f4-3280-4da1-adf1-6c9acc11ddae; published name: filings_10k_2024; https://mostlyright.md/datasets/us-stocks-and-etfs-prices-and-sec-fundamentals-since-2010/tables?table=filings-10k-2024 — Yearly intermediate used to assemble annual report history.
- Annual report profiles — 2025 (build stage) — table id: 298a9685-bdd3-4a50-a9c7-44d8d9b56312; published name: filings_10k_2025; https://mostlyright.md/datasets/us-stocks-and-etfs-prices-and-sec-fundamentals-since-2010/tables?table=filings-10k-2025 — Yearly intermediate used to assemble annual report history.
- Annual report profiles — 2026 (build stage) — table id: 40bb57ee-eff4-49a4-b878-c41c0548f054; published name: filings_10k_2026; https://mostlyright.md/datasets/us-stocks-and-etfs-prices-and-sec-fundamentals-since-2010/tables?table=filings-10k-2026 — Yearly intermediate used to assemble annual report history.
- Annual report source index — latest — table id: 8c21d6fd-85bc-41b8-b81f-85c3489998b0; published name: source_10k_index; https://mostlyright.md/datasets/us-stocks-and-etfs-prices-and-sec-fundamentals-since-2010/tables?table=source-10k-index
- Annual report source index — 2026 — table id: d758f5f1-f759-4daf-8408-93740b4238ff; published name: source_10k_index_2026; https://mostlyright.md/datasets/us-stocks-and-etfs-prices-and-sec-fundamentals-since-2010/tables?table=source-10k-index-2026
- Annual report sections — part 1 — table id: 9557d140-2b20-4104-a9aa-b1a19c29f128; published name: source_10k_sections; https://mostlyright.md/datasets/us-stocks-and-etfs-prices-and-sec-fundamentals-since-2010/tables?table=source-10k-sections — Extracted report text and cover facts used by downstream report profiles.
- Annual report sections — part 2 — table id: ee62f70e-2e10-4dd6-bda8-22c0e12f26bf; published name: source_10k_sections_2; https://mostlyright.md/datasets/us-stocks-and-etfs-prices-and-sec-fundamentals-since-2010/tables?table=source-10k-sections-2 — Extracted report text and cover facts used by downstream report profiles.
- Annual report sections — part 3 — table id: 8a37a44d-28bc-44ff-98e2-75d18e7152ee; published name: source_10k_sections_3; https://mostlyright.md/datasets/us-stocks-and-etfs-prices-and-sec-fundamentals-since-2010/tables?table=source-10k-sections-3 — Extracted report text and cover facts used by downstream report profiles.
- Annual report sections — part 4 — table id: 3174765a-05dd-4a19-af64-da809a761071; published name: source_10k_sections_4; https://mostlyright.md/datasets/us-stocks-and-etfs-prices-and-sec-fundamentals-since-2010/tables?table=source-10k-sections-4 — Extracted report text and cover facts used by downstream report profiles.
- Annual report sections — part 5 — table id: 4b13f653-f402-4d56-baac-1c5bc968c165; published name: source_10k_sections_5; https://mostlyright.md/datasets/us-stocks-and-etfs-prices-and-sec-fundamentals-since-2010/tables?table=source-10k-sections-5 — Extracted report text and cover facts used by downstream report profiles.
- Annual report sections — 2026 / 1 — table id: f22ca27e-beb6-406e-8c3d-e44a379b676a; published name: source_10k_sections_2026_1; https://mostlyright.md/datasets/us-stocks-and-etfs-prices-and-sec-fundamentals-since-2010/tables?table=source-10k-sections-2026-1 — Extracted report text and cover facts used by downstream report profiles.
- Annual report sections — 2026 / 2 — table id: cf0c5af0-f7aa-4170-ad76-49711642add4; published name: source_10k_sections_2026_2; https://mostlyright.md/datasets/us-stocks-and-etfs-prices-and-sec-fundamentals-since-2010/tables?table=source-10k-sections-2026-2 — Extracted report text and cover facts used by downstream report profiles.
- Annual report sections — 2026 / 3 — table id: 211f96bf-ee4d-498f-9c0e-ab46462362c5; published name: source_10k_sections_2026_3; https://mostlyright.md/datasets/us-stocks-and-etfs-prices-and-sec-fundamentals-since-2010/tables?table=source-10k-sections-2026-3 — Extracted report text and cover facts used by downstream report profiles.
- Filing activity aggregates — table id: 7f4d90d1-7a1b-436b-8cf4-1d3c0401e9f3; published name: source_filing_activity; https://mostlyright.md/datasets/us-stocks-and-etfs-prices-and-sec-fundamentals-since-2010/tables?table=source-filing-activity
- Financial history aggregates — table id: 4bb569d0-1e6e-4028-bd60-9b79b8bf9595; published name: source_fundamentals_history_stats; https://mostlyright.md/datasets/us-stocks-and-etfs-prices-and-sec-fundamentals-since-2010/tables?table=source-fundamentals-history-stats
- Screener input — prices and financials — table id: b680c806-756a-4a03-9ef7-8c9958de2974; published name: source_stock_screener; https://mostlyright.md/datasets/us-stocks-and-etfs-prices-and-sec-fundamentals-since-2010/tables?table=source-stock-screener

## How to use it

1. Read a table's schema — no account needed.
2. Fetch its published sample rows — no account needed.
   The first 500 rows of every table, in stored order, are free to everyone, with or without an account. Without an account you get that sample and nothing else: no filter, sort, search, download or page past row 500.
3. Sign in at https://mostlyright.md/login, connect this dataset to a workspace on its page, and create an `mr_use_` key.
4. Query bounded JSON, or download the complete Parquet snapshot and read it locally.
   A free workspace may read 100,000 rows and run 1,000 queries a UTC month past the sample. The allowance is shared by everyone in the workspace, and a free workspace may have any number of members. Reads count against the workspace whose data or key they use. A subscribed workspace is never counted, for anyone working in it.

Agents can do all of this over MCP at `https://mostlyright.md/api/mcp` — searching, reading schemas and sampling rows work with no credential at all.

## Table: Stock & ETF screener

- Table id: `336bc9d4-39a9-44f3-a758-8640fa3ee00d`
- Slug: `search-stocks`
- Immutable version: `7ab63186-a391-5c03-9f73-29335252e547`
- Published name: search_stocks
- Section: Explore
- Description: One row per listing, combining prices, financials and company information. Inputs refresh at different cadences.
- Schema: `GET https://mostlyright.md/api/v2/public/tables/336bc9d4-39a9-44f3-a758-8640fa3ee00d/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/336bc9d4-39a9-44f3-a758-8640fa3ee00d/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/336bc9d4-39a9-44f3-a758-8640fa3ee00d/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/336bc9d4-39a9-44f3-a758-8640fa3ee00d/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (245)

| Column | Type | Description |
| --- | --- | --- |
| `symbol` | string | Ticker symbol as the exchange lists it, such as AAPL, MSFT or BRK.B. |
| `company_name` | string | Company or fund name, such as Apple Inc. or SPDR S&P 500 ETF Trust. |
| `security_name` | string | Full listed security name with its share class, such as Apple Inc. - Common Stock. |
| `exchange` | string | Listing exchange: Nasdaq, NYSE, NYSE American, NYSE Arca, Cboe BZX or IEX. |
| `security_type` | string | Kind of security: common, etf, etn, adr, preferred, debt, warrant, unit, right or other. Partnership common units count as common and depositary shares as adr. |
| `is_etf` | boolean | True for an exchange-traded fund. |
| `sector` | string | Industry sector derived from the SEC SIC code: Information Technology, Health Care, Financials, Real Estate, Energy, Utilities, Materials, Industrials, Consume… |
| `industry` | string | SEC SIC industry title, such as Services-Prepackaged Software or Semiconductors & Related Devices. |
| `sic_code` | integer | Four-digit SEC Standard Industrial Classification code. |
| `cik` | integer | SEC Central Index Key of the issuer. |
| `state` | string | US state or region code of the business address, such as CA or NY. |
| `country` | string | Country of the business address as the SEC records it. |
| `price_date` | date | Trading day of the latest price. |
| `price` | decimal | Latest closing share price in US dollars, the stock price. |
| `price_change_1d_pct` | decimal | Price change on the latest trading day against the day before, percent; daily gain or loss. Empty when the daily history has not caught up with the latest quot… |
| `volume` | integer | Shares traded on the latest trading day. |
| `market_cap_usd` | decimal | Market capitalization (market value, company size) in US dollars: EODHD's figure, or price times SEC diluted shares when EODHD has none. Empty for a preferred,… |
| `market_cap_size` | string | Size bucket by market cap: mega (200B+), large (10B to 200B), mid (2B to 10B), small (300M to 2B), micro (under 300M). Empty for a preferred, debt, warrant, un… |
| `price_return_1w_pct` | decimal | Price return over the last week, 7 days, percent, on adjusted closes. |
| `price_return_1m_pct` | decimal | Price return over the last month, 30 days, percent. |
| `price_return_3m_pct` | decimal | Price return over the last 3 months, a quarter, percent. |
| `price_return_6m_pct` | decimal | Price return over the last 6 months, half year, percent. |
| `price_return_ytd_pct` | decimal | Price return year to date (YTD), since the last close of the previous calendar year, percent. |
| `price_return_1y_pct` | decimal | Price return over the last 1 year, 12 months, percent. |
| `price_return_3y_pct` | decimal | Price return over the last 3 years, percent. |
| `price_return_5y_pct` | decimal | Price return over the last 5 years, percent. |
| `price_return_10y_pct` | decimal | Price return over the last 10 years, a decade, percent. |
| `volatility_30d_pct` | decimal | Annualized volatility of daily returns over the last 30 days (21 trading days), percent. |
| `volatility_90d_pct` | decimal | Annualized volatility of daily returns over the last 90 days (63 trading days), percent. |
| `volatility_1y_pct` | decimal | Annualized volatility of daily returns over the last year (252 trading days), percent; risk. |
| `max_drawdown_1y_pct` | decimal | Maximum drawdown over the last year: the deepest fall from a running peak, percent, zero or negative. |
| `max_drawdown_3y_pct` | decimal | Maximum drawdown over the last 3 years, percent, zero or negative; weekly closes before June 2024 and daily closes after. |
| `max_drawdown_all_pct` | decimal | Maximum drawdown over all history since 2010, all-time worst crash from a peak, percent; weekly closes before June 2024 and daily closes after. |
| `high_52w` | decimal | 52-week high: highest adjusted closing price over the last year, US dollars. |
| `low_52w` | decimal | 52-week low: lowest adjusted closing price over the last year, US dollars. |
| `pct_from_52w_high` | decimal | Percent below the 52-week high; 0 means at the high, -20 means 20 percent below. |
| `pct_above_52w_low` | decimal | Percent above the 52-week low; 0 means at the low. |
| `all_time_high` | decimal | All-time high adjusted closing price since 2010, US dollars, ATH; weekly closes before June 2024 and daily closes after. |
| `all_time_high_date` | date | Date of the all-time high since 2010. |
| `all_time_low` | decimal | All-time low adjusted closing price since 2010, US dollars; weekly closes before June 2024 and daily closes after. |
| `pct_from_all_time_high` | decimal | Percent below the all-time high since 2010; 0 means at a record. |
| `pct_above_all_time_low` | decimal | Percent above the all-time low since 2010. |
| `sma_20` | decimal | 20-day simple moving average of the adjusted close, US dollars. |
| `sma_50` | decimal | 50-day simple moving average of the adjusted close, US dollars. |
| `sma_200` | decimal | 200-day simple moving average of the adjusted close, US dollars. |
| `above_sma_20` | boolean | True when the price is above its 20-day moving average. |
| `above_sma_50` | boolean | True when the price is above its 50-day moving average. |
| `above_sma_200` | boolean | True when the price is above its 200-day moving average, a long-term uptrend. |
| `pct_vs_sma_200` | decimal | Percent the price sits above or below its 200-day moving average. |
| `ma_cross` | string | golden when the 50-day moving average is above the 200-day, death when below. |
| `last_golden_cross_date` | date | Most recent day the 50-day average crossed above the 200-day, a golden cross. |
| `last_death_cross_date` | date | Most recent day the 50-day average crossed below the 200-day, a death cross. |
| `rsi_14` | decimal | Relative strength index (RSI), 14 days, 0 to 100; under 30 oversold, over 70 overbought. |
| `macd_histogram` | decimal | MACD line minus its signal line; positive is bullish momentum. |
| `avg_volume_20d` | decimal | Average shares traded per day over the last 20 trading days. |
| `avg_volume_90d` | decimal | Average shares traded per day over the last 90 days (63 trading days). |
| `avg_dollar_volume_20d` | decimal | Average US dollars traded per day over the last 20 trading days; liquidity, turnover. |
| `avg_dollar_volume_90d` | decimal | Average US dollars traded per day over the last 90 days. |
| `beta_1y` | decimal | Beta against SPY (the S&P 500) from daily returns over the last year; above 1 swings more than the market. |
| `correlation_spy_1y` | decimal | Correlation of daily returns with SPY over the last year, -1 to 1. |
| `relative_return_3m_pct` | decimal | Return over 3 months minus SPY's, percentage points; outperformance versus the S&P 500. |
| `relative_return_1y_pct` | decimal | Return over 1 year minus SPY's, percentage points; beat or lag the market. |
| `fiscal_year` | integer | Calendar year of the latest annual report in SEC XBRL frames. |
| `fiscal_year_end_date` | date | Period end date of the latest annual report. |
| `fiscal_year_sales_usd` | decimal | Sales in the latest fiscal year alone, US dollars. |
| `fiscal_year_earnings_usd` | decimal | Earnings in the latest fiscal year alone, US dollars. |
| `dividends_paid_usd` | decimal | Cash dividends paid in the latest fiscal year, US dollars. |
| `buybacks_usd` | decimal | Share repurchases (stock buybacks) in the latest fiscal year, US dollars. |
| `revenue_growth_pct` | decimal | Revenue growth in the latest fiscal year against the year before, percent; annual top-line growth. |
| `latest_quarter` | string | Calendar quarter of the latest quarterly report, such as CY2026Q2. |
| `quarter_end_date` | date | Period end date of the latest quarterly report. |
| `quarterly_sales_usd` | decimal | Sales in the latest quarter alone, US dollars. |
| `quarterly_earnings_usd` | decimal | Earnings in the latest quarter alone, US dollars. |
| `quarterly_sales_growth_pct` | decimal | Latest quarter's sales against the same quarter a year earlier, percent; quarterly top-line growth. |
| `quarterly_earnings_growth_pct` | decimal | Latest quarter's net income against the same quarter a year earlier, percent. |
| `gross_margin_pct` | decimal | Gross margin in the latest fiscal year, percent of revenue. |
| `operating_margin_pct` | decimal | Operating margin in the latest fiscal year, percent of revenue. |
| `profit_margin_pct` | decimal | Net profit margin over the trailing twelve months, percent of revenue. |
| `is_profitable` | boolean | True when trailing twelve month net income is positive. |
| `pays_dividend` | boolean | True when the company paid cash dividends in its latest fiscal year. |
| `free_cash_flow_yield_pct` | decimal | Free cash flow yield: annual free cash flow over market cap, percent. Empty for a preferred, debt, warrant, unit or right listing, which is not the company's c… |
| `earnings_yield_pct` | decimal | Earnings yield: trailing net income over market cap, percent, the inverse of P/E. Empty for a preferred, debt, warrant, unit or right listing, which is not the… |
| `dividend_yield_pct` | decimal | Dividend yield: annual cash dividends over market cap, percent. Empty for a preferred, debt, warrant, unit or right listing, which is not the company's common… |
| `history_start_date` | date | First day in the price history: early January 2010, or the first week of trading for later listings. |
| `trading_days` | integer | Number of daily bars since June 2024 that the moving averages, RSI, volatility and 52-week range use. |
| `history_end_date` | date | Last trading day in the daily price history that the moving averages, volatility and drawdowns use. |
| `edgar_url` | string | Link to the company's SEC EDGAR filing index. |
| `revenue_usd` | decimal | Revenue (sales, turnover) over the trailing twelve months, US dollars; the latest fiscal year when no trailing figure exists. |
| `net_income_usd` | decimal | Net income (earnings, profit) over the trailing twelve months, US dollars; the latest fiscal year when no trailing figure exists. |
| `eps_ttm` | decimal | Diluted earnings per share over the trailing twelve months, US dollars. |
| `gross_profit_usd` | decimal | Gross profit for the latest fiscal year, US dollars. |
| `cost_of_revenue_usd` | decimal | Cost of revenue (cost of goods sold) for the latest fiscal year, US dollars. |
| `operating_income_usd` | decimal | Operating income (EBIT) for the latest fiscal year, US dollars. |
| `ebitda_usd` | decimal | EBITDA for the latest fiscal year: operating income plus depreciation and amortization, US dollars. |
| `ebitda_margin_pct` | decimal | EBITDA as a percent of fiscal-year revenue. |
| `sga_usd` | decimal | Selling, general and administrative expense for the latest fiscal year, US dollars. |
| `rnd_usd` | decimal | Research and development expense for the latest fiscal year, US dollars. |
| `rnd_pct_of_revenue` | decimal | Research and development spend as a percent of fiscal-year revenue (R&D intensity). |
| `interest_expense_usd` | decimal | Interest expense for the latest fiscal year, US dollars. |
| `interest_coverage` | decimal | Operating income divided by interest expense for the latest fiscal year; how many times earnings cover interest. |
| `income_tax_usd` | decimal | Income tax expense for the latest fiscal year, US dollars. |
| `depreciation_amortization_usd` | decimal | Depreciation, depletion and amortization for the latest fiscal year, US dollars. |
| `stock_based_compensation_usd` | decimal | Share-based compensation for the latest fiscal year, US dollars. |
| `sbc_pct_of_revenue` | decimal | Share-based compensation as a percent of fiscal-year revenue. |
| `operating_cash_flow_usd` | decimal | Net cash from operating activities for the latest fiscal year, US dollars. |
| `capex_usd` | decimal | Capital expenditure (payments for property, plant and equipment) for the latest fiscal year, US dollars. |
| `capex_pct_of_revenue` | decimal | Capital expenditure as a percent of fiscal-year revenue (capital intensity). |
| `free_cash_flow_usd` | decimal | Free cash flow for the latest fiscal year: operating cash flow minus capital expenditure, US dollars. |
| `fcf_margin_pct` | decimal | Free cash flow as a percent of fiscal-year revenue. |
| `fiscal_year_eps` | decimal | Diluted earnings per share for the latest fiscal year, US dollars. |
| `earnings_growth_pct` | decimal | Fiscal-year net income growth over the year before, percent. |
| `eps_growth_pct` | decimal | Fiscal-year diluted EPS growth over the year before, percent. |
| `quarterly_eps` | decimal | Diluted earnings per share for the latest quarter, US dollars. |
| `quarterly_eps_growth_pct` | decimal | Latest-quarter diluted EPS growth over the same quarter a year earlier, percent. |
| `shares_outstanding` | decimal | Diluted shares on the latest balance sheet or quarter, from the SEC filing. |
| `latest_filing_url` | string | EDGAR index page of the latest 10-Q or 10-K the quarterly figures come from. |
| `balance_sheet_date` | date | Date of the latest balance sheet the cash, debt, assets and equity figures come from. |
| `cash_usd` | decimal | Cash and cash equivalents (cash on hand) on the latest balance sheet, US dollars. |
| `short_term_investments_usd` | decimal | Short-term investments (marketable securities) on the latest balance sheet, US dollars. |
| `long_term_investments_usd` | decimal | Long-term marketable or held-to-maturity securities on the latest balance sheet, US dollars. |
| `cash_and_investments_usd` | decimal | Cash plus short- and long-term investments on the latest balance sheet, US dollars: the broad cash pile (liquidity, cash reserves). |
| `total_debt_usd` | decimal | Total debt (borrowings, loans, notes, bonds) on the latest balance sheet, US dollars; empty when the filer tags no borrowing concept. |
| `long_term_debt_usd` | decimal | Long-term borrowings, noncurrent portion, on the latest balance sheet, US dollars. |
| `current_debt_usd` | decimal | Borrowings due within a year, including short-term borrowings and commercial paper, US dollars. |
| `finance_lease_usd` | decimal | Finance (capital) lease liabilities on the latest balance sheet, US dollars. |
| `net_cash_usd` | decimal | Cash plus short-term investments minus total debt, US dollars, only when both are reported; negative means net debt. |
| `total_assets_usd` | decimal | Total assets on the latest balance sheet, US dollars. |
| `total_liabilities_usd` | decimal | Total liabilities on the latest balance sheet, US dollars. |
| `book_value_usd` | decimal | Stockholders' equity (book value, shareholders' funds, net assets) on the latest balance sheet, US dollars. |
| `current_assets_usd` | decimal | Current assets on the latest balance sheet, US dollars. |
| `current_liabilities_usd` | decimal | Current liabilities on the latest balance sheet, US dollars. |
| `inventory_usd` | decimal | Inventory on the latest balance sheet, US dollars. |
| `goodwill_usd` | decimal | Goodwill on the latest balance sheet, US dollars. |
| `debt_to_equity` | decimal | Total debt divided by stockholders equity (leverage); empty when debt is not reported or equity is not positive. |
| `debt_to_assets` | decimal | Total debt divided by total assets (leverage). |
| `current_ratio` | decimal | Current assets divided by current liabilities (liquidity). |
| `cash_to_market_cap_pct` | decimal | Cash and investments as a percent of market capitalization. Empty for a preferred, debt, warrant, unit or right listing, which is not the company's common equi… |
| `roe_pct` | decimal | Return on equity: trailing net income over stockholders equity, percent. |
| `roa_pct` | decimal | Return on assets: trailing net income over total assets, percent. |
| `enterprise_value_usd` | decimal | Enterprise value: market capitalization plus total debt minus cash and short-term investments, US dollars; empty when debt is not reported. Empty for a preferr… |
| `ev_to_sales` | decimal | Enterprise value divided by trailing revenue. Empty for a preferred, debt, warrant, unit or right listing, which is not the company's common equity. |
| `ev_to_ebitda` | decimal | Enterprise value divided by fiscal-year EBITDA; empty when EBITDA is not positive. Empty for a preferred, debt, warrant, unit or right listing, which is not th… |
| `pe_ratio` | decimal | Price to earnings: price over trailing diluted EPS; empty when earnings are not positive. Empty for a preferred, debt, warrant, unit or right listing, which is… |
| `price_to_sales` | decimal | Market capitalization over trailing revenue. Empty for a preferred, debt, warrant, unit or right listing, which is not the company's common equity. |
| `price_to_book` | decimal | Market capitalization over stockholders equity; empty when equity is not positive. Empty for a preferred, debt, warrant, unit or right listing, which is not th… |
| `first_fiscal_year` | integer | First fiscal year with SEC XBRL fundamentals in this dataset (2010 at the earliest). |
| `fiscal_years_reported` | integer | Fiscal years with SEC fundamentals in this dataset. |
| `revenue_cagr_3y_pct` | decimal | Compound annual revenue growth over the last three fiscal years, percent. |
| `revenue_cagr_5y_pct` | decimal | Compound annual revenue growth over the last five fiscal years, percent. |
| `revenue_cagr_10y_pct` | decimal | Compound annual revenue growth over the last ten fiscal years, percent. |
| `net_income_cagr_5y_pct` | decimal | Compound annual net income growth over the last five fiscal years, percent; only when both years were profitable. |
| `revenue_5y_ago_usd` | decimal | Revenue five fiscal years before the latest, US dollars. |
| `revenue_10y_ago_usd` | decimal | Revenue ten fiscal years before the latest, US dollars. |
| `consecutive_revenue_growth_years` | integer | Fiscal years in a row, ending with the latest, in which revenue grew over the year before. |
| `consecutive_profitable_years` | integer | Fiscal years in a row, ending with the latest, with positive net income. |
| `profitable_years_10y` | integer | Fiscal years with positive net income among the last ten reported. |
| `dividend_years_10y` | integer | Fiscal years with dividends paid among the last ten reported. |
| `buyback_years_10y` | integer | Fiscal years with share repurchases among the last ten reported. |
| `cumulative_fcf_5y_usd` | decimal | Free cash flow summed over the last five fiscal years, US dollars. |
| `cumulative_dividends_5y_usd` | decimal | Dividends paid summed over the last five fiscal years, US dollars. |
| `cumulative_buybacks_5y_usd` | decimal | Share repurchases summed over the last five fiscal years, US dollars. |
| `shareholder_yield_pct` | decimal | Latest fiscal-year dividends plus buybacks as a percent of market capitalization. Empty for a preferred, debt, warrant, unit or right listing, which is not the… |
| `sec_company_name` | string | Company name as registered with the SEC. |
| `former_name` | string | The most recent former name the SEC lists for the registrant. |
| `sic_division` | string | SIC division of the registrant, such as Manufacturing or Finance, Insurance and Real Estate. |
| `sic_office` | string | SEC review office the registrant is assigned to, such as Office of Technology. |
| `hq_city` | string | City of the principal executive offices: the 10-K cover page, else the SEC business address. |
| `hq_state` | string | State or province of the principal executive offices: the 10-K cover page, else the SEC business address. |
| `hq_country` | string | Country of the SEC business address. |
| `headquarters` | string | Headquarters as the 10-K Item 1 states it, verbatim. |
| `incorporation_state` | string | State of incorporation, such as DE. |
| `incorporation_country` | string | Country of incorporation. |
| `fiscal_year_end_mmdd` | string | Fiscal year end as month and day, MMDD, such as 0930. |
| `filer_status` | string | SEC filer status as registered: Large accelerated filer, Accelerated filer or Non-accelerated filer. |
| `nasdaq_market_tier` | string | Nasdaq market tier: Global Select, Global Market or Capital Market; empty off Nasdaq. |
| `financial_status` | string | Nasdaq financial status flag; Normal, or Deficient, Delinquent or Bankrupt. |
| `latest_xbrl_form` | string | The latest XBRL financial filing form the SEC lists for the registrant, such as 10-Q. |
| `latest_xbrl_filed` | date | Date of the latest XBRL financial filing. |
| `latest_filing_form` | string | Form type of the most recent SEC filing of any kind, such as 8-K or 4. |
| `latest_filing_date` | date | Date of the most recent SEC filing of any kind. |
| `first_filing_date` | date | Date of the earliest SEC filing in this dataset (2010 at the earliest). |
| `filings_12m` | integer | SEC filings of any kind in the last twelve months. |
| `insider_filings_12m` | integer | Form 4 insider transaction filings in the last twelve months. |
| `reports_8k_12m` | integer | Form 8-K current reports in the last twelve months. |
| `last_10q_date` | date | Date of the latest 10-Q quarterly report. |
| `last_8k_date` | date | Date of the latest 8-K current report. |
| `last_proxy_date` | date | Date of the latest DEF 14A proxy statement. |
| `day_open` | decimal | Latest trading day's opening price, US dollars. |
| `day_high` | decimal | Latest trading day's high, US dollars. |
| `day_low` | decimal | Latest trading day's low, US dollars. |
| `avg_volume_50d` | decimal | Average daily volume over 50 trading days, shares. |
| `relative_volume_50d` | decimal | Latest day's volume divided by the 50-day average (unusual volume when well above 1). |
| `pct_vs_ema_50d` | decimal | Price distance from the 50-day exponential moving average, percent. |
| `pct_vs_ema_200d` | decimal | Price distance from the 200-day exponential moving average, percent. |
| `latest_10k_date` | date | Filing date of the latest 10-K. |
| `latest_10k_url` | string | The latest 10-K main document on EDGAR. |
| `latest_10k_form` | string | Form type of the latest annual report: 10-K, 10-KT or 10-K405. |
| `latest_10k_period` | date | Fiscal period the latest 10-K covers. |
| `latest_10k_accession` | string | SEC accession number of the latest 10-K. |
| `business_description` | string | What the company does, in its own words from the latest 10-K Item 1, one to three sentences. |
| `business_excerpt` | string | The first 1,200 characters of the latest 10-K Item 1 Business, verbatim. |
| `products` | string | Main products or services named in the latest 10-K, comma separated. |
| `segments` | string | Reportable business segments named in the latest 10-K, comma separated. |
| `markets` | string | Geographic markets, regions or countries the latest 10-K says the company operates or sells in, comma separated. |
| `major_customers` | string | Customers the latest 10-K names as major or significant. |
| `customer_concentration` | string | The 10-K sentence stating what share of revenue the largest customers account for. |
| `competitors` | string | Competitors named in the latest 10-K, comma separated. |
| `key_suppliers` | string | Suppliers the latest 10-K names as key, sole or single-source. |
| `manufacturing` | string | How or where products are made, as the latest 10-K states it. |
| `regulators` | string | Regulators and agencies the latest 10-K names as regulating the business, comma separated. |
| `backlog` | string | Stated backlog or remaining performance obligations, with its date, from the latest 10-K. |
| `employees_count` | integer | Employees as stated in the latest 10-K. |
| `employees_as_of` | string | The date the employee count is stated as of. |
| `founded_year` | integer | Year founded or incorporated, from the latest 10-K. |
| `website` | string | The company's website as a bare domain, such as apple.com: the latest 10-K, else Wikidata's official website matched by SEC CIK, else by ticker; for an ETF or… |
| `website_url` | string | The website address as its source states it, with https:// added when the source gives no scheme. |
| `auditor_10k` | string | Audit firm that signed the latest 10-K, such as Ernst & Young LLP. |
| `auditor_location` | string | City and state of the signing audit office. |
| `big4_auditor` | boolean | True when the auditor is Deloitte, EY, PwC or KPMG. |
| `icfr_auditor_attestation` | boolean | True when the auditor attested to internal control over financial reporting in the latest 10-K. |
| `public_float_usd` | decimal | Market value of shares held by non-affiliates (public float) as the latest 10-K cover states it, US dollars. |
| `shell_company` | boolean | True when the latest 10-K cover checks the shell company box. |
| `smaller_reporting_company` | boolean | True when the latest 10-K cover checks smaller reporting company. |
| `emerging_growth_company` | boolean | True when the latest 10-K cover checks emerging growth company. |
| `well_known_seasoned_issuer` | boolean | True when the latest 10-K cover checks well-known seasoned issuer. |
| `sector_10k` | string | GICS sector a classification model assigned from the 10-K business description. |
| `company_type` | string | Kind of company a classification model assigned from the 10-K: operating company, bank or lender, insurer, real estate investment trust, clinical-stage biotech… |
| `business_model` | string | Who the company mainly sells to, per a classification model reading the 10-K: businesses, consumers, both businesses and consumers, governments, or none fits. |
| `revenue_model` | string | How the company mainly earns revenue, per a classification model reading the 10-K: product sales, services or contracts, subscriptions or recurring fees, trans… |
| `geographic_focus` | string | Where the company mainly does business, per a classification model reading the 10-K: mostly the United States, global, or mostly outside the United States. |
| `ai_exposure` | string | How central artificial intelligence is to the business, per a classification model reading the 10-K: core, significant, peripheral or none. |
| `top_risk_theme` | string | The theme the 10-K Risk Factors stress most, per a classification model: competition, regulation and government policy, economy and demand, cybersecurity and t… |
| `going_concern_doubt` | boolean | True when the latest 10-K states substantial doubt about continuing as a going concern (rule on the text). |
| `going_concern_risk` | boolean | True when a classification model judged the 10-K says there is substantial doubt about continuing as a going concern. |
| `material_weakness` | boolean | True when the latest 10-K reports a material weakness in internal control. |
| `tariff_risk` | boolean | True when a classification model judged the 10-K names tariffs or trade restrictions as a risk. |
| `ai_risk` | boolean | True when a classification model judged the 10-K names artificial intelligence as a risk. |
| `ai_mentions` | integer | Times the latest 10-K mentions artificial intelligence, machine learning or AI. |
| `tariff_mentions` | integer | Times the latest 10-K mentions tariffs. |
| `risk_factors_length` | integer | Characters in the latest 10-K Item 1A Risk Factors; longer means more risks disclosed. |
| `cybersecurity_length` | integer | Characters in the latest 10-K Item 1C Cybersecurity. |
| `legal_proceedings_length` | integer | Characters in the latest 10-K Item 3 Legal Proceedings. |
| `mdna_length` | integer | Characters in the latest 10-K Item 7 Management's Discussion and Analysis. |
| `logo_url` | string | Logo image for the result card: Wikidata's logo on upload.wikimedia.org (a 250 px PNG of an SVG, or the original file), else the 128 px favicon of the website… |
| `search_text` | string | Ticker, names, industry, sector, SIC division, location and the 10-K business description, products, segments, markets, competitors and labels folded into one… |

## Table: Latest daily prices

- Table id: `e51fc3a4-8db4-4f77-bd81-9f5ea0fc6fdf`
- Slug: `source-quotes-latest`
- Immutable version: `3cb46bb4-7084-551a-8a24-2ac615b4cf15`
- Published name: source_quotes_latest
- Section: Prices
- Description: Latest end-of-day prices and indicators per security. Scheduled after US trading days.
- Schema: `GET https://mostlyright.md/api/v2/public/tables/e51fc3a4-8db4-4f77-bd81-9f5ea0fc6fdf/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/e51fc3a4-8db4-4f77-bd81-9f5ea0fc6fdf/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/e51fc3a4-8db4-4f77-bd81-9f5ea0fc6fdf/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/e51fc3a4-8db4-4f77-bd81-9f5ea0fc6fdf/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (30)

| Column | Type | Description |
| --- | --- | --- |
| `symbol` | string | Exchange ticker as source_securities lists it, such as AAPL or BRK.B. |
| `eodhd_code` | string | The ticker as EODHD codes it, with a dash for a class share. |
| `security_name` | string | The security's listed name. |
| `exchange` | string | The listing exchange: Nasdaq, NYSE, NYSE American, NYSE Arca or Cboe BZX. |
| `security_type` | string | common, etf, adr, preferred, warrant, unit or other, from source_securities. |
| `is_etf` | boolean | True for an exchange-traded fund. |
| `cik` | integer | SEC Central Index Key of the issuer, when it has one. |
| `quote_date` | date | The trading day of the latest bar. |
| `open` | decimal | Opening price of the latest day, in US dollars. |
| `high` | decimal | High of the latest day, in US dollars. |
| `low` | decimal | Low of the latest day, in US dollars. |
| `close` | decimal | Latest close, the current price, in US dollars. |
| `adjusted_close` | decimal | Latest close adjusted for splits and dividends, in US dollars. |
| `volume` | integer | Shares traded on the latest day. |
| `dollar_volume` | decimal | Close times volume: US dollars traded on the latest day. |
| `market_cap_usd` | decimal | Market capitalisation in US dollars from EODHD, today's figure; the company size or valuation. |
| `market_cap_size` | string | Size bucket from market cap: mega (200 billion and up), large (10 to 200 billion), mid (2 to 10 billion), small (300 million to 2 billion) or micro. |
| `beta` | decimal | Beta against the market from EODHD; above 1 moves more than the market. Empty where EODHD reports none (it sends 0 for most ETFs). |
| `ema_50d` | decimal | 50-day exponential moving average from EODHD. |
| `ema_200d` | decimal | 200-day exponential moving average from EODHD. |
| `pct_vs_ema_50d` | decimal | Percent the close sits above or below the 50-day EMA. |
| `pct_vs_ema_200d` | decimal | Percent the close sits above or below the 200-day EMA. |
| `high_250d` | decimal | Highest price over 250 trading days, about one year, the 52-week high. |
| `low_250d` | decimal | Lowest price over 250 trading days, the 52-week low. |
| `pct_from_250d_high` | decimal | Percent the close sits from the 250-day high; 0 means at the high. |
| `pct_from_250d_low` | decimal | Percent the close sits above the 250-day low. |
| `avg_volume_14d` | decimal | Average daily shares traded over 14 days. |
| `avg_volume_50d` | decimal | Average daily shares traded over 50 days. |
| `avg_volume_200d` | decimal | Average daily shares traded over 200 days. |
| `relative_volume_50d` | decimal | Latest volume divided by the 50-day average volume; above 2 is unusual volume. |

## Table: Daily price history — A–D

- Table id: `6ae30c00-b755-4fd3-804c-b0de2d8fb7c6`
- Slug: `series-prices-a-d`
- Immutable version: `63b466fc-2f08-5d93-8ef3-918349cb32db`
- Published name: series_prices_a_d
- Section: Prices
- Description: Daily OHLC, adjusted close, volume and technical indicators since 2010. History rebuilds weekly on Saturdays.
- Schema: `GET https://mostlyright.md/api/v2/public/tables/6ae30c00-b755-4fd3-804c-b0de2d8fb7c6/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/6ae30c00-b755-4fd3-804c-b0de2d8fb7c6/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/6ae30c00-b755-4fd3-804c-b0de2d8fb7c6/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/6ae30c00-b755-4fd3-804c-b0de2d8fb7c6/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (48)

| Column | Type | Description |
| --- | --- | --- |
| `symbol` | string | Exchange ticker as source_securities lists it, such as AAPL or BRK.B. |
| `eodhd_code` | string | The ticker as EODHD codes it, with a dash for a class share, such as BRK-B. |
| `security_name` | string | The security's listed name. |
| `exchange` | string | The listing exchange: Nasdaq, NYSE, NYSE American, NYSE Arca or Cboe BZX. |
| `security_type` | string | common, etf, adr, preferred or other, from source_securities. |
| `is_etf` | boolean | True for an exchange-traded fund. |
| `cik` | integer | SEC Central Index Key of the issuer, when it has one. |
| `date` | date | The trading day. |
| `open` | decimal | Opening price that day in US dollars, as traded. |
| `high` | decimal | Day's high in US dollars, as traded. |
| `low` | decimal | Day's low in US dollars, as traded. |
| `close` | decimal | Closing price in US dollars, as traded, not adjusted. |
| `adjusted_close` | decimal | Close adjusted for splits and dividends, in US dollars; every return and indicator uses it. |
| `volume` | integer | Shares traded that day. |
| `dollar_volume` | decimal | Close times volume: US dollars traded that day, the trading value or turnover. |
| `return_1d_pct` | decimal | Daily price change in percent: today's adjusted close against the previous trading day, the daily gain or loss. |
| `return_5d_pct` | decimal | Price change over 5 trading days, one week, in percent. |
| `return_1m_pct` | decimal | Price change over 21 trading days, one month, in percent. |
| `return_3m_pct` | decimal | Price change over 63 trading days, three months, in percent. |
| `return_6m_pct` | decimal | Price change over 126 trading days, six months, in percent. |
| `return_1y_pct` | decimal | Price change over 252 trading days, one year, 12 months, in percent. |
| `sma_20` | decimal | Simple moving average of the adjusted close over 20 trading days. |
| `sma_50` | decimal | Simple moving average of the adjusted close over 50 trading days, the 50-day moving average. |
| `sma_200` | decimal | Simple moving average of the adjusted close over 200 trading days, the 200-day moving average. |
| `ema_12` | decimal | Exponential moving average of the adjusted close, 12-day span. |
| `ema_26` | decimal | Exponential moving average of the adjusted close, 26-day span. |
| `ema_50` | decimal | Exponential moving average of the adjusted close, 50-day span. |
| `ema_200` | decimal | Exponential moving average of the adjusted close, 200-day span. |
| `macd_line` | decimal | MACD: the 12-day minus the 26-day exponential moving average. |
| `macd_signal` | decimal | MACD signal line: the 9-day exponential average of the MACD line. |
| `macd_histogram` | decimal | MACD histogram: MACD line minus signal line; positive is bullish momentum. |
| `rsi_14` | decimal | Relative strength index over 14 days with Wilder smoothing, 0 to 100; under 30 is oversold, over 70 overbought. |
| `atr_14` | decimal | Average true range over 14 days with Wilder smoothing, in US dollars. |
| `atr_14_pct` | decimal | Average true range as a percent of the adjusted close. |
| `volatility_20d_pct` | decimal | Annualized volatility of daily returns over the last 20 trading days, in percent. |
| `volatility_1y_pct` | decimal | Annualized volatility of daily returns over the last 252 trading days, in percent. |
| `high_52w` | decimal | Highest adjusted high over the last 252 trading days, the 52-week high. |
| `low_52w` | decimal | Lowest adjusted low over the last 252 trading days, the 52-week low. |
| `pct_from_52w_high` | decimal | Percent the adjusted close sits from the 52-week high; 0 means at the high. |
| `pct_from_52w_low` | decimal | Percent the adjusted close sits above the 52-week low. |
| `pct_vs_sma_50` | decimal | Percent the adjusted close sits above or below its 50-day moving average. |
| `pct_vs_sma_200` | decimal | Percent the adjusted close sits above or below its 200-day moving average. |
| `ma_cross` | string | golden when the 50-day moving average is above the 200-day, death when below. |
| `avg_volume_20d` | decimal | Average shares traded per day over the last 20 trading days. |
| `avg_volume_50d` | decimal | Average shares traded per day over the last 50 trading days. |
| `relative_volume` | decimal | Today's volume divided by the 20-day average volume; above 2 is unusual volume. |
| `trading_day_number` | integer | Which trading day of this ticker's history since 2010 the row is; indicators need enough days before them. |
| `is_latest` | boolean | True on each ticker's most recent trading day in the table, the latest price. |

## Table: Daily price history — E–G

- Table id: `e1e723fd-57dc-4c95-a528-0983c7d977eb`
- Slug: `series-prices-e-g`
- Immutable version: `adb63c5d-ac2d-52d8-8fe3-b91f896b4b55`
- Published name: series_prices_e_g
- Section: Prices
- Description: Daily OHLC, adjusted close, volume and technical indicators since 2010. History rebuilds weekly on Saturdays.
- Schema: `GET https://mostlyright.md/api/v2/public/tables/e1e723fd-57dc-4c95-a528-0983c7d977eb/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/e1e723fd-57dc-4c95-a528-0983c7d977eb/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/e1e723fd-57dc-4c95-a528-0983c7d977eb/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/e1e723fd-57dc-4c95-a528-0983c7d977eb/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (48)

| Column | Type | Description |
| --- | --- | --- |
| `symbol` | string | Exchange ticker as source_securities lists it, such as AAPL or BRK.B. |
| `eodhd_code` | string | The ticker as EODHD codes it, with a dash for a class share, such as BRK-B. |
| `security_name` | string | The security's listed name. |
| `exchange` | string | The listing exchange: Nasdaq, NYSE, NYSE American, NYSE Arca or Cboe BZX. |
| `security_type` | string | common, etf, adr, preferred or other, from source_securities. |
| `is_etf` | boolean | True for an exchange-traded fund. |
| `cik` | integer | SEC Central Index Key of the issuer, when it has one. |
| `date` | date | The trading day. |
| `open` | decimal | Opening price that day in US dollars, as traded. |
| `high` | decimal | Day's high in US dollars, as traded. |
| `low` | decimal | Day's low in US dollars, as traded. |
| `close` | decimal | Closing price in US dollars, as traded, not adjusted. |
| `adjusted_close` | decimal | Close adjusted for splits and dividends, in US dollars; every return and indicator uses it. |
| `volume` | integer | Shares traded that day. |
| `dollar_volume` | decimal | Close times volume: US dollars traded that day, the trading value or turnover. |
| `return_1d_pct` | decimal | Daily price change in percent: today's adjusted close against the previous trading day, the daily gain or loss. |
| `return_5d_pct` | decimal | Price change over 5 trading days, one week, in percent. |
| `return_1m_pct` | decimal | Price change over 21 trading days, one month, in percent. |
| `return_3m_pct` | decimal | Price change over 63 trading days, three months, in percent. |
| `return_6m_pct` | decimal | Price change over 126 trading days, six months, in percent. |
| `return_1y_pct` | decimal | Price change over 252 trading days, one year, 12 months, in percent. |
| `sma_20` | decimal | Simple moving average of the adjusted close over 20 trading days. |
| `sma_50` | decimal | Simple moving average of the adjusted close over 50 trading days, the 50-day moving average. |
| `sma_200` | decimal | Simple moving average of the adjusted close over 200 trading days, the 200-day moving average. |
| `ema_12` | decimal | Exponential moving average of the adjusted close, 12-day span. |
| `ema_26` | decimal | Exponential moving average of the adjusted close, 26-day span. |
| `ema_50` | decimal | Exponential moving average of the adjusted close, 50-day span. |
| `ema_200` | decimal | Exponential moving average of the adjusted close, 200-day span. |
| `macd_line` | decimal | MACD: the 12-day minus the 26-day exponential moving average. |
| `macd_signal` | decimal | MACD signal line: the 9-day exponential average of the MACD line. |
| `macd_histogram` | decimal | MACD histogram: MACD line minus signal line; positive is bullish momentum. |
| `rsi_14` | decimal | Relative strength index over 14 days with Wilder smoothing, 0 to 100; under 30 is oversold, over 70 overbought. |
| `atr_14` | decimal | Average true range over 14 days with Wilder smoothing, in US dollars. |
| `atr_14_pct` | decimal | Average true range as a percent of the adjusted close. |
| `volatility_20d_pct` | decimal | Annualized volatility of daily returns over the last 20 trading days, in percent. |
| `volatility_1y_pct` | decimal | Annualized volatility of daily returns over the last 252 trading days, in percent. |
| `high_52w` | decimal | Highest adjusted high over the last 252 trading days, the 52-week high. |
| `low_52w` | decimal | Lowest adjusted low over the last 252 trading days, the 52-week low. |
| `pct_from_52w_high` | decimal | Percent the adjusted close sits from the 52-week high; 0 means at the high. |
| `pct_from_52w_low` | decimal | Percent the adjusted close sits above the 52-week low. |
| `pct_vs_sma_50` | decimal | Percent the adjusted close sits above or below its 50-day moving average. |
| `pct_vs_sma_200` | decimal | Percent the adjusted close sits above or below its 200-day moving average. |
| `ma_cross` | string | golden when the 50-day moving average is above the 200-day, death when below. |
| `avg_volume_20d` | decimal | Average shares traded per day over the last 20 trading days. |
| `avg_volume_50d` | decimal | Average shares traded per day over the last 50 trading days. |
| `relative_volume` | decimal | Today's volume divided by the 20-day average volume; above 2 is unusual volume. |
| `trading_day_number` | integer | Which trading day of this ticker's history since 2010 the row is; indicators need enough days before them. |
| `is_latest` | boolean | True on each ticker's most recent trading day in the table, the latest price. |

## Table: Daily price history — H–L

- Table id: `803b904b-50c6-45a2-ab6d-c9adef71c33b`
- Slug: `series-prices-h-l`
- Immutable version: `8c557e0a-ec11-5b0f-8895-d9db2a0af3b3`
- Published name: series_prices_h_l
- Section: Prices
- Description: Daily OHLC, adjusted close, volume and technical indicators since 2010. History rebuilds weekly on Saturdays.
- Schema: `GET https://mostlyright.md/api/v2/public/tables/803b904b-50c6-45a2-ab6d-c9adef71c33b/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/803b904b-50c6-45a2-ab6d-c9adef71c33b/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/803b904b-50c6-45a2-ab6d-c9adef71c33b/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/803b904b-50c6-45a2-ab6d-c9adef71c33b/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (48)

| Column | Type | Description |
| --- | --- | --- |

This document was cut at 60 KiB. The complete version is at https://mostlyright.md/datasets/us-stocks-and-etfs-prices-and-sec-fundamentals-since-2010.