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
{// Unix timestamps
"s": "ok",
"o": [217.68, 221.03, 219.89],
"h": [222.49, 221.5, 220.94],
"l": [217.19, 217.1402, 218.83],
"c": [221.03, 218.55, 220],
"t": [1569297600, 1569384000, 1569470400],
"v": [33463820, 24018876, 20730608]
}
{ // ISO 8601 with exchange timezone
"s": "ok",
"o": [217.68, 221.03, 219.89],
"h": [222.49, 221.5, 220.94],
"l": [217.19, 217.1402, 218.83],
"c": [221.03, 218.55, 220],
"t": ["2019-09-24T00:00:00-04:00", "2019-09-25T00:00:00-04:00", "2019-09-26T00:00:00-04:00"],
"v": [33463820, 24018876, 20730608]
}
{ // Excel/Sheets timestamp
"s": "ok",
"o": [217.68, 221.03, 219.89],
"h": [222.49, 221.5, 220.94],
"l": [217.19, 217.1402, 218.83],
"c": [221.03, 218.55, 220],
"t": [43732.166666666664, 43733.166666666664, 43734.166666666664],
"v": [33463820, 24018876, 20730608]
}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": [217.68, 221.03, 219.89],
"h": [222.49, 221.5, 220.94],
"l": [217.19, 217.1402, 218.83],
"c": [221.03, 218.55, 220],
"t": [1569297600, 1569384000, 1569470400],
"v": [33463820, 24018876, 20730608]
}
// Request status omitted
// Human-readable keys
// Data can be sent directly to screen
{
"Open": [217.68, 221.03, 219.89],
"High": [222.49, 221.5, 220.94],
"Low": [217.19, 217.1402, 218.83],
"Close": [221.03, 218.55, 220],
"Date": [1569297600, 1569384000, 1569470400],
"Volume": [33463820, 24018876, 20730608]
}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": [217.68, 221.03, 219.89],
"h": [222.49, 221.5, 220.94],
"l": [217.19, 217.1402, 218.83],
"c": [221.03, 218.55, 220],
"t": [1569297600, 1569384000, 1569470400],
"v": [33463820, 24018876, 20730608]
}
// CSV output
o,h,l,c,t,v
217.68,222.49,217.19,221.03,1569297600,33463820
221.03,221.5,217.1402,218.55,1569384000,24018876
219.89,220.94,218.83,220,1569470400,20730608Relative 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": [217.68, 221.03, 219.89],
"h": [222.49, 221.5, 220.94],
"l": [217.19, 217.1402, 218.83],
"c": [221.03, 218.55, 220],
"t": [1569297600, 1569384000, 1569470400],
"v": [33463820, 24018876, 20730608]
}
// Stock Candle endpoint
// Only 2 columns requested
{
"c": [221.03, 218.55, 220],
"t": [1569297600, 1569384000, 1569470400]
}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 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 Calculate Implied Volatility In Your Spreadsheet
Using the OPTIONDATA formula, you can calculate implied volatility for any option.
How to Calculate Theta For An Option
Learn how to calculate theta and understand how to add time decay to your spreadsheets.
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 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 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 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 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 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 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 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 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.