The Future of Market Data
With 24/7 access to the universe of U.S. financial market data, the Market Data API offers an unmatched, one-stop solution for traders and developers alike.
Multi-Asset Data Coverage
All U.S. Market Data, One Flat Fee
Get complete access to U.S. stocks, options, ETFs, mutual funds, and more — all included in a single membership. No upsells, no add-ons. Just one simple plan for everything you need.
Stocks
Harness real-time quotes and decades of historical pricing data. Access fundamental data, earnings, and more.
Options
Master volatility. Get current and historical options quotes and option chains.
ETFs
Performance data for all index funds and manager-managed funds that trade in the US.
Mutual Funds
Venture into the landscape of mutual funds with our pricing and performance data.
Closed-End Funds
Discover the advantages of CEFs with Market Data's historical pricing and performance metrics.
Indices
Empower your strategy with top-tier equity indices from the US and beyond.
Futures
Historical and front month futures pricing for insights into the global commodities trade.
Currencies
Defy borders, redefine trading. Dive fearlessly into currencies data.
Crypto
Elevate your crypto trading. Power-packed data for crypto champions.
Bonds
Master fixed income securities, explore yield curves, and immerse yourself in bond data.
Economic Indicators
From employment rates to inflation, gain a 360-degree view of the US economy with our economic indicators.
Unparalleled Ease-of-Use
Get Started Faster with Our Developer-Friendly Features
Building with the Market Data API is not just about comprehensive data coverage; it's also about unparalleled ease-of-use. Whether you're a beginner or an experienced developer, you'll appreciate how our API has been designed to get you up and running as quickly as possible. Here are some of the features that make it happen:
Unix, ISO timestamp & spreadsheet date formats
Choose the date format that best fits your project requirements, giving you the flexibility to integrate seamlessly with different platforms. Our API handles all date conversions, daylight savings time shifts, and frees you to focus on more important issues.
- Seconds from the unix epoch
- ISO 8601 timestamp with exchange timezone
- Days from Microsoft Excel / Google Sheets epoch
{
"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],
// Unix timestamps
"t": [1787889600, 1788148800, 1788235200],
"v": [38649398, 41242724, 28443573]
}
{
"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],
// ISO 8601 with exchange timezone
"t": [
"2026-08-28T00:00:00-04:00", "2026-08-31T00:00:00-04:00",
"2026-09-01T00:00:00-04:00"
],
"v": [38649398, 41242724, 28443573]
}
{
"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],
// Excel / Google Sheets serial
"t": [46262.16666666667, 46265.16666666667, 46266.16666666667],
"v": [38649398, 41242724, 28443573]
}Human Readable Output
Generate tabular data with human-readable output that can be printed directly to the screen, with error/status messaging suppressed. Make debugging and data interpretation straightforward, saving you time in development and analysis.
- Straightforward debugging and data interpretation
- Save time in development and analysis
- Render data directly to the screen with no transformation
- Status & error messaging suppressed
// Request status included
// Compressed keys
{
"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]
}
// Request status omitted
// Human-readable keys
// Data can be sent directly to screen
{
"Open": [316.85, 319.6, 316.7],
"High": [322.37, 321.24, 327.3],
"Low": [315.45, 312.8, 314.73],
"Close": [319.7, 316.85, 325.575],
"Date": [1787889600, 1788148800, 1788235200],
"Volume": [38649398, 41242724, 28443573]
}Work in the Data Format That Suits Your Project
All output can be formatted as JSON or CSV. Flexibility to work in the data format that suits your project, making it easier to integrate with different tools and platforms.
- Every endpoint can output both json and csv formats
- Combine csv format with spreadsheet dates & human-readable output to generate complete spreadsheets with a single API request
- Error messaging and status columns are omitted from spreadsheet output
// JSON output
{
"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]
}
// CSV output
o,h,l,c,t,v
316.85,322.37,315.45,319.7,1787889600,38649398
319.6,321.24,312.8,316.85,1788148800,41242724
316.7,327.3,314.73,325.575,1788235200,28443573Relative Dates
Use keywords like "today", "yesterday", or "now" for date queries. Allows for faster, more intuitive and streamlined coding, as API calls relative to today can be hardcoded with relative date keywords. Query options expirations using days to expiry "DTE".
- Use keywords like "yesterday" or "today"
- Request intraday candles relative to 'now' to access the most recently available exchange data
- Use "DTE" to match the closest expiration date
Try It In Your Browser
- Intraday 30 minute candles for today: /v1/stocks/candles/30/AAPL/?from=today&to=now
- Option expirations 45 days out: /v1/options/chain/AAPL/?dte=45
- Daily candles with 2 years of history: /v1/stocks/candles/D/AAPL/?from=2YearsAgo&to=today
Get Precisely What You Need
You can include or suppress columns in the output to receive exactly the data needed. Columns are returned in the order you request them. Get precisely what you need, no more and no less, optimizing data loads and application performance.
- Get exactly the data needed
- Columns are returned in the order you request them
- Ideal use-case: Dataframes or spreadsheets
// Stock Candle endpoint
// Standard output
{
"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]
}
// Stock Candle endpoint
// Only 2 columns requested
{
"c": [319.7, 316.85, 325.575],
"t": [1787889600, 1788148800, 1788235200]
}Recent API & Sheets Tutorials
Get up and running quickly with our API and Google Sheets Add-on. Learn how to access real-time or historic market data programmatically or in your spreadsheet. View all
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.
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 Bulk Download Stock Data in Google Sheets
Learn how to perform bulk stock data downloads using Market Data's Google Sheets Add-on.
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 Get Stock Market Holidays In Your Spreadsheet
Get past, present, and future stock market holidays for the United States directly into your spreadsheet with the MARKETSTATUS 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 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 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.
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.
How To Get An Option Chain In Google Sheets
Use the OPTIONCHAIN formula to get a complete real-time option chain in Google Sheets. Filter by date, days to expiration, strike, deltas, and more.
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.
How to Calculate Theta For An Option
Learn how to calculate theta and understand how to add time decay to your spreadsheets.