Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Lvs
@kaggle.rprkh15_sp500_stock_prices.lvs

  • 227.77 KB
  • 4423 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Wed Dec 15 2004 00:00:00 GMT+0000 (Coordinated Universal Time)27.9439437275405132.9791882654932627.7772137591043431.0517902374267626246300
Thu Dec 16 2004 00:00:00 GMT+0000 (Coordinated Universal Time)32.07884331319747433.746142914592331.94546138036372432.752433776855477778200
Fri Dec 17 2004 00:00:00 GMT+0000 (Coordinated Universal Time)32.75242727930890435.51347446441650432.0855075710569535.346744537353524755800
Mon Dec 20 2004 00:00:00 GMT+0000 (Coordinated Universal Time)35.1466685825808436.0003249816466332.2322302155666832.4122962951660166098000
Tue Dec 21 2004 00:00:00 GMT+0000 (Coordinated Universal Time)32.4123136026103932.7991284550479530.41155344086658431.598672866821293209500
Wed Dec 22 2004 00:00:00 GMT+0000 (Coordinated Universal Time)31.47860889525580333.04586910024692531.2785335033138832.3522720336914061837400
Thu Dec 23 2004 00:00:00 GMT+0000 (Coordinated Universal Time)32.4189731602067332.91249240692416632.2122270981997232.345611572265625633500
Mon Dec 27 2004 00:00:00 GMT+0000 (Coordinated Universal Time)32.35228318329047432.6857431328131831.28521236245680431.77873420715332800700
Tue Dec 28 2004 00:00:00 GMT+0000 (Coordinated Universal Time)31.6453458087236532.212226635234831.0117714740894832.078842163085941169600
Wed Dec 29 2004 00:00:00 GMT+0000 (Coordinated Universal Time)32.07884191751621532.1455354251286931.7120365299877231.93878936767578566500

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

Share link

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