Ответ 1
Ад-гипотеза в 2: "Вы не можете установить определенный день и получить его значения"... ну, ВЫ МОЖЕТЕ:
В <URL> per-se содержатся теги выбора данных, которые включают:
http://query.yahooapis.com/v1/public/yql?q=
select * from yahoo.finance.historicaldata
where symbol = "AAPL"
and startDate = "2012-09-11"
and endDate = "2014-02-11"
&format=json
&diagnostics=true
&env=store://datatables.org/alltableswithkeys
&callback=
чтобы получить только последние несколько (пара, обратите внимание на интерпретацию результатов endDate в результатах) между 2014-08-10.. 2014-08-12 на "AAPL":
"results":{
"quote":[
{
"Symbol":"AAPL",
"Date":"2014-08-12",
"Open":"96.04",
"High":"96.88",
"Low":"95.61",
"Close":"95.97",
"Volume":"33795000",
"Adj_Close":"95.97"
},
{
"Symbol":"AAPL",
"Date":"2014-08-11",
"Open":"95.27",
"High":"96.08",
"Low":"94.84",
"Close":"95.99",
"Volume":"36585000",
"Adj_Close":"95.99"
}
]
}
(полный Y! отклик)
{
"query":{
"count":2,
"created":"2014-08-14T21:32:41Z",
"lang":"en-EN",
"diagnostics":{
"url":[
{
"execution-start-time":"0",
"execution-stop-time":"1",
"execution-time":"1",
"content":"http://www.datatables.org/yahoo/finance/yahoo.finance.historicaldata.xml"
},
{
"execution-start-time":"5",
"execution-stop-time":"16",
"execution-time":"11",
"content":"http://ichart.finance.yahoo.com/table.csv?g=d&f=2014&e=12&c=2014&b=10&a=7&d=7&s=AAPL"
},
{
"execution-start-time":"18",
"execution-stop-time":"28",
"execution-time":"10",
"content":"http://ichart.finance.yahoo.com/table.csv?g=d&f=2014&e=12&c=2014&b=10&a=7&d=7&s=AAPL"
}
],
"publiclyCallable":"true",
"cache":[
{
"execution-start-time":"4",
"execution-stop-time":"4",
"execution-time":"0",
"method":"GET",
"type":"MEMCACHED",
"content":"91a0664b4e7cf29d40cce123239fec85"
},
{
"execution-start-time":"17",
"execution-stop-time":"18",
"execution-time":"1",
"method":"GET",
"type":"MEMCACHED",
"content":"31dd9633be8581af77baa442f314c921"
}
],
"query":[
{
"execution-start-time":"5",
"execution-stop-time":"17",
"execution-time":"12",
"params":"{url=[http://ichart.finance.yahoo.com/table.csv?g=d&f=2014&e=12&c=2014&b=10&a=7&d=7&s=AAPL]}",
"content":"select * from csv(0,1) where [email protected]"
},
{
"execution-start-time":"18",
"execution-stop-time":"28",
"execution-time":"10",
"params":"{columnsNames=[Date,Open,High,Low,Close,Volume,Adj_Close], url=[http://ichart.finance.yahoo.com/table.csv?g=d&f=2014&e=12&c=2014&b=10&a=7&d=7&s=AAPL]}",
"content":"select * from csv(2,0) where [email protected] and [email protected]"
}
],
"javascript":{
"execution-start-time":"3",
"execution-stop-time":"29",
"execution-time":"25",
"instructions-used":"34359",
"table-name":"yahoo.finance.historicaldata"
},
"user-time":"31",
"service-time":"23",
"build-version":"0.2.2666"
},
"results":{
"quote":[
{
"Symbol":"AAPL",
"Date":"2014-08-12",
"Open":"96.04",
"High":"96.88",
"Low":"95.61",
"Close":"95.97",
"Volume":"33795000",
"Adj_Close":"95.97"
},
{
"Symbol":"AAPL",
"Date":"2014-08-11",
"Open":"95.27",
"High":"96.08",
"Low":"94.84",
"Close":"95.99",
"Volume":"36585000",
"Adj_Close":"95.99"
}
]
}
}
}
Nota Bene:
Можно обнаружить, что полностью обработанная обработка запросов повторно обертывает запрос источника данных, полученный из источника и после обработки:
http://ichart.finance.yahoo.com/table.csv?g=d&f=2014&e=12&c=2014&b=10&a=7&d=7&s=AAPL
получая:
Date,Open,High,Low,Close,Volume,Adj Close
2014-08-12,96.04,96.88,95.61,95.97,33795000,95.97
2014-08-11,95.27,96.08,94.84,95.99,36585000,95.99
В aspera Ad Astra... (... больше ГГц, больше TB, больше Gbps, больше..., больше..., Moore!)