Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Abc
@kaggle.rprkh15_sp500_stock_prices.abc

  • 339.54 KB
  • 6866 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Tue Apr 04 1995 00:00:00 GMT+0000 (Coordinated Universal Time)2.27766324098778752.3018937009982962.1807414009457542.28977847099304240387200
Wed Apr 05 1995 00:00:00 GMT+0000 (Coordinated Universal Time)2.25343270878215442.3018936272505882.20497179031372072.204971790313720712236800
Thu Apr 06 1995 00:00:00 GMT+0000 (Coordinated Universal Time)2.2049713521390352.27766271539636562.2049713521390352.24131703376773776000
Fri Apr 07 1995 00:00:00 GMT+0000 (Coordinated Universal Time)2.25343270878215442.25343270878215442.20497179031372072.20497179031372071920800
Mon Apr 10 1995 00:00:00 GMT+0000 (Coordinated Universal Time)2.20497157521869852.25343248895976882.20497157521869852.22920203208923342047200
Tue Apr 11 1995 00:00:00 GMT+0000 (Coordinated Universal Time)2.20497108938915482.2534319924526532.20497108938915482.21708631515502934096800
Wed Apr 12 1995 00:00:00 GMT+0000 (Coordinated Universal Time)2.20497108938915482.2292015409209042.20497108938915482.21708631515502932457600
Thu Apr 13 1995 00:00:00 GMT+0000 (Coordinated Universal Time)2.20497157521869852.22920203208923342.20497157521869852.22920203208923342297600
Mon Apr 17 1995 00:00:00 GMT+0000 (Coordinated Universal Time)2.20497186095626232.2897784709930422.20497186095626232.2897784709930422233600
Tue Apr 18 1995 00:00:00 GMT+0000 (Coordinated Universal Time)2.24131730642724542.28977822116080752.2292020777438552.2776629924774172441600

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