Brent and WTI Spot Prices

core

Files Size Format Created Updated License Source
9 573kB csv zip 5 days ago ODC-PDDL-1.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 Sources * Name: Daily Europe Brent Spot Price Web: https://www.eia.gov/dnav/pet/hist_xls/RBRTEd.xls * Name: Weekly Europe Brent Spot Price read more
Download

Data Files

File Description Size Last changed Download
brent-day 128kB csv (128kB) , json (356kB)
brent-week 26kB csv (26kB) , json (73kB)
brent-month 6kB csv (6kB) , json (17kB)
brent-year 547B csv (547B) , json (1kB)
wti-day 133kB csv (133kB) , json (356kB)
wti-week 28kB csv (28kB) , json (74kB)
wti-month 6kB csv (6kB) , json (17kB)
wti-year 559B csv (559B) , json (1kB)
oil-prices_zip Compressed versions of dataset. Includes normalized CSV and JSON data with original data and datapackage.json. 311kB zip (311kB)

brent-day  

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) YYYY-MM-DD
Brent Spot Price 2 number Europe Brent Spot Price FOB (Dollars per Barrel)

brent-week  

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) YYYY-MM-DD
Brent Spot Price 2 number Europe Brent Spot Price FOB (Dollars per Barrel)

brent-month  

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) YYYY-MM
Brent Spot Price 2 number Europe Brent Spot Price FOB (Dollars per Barrel)

brent-year  

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) YYYY
Brent Spot Price 2 number Europe Brent Spot Price FOB (Dollars per Barrel)

wti-day  

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) YYYY-MM-DD
WTI Spot Price 2 number Cushing, OK WTI Spot Price FOB (Dollars per Barrel)

wti-week  

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) YYYY-MM-DD
WTI Spot Price 2 number Cushing, OK WTI Spot Price FOB (Dollars per Barrel)

wti-month  

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) YYYY-MM
WTI Spot Price 2 number Cushing, OK WTI Spot Price FOB (Dollars per Barrel)

wti-year  

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) YYYY
WTI Spot Price 2 number Cushing, OK WTI Spot Price FOB (Dollars per Barrel)

oil-prices_zip  

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

Read me

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

Data

Sources

Data Series History

Europe Brent

20 May 1987 - Today

Cushing, OK WTI

01 February 1986 - Today

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

License

Data

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/

Import into your tool

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

install.packages("jsonlite")
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)
  }
}

In order to work with Data Packages in Pandas you need to install the Frictionless Data data package library and the pandas extension:

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')

# get list of all resources:
resources = package.descriptor['resources']
resourceList = [resources[x]['name'] for x in range(0, len(resources))]
print(resourceList)

# print all tabular data(if exists any)
resources = package.resources
for resource in resources:
    if resource.tabular:
        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)
    }
  }
})()
Datapackage.json