Yahoo YQL get data using sql query for different s

问题:

hot to get nasdaq, Dow Jones,S&P 500, Nikkei 300 from yahoo apl.

select * from yahoo.finance.quotes where symbol in ("^IXIC") not work.

回答1:

You have to use different tables for stock exchange...

You can use any of the 2 options below,

select * from yahoo.finance.quoteslist where symbol= '^IXIC'

OR

select * from yahoo.finance.quoteslist where symbol in ('^GSPC','^IXIC')