Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Elv
@kaggle.rprkh15_sp500_stock_prices.elv

  • 267.04 KB
  • 5210 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Tue Oct 30 2001 00:00:00 GMT+0000 (Coordinated Universal Time)17.01703803225051517.18510818481445316.95401132433009317.18510818481445345441800
Wed Oct 31 2001 00:00:00 GMT+0000 (Coordinated Universal Time)17.269141419080917.85738534207167317.23132571541955517.59687805175781211104400
Thu Nov 01 2001 00:00:00 GMT+0000 (Coordinated Universal Time)17.75233796084385317.89939810755100817.56325948448080617.718723297119143901800
Fri Nov 02 2001 00:00:00 GMT+0000 (Coordinated Universal Time)17.66830680665646718.1094889470544817.65570210639347318.025455474853524075000
Mon Nov 05 2001 00:00:00 GMT+0000 (Coordinated Universal Time)18.27755598506353318.27755598506353317.9624257094589918.0212497711181642763800
Tue Nov 06 2001 00:00:00 GMT+0000 (Coordinated Universal Time)18.0464612903246518.61369516162752517.71032264055866518.508651733398443248200
Wed Nov 07 2001 00:00:00 GMT+0000 (Coordinated Universal Time)18.38260082840230718.38260082840230717.8531826297919818.1725139617919922675200
Thu Nov 08 2001 00:00:00 GMT+0000 (Coordinated Universal Time)18.0674752484667718.1094919916311317.64730140547917617.9414234161376953404000
Fri Nov 09 2001 00:00:00 GMT+0000 (Coordinated Universal Time)17.85738377344040717.85738377344040717.2271231696719217.6472969055175783291600
Mon Nov 12 2001 00:00:00 GMT+0000 (Coordinated Universal Time)17.64730643192701418.00445365905761717.5212545636948318.004453659057617973600

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

Share link

Anyone who has the link will be able to view this.