Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Amt
@kaggle.rprkh15_sp500_stock_prices.amt

  • 306.57 KB
  • 6133 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Fri Feb 27 1998 00:00:00 GMT+0000 (Coordinated Universal Time)14.26610565185546914.77927491990782414.26610565185546914.26610565185546950000
Mon Mar 02 1998 00:00:00 GMT+0000 (Coordinated Universal Time)14.16347694396972814.16347694396972813.95820916217306414.16347694396972875000
Tue Mar 03 1998 00:00:00 GMT+0000 (Coordinated Universal Time)14.0608386993408214.0608386993408213.75293712198299214.0608386993408235000
Wed Mar 04 1998 00:00:00 GMT+0000 (Coordinated Universal Time)12.93186664581298812.93186664581298812.72659892127627412.93186664581298860000
Thu Mar 05 1998 00:00:00 GMT+0000 (Coordinated Universal Time)13.2397670745849613.2397670745849613.2397670745849613.23976707458496400
Fri Mar 06 1998 00:00:00 GMT+0000 (Coordinated Universal Time)13.2397670745849613.44503478116767213.2397670745849613.239767074584963600
Mon Mar 09 1998 00:00:00 GMT+0000 (Coordinated Universal Time)13.23976784052811213.54766941821481113.03450012207031213.0345001220703123200
Tue Mar 10 1998 00:00:00 GMT+0000 (Coordinated Universal Time)13.03449899966900513.85556980279775813.03449899966900513.34240055084228356800
Wed Mar 11 1998 00:00:00 GMT+0000 (Coordinated Universal Time)13.34240055084228313.54766825162447413.23976670045119213.34240055084228310400
Thu Mar 12 1998 00:00:00 GMT+0000 (Coordinated Universal Time)13.34240017956449813.44503402709961113.23976633202938813.445034027099613800

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