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 (opens in a new tab)
- Option expirations 45 days out: /v1/options/chain/AAPL/?dte=45 (opens in a new tab)
- Daily candles with 2 years of history: /v1/stocks/candles/D/AAPL/?from=2YearsAgo&to=today (opens in a new tab)
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 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 Calculate Theta For An Option
Learn how to calculate theta for an option and add time decay to your Google Sheets spreadsheet with the OPTIONDATA formula and Black-Scholes.
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 Bulk Download Stock Data in Google Sheets
Download stock data in bulk with the STOCKDATA formula for Google Sheets: many symbols in one request, so large spreadsheets refresh fast and cost less.
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 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 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 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 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 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.
Agent setup
Set up the API from the coding agent you already use
One prompt points the agent at our llms.txt. It starts with the official SDK for your language, reads your token from the MARKETDATA_TOKEN variable and finishes with a real quote.
The prompt works in
- Claude Code
- Codex
- Cursor
- GitHub Copilot
- Gemini CLI
- Claude Desktop
- ChatGPT
Paste into your coding agent
Read https://www.marketdata.app/llms.txt and set up Market Data. Decide if I want data in a spreadsheet or in code; if unclear, ask one question. Spreadsheet: set up the Google Sheets add-on and its formulas (STOCKDATA, OPTIONDATA, OPTIONCHAIN, EARNINGS) and link its docs. Code: start with the official Market Data SDK for my language (Python, JavaScript, Java, C#, Go, PHP; https://www.marketdata.app/docs/sdk/); never write your own HTTP client while an SDK exists. If I have no account, tell me to sign up for the free trial at https://www.marketdata.app/signup/ and set MARKETDATA_TOKEN myself; you cannot do that step. Read the token from MARKETDATA_TOKEN, never paste it in chat or source, then make one real call (an SDK stock quote or one formula in a cell) to confirm it works.
Prefer to do it yourself? Start the free trial or read the API docs.
In a spreadsheet
You install the free Google Sheets add-on, which signs in with your Google account. The agent then writes the formula for the cell: STOCKDATA for quotes and candles, OPTIONDATA and OPTIONCHAIN for options, EARNINGS for the reporting calendar. One formula in a cell is the first call.
In code
The agent starts with the official SDK for your language: Python, JavaScript, Java, C#, Go and PHP. Every SDK reads MARKETDATA_TOKEN and handles the request and the response for you, so the agent writes no HTTP client of its own. The REST reference is there for a language without an SDK.
What the agent gets right
Our llms.txt tells it what breaks a first integration: the token travels as a Bearer header, a 203 response is a success from the cache, a 402 means the plan does not cover the request, and a 403 clears itself after five minutes. It also knows that signing up and requesting your token are your steps, not its own.