alphavantage.md
265 lines · skills/database-lookup/references/alphavantage.md at 5f2bc03
Alpha Vantage API Reference
Raw lines 1 to 2Overview
Alpha Vantage provides APIs with free and paid entitlements for current and historical stock prices, forex rates, cryptocurrency data, technical indicators, and fundamental data (earnings, balance sheets, income statements). Covers global equities, ETFs, mutual funds, and commodities.
Raw lines 3 to 5Base URL
https://www.alphavantage.co/queryAll requests use a single endpoint with function parameter to select the data type.
Authentication
- API Key: REQUIRED. Get a free key at https://www.alphavantage.co/support/#api-key
- Pass as query parameter:
&apikey=YOUR_KEY
Rate Limits
- Free tier: 25 requests per day for available free endpoints. Entitlement and per-minute quotas vary by plan; do not assume every documented function is free.
- Premium tiers available for higher limits (30, 75, 150+ calls/min).
- Exceeding limits returns a polite JSON message, not an error code.
Raw lines 17 to 23
Key Endpoints (by function parameter)
Raw lines 24 to 251. Stock Time Series
Intraday
GET /query?function=TIME_SERIES_INTRADAY&symbol={symbol}&interval={interval}&apikey={key}| Parameter | Required | Values |
|---|---|---|
symbol | Yes | Ticker symbol (e.g., AAPL, MSFT) |
interval | Yes | 1min, 5min, 15min, 30min, 60min |
outputsize | No | compact (last 100 points, default) or full (full history) |
adjusted | No | true (default) or false |
datatype | No | json (default) or csv |
Example:
https://www.alphavantage.co/query?function=TIME_SERIES_INTRADAY&symbol=AAPL&interval=5min&apikey=YOUR_KEYDaily
GET /query?function=TIME_SERIES_DAILY&symbol=AAPL&apikey=YOUR_KEYDaily (Adjusted for splits/dividends)
GET /query?function=TIME_SERIES_DAILY_ADJUSTED&symbol=AAPL&outputsize=full&apikey=YOUR_KEYWeekly / Monthly
GET /query?function=TIME_SERIES_WEEKLY_ADJUSTED&symbol=AAPL&apikey=YOUR_KEY
GET /query?function=TIME_SERIES_MONTHLY_ADJUSTED&symbol=AAPL&apikey=YOUR_KEYResponse (Daily):
{
"Meta Data": {
"1. Information": "Daily Prices (open, high, low, close) and Volumes",
"2. Symbol": "AAPL",
"3. Last Refreshed": "2024-11-01",
"4. Output Size": "Compact",
"5. Time Zone": "US/Eastern"
},
"Time Series (Daily)": {
"2024-11-01": {
"1. open": "228.6900",
"2. high": "229.8600",
"3. low": "225.8200",
"4. close": "228.5200",
"5. volume": "50423432"
},
"2024-10-31": {
"1. open": "229.3400",
"2. high": "230.2000",
"3. low": "226.3700",
"4. close": "227.5500",
"5. volume": "51235678"
}
}
}Raw lines 26 to 91
2. Stock Search (Symbol Lookup)
GET /query?function=SYMBOL_SEARCH&keywords={query}&apikey={key}Example:
https://www.alphavantage.co/query?function=SYMBOL_SEARCH&keywords=microsoft&apikey=YOUR_KEYResponse:
{
"bestMatches": [
{
"1. symbol": "MSFT",
"2. name": "Microsoft Corporation",
"3. type": "Equity",
"4. region": "United States",
"5. marketOpen": "09:30",
"6. marketClose": "16:00",
"7. timezone": "UTC-04",
"8. currency": "USD",
"9. matchScore": "1.0000"
}
]
}Raw lines 92 to 122
3. Global Quote (Real-Time Price)
GET /query?function=GLOBAL_QUOTE&symbol=AAPL&apikey=YOUR_KEYThe default quote updates at end of day. Real-time and delayed US quotes require the relevant entitlement; intraday, daily-adjusted and some indicators (including MACD) are premium. Check function-specific documentation before choosing a call.
Returns latest price, volume, change, change percent for a single symbol.
Raw lines 123 to 135
4. Forex (FX) Rates
Real-Time Exchange Rate
GET /query?function=CURRENCY_EXCHANGE_RATE&from_currency=USD&to_currency=EUR&apikey=YOUR_KEYFX Time Series
GET /query?function=FX_DAILY&from_symbol=EUR&to_symbol=USD&apikey=YOUR_KEY
GET /query?function=FX_WEEKLY&from_symbol=EUR&to_symbol=USD&apikey=YOUR_KEY
GET /query?function=FX_MONTHLY&from_symbol=EUR&to_symbol=USD&apikey=YOUR_KEY
GET /query?function=FX_INTRADAY&from_symbol=EUR&to_symbol=USD&interval=5min&apikey=YOUR_KEYRaw lines 136 to 152
5. Cryptocurrency
Real-Time Exchange Rate
GET /query?function=CURRENCY_EXCHANGE_RATE&from_currency=BTC&to_currency=USD&apikey=YOUR_KEYCrypto Time Series
GET /query?function=DIGITAL_CURRENCY_DAILY&symbol=BTC&market=USD&apikey=YOUR_KEY
GET /query?function=DIGITAL_CURRENCY_WEEKLY&symbol=BTC&market=USD&apikey=YOUR_KEY
GET /query?function=DIGITAL_CURRENCY_MONTHLY&symbol=BTC&market=USD&apikey=YOUR_KEYRaw lines 153 to 168
6. Technical Indicators
GET /query?function={INDICATOR}&symbol={symbol}&interval={interval}&time_period={n}&series_type={type}&apikey={key}| Parameter | Required | Description |
|---|---|---|
function | Yes | Indicator name (see list below) |
symbol | Yes | Ticker symbol |
interval | Yes | 1min, 5min, 15min, 30min, 60min, daily, weekly, monthly |
time_period | Yes* | Number of data points for calculation (e.g., 14 for RSI) |
series_type | Yes* | close, open, high, low |
*Required for most indicators; some (like MACD, BBANDS) have additional parameters.
Common Indicator Functions: SMA, EMA, WMA, DEMA, TEMA, VWAP, RSI, MACD, STOCH, ADX, CCI, AROON, BBANDS, AD, OBV, ATR, WILLR, MOM
Example -- RSI (14-day):
https://www.alphavantage.co/query?function=RSI&symbol=AAPL&interval=daily&time_period=14&series_type=close&apikey=YOUR_KEYExample -- MACD:
https://www.alphavantage.co/query?function=MACD&symbol=AAPL&interval=daily&series_type=close&apikey=YOUR_KEYRaw lines 169 to 198
7. Fundamental Data
Company Overview
GET /query?function=OVERVIEW&symbol=AAPL&apikey=YOUR_KEYReturns: market cap, PE ratio, EPS, dividend yield, 52-week high/low, sector, description, and ~60 other fields.
Income Statement
GET /query?function=INCOME_STATEMENT&symbol=AAPL&apikey=YOUR_KEYBalance Sheet
GET /query?function=BALANCE_SHEET&symbol=AAPL&apikey=YOUR_KEYCash Flow
GET /query?function=CASH_FLOW&symbol=AAPL&apikey=YOUR_KEYEarnings
GET /query?function=EARNINGS&symbol=AAPL&apikey=YOUR_KEYReturns both annual and quarterly earnings (EPS, estimated EPS, surprise).
Raw lines 199 to 230
8. Commodities & Economic Indicators
GET /query?function=WTI&interval=monthly&apikey=YOUR_KEY
GET /query?function=BRENT&interval=monthly&apikey=YOUR_KEY
GET /query?function=NATURAL_GAS&interval=monthly&apikey=YOUR_KEY
GET /query?function=COPPER&interval=monthly&apikey=YOUR_KEY
GET /query?function=ALUMINUM&interval=monthly&apikey=YOUR_KEY
GET /query?function=WHEAT&interval=monthly&apikey=YOUR_KEY
GET /query?function=CORN&interval=monthly&apikey=YOUR_KEY
GET /query?function=COTTON&interval=monthly&apikey=YOUR_KEY
GET /query?function=SUGAR&interval=monthly&apikey=YOUR_KEY
GET /query?function=COFFEE&interval=monthly&apikey=YOUR_KEYEconomic indicators:
GET /query?function=REAL_GDP&interval=quarterly&apikey=YOUR_KEY
GET /query?function=CPI&interval=monthly&apikey=YOUR_KEY
GET /query?function=INFLATION&apikey=YOUR_KEY
GET /query?function=RETAIL_SALES&apikey=YOUR_KEY
GET /query?function=UNEMPLOYMENT&apikey=YOUR_KEY
GET /query?function=FEDERAL_FUNDS_RATE&interval=monthly&apikey=YOUR_KEY
GET /query?function=TREASURY_YIELD&interval=monthly&maturity=10year&apikey=YOUR_KEYRaw lines 231 to 257
Notes
- All values are returned as strings in JSON.
- JSON keys use numbered prefixes (e.g.,
"1. open","2. high"). - Time series data is keyed by date/timestamp strings, not arrays.
- When rate limited, the API returns:
{"Note": "Thank you for using Alpha Vantage! ..."} - For
outputsize=full, daily data goes back 20+ years. datatype=csvis available only on endpoints that document it. Inspect JSONInformation,Note, andError Messagefields even after HTTP 200.- Free tier is very restrictive (25/day). For production use, a premium key is recommended.