S&P 500 Stock Prices

All companies which included in S&P 500 index

@kaggle.artemburenok_sp_500_stock_prices

Table List

500 tables(151.9 MB)

results for

Ftv

Qcom

Incy

Ceg

Frc

@kaggle.artemburenok_sp_500_stock_prices.frc

145.92 KB
3024 rows
7 columns

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume
Thu Dec 09 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	27.25	28.11000061035156	26.989999771118164	27.920000076293945	25.63092041015625	10609700
Fri Dec 10 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	27.399999618530277	27.71999931335449	27.059999465942383	27.40999984741211	25.16273307800293	1206800
Mon Dec 13 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	27.5	27.71999931335449	27	27.399999618530277	25.15355110168457	473200
Tue Dec 14 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	27.700000762939453	27.96999931335449	27.020000457763672	27.309999465942383	25.070932388305664	358200
Wed Dec 15 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	27.200000762939453	27.700000762939453	27.190000534057617	27.450000762939453	25.199451446533203	242200
Thu Dec 16 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	27.600000381469727	27.649999618530277	27.209999084472656	27.649999618530277	25.383054733276367	260000
Fri Dec 17 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	27.549999237060547	28.059999465942383	27.5	28.059999465942383	25.75943756103516	69800
Mon Dec 20 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	28.100000381469727	28.420000076293945	27.84000015258789	28.13999938964844	25.832883834838867	65900
Tue Dec 21 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	28.170000076293945	29.040000915527344	28.01000022888184	28.90999984741211	26.53974723815918	210200
Wed Dec 22 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	29	30.520000457763672	28.959999084472656	29.450000762939453	27.035478591918945	103000


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