Dataset: Oil Price And Share Price Of A Few Companies

About this Dataset

Oil Price And Share Price Of A Few Companies

Context

This is the oil price and the share price of a few companies.

Content

The share price contains the following columns: Date,Open,High,Low,Close,Adj Close,Volume
The oil price contains the following columns: date and brent oil price

Acknowledgements

The oil price is obtained from the website of the U.S Energy Information administration:
https://www.eia.gov/dnav/pet/hist/LeafHandler.ashx?n=PET&s=rbrte&f=D

Share price dataset in a daily frequency from a few companies:

To download the dataset I use Yahoo finance. The following link is an example to download the share price dataset: https://uk.finance.yahoo.com/quote/RDSB.L/history?period1=946684800&period2=1499122800&interval=1d&filter=history&frequency=1d

Inspiration

Tables

Bp L

@kaggle.javierbravo_oil_price_and_share_price_of_a_few_companies.bp_l

168.13 KB
4472 rows
7 columns


CREATE TABLE bp_l (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "adj_close" DOUBLE,
  "volume" DOUBLE
);

Cne L

@kaggle.javierbravo_oil_price_and_share_price_of_a_few_companies.cne_l

178.32 KB
4472 rows
7 columns


CREATE TABLE cne_l (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "adj_close" DOUBLE,
  "volume" BIGINT
);

Engi Pa

@kaggle.javierbravo_oil_price_and_share_price_of_a_few_companies.engi_pa

173.33 KB
4506 rows
7 columns


CREATE TABLE engi_pa (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "adj_close" DOUBLE,
  "volume" DOUBLE
);

Fp Pa

@kaggle.javierbravo_oil_price_and_share_price_of_a_few_companies.fp_pa

177.2 KB
4506 rows
7 columns


CREATE TABLE fp_pa (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "adj_close" DOUBLE,
  "volume" DOUBLE
);

Pmo L

@kaggle.javierbravo_oil_price_and_share_price_of_a_few_companies.pmo_l

167.19 KB
4472 rows
7 columns


CREATE TABLE pmo_l (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "adj_close" DOUBLE,
  "volume" DOUBLE
);

Rdsb L

@kaggle.javierbravo_oil_price_and_share_price_of_a_few_companies.rdsb_l

161.48 KB
4377 rows
7 columns


CREATE TABLE rdsb_l (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "adj_close" DOUBLE,
  "volume" DOUBLE
);

Rep Mc

@kaggle.javierbravo_oil_price_and_share_price_of_a_few_companies.rep_mc

173.66 KB
4504 rows
7 columns


CREATE TABLE rep_mc (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "adj_close" DOUBLE,
  "volume" DOUBLE
);

Slb Pa

@kaggle.javierbravo_oil_price_and_share_price_of_a_few_companies.slb_pa

166.82 KB
4071 rows
7 columns


CREATE TABLE slb_pa (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "adj_close" DOUBLE,
  "volume" DOUBLE
);

Stl Ol

@kaggle.javierbravo_oil_price_and_share_price_of_a_few_companies.stl_ol

142.41 KB
4461 rows
7 columns


CREATE TABLE stl_ol (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "adj_close" DOUBLE,
  "volume" DOUBLE
);