US metro weekly gasoline price intelligence

Name: US metro weekly gasoline price intelligence
Creator: U.S. Energy Information Administration
License: https://www.eia.gov/petroleum/gasdiesel/
Keywords: gasoline, fuel, pump-prices, energy, weekly, us, metros, demand-forecasting

Commercial use OKFreshLicense: CC0-1.0

Query in workbench

The full snapshot isn't published yet — check back after the next refresh.Download sample CSV Download sample JSONSample rows only (up to 20) — not the complete dataset.

US metro weekly gasoline price intelligence from the keyless U.S. Energy Information Administration Petroleum Navigator history tables: one row per week per metro for the 10 selected metros EIA publishes weekly (Boston, Chicago, Cleveland, Denver, Houston, Los Angeles, Miami, New York City, San Francisco, Seattle), 2003 to present — the finest geography EIA publishes weekly. Each row carries the published price ($/gal), the metro's premium or discount vs the same-week US average, gap-aware week-over-week / 4-week / 52-week changes in dollars and percent (null when a comparison week is missing or not exactly 7/28/364 days earlier — never annualized or filled), the per-week cross-metro price and premium ranks, a price quintile tier, a documented 0-100 fuel-strain score (50% winsorized YoY momentum + 50% trailing-52-week range position), and sharp-move (>=5% WoW) / 52-week-record-high flags. Method: melt EIA's wide month-x-week tables to a tidy panel with validated ISO week dates; momentum requires exact day spacing. Caveats: prices are weekly averages of retail outlets surveyed Monday (not tradable spot prices); EIA publishes only these 10 metros weekly, so all other US metros are out of scope by upstream design; the score is a relative history gauge of fuel-cost pressure, not a price forecast. U.S. federal public domain (commercial reuse allowed with attribution to the U.S. Energy Information Administration).

Source: U.S. Energy Information Administration
Rows: 13,120
Columns: 22
Source cadence: Weekly
Last refreshed: Oct 1, 2026
Theme: energy

Column	Type	Description
week_date	date	EIA reporting week (Monday; the week the Monday survey covers). Join key with metro_name. (unit: date)
metro_name	string	Selected metropolitan area (Boston, Chicago, Cleveland, Denver, Houston, Los Angeles, Miami, New York City, San Francisco, Seattle — the 10 metros EIA publishes weekly). Join key with week_date.
state_code	string	USPS 2-letter code of the metro's state (CA appears twice: Los Angeles and San Francisco).
state_name	string	Full state name.
country	string	Country name (shared normalization layer).
country_code	string	ISO 3166-1 alpha-3 country code (USA).
price_usd_gal	float	Published weekly average retail price, all grades, all formulations, from EIA's Monday outlet survey. (unit: USD/gallon)
premium_vs_us_usd	float	Metro price minus the same-week US average price. Positive = the metro pays a premium; negative = a discount. Null when the US reference week is missing. (unit: USD/gallon)
wow_change_usd	float	Week-over-week price change vs the week exactly 7 days earlier. Null when that week is missing or mis-spaced (holiday skips are never filled). (unit: USD/gallon)
wow_change_pct	float	Week-over-week percent change (same gap-aware rule as wow_change_usd). (unit: percent)
mom4_change_usd	float	4-week price change vs the week exactly 28 days earlier (gap-aware, null on breaks). (unit: USD/gallon)
mom4_change_pct	float	4-week percent change (same gap-aware rule). (unit: percent)
yoy_change_usd	float	52-week price change vs the week exactly 364 days earlier (gap-aware, null on breaks). (unit: USD/gallon)
yoy_change_pct	float	52-week percent change (same gap-aware rule). (unit: percent)
price_rank_week	integer	Cross-metro price rank within the week (1 = cheapest of the 10 metros). Null when the price is null. (unit: rank)
premium_rank_week	integer	Cross-metro rank of premium_vs_us_usd within the week (1 = deepest discount vs the US average). (unit: rank)
price_tier_week	string	Quintile tier of the week's cross-metro price distribution: cheapest_fifth / low_fifth / middle_fifth / high_fifth / priciest_fifth.
fuel_strain_score	float	Documented 0-100 fuel-cost pressure gauge: 100 * (0.5 * winsorized-YoY-component + 0.5 * trailing-52-week range position), where the YoY percent change is winsorized to [-50, +50] and scaled to 0-100. Null until 52 priced weeks exist. A relative history gauge, not a price forecast. (unit: 0-100 score)
sharp_move_flag	boolean	True when \|wow_change_pct\| >= 5.0. Null when wow_change_pct is null.
record_high_52wk_flag	boolean	True when the week's price is >= its trailing-52-week maximum (ties count).
source_url	string	Exact EIA LeafHandler history URL this metro's series was parsed from.
row_hash	string	Deterministic 16-hex sha256 of week_date + metro_name + state_code (idempotency key).

First 10 sample rows — a preview, not the complete dataset.

week_date	metro_name	state_code	state_name	country	country_code	price_usd_gal	premium_vs_us_usd	wow_change_usd	wow_change_pct	mom4_change_usd	mom4_change_pct	yoy_change_usd	yoy_change_pct	price_rank_week	premium_rank_week	price_tier_week	fuel_strain_score	sharp_move_flag	record_high_52wk_flag	source_url	row_hash
2000-06-05	Chicago	IL	Illinois	United States	USA	1.99	0.391	—	—	—	—	—	—	6	6	priciest_fifth	—	—	false	https://www.eia.gov/dnav/pet/hist/LeafHandler.ashx?n=PET&s=EMM_EPM0_PTE_YORD_DPG&f=W	6e038fbae9f2430d
2000-06-05	Denver	CO	Colorado	United States	USA	1.534	-0.065	—	—	—	—	—	—	2	2	cheapest_fifth	—	—	false	https://www.eia.gov/dnav/pet/hist/LeafHandler.ashx?n=PET&s=EMM_EPM0_PTE_YDEN_DPG&f=W	9ee46e521034bada
2000-06-05	Houston	TX	Texas	United States	USA	1.529	-0.07	—	—	—	—	—	—	1	1	cheapest_fifth	—	—	false	https://www.eia.gov/dnav/pet/hist/LeafHandler.ashx?n=PET&s=EMM_EPM0_PTE_Y44HO_DPG&f=W	c3e69d1b920f7c5a
2000-06-05	Los Angeles	CA	California	United States	USA	1.591	-0.008	—	—	—	—	—	—	3	3	low_fifth	—	—	false	https://www.eia.gov/dnav/pet/hist/LeafHandler.ashx?n=PET&s=EMM_EPM0_PTE_Y05LA_DPG&f=W	04e2135913ab5ff6
2000-06-05	New York City	NY	New York	United States	USA	1.654	0.055	—	—	—	—	—	—	4	4	middle_fifth	—	—	false	https://www.eia.gov/dnav/pet/hist/LeafHandler.ashx?n=PET&s=EMM_EPM0_PTE_Y35NY_DPG&f=W	8f114e5b90bbc9f0
2000-06-05	San Francisco	CA	California	United States	USA	1.805	0.206	—	—	—	—	—	—	5	5	high_fifth	—	—	false	https://www.eia.gov/dnav/pet/hist/LeafHandler.ashx?n=PET&s=EMM_EPM0_PTE_Y05SF_DPG&f=W	be56f6bac121d217
2000-06-12	Chicago	IL	Illinois	United States	USA	2.134	0.47	0.144	7.236	—	—	—	—	6	6	priciest_fifth	—	true	false	https://www.eia.gov/dnav/pet/hist/LeafHandler.ashx?n=PET&s=EMM_EPM0_PTE_YORD_DPG&f=W	0cd1a981549aab21
2000-06-12	Denver	CO	Colorado	United States	USA	1.576	-0.088	0.042	2.738	—	—	—	—	2	2	cheapest_fifth	—	false	false	https://www.eia.gov/dnav/pet/hist/LeafHandler.ashx?n=PET&s=EMM_EPM0_PTE_YDEN_DPG&f=W	b1440abd39205642
2000-06-12	Houston	TX	Texas	United States	USA	1.557	-0.107	0.028	1.831	—	—	—	—	1	1	cheapest_fifth	—	false	false	https://www.eia.gov/dnav/pet/hist/LeafHandler.ashx?n=PET&s=EMM_EPM0_PTE_Y44HO_DPG&f=W	fc2bcab5d535d3ef
2000-06-12	Los Angeles	CA	California	United States	USA	1.587	-0.077	-0.004	-0.251	—	—	—	—	3	3	low_fifth	—	false	false	https://www.eia.gov/dnav/pet/hist/LeafHandler.ashx?n=PET&s=EMM_EPM0_PTE_Y05LA_DPG&f=W	72ed555dcc8fedf6

Profiled Oct 1, 2026 from snapshot 20261001T192947Z-d808a4c43c8d

Measured

Completeness: 99.4%
Rows: 13,120
Columns: 22
Columns with gaps: 13

Rows per yearweek_date · 2000–2026 · 27 years

20002026

Column	Missing	Distinct	Range	Distribution
week_datedate	0%	1,301	Jun 5, 2000 → Sep 28, 2026	—
metro_namevarchar	0%	11	—	Chicago1,374 Denver1,374 Houston1,374
state_codevarchar	0%	10	—	CA2,748 CO1,374 IL1,374
state_namevarchar	0%	10	—	California2,748 Colorado1,374 Illinois1,374
countryvarchar	0%	1	—	United States13,120
country_codevarchar	0%	1	—	USA13,120
price_usd_galdouble	0.02%	3,308	1.01 → 6.5median 2.96	263 outside 1st–99th percentile
premium_vs_us_usddouble	0.02%	3,129	-0.851 → 2.55median 0.06	264 outside 1st–99th percentile
wow_change_usddouble	0.11%	1,483	-0.396 → 0.911median -0.004	263 outside 1st–99th percentile
wow_change_pctdouble	0.11%	14,415	-14.04 → 25median -0.1354	264 outside 1st–99th percentile
mom4_change_usddouble	0.34%	3,208	-1.24 → 1.31median 0.007	261 outside 1st–99th percentile
mom4_change_pctdouble	0.34%	14,992	-36.38 → 47.87median 0.2564	262 outside 1st–99th percentile
yoy_change_usddouble	4%	5,646	-1.74 → 2.42median 0.105	252 outside 1st–99th percentile
yoy_change_pctdouble	4%	16,632	-48.61 → 94.92median 3.73	252 outside 1st–99th percentile
price_rank_weekbigint	0.02%	11	1 → 10median 5
premium_rank_weekbigint	0.02%	11	1 → 10median 5
price_tier_weekvarchar	0.02%	5	—	cheapest_fifth2,751 low_fifth2,597 high_fifth2,591
fuel_strain_scoredouble	4.8%	1,068	0.8 → 100median 56.6	246 outside 1st–99th percentile
sharp_move_flagboolean	0.11%	2	—	false12,351 true755
record_high_52wk_flagboolean	0%	2	—	false11,772 true1,348
source_urlvarchar	0%	11	—	https://www.eia.gov/dnav/pet/hist/LeafHandler.ashx?n=PET&s=EMM_EPM0_PTE_Y05LA_DPG&f=W1,374 https://www.eia.gov/dnav/pet/hist/LeafHandler.ashx?n=PET&s=EMM_EPM0_PTE_Y05SF_DPG&f=W1,374 https://www.eia.gov/dnav/pet/hist/LeafHandler.ashx?n=PET&s=EMM_EPM0_PTE_Y35NY_DPG&f=W1,374
row_hashvarchar	0%	11,784	—	00071a547dd4efe61 000891c714a6e3141 0010f78c9f1581061

Point any LLM at the metadata endpoint — the documentation above is machine-readable too (JSON-LD + Croissant).

cURL

curl "https://datazimuts.com/v1/datasets/us_metro_gasoline_price_intel/us_metro_gasoline_weekly" | jq '{title, rows, columns_count, license}'

Python

import requests

ds = requests.get("https://datazimuts.com/v1/datasets/us_metro_gasoline_price_intel/us_metro_gasoline_weekly").json()
print(ds["title"], ds["rows"], "rows")

# Sample rows for an LLM context window
for row in ds.get("sample_rows", [])[:5]:
    print(row)

API endpoint: https://datazimuts.com/v1/datasets/us_metro_gasoline_price_intel/us_metro_gasoline_weekly

Tip: fetch /llms.txt for the full machine-readable catalog.

Cite this snapshot

Pinned to snapshot 20261001T192947Z-d808a4c43c8d and its content hash, so readers get exactly the data you used.

APA

U.S. Energy Information Administration. (2026). US metro weekly gasoline price intelligence [Data set, snapshot 20261001T192947Z-d808a4c43c8d, sha256 d808a4c43c8d]. Datazimuts. Retrieved 2026-10-02, from https://datazimuts.com/en/datasets/us_metro_gasoline_price_intel/us_metro_gasoline_weekly?snapshot=20261001T192947Z-d808a4c43c8d

BibTeX

@misc{dz_us_metro_gasoline_price_intel_us_metro_g_d808a4c4,
  title        = {{US metro weekly gasoline price intelligence}},
  author       = {{U.S. Energy Information Administration}},
  year         = {2026},
  publisher    = {Datazimuts},
  howpublished = {\url{https://datazimuts.com/en/datasets/us_metro_gasoline_price_intel/us_metro_gasoline_weekly?snapshot=20261001T192947Z-d808a4c43c8d}},
  note         = {Snapshot 20261001T192947Z-d808a4c43c8d, sha256 d808a4c43c8d3ad465882655cf697fbbc7698dae1f46efe89027064f6c133af1; accessed 2026-10-02}
}

Embed a table or a chart

Paste this into any page. The embed is pinned to the same snapshot, follows the reader's light or dark setting, and always shows the source, license and a link back.

Type

X axis

Value

Aggregate

Theme

HTML

<iframe src="https://datazimuts.com/embed/chart?dataset=us_metro_gasoline_price_intel%2Fus_metro_gasoline_weekly&lang=en&theme=auto&snapshot=20261001T192947Z-d808a4c43c8d&x=week_date&y=price_usd_gal&agg=avg" title="US metro weekly gasoline price intelligence" width="100%" height="380" style="border:0" loading="lazy"></iframe>

US metro weekly gasoline price intelligence

Follow this dataset

Cite this snapshot

Embed a table or a chart

Use your own AI key