Hi John,

YQL has rate limits on what type of Javascript instructions are executed as well as the duration. You can read more about these limits here: http://developer.yahoo.com/yql/guide/yql-execute-intro-ratelimits.html

To retrieve the full set of data, I would break up your query into smaller ranges. For example, instead of retrieving historical data from 9/11/2007 to 3/10/2010, I'd run queries for 2007-2008, 2008-2009, and 2009-2010. The following query which uses the range 9/11/2007 - 9/11/2008 should work for you:

select * from yahoo.finance.historicaldata where symbol = "YHOO" and startDate = "2007-09-11" and endDate = "2008-09-11"

Best,
Daniel

Daniel,

Now the table is unavailable.  The query you suggested produces the following error:

Error Codes: js.blocked.execute.request Message: 
"The current table 'yahoo.finance.historicaldata' has been blocked. It exceeded the allotted quotas of either time or instructions"

Here is the complete result XML.

<?xml version="1.0" encoding="UTF-8"?>
<query xmlns:yahoo="http://www.yahooapis.com/v1/base.rng"
 yahoo:count="0" yahoo:created="2012-09-27T19:52:05Z" yahoo:lang="en-US">
 <diagnostics>
  <publiclyCallable>true</publiclyCallable>
  <url execution-start-time="18" execution-stop-time="21"
   execution-time="3" proxy="DEFAULT"><![CDATA[http://www.datatables.org/yahoo/finance/yahoo.finance.historicaldata.xml]]></url>
  <cache execution-start-time="23" execution-stop-time="23"
   execution-time="0" method="GET" type="MEMCACHED"><![CDATA[15ff8982201f9901b491bc0b4de2c50d]]></cache>
  <javascript name="yahoo.finance.historicaldata" verb="select"><![CDATA[com.yahoo.platforms.pipes.model.ModuleException: Error Codes: js.blocked.execute.request Message: "The current table 'yahoo.finance.historicaldata' has been blocked. It exceeded the allotted quotas of either time or instructions"]]></javascript>
  <user-time>24</user-time>
  <service-time>3</service-time>
  <build-version>30549</build-version>
 </diagnostics> 
 <results/>
</query>
 

It certainly seems to me that these data sources and the YQL engine is not robust enough for my application. 
I will see if I can find another source for my data.

thanks for your help

JL