Average Price: Gasoline, Unleaded Regular (Cost per Gallon/3.785 Liters) in Houston-The Woodlands-Sugar Land, TX (CBSA) (APUS37B74714) | FRED | St. Louis Fed
- Rows
- 585
- Columns
- 2
- Data range
- 1978-01-01 to 2026-09-01
- Auto-refresh
- Re-checks its source every 14 days
- Last refreshed with new data
- 2026-10-26
Graph and download economic data for Average Price: Gasoline, Unleaded Regular (Cost per Gallon/3.785 Liters) in Houston-The Woodlands-Sugar Land, TX (CBSA) (APUS37B74714) from Jan 1978 to May 2026 about Houston, energy, gas, urban, TX, retail, price, and USA.
AI analysis
Data Quality & Structure Analysis: Houston-Area Unleaded Gasoline Prices
1. Dataset Overview and Source
This series (APUS37B74714) tracks the average retail price per gallon of unleaded regular gasoline in the Houston-The Woodlands-Sugar Land, TX metropolitan area, sourced via the St. Louis Fed's FRED API (https://fred.stlouisfed.org/graph/fredgraph.csv?id=APUS37B74714). The FRED platform is a well-regarded aggregator of government and institutional economic data (this series likely originates from BLS price survey programs), lending it strong credibility. Notably, the stated time coverage extends to May 2026 — beyond the present date — suggesting this is a forward-dated placeholder, a scheduled release window, or an artifact of the source's update cadence rather than actual observed data through that date; this should be verified before treating recent/future-dated rows as real observations. With 581 monthly observations spanning January 1978 to the present, this dataset offers nearly five decades of history, making it valuable for long-run energy price correlation studies, inflation pass-through analysis, and regional cost-of-living research.
2. Data Quality Observations
The dataset shows excellent completeness: zero null cells across both columns and zero nulls reported for each column individually (nulls=0 for both observationdate and APUS37B74714). No disproportionate null concentration exists in any column. Duplicate row detection is flagged as pending recomputation ("Phase D — recomputed against Parquet"), so this should be confirmed before finalizing quality sign-off — a full audit for duplicate observationdate entries is advisable given the join-key role this column will play. One structural quirk worth noting: distinct dates (581) don't match distinct price values (500), which is expected/benign since repeated price levels across different months are normal in a price series, not an indicator of data corruption.
3. Key Column Distributions
The price column (APUS37B74714) spans a wide range from $0.593 to $4.555 per gallon, reflecting nearly 50 years of energy market volatility. The mean ($1.794) sits noticeably above the median ($1.38), and the distribution shows positive skewness (0.707), indicating a right-tailed distribution — consistent with gasoline's history of gradual price increases punctuated by sharp spikes (e.g., 2008 and 2022 oil shocks) rather than symmetric fluctuation. The interquartile range ($1.086 to $2.525) captures the bulk of "normal" pricing regimes, while the standard deviation (0.878) relative to the mean indicates substantial volatility (~49% coefficient of variation) — typical for commodity-linked series and a strong candidate for time-series decomposition (trend/seasonal/residual) before correlation work.
4. Recommended Join Key
The observationdate column is the clear and only viable join key, given its monthly frequency and full date range (1978-01 to 2026-05). Analysts should align this to month-start or month-end conventions depending on the comparison dataset's own date formatting, and consider resampling (e.g., to quarterly or annual) if pairing with lower-frequency indicators like GDP or CPI.
5. Suggested Pairings for Correlation Analysis
Strong candidates include: (a) national or regional CPI/inflation series to assess energy's contribution to headline inflation; (b) WTI or Brent crude oil spot price series to measure retail pass-through lags; (c) Houston-area employment or unemployment data (given the region's oil/gas economic dependency) to explore energy-price-to-labor-market linkages; (d) other CBSA-level gasoline price series (e.g., other Texas or Gulf Coast metros) for regional divergence analysis; and (e) consumer spending or retail sales data to study discretionary income effects from gas price shocks. Given Houston's status as an energy-sector hub, correlating this series with oil/gas employment and drilling activity indices could reveal particularly strong localized relationships.
Columns
- observation_date (date)
- APUS37B74714 (decimal)