Baselight

S&P 500 Stock Prices

All companies which included in S&P 500 index

@kaggle.artemburenok_sp_500_stock_prices

Expe
@kaggle.artemburenok_sp_500_stock_prices.expe

  • 204.21 KB
  • 4381 rows
  • 7 columns
date

Date

open

Open

high

High

low

Low

close

Close

adj_close

Adj Close

volume

Volume

Thu Jul 21 2005 00:00:00 GMT+0000 (Coordinated Universal Time)48.22000122070312549.2000007629394547.8400001525878948.04000091552734431.64081573486328109200
Fri Jul 22 2005 00:00:00 GMT+0000 (Coordinated Universal Time)49.240001678466849.7999992370605547.90000152587890649.72000122070312532.74733734130859456800
Mon Jul 25 2005 00:00:00 GMT+0000 (Coordinated Universal Time)49.7999992370605549.7999992370605548.2999992370605548.4799995422363331.93062782287597739600
Tue Jul 26 2005 00:00:00 GMT+0000 (Coordinated Universal Time)48.7000007629394548.7000007629394547.54831.614484786987305102450
Wed Jul 27 2005 00:00:00 GMT+0000 (Coordinated Universal Time)4848.240001678466847.2999992370605548.1399993896484431.7066993713378998100
Thu Jul 28 2005 00:00:00 GMT+0000 (Coordinated Universal Time)48.2000007629394548.240001678466847.8199996948242248.0999984741210931.6803512573242293600
Fri Jul 29 2005 00:00:00 GMT+0000 (Coordinated Universal Time)48.2000007629394548.7000007629394547.7000007629394548.6800003051757832.06235504150390660700
Mon Aug 01 2005 00:00:00 GMT+0000 (Coordinated Universal Time)48.4599990844726564948.2000007629394548.7000007629394532.07554244995117164950
Tue Aug 02 2005 00:00:00 GMT+0000 (Coordinated Universal Time)525247.2799987792968848.0999984741210931.68035125732422299700
Wed Aug 03 2005 00:00:00 GMT+0000 (Coordinated Universal Time)48.54000091552734448.54000091552734447.5200004577636747.7000007629394531.41689109802246147750

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