Now you can request additional data and/or customized columns!

Try It Now!

Brent and WTI Spot Prices

Certified

core

Files Size Format Created Updated License Source
9 605kB csv zip 5 years ago 13 hours ago Open Data Commons Public Domain Dedication and License v1.0 Daily Europe Brent Spot Price Weekly Europe Brent Spot Price Monthly Europe Brent Spot Price Annual Europe Brent Spot Price Daily Cushing, OK WTI Spot Price Weekly Cushing, OK WTI Spot Price Monthly Cushing, OK WTI Spot Price Annual Cushing, OK WTI Spot Price
Europe Brent and WTI (Western Texas Intermediate) Spot Prices (Annual/ Monthly/ Weekly/ Daily) from EIA U.S. (Energy Information Administration). Data This series is available through the EIA open data API Europe Brent Spot Price FOB (Dollars per Barrel) - From 20 May 1987 till today Cushing, OK read more
Download Developers

Data Files

Download files in this dataset

File Description Size Last changed Download
brent-daily 319kB csv (319kB) , json (505kB)
brent-week 66kB csv (66kB) , json (104kB)
brent-month 15kB csv (15kB) , json (24kB)
brent-year 1kB csv (1kB) , json (2kB)
wti-daily 328kB csv (328kB) , json (521kB)
wti-week 68kB csv (68kB) , json (108kB)
wti-month 16kB csv (16kB) , json (25kB)
wti-year 1kB csv (1kB) , json (2kB)
oil-prices_zip Compressed versions of dataset. Includes normalized CSV and JSON data with original data and datapackage.json. 354kB zip (354kB)

brent-daily  

Signup to Premium Service for additional or customised data - Get Started

This is a preview version. There might be more data in the original version.

Field information

Field Name Order Type (Format) Description
Date 1 date (%Y-%m-%d)
Price 2 number (default)

brent-week  

Signup to Premium Service for additional or customised data - Get Started

This is a preview version. There might be more data in the original version.

Field information

Field Name Order Type (Format) Description
Date 1 date (%Y-%m-%d)
Price 2 number (default)

brent-month  

Signup to Premium Service for additional or customised data - Get Started

This is a preview version. There might be more data in the original version.

Field information

Field Name Order Type (Format) Description
Date 1 date (%Y-%m-%d)
Price 2 number (default)

brent-year  

Signup to Premium Service for additional or customised data - Get Started

This is a preview version. There might be more data in the original version.

Field information

Field Name Order Type (Format) Description
Date 1 date (%Y-%m-%d)
Price 2 number (default)

wti-daily  

Signup to Premium Service for additional or customised data - Get Started

This is a preview version. There might be more data in the original version.

Field information

Field Name Order Type (Format) Description
Date 1 date (%Y-%m-%d)
Price 2 number (default)

wti-week  

Signup to Premium Service for additional or customised data - Get Started

This is a preview version. There might be more data in the original version.

Field information

Field Name Order Type (Format) Description
Date 1 date (%Y-%m-%d)
Price 2 number (default)

wti-month  

Signup to Premium Service for additional or customised data - Get Started

This is a preview version. There might be more data in the original version.

Field information

Field Name Order Type (Format) Description
Date 1 date (%Y-%m-%d)
Price 2 number (default)

wti-year  

Signup to Premium Service for additional or customised data - Get Started

This is a preview version. There might be more data in the original version.

Field information

Field Name Order Type (Format) Description
Date 1 date (%Y-%m-%d)
Price 2 number (default)

Integrate this dataset into your favourite tool

Use our data-cli tool designed for data wranglers:

data get https://datahub.io/core/oil-prices
data info core/oil-prices
tree core/oil-prices
# Get a list of dataset's resources
curl -L -s https://datahub.io/core/oil-prices/datapackage.json | grep path

# Get resources

curl -L https://datahub.io/core/oil-prices/r/0.csv

curl -L https://datahub.io/core/oil-prices/r/1.csv

curl -L https://datahub.io/core/oil-prices/r/2.csv

curl -L https://datahub.io/core/oil-prices/r/3.csv

curl -L https://datahub.io/core/oil-prices/r/4.csv

curl -L https://datahub.io/core/oil-prices/r/5.csv

curl -L https://datahub.io/core/oil-prices/r/6.csv

curl -L https://datahub.io/core/oil-prices/r/7.csv

curl -L https://datahub.io/core/oil-prices/r/8.zip

If you are using R here's how to get the data you want quickly loaded:

install.packages("jsonlite", repos="https://cran.rstudio.com/")
library("jsonlite")

json_file <- 'https://datahub.io/core/oil-prices/datapackage.json'
json_data <- fromJSON(paste(readLines(json_file), collapse=""))

# get list of all resources:
print(json_data$resources$name)

# print all tabular data(if exists any)
for(i in 1:length(json_data$resources$datahub$type)){
  if(json_data$resources$datahub$type[i]=='derived/csv'){
    path_to_file = json_data$resources$path[i]
    data <- read.csv(url(path_to_file))
    print(data)
  }
}

Note: You might need to run the script with root permissions if you are running on Linux machine

Install the Frictionless Data data package library and the pandas itself:

pip install datapackage
pip install pandas

Now you can use the datapackage in the Pandas:

import datapackage
import pandas as pd

data_url = 'https://datahub.io/core/oil-prices/datapackage.json'

# to load Data Package into storage
package = datapackage.Package(data_url)

# to load only tabular data
resources = package.resources
for resource in resources:
    if resource.tabular:
        data = pd.read_csv(resource.descriptor['path'])
        print (data)

For Python, first install the `datapackage` library (all the datasets on DataHub are Data Packages):

pip install datapackage

To get Data Package into your Python environment, run following code:

from datapackage import Package

package = Package('https://datahub.io/core/oil-prices/datapackage.json')

# print list of all resources:
print(package.resource_names)

# print processed tabular data (if exists any)
for resource in package.resources:
    if resource.descriptor['datahub']['type'] == 'derived/csv':
        print(resource.read())

If you are using JavaScript, please, follow instructions below:

Install data.js module using npm:

  $ npm install data.js

Once the package is installed, use the following code snippet:

const {Dataset} = require('data.js')

const path = 'https://datahub.io/core/oil-prices/datapackage.json'

// We're using self-invoking function here as we want to use async-await syntax:
;(async () => {
  const dataset = await Dataset.load(path)
  // get list of all resources:
  for (const id in dataset.resources) {
    console.log(dataset.resources[id]._descriptor.name)
  }
  // get all tabular data(if exists any)
  for (const id in dataset.resources) {
    if (dataset.resources[id]._descriptor.format === "csv") {
      const file = dataset.resources[id]
      // Get a raw stream
      const stream = await file.stream()
      // entire file as a buffer (be careful with large files!)
      const buffer = await file.buffer
      // print data
      stream.pipe(process.stdout)
    }
  }
})()

Read me

Europe Brent and WTI (Western Texas Intermediate) Spot Prices (Annual/ Monthly/ Weekly/ Daily) from EIA U.S. (Energy Information Administration).

Data

This series is available through the EIA open data API

Definitions

Brent

A blended crude stream produced in the North Sea region which serves as a reference or “marker” for pricing a number of other crude streams. source

West Texas Intermediate (WTI - Cushing)

A crude stream produced in Texas and southern Oklahoma which serves as a reference or “marker” for pricing a number of other crude streams and which is traded in the domestic spot market at Cushing, Oklahoma. source

Preparation

You will need Python 3.6 or greater and dataflows library to run the script

To update the data run the process script locally:

# Install dataflows
pip install dataflows

# Run the script
python oil_prices_flow.py

License

U.S. government publications are in the public domain and are not subject to copyright protection. You may use and/or distribute any of our data, files, databases, reports, graphs, charts, and other information products that are on our website or that you receive through our email distribution service. However, if you use or reproduce any of our information products, you should use an acknowledgment, which includes the publication date, such as: “Source: U.S. Energy Information Administration (Oct 2008).”

You may find further information here

Additional work

All the additional work made to build this Data Package is made available under the Public Domain Dedication and License v1.0 whose full text can be found at: http://www.opendatacommons.org/licenses/pddl/1.0/


Keywords and keyphrases: brent crude oil price history excel, oil spot price, wti price, oil price history, daily crude oil prices, oil price data, brent crude spot price, oil price chart.
Datapackage.json

Request Customized Data


Notifications of data updates and schema changes

Warranty / guaranteed updates

Workflow integration (e.g. Python packages, NPM packages)

Customized data (e.g. you need different or additional data)

Or suggest your own feature from the link below