Download Historical Market Data to CSV & Excel
Export price history for stocks, forex, commodities, and crypto. Get completed bars from the latest 24 hours free, without an account. For longer history, sign in and connect your API key.
Four markets, one download format
Compare markets using the same price columns in every download. Available history varies by instrument. Select Show chart to see data for your chosen period.
US stocks
Historical OHLCV bars for US-listed equities by ticker. Prices are as-traded, not adjusted for splits or dividends.
Forex
Currency pairs such as EURUSD and GBPUSD. Per-bar volume is a tick count where the source reports one.
Commodities & metals
Metals, energy, and industrials, including gold (XAUUSD), silver, and WTI crude (USOUSD).
Crypto
Crypto pairs quoted in USD or EUR, such as BTCUSD and BTCEUR. Available history varies by pair and interval.
Without an account
Preview a chart and download CSV or Excel for the latest 24 hours. Choose 5-minute, 15-minute, 30-minute, or 1-hour intervals, with up to 300 completed bars. All times are in UTC.
With your account
Sign in and connect your key for longer periods and more intervals. Every plan includes full available history. Loading data uses your API request allowance. Downloads use the data already loaded.
Ready for your spreadsheet
Open a CSV in your preferred analysis tool, or download an Excel workbook with your prices and dataset details in separate sheets.
Data sheet
One row per bar with a UTC timestamp, open, high, low, close, and volume. Exports use the values returned by the API. Unavailable volume is left blank.
Metadata sheet
Check the instrument, currency, interval, and time period behind your data. The sheet also notes incomplete results and available price and volume details. Missing source details are marked Unknown.
Read your CSV with confidence
Seven columns, one row per historical bar. Keep the instrument, quote currency and actual interval with your file.
Column meanings and important differences
- Time (UTC)
- Bar-open instant in ISO 8601 UTC text, ending in Z.
- Timestamp (ms)
- The same instant in Unix milliseconds, not seconds.
- Open
- First price in the returned bar.
- High
- Highest price in the returned bar.
- Low
- Lowest price in the returned bar.
- Close
- Last price in the returned bar.
- Volume
- Reported volume or tick count. Blank means unavailable, not zero.
Time and completeness. A 1h bar opening at 00:00 covers that bucket, conventionally [00:00, 01:00). Guest downloads contain fully closed buckets inside the latest 24 hours. Own-key history may include a forming latest bar; CSV has no per-row closed flag. A partial result describes dataset coverage, not candle finality. Missing periods are not filled with invented bars.
Currency and volume. Prices stay in the instrument’s quote currency and unit. Forex and commodity volume is a tick count where reported, not lots or physical units; unreported legacy zero becomes blank. Crypto and stock volume units may be Unknown. Use explicit metadata rather than guessing. Stock prices are not split/dividend adjusted.
Precision and file format. UTF-8 with a BOM, comma-separated fields and CRLF line endings. Numbers retain the exported float64 value without screen rounding; precision already lost upstream cannot be restored.
Keep the context. CSV has data columns only. Download Excel too when you need its Metadata sheet: instrument, actual interval, currency, time window, completeness, price basis, adjustment and volume details. Stock daily bars represent a trading session; weekly and monthly bars use calendar boundaries.
Five annotated example rows
Synthetic 1h bars on 1 October 2026 UTC, not live prices. Example currency: USD; volume unit: unknown. The fixture includes full ISO timestamps and matching epoch milliseconds.
| UTC open | Open | High | Low | Close | Volume | What to notice |
|---|---|---|---|---|---|---|
| 00:00 | 100 | 104 | 99 | 103 | 12.5 | A normal bar. |
| 01:00 | 103 | 105 | 101 | 102 | blank | Volume is unavailable. |
| 02:00 | 102 | 103 | 100 | 101 | 0 | A reported zero is preserved. |
| 04:00 | 101 | 106 | 101 | 105 | 7.25 | 03:00 is missing; no candle is invented. |
| 05:00 | 105.123456789 | 107 | 104 | 106 | 2.75 | Exported precision is retained. |
Four steps to a workbook
- Step 1
Choose a market and enter a symbol
Use the default symbol or type your own, such as AAPL, EURUSD, XAUUSD, or BTCUSD.
- Step 2
Set the interval and period
Without an account, choose 5-minute, 15-minute, 30-minute, or 1-hour bars from the latest 24 hours. Sign in and connect your API key for longer periods and more intervals.
- Step 3
Show the chart
Select Show chart to load your data. Check the chart and table before downloading.
- Step 4
Download CSV or Excel
Save the loaded data as CSV or an Excel workbook with separate sheets for prices and dataset details.
Limitations
- Without an account, downloads cover only the latest 24 hours. For longer history, sign in and connect your API key.
- Prices are historical bars, not live quotes.
- Closed markets and periods with no trades may return no data. Earlier sessions are not added to fill the gap.
- Large results may be limited to what your browser can process. Incomplete results are labelled partial. Choose a shorter period to reduce the size.
Common questions
Do I need an account to use it?
No. You can preview completed bars from the latest 24 hours for one instrument and download them as CSV or Excel without an account. For longer periods, sign in or create an account, then connect your API key. Every plan includes full available history. API request limits still apply.
What can I download without an account?
The latest 24 hours of completed bars in 5-minute, 15-minute, 30-minute, or 1-hour intervals, up to 300 bars. All times are shown in UTC.
Can I download crypto prices in EUR?
For pairs such as BTCEUR, sign in and connect your API key. Prices stay in the pair's quote currency, and available history depends on the pair and period. The crypto preview without an account currently covers USD pairs.
What is included in the Excel download?
The .xlsx workbook has a Data sheet for your prices and a Metadata sheet with the instrument, time period, and available source details. For direct worksheet imports, see the SiftingIO Excel add-in setup guide linked below.
How is the downloaded file structured?
Each row contains a UTC timestamp, open, high, low, close, and volume. A timestamp in milliseconds is also included. Volume is left blank when it is unavailable.
What happens on weekends or when a market is closed?
You will see a no-data message if there are no bars in your selected period. Without an account, the download window stays within the latest 24 hours. Earlier sessions are not added to fill the gap.
Where does my API key go?
Your key is kept only while this page is open and is never included in a download. Refreshing or reopening the page clears it, so you will need to connect it again.
Need data in your code or directly in a worksheet? Explore the API documentation and the Excel add-in setup guide.