Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Wab
@kaggle.rprkh15_sp500_stock_prices.wab

  • 329.37 KB
  • 6815 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Fri Jun 16 1995 00:00:00 GMT+0000 (Coordinated Universal Time)6.9044823646545417.3647811889648446.84694501161575356.9044823646545416212400
Mon Jun 19 1995 00:00:00 GMT+0000 (Coordinated Universal Time)6.9620156412539277.0195529606031336.5017170864602796.6167917251586911528200
Tue Jun 20 1995 00:00:00 GMT+0000 (Coordinated Universal Time)6.6743290445078976.7318663638571036.6167917251586916.616791725158691863000
Wed Jun 21 1995 00:00:00 GMT+0000 (Coordinated Universal Time)6.6743300277574936.6743300277574936.444180716455516.501718044281006629000
Thu Jun 22 1995 00:00:00 GMT+0000 (Coordinated Universal Time)6.5017184640607256.9620171163836096.4441811325203666.731867790222168546200
Fri Jun 23 1995 00:00:00 GMT+0000 (Coordinated Universal Time)6.7894051217625286.8469424533028886.6743304586818076.731867790222168365000
Mon Jun 26 1995 00:00:00 GMT+0000 (Coordinated Universal Time)6.7318673555829886.7894046834084846.444180716455516.501718044281006515400
Tue Jun 27 1995 00:00:00 GMT+0000 (Coordinated Universal Time)6.5592551401683256.5592551401683256.4441804885864256.444180488586426270800
Wed Jun 28 1995 00:00:00 GMT+0000 (Coordinated Universal Time)6.5017178143773766.5017178143773766.4441804885864256.444180488586426500400
Thu Jun 29 1995 00:00:00 GMT+0000 (Coordinated Universal Time)6.4441804885864256.5592551401683256.4441804885864256.444180488586426309200

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