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)
- Ftv
- Qcom
- Incy
- Ceg
- Meta
- Aig
- Cme
- Mlm
- Aos
- Enph
- Tyl
- Adi
- Cpt
- Hd
- Elv
- Cmi
- Expd
- Reg
- Dltr
- Gpc
- Fcx
- Alb
- Dxcm
- Whr
- Cboe
- Nvr
- Lw
- Ball
- Intc
- Sbny
- Eqix
- Eix
- Cat
- Exr
- Foxa
- Dri
- Chtr
- Frt
- Ajg
- Azo
- Cag
- Nvda
- It
- Tfc
- Keys
- Awk
- Cdns
- Jci
- Rcl
- Trow
- Unh
- Aon
- Adp
- Tpr
- Xom
- Wmb
- Crm
- Expe
- Kmi
- Hrl
- Bxp
- Dow
- Rhi
- Pm
- So
- Nue
- Frc
- Syk
- Rsg
- Msci
- Iqv
- Pnw
- Pru
- Sna
- Etsy
- Stx
- Pg
- Vz
- Sbux
- Rol
- Bax
- Tfx
- Vtrs
- Pool
- Pld
- Gd
- Amt
- Ppl
- Oke
- El
- Axp
- Crl
- Pcg
- Spgi
- Rl
- Phm
- Ntrs
- Fast
- Well
- Vrsn
- Pkg
- Ben
- Pgr
- Nwsa
- Mpc
- Omc
- Duk
- Hlt
- Csco
- Algn
- Ftnt
- Ups
- Pnr
- Lin
- Mas
- Ulta
- Zbra
- Biib
- Eqr
- Ogn
- Dlr
- Mkc
- Acn
- Dov
- Txn
- Cci
- Mmm
- Rmd
- Vmc
- Uhs
- Emr
- Anss
- Bkr
- Intu
- Dva
- Mchp
- Abbv
- Tsla
- Tmo
- Rop
- Wrk
- Bk
- Gnrc
- Efx
- Sivb
- Orcl
- Lvs
- Czr
- Wy
- Ctsh
- Khc
- Mro
- Re
- Ibm
- Cvs
- Fdx
- Qrvo
- Goog
- Noc
- Dish
- Fds
- Carr
- Amgn
- De
- Kim
- Cl
- Klac
- Swk
- Wba
- Hban
- Rjf
- Flt
- Dpz
- Tdy
- Amzn
- Hon
- Mco
- Hii
- Coo
- Glw
- Ttwo
- Avgo
- Mpwr
- Ms
- Lkq
- Dg
- Cb
- Trv
- Mdlz
- Nke
- Has
- Itw
- Amp
- Bio
- Amcr
- Aph
- Ctva
- Aep
- Bkng
- Uri
- Now
- Alle
- Mo
- All
- Ame
- Mos
- Kdp
- Hpq
- See
- Mnst
- Ppg
- Vno
- Slb
- Ni
- Wtw
- Mdt
- Tap
- Tsn
- Otis
- Ci
- Ma
- Clx
- Cop
- Nem
- Orly
- Afl
- Holx
- Ctra
- Xel
- Zion
- Abc
- Dxc
- Lnc
- Tgt
- Sjm
- Udr
- Iex
- Fitb
- Hsic
- Cday
- Kmx
- Cof
- Ldos
- Peak
- Len
- Kmb
- Key
- Vrtx
- Cnc
- Regn
- Evrg
- Ph
- Aiz
- Pwr
- Cinf
- Mtd
- Amd
- Ste
- Gpn
- Cpb
- Ndsn
- Shw
- Hes
- Jnj
- Wm
- Avb
- A
- Pep
- Trgp
- Fox
- Cprt
- Idxx
- Xyl
- Vlo
- Mtch
- Mmc
- Zts
- Avy
- Dhr
- Ptc
- Xray
- Cah
- Rost
- Csgp
- Ess
- Bby
- Lrcx
- Aal
- Fisv
- Rf
- Ed
- Gww
- Eog
- Cmcsa
- Vfc
- Grmn
- F
- Ea
- Jpm
- Ntap
- Cost
- Dfs
- Bbwi
- Exc
- Alk
- Met
- Amat
- Fbhs
- Aee
- Irm
- Para
- Ba
- Stz
- Jnpr
- Sedg
- Hwm
- Epam
- Wst
- Dvn
- Pfg
- Hpe
- Stt
- Pki
- Hal
- Bsx
- Gs
- Tsco
- Hsy
- Vrsk
- Kr
- Rok
- Ce
- Sre
- Usb
- Aap
- Wab
- Ew
- Adsk
- Tt
- Mck
- Mu
- Atvi
- Tjx
- Payc
- Aptv
- Trmb
- J
- Nsc
- Csx
- Peg
- Cfg
- Are
- Akam
- Wat
- Syy
- Mgm
- Hst
- Lly
- Etn
- Bdx
- Cdw
- Acgl
- Ir
- Gen
- Adm
- Spg
- Jkhy
- Hig
- Ilmn
- Hum
- Tdg
- Fang
- Dis
- Nws
- Wynn
- Ccl
- Zbh
- Ter
- Payx
- Invh
- Cvx
- Dal
- D
- Chrw
- Eqt
- Gl
- Snps
- Aes
- Bro
- Swks
- Wrb
- Lyv
- Cma
- V
- Cbre
- Etr
- Msft
- Dgx
- Vici
- Ice
- Isrg
- Psx
- Lmt
- Br
- Pnc
- Dd
- On
- Dte
- Mrna
- Wfc
- Fis
- Lh
- Wbd
- Bmy
- Apd
- C
- Emn
- Adbe
- Gis
- Lnt
- Pfe
- Odfl
- Maa
- Yum
- Vtr
- Wec
- Nclh
- Cms
- Txt
- Fmc
- Aapl
- Blk
- Jbht
- Ecl
- Nxpi
- Es
- Hca
- Apa
- Oxy
- Lumn
- Mhk
- Mcd
- Mtb
- Ge
- Ip
- Rtx
- Ffiv
- O
- Sbac
- Nee
- Cnp
- Syf
- Fe
- Pypl
- Iff
- Bwa
- Bac
- Luv
- Nrg
- Tel
- Msi
- Pxd
- Ebay
- Pcar
- Dhi
- Ato
- Tech
- Ual
- Gm
- Low
- Tmus
- Anet
- Unp
- Ko
- Mar
- Ivz
- Wmt
- Abt
- Ipg
- Cmg
- L
- Ctlt
- Schw
- Ctas
- Mktx
- Wdc
- Lhx
- Ndaq
- Nflx
- Chd
- Lyb
- Moh
- Abmd
- Gild
- Psa
- Nwl
- K
- T
- Googl
- Cf
Wrk
@kaggle.artemburenok_sp_500_stock_prices.wrk
- 91.92 KB
- 1883 rows
- 7 columns
dateDate | openOpen | highHigh | lowLow | closeClose | adj_closeAdj Close | volumeVolume |
|---|---|---|---|---|---|---|
| Wed Jun 24 2015 00:00:00 GMT+0000 (Coordinated Universal Time) | 57.16731262207031 | 57.16731262207031 | 57.10424423217773 | 57.10424423217773 | 45.1943473815918 | 3663 |
| Thu Jun 25 2015 00:00:00 GMT+0000 (Coordinated Universal Time) | 56.67177200317383 | 56.67177200317383 | 55.770790100097656 | 55.770790100097656 | 44.13901519775391 | 4107 |
| Fri Jun 26 2015 00:00:00 GMT+0000 (Coordinated Universal Time) | 55.770790100097656 | 55.770790100097656 | 55.770790100097656 | 55.770790100097656 | 44.13901519775391 | 111 |
| Mon Jun 29 2015 00:00:00 GMT+0000 (Coordinated Universal Time) | 54.8878288269043 | 54.8878288269043 | 54.77970886230469 | 54.77970886230469 | 43.354618072509766 | 333 |
| Tue Jun 30 2015 00:00:00 GMT+0000 (Coordinated Universal Time) | 55.25722885131836 | 55.32029724121094 | 54.35624694824219 | 54.86980819702149 | 43.42594909667969 | 2015023 |
| Wed Jul 01 2015 00:00:00 GMT+0000 (Coordinated Universal Time) | 54.72565078735352 | 56.22127914428711 | 54.62654113769531 | 56.22127914428711 | 44.49554061889648 | 213545 |
| Thu Jul 02 2015 00:00:00 GMT+0000 (Coordinated Universal Time) | 56.76187133789063 | 58.56383514404297 | 56.22127914428711 | 58.55482482910156 | 46.34238052368164 | 1936776 |
| Mon Jul 06 2015 00:00:00 GMT+0000 (Coordinated Universal Time) | 58.67195129394531 | 59.82521057128906 | 56.75286102294922 | 57.43760681152344 | 45.45819091796875 | 2322244 |
| Tue Jul 07 2015 00:00:00 GMT+0000 (Coordinated Universal Time) | 57.581764221191406 | 57.65384292602539 | 55.44643783569336 | 56.28435134887695 | 44.54546356201172 | 3388636 |
| Wed Jul 08 2015 00:00:00 GMT+0000 (Coordinated Universal Time) | 56.31137847900391 | 57.57275390625 | 53.60843276977539 | 53.797637939453125 | 42.57737731933594 | 4200195 |
CREATE TABLE wrk (
"date" TIMESTAMP,
"open" DOUBLE,
"high" DOUBLE,
"low" DOUBLE,
"close" DOUBLE,
"adj_close" DOUBLE,
"volume" DOUBLE
);