Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Irm
@kaggle.rprkh15_sp500_stock_prices.irm

  • 321.96 KB
  • 6656 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Thu Feb 01 1996 00:00:00 GMT+0000 (Coordinated Universal Time)1.34077907057821771.34077907057821771.3201518013852831.330465435981750513718164
Fri Feb 02 1996 00:00:00 GMT+0000 (Coordinated Universal Time)1.33046543152390481.34077906608581521.32015179696199471.34077906608581543828860
Mon Feb 05 1996 00:00:00 GMT+0000 (Coordinated Universal Time)1.34077883299696231.34077883299696231.32015156745910641.3201515674591064908190
Tue Feb 06 1996 00:00:00 GMT+0000 (Coordinated Universal Time)1.32015156745910641.34077883299696231.32015156745910641.3201515674591064509419
Wed Feb 07 1996 00:00:00 GMT+0000 (Coordinated Universal Time)1.32015156745910641.34077883299696231.32015156745910641.3201515674591064366453
Thu Feb 08 1996 00:00:00 GMT+0000 (Coordinated Universal Time)1.32015156745910641.34077883299696231.32015156745910641.3201515674591064794803
Fri Feb 09 1996 00:00:00 GMT+0000 (Coordinated Universal Time)1.32015156745910641.34077883299696231.32015156745910641.3201515674591064515992
Mon Feb 12 1996 00:00:00 GMT+0000 (Coordinated Universal Time)1.32015156745910641.34077883299696231.32015156745910641.3201515674591064351664
Tue Feb 13 1996 00:00:00 GMT+0000 (Coordinated Universal Time)1.32015156745910641.34077883299696231.32015156745910641.3201515674591064216914
Wed Feb 14 1996 00:00:00 GMT+0000 (Coordinated Universal Time)1.32015156745910641.34077883299696231.32015156745910641.3201515674591064460121

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