XAU/JPY Historical Data Downloader
A desktop app that downloads Gold vs Japanese Yen (XAU/JPY) price history on your own machine, written straight to your disk as CSV or JSON. History runs from 2024-09-17 — around 2 years — at every timeframe from raw ticks to monthly candles. A complete XAU/JPY 1-minute series is roughly 709K rows, about 35 MB as CSV.
Preview a XAU/JPY download →Or work out the size first: the file-size calculator takes a range and returns the row count and CSV size.
Windows, macOS, Linux · €9 one-time for the entry licence · get the app
What the app fetches for XAU/JPY
| Symbol | XAU/JPY |
|---|---|
| Instrument | Gold vs Japanese Yen |
| Asset class | Forex Metals |
| History available from | 2024-09-17 |
| Timeframes | Tick → 1s → 1m → 5m → 15m → 30m → 1h → 4h → Daily → Monthly |
| Price types | Bid & Ask (with volume) |
| File formats | CSV, JSON (MetaTrader, NinjaTrader, Parquet & SQLite/DuckDB from the Pro licence) |
| Coverage | 2024-09-17 → 2026-09-17 (last completed trading day) |
| Retrieval | Local — your machine connects directly to Dukascopy Bank SA |
| Runs on | Windows, macOS, Linux |
XAU/JPY timeframes the app supports
- Tick (every quote)
- 1 second
- 1 minute
- 5 minutes
- 15 minutes
- 30 minutes
- 1 hour
- 4 hours
- Daily
- Monthly
XAU/JPY coverage & file size, timeframe by timeframe
Every XAU/JPY timeframe shares the same 2024-09-17 start date, but not the same scale — coarser candles stay small while tick and intraday files grow fast. Current through 2026-09-17:
| Timeframe | History from | Approx. rows | Approx. CSV |
|---|---|---|---|
| Tick (every quote) | 2024-09-17 | very large | — |
| 1 second | 2024-09-17 | very large | — |
| 1 minute | 2024-09-17 | ~709K | ~35 MB |
| 5 minutes | 2024-09-17 | ~142K | ~7 MB |
| 15 minutes | 2024-09-17 | ~47,300 | ~2 MB |
| 30 minutes | 2024-09-17 | ~23,600 | ~1 MB |
| 1 hour | 2024-09-17 | ~11,800 | ~591 KB |
| 4 hours | 2024-09-17 | ~3,000 | ~148 KB |
| Daily | 2024-09-17 | ~490 | ~25 KB |
| Monthly | 2024-09-17 | ~20 | ~1 KB |
Counts are approximate, derived from forex session hours across the available history. Tick and 1-second runs are queued and resumable rather than fetched in one pass. See the data methodology for how candles are built.
Working with the XAU/JPY series
Listed September 2024, this is the youngest gold cross here — but the concept it prices is old and important: gold versus the currency of the world's largest net creditor, the classic yen-debasement hedge. With almost no listed history, treat quoted-series statistics as meaningless for now and build the long view synthetically from XAU/USD × USD/JPY.
What's inside the XAU/JPY file
timestamp,open,high,low,close,volumeOne row per candle; tick files instead carry timestamp,bid,ask on every quote. All timestamps are UTC. Worked examples and import steps are in the CSV & JSON format guide.
About Gold vs Japanese Yen
Gold vs Japanese Yen (XAU/JPY) is a spot precious-metals instrument with 2 years of retrievable history. It is commonly used for backtesting forex trading strategies and expert advisors (EAs), spread and volatility analysis, training algorithmic and machine-learning models, and charting currency-pair history. Pick any date range from 2024-09-17 onward, choose a timeframe and the bid or ask side, and the app fetches and writes the files locally — no scripting.
Frequently asked questions
- How far back does XAU/JPY data go?
- XAU/JPY history runs from 2024-09-17 — roughly 2 years — up to the last completed trading day, at every timeframe from raw ticks to monthly candles. Every licence tier reaches all of it.
- How large is a full XAU/JPY download?
- The complete XAU/JPY 1-minute history is roughly 709K rows, about 35 MB as CSV. Daily candles over the same instrument are far smaller — around 490 rows, 25 KB. Tick and 1-second runs are larger again and are queued and resumable rather than fetched in one pass. Sizes are approximate; nothing is priced by volume.
- What columns are in the XAU/JPY CSV file?
- OHLC files contain a timestamp plus open, high, low and close columns (with volume); tick files contain a timestamp with bid and ask prices. All timestamps are UTC. The files import directly into Excel, Google Sheets, Python (pandas read_csv), R, MetaTrader, NinjaTrader and TradingView.
- Do you sell XAU/JPY data?
- No — we sell software. The MarketData Hub client retrieves Gold vs Japanese Yen (XAU/JPY) on your own machine, under your instruction, directly from the source; we never host, cache or relay it. Your use of the retrieved data is subject to the source's terms.
Guides
- Get the app — Windows, macOS, Linux
- How to download historical forex data
- CSV & JSON format — columns explained
- Tick data vs OHLC candles
- Backtesting with historical data
- Gold price history
- Gold tick data
- Backtesting gold
- Gold–silver ratio
Related Forex Metals
- XAG/USD — Spot Silver
- XAU/USD — Spot Gold
- XAG/EUR — Silver vs Euro
- XAG/GBP — Silver vs Pound Sterling
- XAG/AUD — Silver vs Australian Dollar
- XAU/CHF — Gold vs Swiss Franc
- XAU/EUR — Gold vs Euro
- XAU/GBP — Gold vs Pound Sterling
- XAG/HKD — Silver vs Hong Kong Dollar
- XAG/MXN — Silver vs Mexican Peso
- XAG/NZD — Silver vs New Zealand Dollar
- XAG/DKK — Silver vs Danish Krone
Preview your XAU/JPY download — pick a range, see the exact file →
Sizing it up rather than fetching it? Estimate XAU/JPY rows and CSV size for any date range.
The preview runs in the browser; the download runs in the free desktop app, on your machine.