LBMA gold price fix history: the record contracts settle against

Five fields, flat, no nesting - which is why integration is quick and joins never surprise:

• metal - gold | silver | platinum | palladium
• auction_period - AM | PM (silver runs its single noon fix)
• currency - USD | GBP | EUR
• price - one auction-derived figure per troy ounce
• date - a London business day

One row per metal x auction x currency x business day: four metals, up to two auctions, three currencies. On a given London business day the gold AM and PM prints land minutes after their auctions close, each carrying all three currency views of the same ounce. Beside the benchmark itself, the Shanghai Gold Exchange benchmark and market data record offers the useful contrast case - China's physical exchange fixing twice daily in yuan per gram - so a desk testing whether London's print leads or lags Asian physical demand has both sides keyed the same way.

A workable long-run series stacks layers, each labelled with what it is:

1. Anchor on the auction record. Take the LBMA Precious Metals Prices prints for your span - one settled figure per session, the same number counterparties cite back at you.
2. Add the monthly layer beneath. The Pink Sheet extends to January 1960 with nominal and MUV-deflated constant-2010 columns, so sixty-plus years of nominal history become one comparable line.
3. Insert daily context where you need day-level texture. Stooq XAUUSD supplies continuous OHLC back to 1793; Yahoo Finance gold futures (GC=F) adds the exchange-traded view.
4. Pin provenance on every row. Never merge fix and spot layers silently - a provenance column naming the benchmark per observation is the cheapest insurance available, because valuing a fix-referenced contract off spot bakes in basis error that compounds daily.

Datadory ships this assembly work with the request: name the metals, sessions, currencies and span in a sample brief and the layers arrive aligned on one date key, benchmark-labelled, field dictionary attached.

This page is the fix-history thread in a 17-dataset gold pool. Continue with:

1. Gold data guide - the pillar post covering all seventeen pooled datasets, price backbone to vault bar lists.
2. LBMA silver price fix history - the noon-silver counterpart of this page.
3. How far back does gold price history go? - depth audited series by series, 1793 onward.
4. LBMA versus LPPM comparison - where two benchmark philosophies meet head to head.
5. Shanghai Gold Exchange benchmark history - the Asian physical benchmark's own record.

For the structured index behind all of it, the gold data hub lists every pooled dataset with coverage, granularity and use cases - request a sample cut scoped to your span.