Get Historical Stock Prices

Retrieve historical daily stock price data for any publicly traded company. Each record includes the open, high, low, close, adjusted close, volume, VWAP (volume-weighted average price), and daily change metrics. Results are sorted by date in descending order by default.

Use the date_start and date_end parameters to filter to a specific date range, or set a limit to control how many trading days are returned. Add format=excel to get tab-separated values compatible with Google Sheets IMPORTDATA() and Excel.

GEThttps://api.roic.ai/v2/stock-prices/{identifier}

Parameters

Path Parameters

identifierstringrequired

Company identifier — supports ticker symbol (e.g., `AAPL`), CIK, CUSIP, or ISIN.

Example: AAPL

Query Parameters

apikeystringrequired

Your API key for authentication.

limitnumberoptional

Maximum number of price records to return.

Default: 100
date_startstringoptional

Filter results starting from this date (YYYY-MM-DD format).

Example: 2020-01-01
date_endstringoptional

Filter results ending at this date (YYYY-MM-DD format).

Example: 2024-12-31
orderstringoptional

Sort order for time-series data.

Default: DESCValues: ASC, DESC
formatstringoptional

Response format. Use `json` for JSON (default) or `excel` for tab-separated values compatible with Google Sheets and Excel.

Default: jsonValues: json, excel

Code Examples

curl "https://api.roic.ai/v2/stock-prices/AAPL?apikey=YOUR_API_KEY"

Response

Response
200 OK
[
  {
    "date": "2024-12-20",
    "open": 254.77,
    "high": 255.27,
    "low": 248.68,
    "close": 249.79,
    "adj_close": 249.45,
    "volume": 57620328,
    "unadjusted_volume": 57620328,
    "change": -4.98,
    "change_percent": -1.954,
    "vwap": 251.22,
    "label": "December 20, 24"
  }
]

Use Cases

  • Stock price charts. Build candlestick or line charts using daily OHLCV data for any date range
  • Trading strategy backtests. Download years of historical prices to test buy/sell signals against real market data
  • Adjusted close analysis. Use the adj_close field for accurate long-term return calculations that account for stock splits and dividends
  • Spreadsheet imports. Use format=excel with Google Sheets IMPORTDATA() to pull price history directly into your financial models
  • Technical indicators. Compute moving averages, RSI, MACD, Bollinger Bands, and other indicators from daily OHLCV data
  • Event studies. Analyze price action around earnings calls, FDA approvals, product launches, or macroeconomic events
  • Volatility analysis. Calculate historical volatility, average true range, and other risk metrics from high/low/close data

Related Endpoints