Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Nlsn
@kaggle.rprkh15_sp500_stock_prices.nlsn

  • 148.09 KB
  • 2883 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Thu Jan 27 2011 00:00:00 GMT+0000 (Coordinated Universal Time)19.35396937289750220.09237443120427719.35396937289750219.7426033020019575809300
Fri Jan 28 2011 00:00:00 GMT+0000 (Coordinated Universal Time)19.7426066523483319.7426066523483319.43169975280761719.4316997528076172611900
Mon Jan 31 2011 00:00:00 GMT+0000 (Coordinated Universal Time)19.41615400935293720.5976017084342119.23738272768855520.2633762359619182505300
Tue Feb 01 2011 00:00:00 GMT+0000 (Coordinated Universal Time)20.5587346016492120.6986415650862619.8203295735479620.0146465301513672155300
Wed Feb 02 2011 00:00:00 GMT+0000 (Coordinated Universal Time)20.1934163427488620.46546035921040720.0068722555376820.170099258422851173100
Thu Feb 03 2011 00:00:00 GMT+0000 (Coordinated Universal Time)20.02241796676876420.2711434163836820.01464511115321420.17009925842285668300
Fri Feb 04 2011 00:00:00 GMT+0000 (Coordinated Universal Time)20.24783010873719721.06396237010518720.0146503097869220.271148681640625720200
Mon Feb 07 2011 00:00:00 GMT+0000 (Coordinated Universal Time)20.24783040629432320.3644217900038719.9291506512025720.045742034912111204800
Tue Feb 08 2011 00:00:00 GMT+0000 (Coordinated Universal Time)19.97578430773930320.2555997252011819.9369200257857320.2322826385498053632000
Wed Feb 09 2011 00:00:00 GMT+0000 (Coordinated Universal Time)20.18564511983793620.3644178484141319.8436483402155219.882511138916016873200

CREATE TABLE nlsn (
  "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.