Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Lw
@kaggle.rprkh15_sp500_stock_prices.lw

  • 75.94 KB
  • 1425 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Thu Nov 10 2016 00:00:00 GMT+0000 (Coordinated Universal Time)29.7293815460400930.01702310142182727.6694795036848728.142700195312535019100
Fri Nov 11 2016 00:00:00 GMT+0000 (Coordinated Universal Time)27.6509187758043227.9200057545107826.76943079373818427.734428405761726020100
Mon Nov 14 2016 00:00:00 GMT+0000 (Coordinated Universal Time)27.2240934152895328.2354862517723626.6766421819714228.0127944946289034481900
Tue Nov 15 2016 00:00:00 GMT+0000 (Coordinated Universal Time)27.50245838273411228.4860158812122827.4839020631716828.235486984252933667200
Wed Nov 16 2016 00:00:00 GMT+0000 (Coordinated Universal Time)28.55096679945918229.7293789010345628.40250562742728529.4138984680175754342300
Thu Nov 17 2016 00:00:00 GMT+0000 (Coordinated Universal Time)29.13553609329821430.68046091136950428.42570591497872530.165485382080085252000
Fri Nov 18 2016 00:00:00 GMT+0000 (Coordinated Universal Time)29.8221615872461330.71292849342014429.4974039254930130.3232192993164064253400
Mon Nov 21 2016 00:00:00 GMT+0000 (Coordinated Universal Time)29.93351150055565330.1562050336096629.03346717263004729.451013565063485036700
Tue Nov 22 2016 00:00:00 GMT+0000 (Coordinated Universal Time)29.24687730884121730.75932783422514728.2354845338926930.3417797088623055601700
Wed Nov 23 2016 00:00:00 GMT+0000 (Coordinated Universal Time)30.34178573089998631.0562563228590830.1562083561739630.6387081146240233619500

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