Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

like image 861
owner Avatar asked Jun 23 '15 21:06

owner


1 Answers

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

like image 139
josuebrunel Avatar answered Oct 20 '22 17:10

josuebrunel