Name: S&P500 Stock Prices
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

S&P500 Stock Prices

Context

The Standard and Poor's 500 is a stock market index tracking the performance of 500 large companies listed on stock exchanges in the United States. It is one of the most commonly followed equity indices. As of December 31, 2020, more than $5.4 trillion was invested in assets tied to the performance of the index.

Inspiration

This dataset can be used to create some interesting visualizations and identify how stock prices of a particular company vary over time. Working with stock data is one of the best ways to get acquainted with timeseries forecasting. Can you create a model to stay one step ahead of the market and make statistically informed trading decisions?

Content

The naming convention of the files are in the form ticker.csv. The individual files contain the historical stock price data of that company. All the files have the following columns:

Date: The date is in the format yy-mm-dd
Open: Price of the stock when the market opens
High: Highest price reached in the day
Low: Lowest price reached in the day
Close: Price of the stock when the market closes
Volume: Number of shares traded in a day
Dividends: The dividends of the stock
Stock Splits: The stock splits of the company. In a stock split, a company divides its existing stock into multiple shares to boost liquidity.

Acknowledgement

Credits to Yahoo Finance that simplified the process of scraping stock data.

Tables

Ea

@kaggle.rprkh15_sp500_stock_prices.ea

400.17 kB
8,266 rows
8 columns

CREATE TABLE ea (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" DOUBLE,
  "stock_splits" DOUBLE
);

Ebay

@kaggle.rprkh15_sp500_stock_prices.ebay

313.66 kB
5,988 rows
8 columns

CREATE TABLE ebay (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" DOUBLE,
  "stock_splits" DOUBLE
);

Ecl

@kaggle.rprkh15_sp500_stock_prices.ecl

504.22 kB
12,457 rows
8 columns

CREATE TABLE ecl (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" DOUBLE,
  "stock_splits" DOUBLE
);

Ed

@kaggle.rprkh15_sp500_stock_prices.ed

646.21 kB
15,236 rows
8 columns

CREATE TABLE ed (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" DOUBLE,
  "stock_splits" DOUBLE
);

Efx

@kaggle.rprkh15_sp500_stock_prices.efx

477.76 kB
10,671 rows
8 columns

CREATE TABLE efx (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" DOUBLE,
  "stock_splits" DOUBLE
);

Eix

@kaggle.rprkh15_sp500_stock_prices.eix

551.29 kB
12,407 rows
8 columns

CREATE TABLE eix (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" DOUBLE,
  "stock_splits" DOUBLE
);

El

@kaggle.rprkh15_sp500_stock_prices.el

345.98 kB
6,707 rows
8 columns

CREATE TABLE el (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" DOUBLE,
  "stock_splits" DOUBLE
);

Elv

@kaggle.rprkh15_sp500_stock_prices.elv

273.45 kB
5,210 rows
8 columns

CREATE TABLE elv (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" DOUBLE,
  "stock_splits" DOUBLE
);

Emn

@kaggle.rprkh15_sp500_stock_prices.emn

367.83 kB
7,195 rows
8 columns

CREATE TABLE emn (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" DOUBLE,
  "stock_splits" DOUBLE
);

Emr

@kaggle.rprkh15_sp500_stock_prices.emr

611.45 kB
12,637 rows
8 columns

CREATE TABLE emr (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" DOUBLE,
  "stock_splits" DOUBLE
);

Enph

@kaggle.rprkh15_sp500_stock_prices.enph

99 kB
2,587 rows
8 columns

CREATE TABLE enph (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" BIGINT,
  "stock_splits" BIGINT
);

Eog

@kaggle.rprkh15_sp500_stock_prices.eog

413.79 kB
8,256 rows
8 columns

CREATE TABLE eog (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" DOUBLE,
  "stock_splits" DOUBLE
);

Epam

@kaggle.rprkh15_sp500_stock_prices.epam

115.44 kB
2,623 rows
8 columns

CREATE TABLE epam (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" BIGINT,
  "stock_splits" BIGINT
);

Eqix

@kaggle.rprkh15_sp500_stock_prices.eqix

281.38 kB
5,513 rows
8 columns

CREATE TABLE eqix (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" DOUBLE,
  "stock_splits" DOUBLE
);

Eqr

@kaggle.rprkh15_sp500_stock_prices.eqr

366.51 kB
7,281 rows
8 columns

CREATE TABLE eqr (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" DOUBLE,
  "stock_splits" DOUBLE
);

Es

@kaggle.rprkh15_sp500_stock_prices.es

487.96 kB
12,457 rows
8 columns

CREATE TABLE es (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" DOUBLE,
  "stock_splits" BIGINT
);

Ess

@kaggle.rprkh15_sp500_stock_prices.ess

340.55 kB
7,075 rows
8 columns

CREATE TABLE ess (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" DOUBLE,
  "stock_splits" BIGINT
);

Etn

@kaggle.rprkh15_sp500_stock_prices.etn

600.82 kB
12,637 rows
8 columns

CREATE TABLE etn (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" DOUBLE,
  "stock_splits" DOUBLE
);

Etr

@kaggle.rprkh15_sp500_stock_prices.etr

547.36 kB
12,637 rows
8 columns

CREATE TABLE etr (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" DOUBLE,
  "stock_splits" BIGINT
);

Etsy

@kaggle.rprkh15_sp500_stock_prices.etsy

81.75 kB
1,823 rows
8 columns

CREATE TABLE etsy (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" BIGINT,
  "stock_splits" BIGINT
);

Evrg

@kaggle.rprkh15_sp500_stock_prices.evrg

488.67 kB
12,457 rows
8 columns

CREATE TABLE evrg (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" DOUBLE,
  "stock_splits" DOUBLE
);

Ew

@kaggle.rprkh15_sp500_stock_prices.ew

232.69 kB
5,609 rows
8 columns

CREATE TABLE ew (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" BIGINT,
  "stock_splits" DOUBLE
);

Exc

@kaggle.rprkh15_sp500_stock_prices.exc

541.4 kB
12,408 rows
8 columns

CREATE TABLE exc (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" DOUBLE,
  "stock_splits" DOUBLE
);

Expd

@kaggle.rprkh15_sp500_stock_prices.expd

417.4 kB
9,525 rows
8 columns

CREATE TABLE expd (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" DOUBLE,
  "stock_splits" DOUBLE
);

Expe

@kaggle.rprkh15_sp500_stock_prices.expe

224.77 kB
4,273 rows
8 columns

CREATE TABLE expe (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" DOUBLE,
  "stock_splits" DOUBLE
);