US retail diesel prices (weekly, by PADD)

Name: US retail diesel prices (weekly, by PADD)
Creator: U.S. Energy Information Administration
License: https://www.eia.gov/dnav/pet/pet_pri_gnd_dcus_nus_w.htm
Keywords: diesel, fuel, pump-prices, energy, weekly, us, 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.

Weekly US retail diesel price intelligence from the keyless U.S. Energy Information Administration Petroleum Navigator history tables: one row per week per region (US average + the 5 PADDs — East Coast, Midwest, Gulf Coast, Rocky Mountain, West Coast), 1994 to present. Each row carries the published No 2 diesel retail price ($/gal), gap-aware week-over-week / 4-week / 52-week changes (null when a holiday week was skipped, never annualized), the PADD's premium or discount vs the national average, the price's position in its trailing-52-week range, a documented 0-100 diesel-cost pressure score (50% winsorized YoY momentum + 50% range position, min-max over each region's history), pressure quartile tiers, per-week PADD price and pressure ranks, and 52-week-record-high / sharp weekly move (>=5%) flags. Method: melt EIA's wide month-x-week tables to a tidy panel with validated ISO week dates; momentum requires exact 7/28/364-day spacing. Caveats: prices are weekly averages of retail outlets surveyed Monday (not tradable spot prices); the score is a relative history gauge of diesel-cost pressure for shipping and logistics, 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: 10,182
Columns: 23
Source cadence: Weekly
Last refreshed: Sep 29, 2026
Theme: energy

Column	Type	Description
region	string	Canonical region name: 'United States' (national average) or one of the five Petroleum Administration for Defense Districts — East Coast (PADD 1), Midwest (PADD 2), Gulf Coast (PADD 3), Rocky Mountain (PADD 4), West Coast (PADD 5).
region_code	string	Stable region code: 'US' for the national average, 'PADD1'..'PADD5' for the districts; the join key for region-grain panels.
country_code	string	ISO alpha-3 country code (USA for every row; the region identity rides in region/region_code). (unit: ISO 3166-1 alpha-3)
week_date	string	The Monday date printed on EIA's weekly table (collection/release Monday); the ISO date join key. EIA occasionally skips a holiday Monday — those weeks are absent, never interpolated. (unit: ISO date)
price_usd_gal	float	Published weekly retail No 2 diesel price, verbatim from EIA (null only if EIA prints an empty cell for a dated week). (unit: US dollars per gallon)
us_avg_price_usd_gal	float	The national-average price for the same week (joined from the US series); the baseline for the premium columns. (unit: US dollars per gallon)
premium_vs_us_usd	float	price_usd_gal minus us_avg_price_usd_gal (null on the national row). Positive = the PADD pays more than the national average that week. (unit: US dollars per gallon)
premium_vs_us_pct	float	premium_vs_us_usd as a percent of the national average (null on the national row). (unit: percent)
wow_change_usd	float	Week-over-week change in dollars, computed only when the previous observation is exactly 7 days back; null after a skipped holiday week (a gapped comparison would be a 2-week move mislabeled as weekly). (unit: US dollars per gallon)
wow_change_pct	float	wow_change_usd as a percent of the previous week's price (same 7-day exactness gate). (unit: percent)
mom_change_pct	float	4-week percent change; requires the comparison week to be exactly 28 days back, else null. (unit: percent)
yoy_change_pct	float	52-week percent change; requires the comparison week to be exactly 364 days back, else null. (unit: percent)
range_pos_52w	float	Position of this week's price inside its own trailing-52-week range: 0 = 52-week low, 1 = 52-week high. Null until 52 weeks of history exist or when the 52-week range is zero. (unit: 0-1)
diesel_cost_pressure_score	float	Documented 0-100 composite: 100 * (0.50 * min-max(winsor(yoy_change_pct, +/-50pp)) + 0.50 * min-max(range_pos_52w)), min-max taken over the region's own scored history. Higher = diesel costs high AND rising — the shipping/logistics cost pressure signal. Null until both components are defined. (unit: 0-100 score)
pressure_tier	string	Score quartile over the region's scored history: 'p1' (top quartile, highest diesel-cost pressure) .. 'p4'.
pressure_rank_week	integer	Per-week rank of diesel_cost_pressure_score across the 5 PADDs (1 = highest pressure that week; rank method 'min'; null on the national row and when the score is null). (unit: rank)
price_rank_week	integer	Per-week rank of price_usd_gal across the 5 PADDs (1 = priciest region that week; rank method 'min'; null on the national row). (unit: rank)
record_high_52w_flag	integer	1 when the week's price equals its trailing-52-week maximum (including the current week). (unit: binary)
sharp_move_flag	integer	1 when \|wow_change_pct\| >= 5 (documented sharp-move threshold). (unit: binary)
days_since_prev	float	Calendar days between this observation and the region's previous one (7 in normal weeks; >7 after a skipped holiday Monday; null for each series' first week). (unit: days)
as_of	string	Fetch date in UTC (snapshot vintage). (unit: ISO date)
source_url	string	The exact EIA LeafHandler history URL this region's series was read from (provenance). (unit: URL)
row_hash	string	Deterministic 16-hex row hash of region_code + week_date (idempotency).

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

region	region_code	country_code	week_date	price_usd_gal	us_avg_price_usd_gal	premium_vs_us_usd	premium_vs_us_pct	wow_change_usd	wow_change_pct	mom_change_pct	yoy_change_pct	range_pos_52w	diesel_cost_pressure_score	pressure_tier	pressure_rank_week	price_rank_week	record_high_52w_flag	sharp_move_flag	days_since_prev	as_of	source_url	row_hash
East Coast (PADD 1)	PADD1	USA	2026-09-21	6.268	6.529	-0.261	-3.998	0.11	1.786	14.005	67.37	1	100	p1	1	4	1	0	7	2026-09-29	https://www.eia.gov/dnav/pet/hist/LeafHandler.ashx?n=PET&s=EMD_EPD2D_PTE_R10_DPG&f=W	7d9c628ddafe2f1e
Midwest (PADD 2)	PADD2	USA	2026-09-21	6.68	6.529	0.151	2.313	0.43	6.88	18.524	79.04	1	100	p1	1	2	1	1	7	2026-09-29	https://www.eia.gov/dnav/pet/hist/LeafHandler.ashx?n=PET&s=EMD_EPD2D_PTE_R20_DPG&f=W	2e98a506c9ad1ef6
Gulf Coast (PADD 3)	PADD3	USA	2026-09-21	6.177	6.529	-0.352	-5.391	0.15	2.489	12.698	81.676	1	100	p1	1	5	1	0	7	2026-09-29	https://www.eia.gov/dnav/pet/hist/LeafHandler.ashx?n=PET&s=EMD_EPD2D_PTE_R30_DPG&f=W	1bae26530763683e
Rocky Mountain (PADD 4)	PADD4	USA	2026-09-21	6.34	6.529	-0.189	-2.895	0.274	4.517	14.502	69.202	1	100	p1	1	3	1	0	7	2026-09-29	https://www.eia.gov/dnav/pet/hist/LeafHandler.ashx?n=PET&s=EMD_EPD2D_PTE_R40_DPG&f=W	1ae1b2ea2888014c
West Coast (PADD 5)	PADD5	USA	2026-09-21	7.456	6.529	0.927	14.198	0.206	2.841	16.373	64.81	1	100	p1	1	1	1	0	7	2026-09-29	https://www.eia.gov/dnav/pet/hist/LeafHandler.ashx?n=PET&s=EMD_EPD2D_PTE_R50_DPG&f=W	5c6396fe64442ded
United States	US	USA	2026-09-21	6.529	6.529	—	—	0.244	3.882	15.517	74.153	1	100	p1	—	—	1	0	7	2026-09-29	https://www.eia.gov/dnav/pet/hist/LeafHandler.ashx?n=PET&s=EMD_EPD2D_PTE_NUS_DPG&f=W	300f98b6d25d5d7c
East Coast (PADD 1)	PADD1	USA	2026-09-14	6.158	6.285	-0.127	-2.021	0.414	7.208	15.318	64.301	1	100	p1	1	3	1	1	7	2026-09-29	https://www.eia.gov/dnav/pet/hist/LeafHandler.ashx?n=PET&s=EMD_EPD2D_PTE_R10_DPG&f=W	4ac2080b6c5abb19
Midwest (PADD 2)	PADD2	USA	2026-09-14	6.25	6.285	-0.035	-0.557	0.304	5.113	14.995	68.464	1	100	p1	1	2	1	1	7	2026-09-29	https://www.eia.gov/dnav/pet/hist/LeafHandler.ashx?n=PET&s=EMD_EPD2D_PTE_R20_DPG&f=W	4702cdfc244c0cde
Gulf Coast (PADD 3)	PADD3	USA	2026-09-14	6.027	6.285	-0.258	-4.105	0.273	4.745	15.085	77.84	1	100	p1	1	5	1	0	7	2026-09-29	https://www.eia.gov/dnav/pet/hist/LeafHandler.ashx?n=PET&s=EMD_EPD2D_PTE_R30_DPG&f=W	746c62ea6b4b43dc
Rocky Mountain (PADD 4)	PADD4	USA	2026-09-14	6.066	6.285	-0.219	-3.484	0.261	4.496	11.774	62.977	1	100	p1	1	4	1	0	7	2026-09-29	https://www.eia.gov/dnav/pet/hist/LeafHandler.ashx?n=PET&s=EMD_EPD2D_PTE_R40_DPG&f=W	11acb55e24ac5978

Profiled Sep 29, 2026 from snapshot 20260929T125150Z-a5bd8c39cee3

Measured

Completeness: 96.4%
Rows: 10,182
Columns: 23
Columns with gaps: 12

Column	Missing	Distinct	Range	Distribution
regionvarchar	0%	6	—	East Coast (PADD 1)1,697 Gulf Coast (PADD 3)1,697 Midwest (PADD 2)1,697
region_codevarchar	0%	5	—	PADD11,697 PADD21,697 PADD31,697
country_codevarchar	0%	1	—	USA10,182
week_datevarchar	0%	1,933	—	1994-03-216 1994-03-286 1994-04-046
price_usd_galdouble	0%	3,530	0.928 → 7.46median 2.75	200 outside 1st–99th percentile
us_avg_price_usd_galdouble	0%	1,223	0.953 → 6.53median 2.71	198 outside 1st–99th percentile
premium_vs_us_usddouble	16.7%	2,086	-0.487 → 1.28median -0.004	170 outside 1st–99th percentile
premium_vs_us_pctdouble	16.7%	7,320	-10.69 → 29.23median -0.191	170 outside 1st–99th percentile
wow_change_usddouble	0.06%	1,015	-0.328 → 1.03median -0.001	205 outside 1st–99th percentile
wow_change_pctdouble	0.06%	9,844	-10.14 → 28.6median -0.066	204 outside 1st–99th percentile
mom_change_pctdouble	0.24%	8,951	-23.43 → 47.15median 0.0988	204 outside 1st–99th percentile
yoy_change_pctdouble	3.1%	11,188	-52.24 → 86.93median 3.4	198 outside 1st–99th percentile
range_pos_52wdouble	3%	7,125	0 → 1median 0.5747
diesel_cost_pressure_scoredouble	3.1%	9,705	0 → 100median 56.76	99 outside 1st–99th percentile
pressure_tiervarchar	3.1%	4	—	p12,468 p42,468 p22,467
pressure_rank_weekbigint	19.2%	5	1 → 5median 3
price_rank_weekbigint	16.7%	5	1 → 5median 3
record_high_52w_flagbigint	0%	2	0 → 1median 0
sharp_move_flagbigint	0%	2	0 → 1median 0
days_since_prevdouble	0.06%	1	7 → 7median 7
as_ofvarchar	0%	1	—	2026-09-2910,182
source_urlvarchar	0%	4	—	https://www.eia.gov/dnav/pet/hist/LeafHandler.ashx?n=PET&s=EMD_EPD2D_PTE_NUS_DPG&f=W1,697 https://www.eia.gov/dnav/pet/hist/LeafHandler.ashx?n=PET&s=EMD_EPD2D_PTE_R10_DPG&f=W1,697 https://www.eia.gov/dnav/pet/hist/LeafHandler.ashx?n=PET&s=EMD_EPD2D_PTE_R20_DPG&f=W1,697
row_hashvarchar	0%	10,504	—	000a433b2426ca461 001b78497d5385851 0028bcc71f61bced1

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

cURL

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

Python

import requests

ds = requests.get("https://datazimuts.com/v1/datasets/eia_diesel_price_weekly/us_retail_diesel_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/eia_diesel_price_weekly/us_retail_diesel_weekly

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

Cite this snapshot

Pinned to snapshot 20260929T125150Z-a5bd8c39cee3 and its content hash, so readers get exactly the data you used.

APA

U.S. Energy Information Administration. (2026). US retail diesel prices (weekly, by PADD) [Data set, snapshot 20260929T125150Z-a5bd8c39cee3, sha256 a5bd8c39cee3]. Datazimuts. Retrieved 2026-09-30, from https://datazimuts.com/en/datasets/eia_diesel_price_weekly/us_retail_diesel_weekly?snapshot=20260929T125150Z-a5bd8c39cee3

BibTeX

@misc{dz_eia_diesel_price_weekly_us_retail_diesel_a5bd8c39,
  title        = {{US retail diesel prices (weekly, by PADD)}},
  author       = {{U.S. Energy Information Administration}},
  year         = {2026},
  publisher    = {Datazimuts},
  howpublished = {\url{https://datazimuts.com/en/datasets/eia_diesel_price_weekly/us_retail_diesel_weekly?snapshot=20260929T125150Z-a5bd8c39cee3}},
  note         = {Snapshot 20260929T125150Z-a5bd8c39cee3, sha256 a5bd8c39cee387e4e81c21ce3234ad0370a6c7c708a6327c3e915859c3a913f3; accessed 2026-09-30}
}

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=eia_diesel_price_weekly%2Fus_retail_diesel_weekly&lang=en&theme=auto&snapshot=20260929T125150Z-a5bd8c39cee3&x=week_date&y=price_usd_gal&agg=avg" title="US retail diesel prices (weekly, by PADD)" width="100%" height="380" style="border:0" loading="lazy"></iframe>

US retail diesel prices (weekly, by PADD)

Follow this dataset

Cite this snapshot

Embed a table or a chart

Use your own AI key