🗄️Developer Resource // JSON Endpoint
SPY JSON Data API
Absolute endpoints (copy‑paste)
JSON:
https://www.pocketportfolio.app/api/tickers/SPY/json?range=maxCSV:
https://www.pocketportfolio.app/api/tickers/SPY/csv?range=maxLiteral URL query target:
https://www.pocketportfolio.app/api/tickers/spy/jsonAccess 402 data points for SPY spanning 34 years (1993–Jun 5, 2026). Optimized JSON format (58.9 KB).
Local-first charts from this JSON — open the Terminal.
Parse and visualize without shipping raw ledgers to a vendor database.
Download as CSV
Prefer CSV format? Download SPY historical data as a CSV file for Excel, Google Sheets, or any spreadsheet application.
GET /api/tickers/SPY/json● 200 OK (Live)Tired of exporting to Excel? Track SPY and analyze your portfolio locally with Pocket Portfolio.
Start Free — Local First{
"symbol": "SPY",
"timestamp": "2026-06-07T05:09:18.275Z",
"price": 737.55,
"change_24h": -2.580934895454976,
"history_sample": [
{
"date": "1993-02-01",
"open": 43.97,
"high": 45.13,
"low": 42.81,
"close": 44.41,
"volume": 5417600
},
{
"date": "1993-03-01",
"open": 44.56,
"high": 45.84,
"low": 44.22,
"close": 45.19,
"volume": 3019200
}
]
}💻
Import via CLI
Don't scrape. Use our open-source importer to normalize this dataset directly into your local database.
npx pocket-portfolio --import SPY🛡️
Need to archive this data?
Don't rely on ephemeral endpoints. Automatically sync SPY.json updates to your private Google Drive for backtesting and compliance.
Enable Sovereign SyncIncludes unlimited API calls & historical CSV exports.
Dataset Specifications
- Format: Standardized JSON (OHLCV)
- Frequency: End-of-Day (EOD) + Real-time delay
- Adjustments: Split-adjusted, Dividend-adjusted
- Source: Multi-provider aggregation (AlphaVantage, Yahoo fallback)