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

Hsic

@kaggle.rprkh15_sp500_stock_prices.hsic

260 kB
6,717 rows
8 columns

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

Hst

@kaggle.rprkh15_sp500_stock_prices.hst

496.81 kB
10,671 rows
8 columns

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

Hsy

@kaggle.rprkh15_sp500_stock_prices.hsy

499.92 kB
10,671 rows
8 columns

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

Hum

@kaggle.rprkh15_sp500_stock_prices.hum

484.5 kB
10,218 rows
8 columns

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

Hwm

@kaggle.rprkh15_sp500_stock_prices.hwm

77.72 kB
1,432 rows
8 columns

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

Ibm

@kaggle.rprkh15_sp500_stock_prices.ibm

775.38 kB
15,236 rows
8 columns

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

Ice

@kaggle.rprkh15_sp500_stock_prices.ice

221.03 kB
4,190 rows
8 columns

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

Idxx

@kaggle.rprkh15_sp500_stock_prices.idxx

282.9 kB
7,823 rows
8 columns

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

Iex

@kaggle.rprkh15_sp500_stock_prices.iex

386.75 kB
8,342 rows
8 columns

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

Iff

@kaggle.rprkh15_sp500_stock_prices.iff

551.08 kB
11,996 rows
8 columns

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

Ilmn

@kaggle.rprkh15_sp500_stock_prices.ilmn

229.81 kB
5,523 rows
8 columns

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

Incy

@kaggle.rprkh15_sp500_stock_prices.incy

245.77 kB
7,222 rows
8 columns

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

Intc

@kaggle.rprkh15_sp500_stock_prices.intc

520.59 kB
10,671 rows
8 columns

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

Intu

@kaggle.rprkh15_sp500_stock_prices.intu

370.76 kB
7,387 rows
8 columns

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

Ip

@kaggle.rprkh15_sp500_stock_prices.ip

719.71 kB
15,236 rows
8 columns

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

Ipg

@kaggle.rprkh15_sp500_stock_prices.ipg

482.44 kB
10,671 rows
8 columns

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

Iqv

@kaggle.rprkh15_sp500_stock_prices.iqv

103.11 kB
2,310 rows
8 columns

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

Ir

@kaggle.rprkh15_sp500_stock_prices.ir

70.4 kB
1,300 rows
8 columns

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

Irm

@kaggle.rprkh15_sp500_stock_prices.irm

329.68 kB
6,656 rows
8 columns

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

Isrg

@kaggle.rprkh15_sp500_stock_prices.isrg

239.54 kB
5,552 rows
8 columns

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

It

@kaggle.rprkh15_sp500_stock_prices.it

278.2 kB
7,244 rows
8 columns

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

Itw

@kaggle.rprkh15_sp500_stock_prices.itw

525.22 kB
12,443 rows
8 columns

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

Ivz

@kaggle.rprkh15_sp500_stock_prices.ivz

341.17 kB
6,766 rows
8 columns

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

J

@kaggle.rprkh15_sp500_stock_prices.j

421.87 kB
10,671 rows
8 columns

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

Jbht

@kaggle.rprkh15_sp500_stock_prices.jbht

436.08 kB
9,738 rows
8 columns

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