Energy Market Price Fluctuation Data
This dataset provides synthetic, hourly market price records for key energy commodities across multiple regions, including price, volume, volatility, and percentage change metrics. Designed for trading analysis, risk modeling, and forecasting, it enables detailed time series and comparative studies in energy markets. The dataset supports robust analytics for market participants, researchers, and risk managers.
Sample rows
preview · 8 of 200 rows · all 12 columns| record_idstring | data_sourcestring | pricefloat | is_peak_hourboolean | commoditystring | timestampdatetime | market_regionstring | currencystring | unitstring | volume_tradedfloat | price_change_pctfloat | price_volatilityfloat |
|---|---|---|---|---|---|---|---|---|---|---|---|
| REC-001A | historical_model | 42.56 | false | electricity | 2024-04-01T01:00:00Z | CAISO | USD | MWh | 1832.2 | 2.18 | 3.92 |
| REC-002B | historical_model | 3.78 | false | natural_gas | 2024-04-01T02:00:00Z | PJM | USD | MMbtu | 520.8 | -2.1 | 0.7 |
| REC-003C | historical_model | 74.33 | false | coal | 2024-04-01T03:00:00Z | ERCOT | USD | ton | 2455.9 | 4.5 | 2.8 |
| REC-004D | simulation | 61.15 | false | renewable_energy | 2024-04-01T04:00:00Z | EU | EUR | MWh | 1903.7 | 9.25 | 5.2 |
| REC-005E | simulation | 79.66 | true | crude_oil | 2024-04-01T05:00:00Z | CAISO | USD | barrel | 3845.1 | 6.34 | 6.9 |
| REC-006F | historical_model | 82.24 | false | electricity | 2024-04-01T06:00:00Z | ERCOT | USD | MWh | 1705.5 | 0.83 | 1.64 |
| REC-007G | historical_model | 37.29 | false | natural_gas | 2024-04-01T07:00:00Z | EU | EUR | MMbtu | 2058.2 | 3.12 | 4.1 |
| REC-008H | simulation | 98.77 | true | coal | 2024-04-01T08:00:00Z | PJM | USD | ton | 2900.3 | 8.32 | 7.3 |
| REC-009I | historical_model | 56.88 | false | renewable_energy | 2024-04-01T09:00:00Z | CAISO | USD | MWh | 1179.8 | 2.47 | 2 |
| REC-010J | historical_model | 66.31 | false | crude_oil | 2024-04-01T10:00:00Z | ERCOT | USD | barrel | 2921.2 | -1.95 | 0.9 |
| REC-011K | simulation | 106.15 | true | electricity | 2024-04-01T11:00:00Z | EU | EUR | MWh | 2124.3 | 11.73 | 8.7 |
| REC-012L | historical_model | 2.89 | false | natural_gas | 2024-04-01T12:00:00Z | CAISO | USD | MMbtu | 124.8 | -8.7 | 1.1 |
| REC-013M | simulation | 0.99 | false | coal | 2024-04-01T13:00:00Z | EU | EUR | ton | 0 | -100 | 0 |
| REC-014N | historical_model | 62.75 | false | renewable_energy | 2024-04-01T14:00:00Z | PJM | USD | MWh | 1825.4 | 3.75 | 2.2 |
| REC-015O | simulation | 72.21 | true | crude_oil | 2024-04-01T15:00:00Z | EU | EUR | barrel | 3215.8 | 6.89 | 5.3 |
| REC-016P | simulation | 87.47 | true | electricity | 2024-04-01T16:00:00Z | PJM | USD | MWh | 2500.6 | 14.2 | 9.8 |
| REC-017Q | historical_model | 5.15 | false | natural_gas | 2024-04-01T17:00:00Z | ERCOT | USD | MMbtu | 1636 | 2.19 | 2.7 |
| REC-018R | historical_model | 85.24 | false | coal | 2024-04-01T18:00:00Z | CAISO | USD | ton | 2101.6 | 5.12 | 4.6 |
| REC-019S | historical_model | 59.81 | false | renewable_energy | 2024-04-01T19:00:00Z | ERCOT | USD | MWh | 1097.3 | 2.37 | 2.2 |
| REC-020T | third-party_provider | 10000 | true | crude_oil | 2024-04-01T20:00:00Z | PJM | USD | barrel | 10000 | 100 | 950 |
What the 200 rows show
from the 200-row sampleSimulation (data source) stands out: 58 of its 84 rows have is_
- 38%is_
peak_ hour = true - 67.3median price
- 2currencies
- 4market regions
- 4units
- 2,173median volume_
traded
Median 67.3, from 0.02 to 10,000.
- string 6
- float 4
- datetime 1
- boolean 1
Columns
12 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 6 columns | |||
record_id | string | Unique identifier for each hourly market price recordunique | REC-001A |
commodity | string | Name of the energy commodity (e.g., electricity, natural gas, crude oil)5 values | electricity |
market_region | string | Geographic or market region identifier (e.g., PJM, ERCOT, EU, CAISO)4 regions | CAISO |
currency | string | Currency code for the price value (ISO 4217, e.g., USD, EUR)2 currencies | USD |
unit | string | Unit of measurement for the commodity price (e.g., MWh, MMbtu, barrel, ton)4 units | MWh |
data_source | string | Source or origin of the synthetic data (e.g., simulation, historical model, third-party provider)3 sources · optional | historical_model |
| Numbers 4 columns | |||
price | float | Market price of the commodity for the given hour (in USD per standard unit)0 or more | 42.56 |
volume_traded | float | Total volume of commodity traded in the given hour (in standard units)0 or more · optional | 1832.2 |
price_change_pct | float | Percentage change in price compared to the previous hour-100 to 100 · optional | 2.18 |
price_volatility | float | Volatility measure for the price in the given hour (e.g., standard deviation over past 24 hours)0 or more · optional | 3.92 |
| Dates and times 1 column | |||
timestamp | datetime | Date and hour for which the market price is recorded (ISO 8601 format, UTC recommended) | 2024-04-01T01:00:00Z |
| True or false 1 column | |||
is_peak_hour | boolean | Indicates whether the hour is considered a peak trading hour in the regionoptional | false |
Use it for
An energy dashboard
The is_
peak_ hour rate, price by data_ source and a breakdown of commodity. Excel, Power BI or Tableau. Why do 76 of 200 rows have is_
peak_ hour = true? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Records200REC-001A42.56historic…REC-005E79.66simulati…REC-008H98.77simulati…
A software demo
Believable records with timestamp, commodity and market_
region to fill a screen in front of a buyer.
blueprint · energy-market-price-fluctuation-data
Behind this dataset
Same schema. As many rows as you need.
These 200 rows came out of a blueprint — 12 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.
- Commodity: electricity, gas, oil
- Price per MWh or barrel
- Volatility injected at 5% intervals
- Peak/valley periods flagged
1 credit per row. Preview 20 rows free. Buy rows for the full run.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- energy-market-price-fluctuation-data