I think you can solve your problem by including the following prior to your select statement: "use 'http://www.datatables.org/yahoo/finance/yahoo.finance.quotes.xml';"
Therefore, your entire YQL statement should look like the following: "use 'http://www.datatables.org/yahoo/finance/yahoo.finance.quotes.xml'; select * from yahoo.finance.quotes where symbol in ('YHOO', 'GOOG', 'GE')"
Maybe someone can help me out with an issue I've ran into in the last few days...
I'm having some issues with the options table where the query is returning no value after a number of passes. If I attempt to restart the script it kicks out immediately. I was reading somewhere that Yahoo limits queries to 1,000/hr... This was not a problem when I ran the script a few days ago. Not to mention it looks like my script only made it through less than 600 queries before it started returning no value.
How do I modify my python code to allow for up to 10,000 calls per hour? Can I make a call to yahoo.finance.options over the "/v1/yql/" as defined below by signing up for an access key and modifying my code or is yahoo.finance.options limited to being viewed via the "/v1/public/"?
Per yahoo... Usage Limits: - Per application limit (identified by your Access Key): 100,000 calls per day - Per IP limits: /v1/public/*: 1,000 calls per hour; /v1/yql/*: 10,000 calls per hour