YQL Console - No definition found for Table yahoo.finance.quotes

xml yahoo yahoo-api yahoo-finance
owner picture owner · Jun 23, 2015 · Viewed 8.2k times · Source

I am currently learning how to query data via YQL, and wondering whether the tables : yahoo.finance.quotes && yahoo.finance.historicaldata nowadays work.

As a matter of fact, simple queries raised in https://stackoverflow.com/questions/12417624/:

select * from yahoo.finance.quotes where symbol in ("YHOO","AAPL","GOOG","MSFT") 

select * from yahoo.finance.historicaldata where symbol in ("YHOO","AAPL","GOOG","MSFT") and startDate = "2012-09-13" and endDate = "2012-09-13"

return:

<description>No definition found for Table yahoo.finance.quotes</description>

However, I can see those tables available in DATATABLES --> Show Community Tables

Thanks

Answer

josuebrunel picture josuebrunel · Jun 24, 2015

What you need to do, it to import community table. You can do something like this 

env 'store://datatables.org/alltableswithkeys'; select * from yahoo.finance.quotes where symbol in ("YHOO","AAPL","GOOG","MSFT")

In the yql console, those tables only appear when you check Show Community Table

Hope it will help

Related questions

How do I comment out a block of tags in XML?

How do I comment out a block of tags in XML? I.e. How can I comment out <staticText> and everything inside it, in the code below? <detail> <band height="20"> <staticText> <…

Read More
Text editor to open big (giant, huge, large) text files

I mean 100+ MB big; such text files can push the envelope of editors. I need to look through a large XML file, but cannot if the editor is buggy. Any suggestions?

Read More
How do I parse XML in Python?

I have many rows in a database that contains XML and I'm trying to write a Python script to count instances of a particular node attribute. My tree looks like: <foo> <bar> <type foobar="1"/> &…

Read More