Baselight
Sign In

S&P 500 Stock Prices

All companies which included in S&P 500 index

@kaggle.artemburenok_sp_500_stock_prices

Dal
@kaggle.artemburenok_sp_500_stock_prices.dal

  • 171.34 KB
  • 3933 rows
  • 7 columns
date

Date

open

Open

high

High

low

Low

close

Close

adj_close

Adj Close

volume

Volume

Thu May 03 2007 00:00:00 GMT+0000 (Coordinated Universal Time)21.7521.95000076293945320.54999923706054720.7199993133544918.404478073120128052800
Fri May 04 2007 00:00:00 GMT+0000 (Coordinated Universal Time)21.2521.35000038146972720.70000076293945320.97999954223632818.635419845581055437300
Mon May 07 2007 00:00:00 GMT+0000 (Coordinated Universal Time)21.20000076293945321.29000091552734420.20000076293945320.3600006103515618.0847053527832032646300
Tue May 08 2007 00:00:00 GMT+0000 (Coordinated Universal Time)202019.29999923706054719.629999160766617.4362792968754166100
Wed May 09 2007 00:00:00 GMT+0000 (Coordinated Universal Time)19.7520.20000076293945319.629999160766619.79000091552734417.5784130096435557541100
Thu May 10 2007 00:00:00 GMT+0000 (Coordinated Universal Time)19.79000091552734419.98999977111816419.54999923706054719.70000076293945317.498460769653323170600
Fri May 11 2007 00:00:00 GMT+0000 (Coordinated Universal Time)19.70999908447265619.79999923706054719.1100006103515619.29999923706054717.143161773681643539400
Mon May 14 2007 00:00:00 GMT+0000 (Coordinated Universal Time)19.14999961853027719.3899993896484418.7518.8899993896484416.7789802551269531924800
Tue May 15 2007 00:00:00 GMT+0000 (Coordinated Universal Time)18.64999961853027718.85000038146972718.14999961853027718.20000076293945316.1660881042480473438700
Wed May 16 2007 00:00:00 GMT+0000 (Coordinated Universal Time)18.05999946594238318.47999954223632818.02000045776367218.3400001525878916.2904510498046882607600

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