Stock & ETF Data
US stock and ETF data, simplified.
Access real-time prices, historical data, and fundamentals for every listed stock and ETF—via API or Google Sheets.
Market Data Stock APIs
Simple to Use, Quick to Deploy, Easy to Adapt
Get market data into your applications without the overhead. Our APIs are designed for speed, clarity, and flexibility—so you can focus on building, not debugging.
Unlock the U.S. Stock Markets
Get fast, responsive pricing for U.S. equities—ideal for apps, dashboards, and tools that need consistent, up-to-the-minute quote data.
- Live pricing for any U.S. stock
- Last trade, daily & percent change included
- 52-week high/low optional
- Optional intraday-updated daily candle information
{
"s": "ok",
"symbol": ["AAPL"],
"ask": [182.12],
"askSize": [3],
"bid": [182.1],
"bidSize": [3],
"mid": [182.11],
"last": [182.1],
"change": [-0.3],
"changepct": [-0.0016],
"volume": [4051215],
"o": [182.85],
"h": [182.96],
"l": [181.93],
"c": [182.1],
"52weekHigh": [199.62],
"52weekLow": [164.08],
"updated": [1715175712]
}Supercharge your Charts & Analysis
Access robust, high-quality candlestick data to power your charting and analysis tools. One simple endpoint gives you flexible access to intraday and daily pricing, with full support for historical and recent trading activity.
- Flexible daily and intraday resolutions—1 minute to 1 year
- High-quality daily & intraday candles, updated throughout the trading day.
- Choose between as-traded or split-adjusted historical data
- Covers both regular and extended hours sessions
- Query by start/end, relative dates, or fixed count
{
"s": "ok",
"o": [221.03,
218.55,
220],
"h": [222.49,
221.5,
220.94],
"l": [217.19,
217.14,
218.83],
"c": [217.68,
221.03,
219.89],
"v": [33463820,
24018876,
20730608],
"t": [1569297600,
1569384000,
1569470400]
}Take Control of Quarterly Earnings
Don't let earnings sneak up on you. Get programmatic access to earnings reports, including reporting dates, analyst EPS estimates, earnings surprises, and more. Enhance your financial analysis with comprehensive data on reported and estimated earnings per share.
- Includes analyst EPS estimates, allowing for direct comparison with reported figures
- Earnings data for each fiscal quarter, ensuring comprehensive coverage throughout the year
- Surprise EPS values and their percentage differences for performance evaluation
- Dates of earnings reports and expected report times for precise planning
{ "s": "ok",
"symbol":
["AAPL", "AAPL", "AAPL", "AAPL"],
"fiscalYear":
[2023, 2023, 2023, 2023],
"fiscalQuarter":
[1, 2, 3, 4],
"date":
["2022-12-31", "2023-03-31", "2023-06-30", "2023-09-30"],
"reportDate":
["2023-02-02", "2023-05-04", "2023-08-03", "2023-11-02"],
"reportTime":
["after close", "after close", "after close", "after close"],
"currency":
["USD", "USD", "USD", "USD"],
"reportedEPS":
[1.88, 1.52, 1.26, 1.46],
"estimatedEPS":
[1.94, 1.43, 1.19, 1.39],
"surpriseEPS":
[-0.06, 0.09, 0.07, 0.07],
"surpriseEPSpct":
[-0.0309, 0.0629, 0.0588, 0.0504],
"updated":
["2024-05-09", "2024-05-09", "2024-05-09", "2024-05-09"]}Get The Why Behind Each Move
Get a steady stream of headlines and summaries from trusted sources, helping users stay current on what's moving the market. Ideal for personal dashboards, watchlists, or chart annotations.
- Query by date range or request a specific number of headlines
- Includes headline, content excerpt, and source URL for each story
- Delivered as HTML for easy display in personal tools and apps
{
"s": "ok",
"symbol": [
"AAPL",
"AAPL"],
"headline": [
"iPhone Exports From India Double, Predicted To Hit Record $13B This Year As Apple's Pivot Away From China Pays Off",
"Warren Buffett's $189 Billion Subtle Warning to Wall Street Shouldn't Be Ignored"],
"source": [
"https://finance.yahoo.com/news/iphone-exports-india-double-predicted-113756676.html",
"https://finance.yahoo.com/news/warren-buffetts-189-billion-subtle-084100685.html"],
"publicationDate": [
1715572800,
1715572800],
"updated": 1715572800
}The STOCKDATA Formula
One Formula For Real-Time + Historical Data
Designed for both real-time insights and in-depth historical analysis, STOCKDATA is fully configurable and provides a comprehensive view of market movements. Resolutions down to the minute and real-time quotes are supported.
STOCKDATA real-time quote with a custom column configuration

STOCKDATA real-time quotes using cell references with the header row disabled in the output

STOCKDATA 1-minute candles using relative dates for automatic updating

Get Started With Stock Data
Learn how to make the most of our stock data with these quickstart tutorials for Google Sheets and the Market Data API. View all

How To Get Historical Options Prices For Your Spreadsheet
Using the Market Data Add-on, it is possible to get historical options prices going back decades directly into your spreadsheet with a simple formula.

How To Use the Stock Market API — With Examples!
Get real-time and historical market data from the stock market api. Learn quickly with easy to use examples that work right from your browser.

How To Calculate Implied Volatility In Your Spreadsheet
Using the OPTIONDATA formula, you can calculate implied volatility for any option.

How To Use The Historical Stock Data API
Learn by example and get started with the historical stock data api. Both daily and intraday data is available going back decades.

How To Use The Mutual Fund API
Learn by example and get started with the mutual fund api. Get candlestick and pricing data going back decades.

How To Calculate Option Greeks In Your Spreadsheet
The OPTIONDATA formula will calculate the option greeks to your spreadsheet automatically using the keyword "greeks" as a parameter. Risk management has never been easier.

How To Get Options Prices in Google Sheets
Learn how to add real-time and historical options prices into your Google Sheets spreadsheets using a single formula.

How To Use The Free Stock Market API: A Guided Tour of our Swagger UI
Finally, a free stock market API without scraping or proxies. Learn how to get stock pricing data, both current and historical, using swagger.

How To Build A Covered Call Spreadsheet
Learn how to build a covered call spreadsheet to track all your covered calls. Download our free covered call tracking spreadsheet example sheet for Google Sheets and begin tracking your covered calls today.

How To Use The Option Data API — With Examples!
The Option Data API allows you to easily get a real-time or historical option quote for stock, ETF, or index options.

How To Use The Option Chain API — With Examples!
The Option Chain API allows for ample sorting & filtering during each request, making it easy to get exactly the data you need.

How to Calculate Theta For An Option
Learn how to calculate theta and understand how to add time decay to your spreadsheets.
Frequently Asked Questions
This section explains how our stock data works—what's included, how it's sourced, and the types of access available. Browse the questions below to learn more about our stock coverage, including supported exchanges, timeframes, extended hours, and historical depth. If you have specific needs not covered here, feel free to reach out to our sales team.
Our real-time data comes from the Investors Exchange (IEX), one of the 16 U.S. stock exchanges. IEX publishes real-time quotes and trades for thousands of U.S. exchange-listed stocks—including popular symbols like SPY, QQQ, AAPL, TSLA, NVDA, and more. This data is fast, high-quality, and available without exchange fees for personal and non-commercial use.
Will I see real-time prices for stocks that don't list on IEX? Yes. In the U.S., stocks can trade on multiple exchanges, not just the one they're listed on. For example, NVDA is listed on NASDAQ, but it also trades on NYSE, IEX, and other venues. The same goes for TSLA, AAPL, and all major stocks. IEX handles trades for nearly all actively traded U.S. stocks and ETFs, and it publishes real-time quotes and trades for them. That means you'll still get live, real-time updates for these stocks—even if they're officially listed on the NYSE, Nasdaq, or elsewhere.
Is the data the same for the spreadsheet and the API? Spreadsheet users receive real-time stock quotes directly from the IEX exchange—offering true exchange-sourced pricing at an unbeatable value. This makes it ideal for personal dashboards, research models, and custom tracking tools where fast, reliable data matters.
API users receive Smart Mid, our proprietary real-time pricing model designed to reflect fair market value with greater precision than a simple midpoint. Smart Mid adjusts dynamically based on top-of-book order size, recent trades, and quote activity—providing a fast, liquidity-aware estimate of the current real-time price. It is derived from IEX data and offers a reliable, high-performance solution for personal and non-commercial use.
Yes, we include both pre-market and after-hours trading data for all the stocks we support. You can access it through the API or directly in Google Sheets using our add-on.
We offer historical stock data going back to 2010. For some stocks, data may be available further back, depending on the symbol.
By default, intraday data is provided as traded, and daily data is split-adjusted. However, you can request either format—split-adjusted or raw—for both daily and intraday data, depending on your needs. Dividend adjustments are not currently supported.
We offer historical candlestick data based on the full SIP (consolidated tape), giving you accurate price and volume data that reflects activity across all major U.S. exchanges. It's a reliable foundation for research, backtesting, and long-term analysis.
We do not currently offer real-time SIP feeds or direct exchange-specific feeds. Instead, our real-time coverage is built around two solutions: IEX-sourced quotes in spreadsheets and our Smart Mid model in the API, which estimates real-time pricing based on top-of-book activity.
Our goal is to offer high-quality market data at accessible pricing for individual users. As we grow, we plan to expand our real-time offerings—adding consolidated and exchange-specific feeds where it makes sense technically and economically, without compromising affordability.
Our candlestick data — both daily and intraday — is based on official exchange data and is typically delayed by up to 15 minutes to comply with exchange distribution rules.
We also provide real-time stock quote data for paid users, giving you access to the latest market prices when needed.
Because candlestick data reflects slightly delayed exchange information, the "close" price of a candle may not match the real-time "last" price from a quote at any given moment.
Candlesticks are refreshed continuously during market hours using the latest available official data, ensuring consistent and reliable pricing.
If you need the most current trade information, we recommend using our real-time quote formulas or endpoints alongside candlestick data.
Our historical data reflects each symbol exactly as it was traded on a given date. If a company has changed its ticker or been delisted, you'll need to use the symbol that was active at the time. We include data for most delisted stocks, making it possible to analyze long-term histories—even across corporate actions. While we don't currently offer a built-in symbol change tracker, you're free to integrate one externally to support your workflow.
Get Data Anywhere
How would you like to receive your data? Let's get started.

Market Data API
Our RESTful API allows on-demand access to our entire data catalog. With a single subscription plan, get access to both real-time and historic data on whatever instrument you need.

Google Sheets Add-on
Use simple formulas based on GoogleFinance to download market data directly into your Google spreadsheets. Both real-time and historical data is available.