Getting a stock's price history

Question

Are there any simple HTTP APIs out there which will let me get the stock price for a symbol (such as GOOG) at a specific date and time?

Something like...

http://somewebsite.com/?
    symbol=GOOG&
    year=2010&
    month=7&
    day=30&
    hour=4&
    minute=00

Giving a response of $484.85

I'm hoping to have an end result of a haskell function whose type signature looks something like...

getQuote :: Symbol -> Date -> Time -> Price

score 11 · Accepted Answer · answered Jul 31 '10 at 22:09

11

I believe YQL with Yahoo finance can complete this task, they have data going back to 1996 looking on some stocks.

http://www.yqlblog.net/blog/2009/06/02/getting-stock-information-with-yql-and-open-data-tables/

http://www.gummy-stuff.org/Yahoo-data.htm

answered Jul 31 '10 at 22:09

Anders

6,188
4
26
31

That article uses XML. If you want JSON, just add `&format=json` to the end of the request. – Timo Ernst Sep 28 '15 at 15:13

Timo Ernst · Answer 2 · 2015-09-28T15:09:20.223

Here is an example on how to get the data in JSON-format from 2014-01-01 to 2015-01-01 for Apple stock (AAPL) via Yahoo Finance API using YQL.

The YQL query is URL-encoded:

select%20*%20from%20yahoo.finance.historicaldata%20where%20symbol%3D%22AAPL%22%20and%20startDate%3D%222014-01-01%22%20and%20endDate%3D%222015-01-01%22

So, if you decode it, you'll get:

select * from yahoo.finance.historicaldata where symbol="AAPL" and startDate="2014-01-01" and endDate="2015-01-01"

Just change the date values to ones you want and decode the whole thing back, for example using this URL-encoder: http://meyerweb.com/eric/tools/dencoder/

Then, put the whole thing together by adding the encoded query into the request URL:

http://query.yahooapis.com/v1/public/yql?q={ENTER_QUERY_HERE}&env=http://datatables.org/alltables.env&format=json

So, you end up with something like this:

http://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20yahoo.finance.historicaldata%20where%20symbol%3D%22AAPL%22%20and%20startDate%3D%222014-01-01%22%20and%20endDate%3D%222015-01-01%22&env=http://datatables.org/alltables.env&format=json

Which will return you some fine JSON-formated data for the time period you've set.

score 0 · Answer 3 · answered Feb 05 '13 at 17:19

0

You can find historic intraday data at http://www.myinvestorshub.com/historic_intraday_data.php ( for all countries)

answered Feb 05 '13 at 17:19

user2043582

1

score 0 · Answer 4 · answered Oct 19 '10 at 06:25

0

Take a look at the Historical Securities Data API at http://www.mergent.com/servius - I don't think they'll have intraday data though...

answered Oct 19 '10 at 06:25

Eugene Osovetsky

6,443
2
38
59

Getting a stock's price history

4 Answers4