1

Too many instructions executed

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).

2 Replies
  • I'm getting the same issue too. Are you still having problems?
    0
  • Me too! Why doesn&#39;t this work? I have nothing but problems when doing anything with yahoo financial data, the service is unbelievably bad. <br>If it wasn&#39;t so totally pathetic it would be funny!!!!! <br><br><div class="quote"><div class="quotetop">QUOTE<cite>(Mark @ 26 May 2011 4:58 AM)</cite></div><blockquote class="quotemain">I&#39;m getting the same issue too. Are you still having problems?</blockquote></div>
    0
  • Okay, the same issue hit me as well. Seems one year would be fine by the method of trial and error... If you want anything longer, then have to do it programmatically.

    1

Recent Posts

in YQL