Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Chrw
@kaggle.rprkh15_sp500_stock_prices.chrw

  • 314.11 KB
  • 6224 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Thu Oct 16 1997 00:00:00 GMT+0000 (Coordinated Universal Time)3.78834364964411833.78834364964411833.6254041378314683.7068738937377937436400
Fri Oct 17 1997 00:00:00 GMT+0000 (Coordinated Universal Time)3.6865066216644633.7476089413605593.52356710247487343.64577174186706543390400
Mon Oct 20 1997 00:00:00 GMT+0000 (Coordinated Universal Time)3.58466953342243773.6661392955456753.5643020928916283.6050369739532473068000
Tue Oct 21 1997 00:00:00 GMT+0000 (Coordinated Universal Time)3.6254043019683673.70687406156316173.5846694221709693.64577174186706542382400
Wed Oct 22 1997 00:00:00 GMT+0000 (Coordinated Universal Time)3.7068754988289923.74761039442051923.6457731554417013.7272429466247561525200
Thu Oct 23 1997 00:00:00 GMT+0000 (Coordinated Universal Time)3.70687406156316173.70687406156316173.6050368620696683.64577174186706541622400
Fri Oct 24 1997 00:00:00 GMT+0000 (Coordinated Universal Time)3.6865080510332283.7272429466247563.6254057076459373.727242946624756813600
Mon Oct 27 1997 00:00:00 GMT+0000 (Coordinated Universal Time)3.6865080619064463.7476104054739573.5032010312039163.5337522029876711507200
Tue Oct 28 1997 00:00:00 GMT+0000 (Coordinated Universal Time)3.421729902981383.70687406156316173.2180555039943933.64577174186706542955600
Wed Oct 29 1997 00:00:00 GMT+0000 (Coordinated Universal Time)3.7068751477404853.72724259360719133.6457728101403683.68650770187377931859200

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