Oil Price And Share Price Of A Few Companies
Just a daily oil price dataset and a few companies dataset
@kaggle.javierbravo_oil_price_and_share_price_of_a_few_companies
Just a daily oil price dataset and a few companies dataset
@kaggle.javierbravo_oil_price_and_share_price_of_a_few_companies
This is the oil price and the share price of a few companies.
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
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
CREATE TABLE bp_l (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE cne_l (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" BIGINT
);CREATE TABLE engi_pa (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE fp_pa (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE pmo_l (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE rdsb_l (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE rep_mc (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE slb_pa (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" DOUBLE
);CREATE TABLE stl_ol (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" DOUBLE
);Anyone who has the link will be able to view this.