I'm trying to get all of AAPL's stock prices going back to 2006 from yahoo.finance.historicaldata .
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?
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).
Me too! Why doesn't this work? I have nothing but problems when doing anything with yahoo financial data, the service is unbelievably bad. <br>If it wasn'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'm getting the same issue too. Are you still having problems?</blockquote></div>