Does anyone know of a publicly available dataset for S&P500 index published daily in json format?

Took a look at quandl but nothing for free. Google searches bring back a whole host of unhelpful sponsored ads, old data or monthly publications.

  • $\begingroup$ Why not just pull it down in csv and parse into JSON? $\endgroup$ – Kch Jan 1 '18 at 21:10
  • $\begingroup$ Trying to keep things efficient - think thats gonna be the way forward. Or the S&P ETF prices in Json.. $\endgroup$ – DVCITIS Jan 1 '18 at 21:12

try the Bloomberg API: https://www.bloomberg.com/markets/chart/data/1D/SPX:IND

I hope it's what you're looking for.

| improve this answer | |
  • 1
    $\begingroup$ This looks close! I'm looking for the last year of close values though. How did you navigate to the API - I find the SPX:IND quote at the below link and don't see the option? bloomberg.com/quote/SPX:IND $\endgroup$ – DVCITIS Jan 2 '18 at 20:59
  • $\begingroup$ You can find the logic behind this explained here: github.com/matthewfieger/bloomberg_stock_data $\endgroup$ – DataAdventurer Jan 7 '18 at 19:30
  • $\begingroup$ Sadly it appears Bloomberg blocks traffic to this endpoint from AWS ip addresses. I have not found a good alternative for scripts running there. $\endgroup$ – Michael Graczyk Apr 23 '19 at 3:34

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.