# Stock & ETF Data – API & Google Sheets Access > 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. Source: https://www.marketdata.app/data/stocks/ --- 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. [Sign up For Free](/signup/) [Pricing](/pricing/) 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. QuotesCandlesEarningsNews [GET /v1/stocks/quotes/{symbol}](/docs/api/stocks/quotes) 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 [Try for Free](/signup/) [View Docs](/docs/api/stocks/quotes) ``` { "s": "ok", "symbol": ["AAPL"], "ask": [325.08], "askSize": [80], "bid": [325.03], "bidSize": [120], "mid": [325.055], "last": [325.02], "change": [8.17], "changepct": [0.0258], "volume": [29611705], "updated": [1788283103] } ``` [GET /v1/stocks/candles/{resolution}/{symbol}](/docs/api/stocks/candles) 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 [Try for Free](/signup/) [View Docs](/docs/api/stocks/candles) ``` { "s": "ok", "o": [316.85, 319.6, 316.7], "h": [322.37, 321.24, 327.3], "l": [315.45, 312.8, 314.73], "c": [319.7, 316.85, 325.575], "t": [1787889600, 1788148800, 1788235200], "v": [38649398, 41242724, 28443573] } ``` [GET /v1/stocks/earnings/{symbol}](/docs/api/stocks/earnings) 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 [Try for Free](/signup/) [View Docs](/docs/api/stocks/earnings) ``` { "s": "ok", "symbol": ["AAPL"], "fiscalYear": [2026], "fiscalQuarter": [4], "date": [1790740800], "reportDate": [1793246400], "reportTime": ["after close"], "currency": [null], "reportedEPS": [null], "estimatedEPS": [1.98], "surpriseEPS": [null], "surpriseEPSpct": [null], "updated": [1787803200] } ``` [GET /v1/stocks/news/{symbol}](/docs/api/stocks/news) 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 [Try for Free](/signup/) [View Docs](/docs/api/stocks/news) ``` { "s": "ok", "symbol": ["AAPL", "AAPL"], "headline": [ "Apple Stock Did Great During Cook’s Time as CEO—But So Did the Mag 7", "Apple's accusations are making things uncomfortable for OpenAI" ], "source": [ "https://finance.yahoo.com/m/e601ea86-d74b-3fd4-945a-15239a98fb68/apple-stock-did-great-during.html", "https://finance.yahoo.com/technology/ai/articles/apples-accusations-making-things-uncomfortable-160300847.html" ], "publicationDate": [1788235200, 1788235200], "updated": 1788235200 } ``` 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 (image: STOCKDATA real-time quote with a custom column configuration) STOCKDATA real-time quotes using cell references with the header row disabled in the output (image: 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 (image: 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](/topics/data/stocks/) [ (image: The letters API at the centre of a cyan network diagram, its spokes radiating to eight ringed nodes on dark navy.) 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. ](/api/stocks/stock-market-api/)[ (image: A pencil on a blue-tinted calendar page, crossed by a red band lettered MARKET HOLIDAYS.) How To Use The Stock Market Holidays API Use the stock market holidays API to get the open or closed status for any date in the past, present or future. ](/api/stocks/stock-market-holidays/)[ (image: Blue isometric circuitry lettered HISTORICAL STOCK DATA API, above a pill reading GETTING STARTED: LEARN BY EXAMPLE.) 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. ](/api/stocks/historical-stock-data-api/)[ (image: A close, shallow-focus photograph of green and red candlesticks on a dark trading screen.) How To Get Intraday Stock Prices in Google Sheets Learn how to get intraday stock prices in Google Sheets (with prices down to the minute) using a simple formula that works the same way as GoogleFinance. ](/sheets/stocks/intraday-stock-prices/)[ (image: The word EARNINGS across a wireframe globe, ringed by bar charts, pie charts, line graphs and spreadsheet panels on a green background.) How To Get An Earnings Calendar For Any Stock In Google Sheets Add an earnings calendar to Google Sheets using Market Data's EARNINGS formula. Find what Wall Street Analysts are projecting for next quarter. ](/sheets/stocks/earnings-calendar/)[ (image: Rows of five-decimal quotes such as 1.20506 and 1.18189 glowing green and blue on a dark screen.) How To Get Real-Time Stock Prices in Google Sheets The GOOGLEFINANCE formula gives 15-min delayed stock prices. Get real-time stock prices into Google Sheets using the STOCKDATA formula. ](/sheets/stocks/how-to-get-real-time-stock-prices/)[ (image: The letters API at the centre of a cyan network diagram, its spokes radiating to eight ringed nodes on dark navy.) 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. ](/api/stocks/free-stock-market-api/)[ (image: A close, shallow-focus photograph of green and red candlesticks on a dark trading screen.) Candles vs Quotes, What’s The Difference? Candles or quotes? STOCKDATA returns both, and picking the wrong one skews your spreadsheet. Here is what each one holds and when to use it. ](/sheets/stocks/candles-vs-quotes/)[ (image: Rows of green and magenta prices beside six-figure volumes on an angled market quote board.) How To Bulk Download Stock Data in Google Sheets Learn how to perform bulk stock data downloads using Market Data's Google Sheets Add-on. ](/sheets/stocks/bulk-download-stock-data/) ## 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](/contact/?department=sales) team. ## Where does the real-time stock data come from? Is it sourced directly from the exchanges? 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. ## Do you offer pre-market and after-hours data? 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. ## How far back does your historical data go? We offer historical stock data going back to 2010. For some stocks, data may be available further back, depending on the symbol. ## Is the data adjusted for splits and dividends? 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. ## Do you offer consolidated tape data or exchange-specific feeds? 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. ## How often is candlestick data refreshed? 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. ## How do you handle symbol changes or delistings? 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. (image: API network diagram showing interconnected nodes representing Market Data API infrastructure) ### 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. [Try For Free](/signup/) [Try It](https://api.marketdata.app) [View Docs](/docs/api/) (image: Google Sheets interface showing market data integration with spreadsheet formulas) ### 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. [Try For Free](/signup/) [Install](https://workspace.google.com/marketplace/app/market_data/453586334945) [View Docs](/docs/sheets/)