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

Ttwo

@kaggle.rprkh15_sp500_stock_prices.ttwo

281.06 kB
6,353 rows
8 columns

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

Twtr

@kaggle.rprkh15_sp500_stock_prices.twtr

92.11 kB
2,183 rows
8 columns

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

Txn

@kaggle.rprkh15_sp500_stock_prices.txn

633.05 kB
12,637 rows
8 columns

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

Txt

@kaggle.rprkh15_sp500_stock_prices.txt

536.42 kB
12,457 rows
8 columns

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

Tyl

@kaggle.rprkh15_sp500_stock_prices.tyl

314.29 kB
10,671 rows
8 columns

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

Ual

@kaggle.rprkh15_sp500_stock_prices.ual

177.32 kB
4,136 rows
8 columns

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

Udr

@kaggle.rprkh15_sp500_stock_prices.udr

422.95 kB
10,671 rows
8 columns

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

Uhs

@kaggle.rprkh15_sp500_stock_prices.uhs

426.92 kB
10,340 rows
8 columns

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

Ulta

@kaggle.rprkh15_sp500_stock_prices.ulta

178.46 kB
3,703 rows
8 columns

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

Unh

@kaggle.rprkh15_sp500_stock_prices.unh

453.18 kB
9,510 rows
8 columns

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

Unp

@kaggle.rprkh15_sp500_stock_prices.unp

546.84 kB
10,723 rows
8 columns

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

Ups

@kaggle.rprkh15_sp500_stock_prices.ups

299.5 kB
5,703 rows
8 columns

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

Uri

@kaggle.rprkh15_sp500_stock_prices.uri

237.37 kB
6,180 rows
8 columns

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

Usb

@kaggle.rprkh15_sp500_stock_prices.usb

493.5 kB
12,407 rows
8 columns

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

V

@kaggle.rprkh15_sp500_stock_prices.v

191.56 kB
3,604 rows
8 columns

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

Vfc

@kaggle.rprkh15_sp500_stock_prices.vfc

503.74 kB
10,671 rows
8 columns

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

Vici

@kaggle.rprkh15_sp500_stock_prices.vici

63.1 kB
1,139 rows
8 columns

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

Vlo

@kaggle.rprkh15_sp500_stock_prices.vlo

482.25 kB
10,217 rows
8 columns

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

Vmc

@kaggle.rprkh15_sp500_stock_prices.vmc

516.46 kB
12,457 rows
8 columns

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

Vno

@kaggle.rprkh15_sp500_stock_prices.vno

460.26 kB
10,671 rows
8 columns

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

Vrsk

@kaggle.rprkh15_sp500_stock_prices.vrsk

165.84 kB
3,212 rows
8 columns

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

Vrsn

@kaggle.rprkh15_sp500_stock_prices.vrsn

299.72 kB
6,152 rows
8 columns

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

Vrtx

@kaggle.rprkh15_sp500_stock_prices.vrtx

277.56 kB
7,801 rows
8 columns

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

Vtr

@kaggle.rprkh15_sp500_stock_prices.vtr

319.56 kB
6,339 rows
8 columns

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

Vtrs

@kaggle.rprkh15_sp500_stock_prices.vtrs

481.75 kB
10,671 rows
8 columns

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