WTI Monthly Spot Prices
- Rows
- 490
- Columns
- 2
- Data range
- 1986-01-15 to 2026-10-15
- Auto-refresh
- Re-checks its source every 14 days
- Last refreshed with new data
- 2026-11-17
Monthly Cushing, OK WTI spot prices in USD per barrel.
AI analysis
WTI Monthly Spot Price Dataset — Analytical Overview
1. Dataset Representation & Value This dataset captures monthly WTI (West Texas Intermediate) crude oil spot prices at the Cushing, Oklahoma delivery hub, expressed in USD per barrel. Sourced directly from the U.S. Energy Information Administration (EIA) — a highly authoritative federal statistical agency — the data originates from eia.gov/dnav/pet, the EIA's petroleum navigation portal, lending strong credibility to its accuracy and continuity. Spanning 486 monthly observations, the series likely covers roughly 40+ years of price history, making it exceptionally valuable for long-horizon macroeconomic, energy, and financial correlation studies. WTI is the primary U.S. crude oil benchmark and a foundational input for pricing energy commodities globally, giving this dataset broad cross-domain relevance.
2. Data Quality Observations Overall data quality is very strong. There are only 2 null cells across the entire dataset, both confined to the price column (Cushing, OK WTI Spot Price FOB), representing a negligible 0.4% missingness rate — almost certainly reflecting months where trading was suspended or reporting was delayed rather than systematic data collection failure. The Date column is completely clean with zero nulls and 486 distinct values, confirming no duplicate or collapsed time periods exist. Duplicate row counts are pending final Parquet reconciliation (Phase D), but the perfect date distinctness (486 distinct dates across 486 rows) strongly implies zero structural duplicates. No type-mismatch issues are evident; both columns align cleanly with their declared types (Date and Decimal). This dataset is essentially analysis-ready with minimal preprocessing needed beyond handling those 2 null price records via forward-fill or interpolation.
3. Key Column Distributions & Notable Patterns The price column tells a richly dynamic story. The mean of $48.35/barrel sits noticeably above the median of $43.01, and combined with a positive skew of 0.557, this indicates the distribution is pulled rightward by high-price periods — most likely the 2007–2014 commodity supercycle and post-COVID recovery spikes. The range is dramatic: from a minimum of $11.35 (consistent with the 1998 oil price collapse) to a maximum of $133.88 (near the 2008 price peak), a nearly 12-fold spread. The interquartile range (Q1: $20.25 → Q3: $71.42) reflects two distinct pricing regimes across the dataset's history — a prolonged low-price era (pre-2000s) and a structurally higher-price era (post-2000s). The standard deviation of $29.40 relative to the mean underscores that oil price volatility is not noise but a core characteristic of this series, making it an ideal dependent or independent variable in volatility-focused studies.
4. Recommended Join Key for Cross-Dataset Correlation The Date column is the natural and only viable join key, and it is ideally suited for the role — zero nulls, 486 distinct values, and a regular monthly cadence. When joining to external datasets, it is critical to standardize date granularity to monthly frequency (e.g., first or last day of month) and align calendar conventions carefully, as some economic series use mid-month or end-of-month anchoring. For datasets at different frequencies (quarterly GDP, annual emissions), temporal aggregation or interpolation will be necessary. The consistency of the monthly interval also makes this dataset well-suited for time-series alignment without resampling gaps.
5. High-Value Datasets for Correlation Discovery Several dataset categories would pair exceptionally well with this series:
- Macroeconomic indicators — U.S. CPI, PPI, or PCE inflation indices (also available from EIA/BLS/FRED) to examine how oil price shocks transmit into broader inflation, a well-documented but time-varying relationship. - Financial markets — S&P 500 monthly returns, USD/EUR exchange rates, or energy sector ETF performance to explore risk-off dynamics and petrodollar effects. - Natural gas & gasoline prices — EIA also publishes Henry Hub natural gas and retail gasoline price series, enabling within-energy cross-commodity correlation analysis and spread modeling. - U.S. GDP & industrial production — to test whether oil price levels are leading, coincident, or lagging indicators of economic activity cycles. - Global events & geopolitical indices — pairing with event-coded datasets (OPEC meeting dates, conflict indices, sanctions timelines) could power regime-change or structural break analyses, given the dramatic price swings visible in the distribution.
Columns
- Date (date)
- Cushing, OK WTI Spot Price FOB (Dollars per Barrel) (decimal)