title: Getting stock's historical data
body: <p>We would like to check on stock's historical data, using HTTP request, and get JSON. </p>
  
  <p>Using the yahoo API ,I found it hard to not only clearly understand the HTTP request fields, but also <strong>to get the data of a certain day</strong> (not average for each day, but the values during a certain day), with this :</p>
  
  <p><code>http://query.yahooapis.com/v1/public/yql?q=select%20*%20from%20yahoo.finance.historicaldata%20where%20symbol%20%3D%20%22AAPL%22%20and%20startDate%20%3D%20%222012-09-11%22%20and%20endDate%20%3D%20%222014-02-11%22&amp;format=json&amp;diagnostics=true&amp;env=store%3A%2F%2Fdatatables.org%2Falltableswithkeys&amp;callback=</code></p>
  
  <p><strong>1.</strong> There is no explanation anywhere of how to set each field (also not at Yahoo console).</p>
  
  <p><strong>2.</strong> You can't set a certain day, and get its values .</p>
  
  <p>Is there a stable solution other than Yahoo which is now free? 
  Or, can someone help me understand what all these junk signs in the request?</p>