I'm trying to get all of AAPL's stock prices going back to 2006 from yahoo.finance.historicaldata .
CODE
select * from yahoo.finance.historicaldata where symbol = 'AAPL' and startDate = '2006-01-01' and endDate='2011-04-01'
When I run the query in the
YQL console I get the error "Too many instructions executed: 50028454." That's reasonable, but is there any documentation on how many instructions is too many, and ultimately, how many rows I can reliably retrieve from the yahoo.finance.historicaldata table?
CODE
cbfunc({
"query": {
"count": 0,
"created": "2011-05-25T12:34:35Z",
"lang": "en-US",
"diagnostics": {
"publiclyCallable": "true",
"redirect": {
"from": "http://datatables.org/alltables.env",
"status": "301",
"content": "http://www.datatables.org/alltables.env"
},
"url": [
{
"execution-time": "3",
"proxy": "DEFAULT",
"content": "http://datatables.org/alltables.env"
},
{
"execution-time": "1",
"proxy": "DEFAULT",
"content": "http://www.datatables.org/yahoo/finance/yahoo.finance.historicaldata.xml"
},
{
"execution-time": "158",
"proxy": "DEFAULT",
"content": "http://ichart.finance.yahoo.com/table.csv?g=d&f=2011&e=1&c=2006&b=1&a=0&d=3&s=AAPL"
},
{
"execution-time": "167",
"content": "select * from csv(0,1) where url=@url"
},
{
"execution-time": "3",
"proxy": "DEFAULT",
"content": "http://ichart.finance.yahoo.com/table.csv?g=d&f=2011&e=1&c=2006&b=1&a=0&d=3&s=AAPL"
},
{
"execution-time": "11",
"content": "select * from csv(2,0) where url=@url and columns=@columnsNames"
}
],
"warning": "Too many instructions executed: 50028454",
"javascript": [
{
"execution-time": "4189",
"instructions-used": "50028454",
"table-name": "yahoo.finance.historicaldata"
},
{
"name": "yahoo.finance.historicaldata",
"verb": "select",
"content": "Too many instructions executed: 50028454"
}
],
"user-time": "4208",
"service-time": "165",
"build-version": "17991"
},
"results": null
}
I've also been intermittently running into other problems with the yahoo.finance.historicaldata table that may be related to
this thread. Since I've only starting messing with YQL last week, I'm not sure if I'm experiencing a global problem or hitting some undocumented rate limit (I definitely haven't gotten anywhere near 1000 queries / hour).
