Baselight

S&P 500 Stock Prices

All companies which included in S&P 500 index

@kaggle.artemburenok_sp_500_stock_prices

Wat
@kaggle.artemburenok_sp_500_stock_prices.wat

  • 297.68 KB
  • 6815 rows
  • 7 columns
date

Date

open

Open

high

High

low

Low

close

Close

adj_close

Adj Close

volume

Volume

Fri Nov 17 1995 00:00:00 GMT+0000 (Coordinated Universal Time)3.753.81253.753.781253.7812512706000
Mon Nov 20 1995 00:00:00 GMT+0000 (Coordinated Universal Time)3.753.781253.753.753.751213200
Tue Nov 21 1995 00:00:00 GMT+0000 (Coordinated Universal Time)3.753.781253.753.753.75909600
Wed Nov 22 1995 00:00:00 GMT+0000 (Coordinated Universal Time)3.753.781253.753.753.751314800
Fri Nov 24 1995 00:00:00 GMT+0000 (Coordinated Universal Time)3.753.781253.753.753.75275200
Mon Nov 27 1995 00:00:00 GMT+0000 (Coordinated Universal Time)3.753.781253.753.753.751011600
Tue Nov 28 1995 00:00:00 GMT+0000 (Coordinated Universal Time)3.6253.6253.31253.531253.531253952000
Wed Nov 29 1995 00:00:00 GMT+0000 (Coordinated Universal Time)3.53.56253.343753.43753.4375708400
Thu Nov 30 1995 00:00:00 GMT+0000 (Coordinated Universal Time)3.43753.753.406253.68753.68751346000
Fri Dec 01 1995 00:00:00 GMT+0000 (Coordinated Universal Time)3.68753.68753.531253.56253.5625790800

CREATE TABLE wat (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "adj_close" DOUBLE,
  "volume" DOUBLE
);