Search code examples
xmlyahooyahoo-apiyahoo-finance

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

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

Solution

  • 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