title: Is YQL / datatables.org down as of May 17-18, 2017?
body: <p>During the past 1-2 days, the http query that I used to download historical stock prices from Yahoo Finance has not been working. The link I have been using is the first one below but I have also tried out the other three (since I saw other people using them):</p>
  
  <pre><code>http://real-chart.finance.yahoo.com/table.csv?s=TRQ&amp;d=6&amp;e=3&amp;f=2016&amp;g=d&amp;a=5&amp;b=25&amp;c=2016&amp;ignore=.csv
  https://real-chart.finance.yahoo.com/table.csv?s=TRQ&amp;d=6&amp;e=3&amp;f=2016&amp;g=d&amp;a=5&amp;b=25&amp;c=2016&amp;ignore=.csv
  http://ichart.finance.yahoo.com/table.csv?s=TRQ&amp;d=6&amp;e=3&amp;f=2016&amp;g=d&amp;a=5&amp;b=25&amp;c=2016&amp;ignore=.csv
  https://ichart.finance.yahoo.com/table.csv?s=TRQ&amp;d=6&amp;e=3&amp;f=2016&amp;g=d&amp;a=5&amp;b=25&amp;c=2016&amp;ignore=.csv
  </code></pre>
  
  <p>One interesting thing that I noticed is that the link that the Yahoo website itself provides (to download the data manually) changed. The link used to be the first in the list above (after all, that's where I got it from) but now it is as follows:</p>
  
  <pre><code>https://query1.finance.yahoo.com/v7/finance/download/TRQ?period1=1466805600&amp;period2=1467496800&amp;interval=1d&amp;events=history&amp;crumb=DuX0UxVwtN0
  </code></pre>
  
  <p>Note that all these links should in theory retrieve the same data: stock prices for TRQ (just an example, I have tried e.g. AAPL as well) from 2016/06/25 to 2016/07/03.</p>
  
  <p>This new links works in the browser or within my program, but it is hardly scalable since it requires a session cookie; if you just leave out the last query parameter, you get an error saying you are not authorized. <a href="https://stackoverflow.com/questions/44044263/yahoo-finance-historical-data-downloader-url-is-not-working">This question</a> asks about how to create said session cookie in an automated way; however, I want to ask about avoiding this problem entirely by trying to directly access the YQL database.</p>
  
  <p>I tried using the following link to directly use the YQL API (converting the spaces to %20 etc., that's not the problem):</p>
  
  <pre><code>https://query.yahooapis.com/v1/public/yql?q=
    select * from yahoo.finance.historicaldata where symbol = "TRQ" 
    and startDate = "2016-06-25" 
    and endDate = "2016-07-03"
   &amp;format=json
   &amp;diagnostics=true
   &amp;env=store://datatables.org/alltableswithkeys
   &amp;callback=
  </code></pre>
  
  <p>This link returns a "connection refused" error. As <a href="https://stackoverflow.com/questions/36027014/yql-request-returning-connection-refused">this question</a> suggests, this might be because the datatables.org site is down (the question in the link refers to a downtime incident about a year ago). Does anybody have more information on this?</p>
  
  <p>Thanks.</p>