title: How to Access Yahoo Finance YQL query with historical data
body: <p>I'm new to YQL. Perhaps this is very trivial, but I couldn't quite figure this out. I know, for instance, how to query current stock data from Yahoo/YQL using the YQL console:</p>
  
  <p><a href="http://developer.yahoo.com/yql/console/" rel="noreferrer">http://developer.yahoo.com/yql/console/</a></p>
  
  <p>with the query string:</p>
  
  <pre><code>select * from yahoo.finance.quotes where symbol in ("YHOO","AAPL","GOOG","MSFT") 
  </code></pre>
  
  <p>However, what if I want, say, the same data from yesterday, or a week ago? I tried things such as</p>
  
  <pre><code>select * from yahoo.finance.quotes where symbol in ("YHOO","AAPL","GOOG","MSFT") and date=20120913
  </code></pre>
  
  <p>But it doesn't appear to work.</p>
  
  <p>Any suggestion is appreciated!</p>