Advertisement
rainerpl

Untitled

Aug 27th, 2016
234
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
JSON 3.69 KB | None | 0 0
  1. {
  2.  "query": {
  3.   "count": 4,
  4.   "created": "2016-08-27T15:04:40Z",
  5.   "lang": "en-US",
  6.   "diagnostics": {
  7.    "url": [
  8.     {
  9.      "execution-start-time": "3",
  10.      "execution-stop-time": "6",
  11.      "execution-time": "3",
  12.      "id": "12970069-12c8-42d4-bf02-e858b8297049",
  13.      "content": "http://sherpa-bcp5903.dht.yahoo.com:4080/YDHTWebService/V1/get/yql.global/store%3A%2F%2Fdatatables.org%2Falltableswithkeys"
  14.     },
  15.     {
  16.      "execution-start-time": "9",
  17.      "execution-stop-time": "20",
  18.      "execution-time": "11",
  19.      "id": "3d6c441f-c44c-4b61-b9d4-dd077d653acf",
  20.      "content": "http://sherpa-bcp5903.dht.yahoo.com:4080/YDHTWebService/V1/get/yql.global/store%3A%2F%2FRjdEzitN2Hceujh3tGHPj6"
  21.     },
  22.     {
  23.      "execution-start-time": "47",
  24.      "execution-stop-time": "58",
  25.      "execution-time": "11",
  26.      "id": "22bac398-6ebd-4a75-bd14-e5258aef6e77",
  27.      "content": "http://sherpa-bcp5903.dht.yahoo.com:4080/YDHTWebService/V1/get/yql.global/store%3A%2F%2FRjdEzitN2Hceujh3tGHPj6"
  28.     },
  29.     {
  30.      "execution-start-time": "82",
  31.      "execution-stop-time": "83",
  32.      "execution-time": "1",
  33.      "id": "c7490dcf-bbd5-4ff7-b2dc-9add45eac38b",
  34.      "content": "http://www.datatables.org/yahoo/finance/yahoo.finance.historicaldata.xml"
  35.     },
  36.     {
  37.      "execution-start-time": "88",
  38.      "execution-stop-time": "89",
  39.      "execution-time": "1",
  40.      "id": "a440ca90-ec99-44d3-849c-cefbb63a4fc7",
  41.      "content": "http://ichart.finance.yahoo.com/table.csv?a=0&b=1&e=7&g=d&c=2016&d=0&f=2016&s=SFLY"
  42.     },
  43.     {
  44.      "execution-start-time": "92",
  45.      "execution-stop-time": "93",
  46.      "execution-time": "1",
  47.      "id": "434c0a2f-dc51-43de-9dfc-b1612e977627",
  48.      "content": "http://ichart.finance.yahoo.com/table.csv?a=0&b=1&e=7&g=d&c=2016&d=0&f=2016&s=SFLY"
  49.     }
  50.    ],
  51.    "publiclyCallable": "true",
  52.    "query": [
  53.     {
  54.      "execution-start-time": "87",
  55.      "execution-stop-time": "90",
  56.      "execution-time": "3",
  57.      "params": "{url=[http://ichart.finance.yahoo.com/table.csv?a=0&b=1&e=7&g=d&c=2016&d=0&f=2016&s=SFLY]}",
  58.      "content": "select * from csv(0,1) where url=@url"
  59.     },
  60.     {
  61.      "execution-start-time": "91",
  62.      "execution-stop-time": "93",
  63.      "execution-time": "2",
  64.      "params": "{columnsNames=[Date,Open,High,Low,Close,Volume,Adj_Close], url=[http://ichart.finance.yahoo.com/table.csv?a=0&b=1&e=7&g=d&c=2016&d=0&f=2016&s=SFLY]}",
  65.      "content": "select * from csv(2,0) where url=@url and columns=@columnsNames"
  66.     }
  67.    ],
  68.    "javascript": {
  69.     "execution-start-time": "85",
  70.     "execution-stop-time": "97",
  71.     "execution-time": "11",
  72.     "instructions-used": "41791",
  73.     "table-name": "yahoo.finance.historicaldata"
  74.    },
  75.    "user-time": "98",
  76.    "service-time": "28",
  77.    "build-version": "0.2.25"
  78.   },
  79.   "results": {
  80.    "quote": [
  81.     {
  82.      "Symbol": "SFLY",
  83.      "Date": "2016-01-07",
  84.      "Open": "41.869999",
  85.      "High": "41.919998",
  86.      "Low": "41.02",
  87.      "Close": "41.25",
  88.      "Volume": "390000",
  89.      "Adj_Close": "41.25"
  90.     },
  91.     {
  92.      "Symbol": "SFLY",
  93.      "Date": "2016-01-06",
  94.      "Open": "42.139999",
  95.      "High": "42.869999",
  96.      "Low": "42.049999",
  97.      "Close": "42.360001",
  98.      "Volume": "305800",
  99.      "Adj_Close": "42.360001"
  100.     },
  101.     {
  102.      "Symbol": "SFLY",
  103.      "Date": "2016-01-05",
  104.      "Open": "43.259998",
  105.      "High": "43.330002",
  106.      "Low": "42.509998",
  107.      "Close": "42.700001",
  108.      "Volume": "288700",
  109.      "Adj_Close": "42.700001"
  110.     },
  111.     {
  112.      "Symbol": "SFLY",
  113.      "Date": "2016-01-04",
  114.      "Open": "43.799999",
  115.      "High": "44.77",
  116.      "Low": "43.00",
  117.      "Close": "43.209999",
  118.      "Volume": "276500",
  119.      "Adj_Close": "43.209999"
  120.     }
  121.    ]
  122.   }
  123.  }
  124. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement