{"action":"created","issue":{"url":"https://api.github.com/repos/quantopian/zipline/issues/1776","repository_url":"https://api.github.com/repos/quantopian/zipline","labels_url":"https://api.github.com/repos/quantopian/zipline/issues/1776/labels{/name}","comments_url":"https://api.github.com/repos/quantopian/zipline/issues/1776/comments","events_url":"https://api.github.com/repos/quantopian/zipline/issues/1776/events","html_url":"https://github.com/quantopian/zipline/issues/1776","id":225471265,"number":1776,"title":"Can't connect to Yahoo - Errors: Loader: failed to cache the new benchmark returns","user":{"login":"kevinyuan","id":231197,"avatar_url":"https://avatars2.githubusercontent.com/u/231197?v=3","gravatar_id":"","url":"https://api.github.com/users/kevinyuan","html_url":"https://github.com/kevinyuan","followers_url":"https://api.github.com/users/kevinyuan/followers","following_url":"https://api.github.com/users/kevinyuan/following{/other_user}","gists_url":"https://api.github.com/users/kevinyuan/gists{/gist_id}","starred_url":"https://api.github.com/users/kevinyuan/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kevinyuan/subscriptions","organizations_url":"https://api.github.com/users/kevinyuan/orgs","repos_url":"https://api.github.com/users/kevinyuan/repos","events_url":"https://api.github.com/users/kevinyuan/events{/privacy}","received_events_url":"https://api.github.com/users/kevinyuan/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":37,"created_at":"2017-05-01T16:53:36Z","updated_at":"2017-06-13T21:41:42Z","closed_at":null,"body":"Dear Zipline Maintainers,\r\n\r\nBefore I tell you about my issue, let me describe my environment:\r\n\r\n# Environment\r\n\r\n* Operating System: Linux hostname  2.6.18-238.12.1.el5 #1 SMP Tue May 31 13:22:04 EDT 2011 x86_64 x86_64 x86_64 GNU/Linux\r\n* Python Version: Python 3.5.1\r\n* Python Bitness: 32\r\n* How did you install Zipline: pip\r\n* Python packages: \r\n\r\nalembic==0.9.1\r\nappdirs==1.4.3\r\nbcolz==0.12.1\r\nBottleneck==1.3.0.dev0\r\nclick==6.7\r\ncontextlib2==0.5.5\r\ncyordereddict==1.0.0\r\nCython==0.25.2\r\ndecorator==4.0.11\r\nempyrical==0.2.2\r\nintervaltree==2.1.0\r\nLogbook==1.0.0\r\nlru-dict==1.1.6\r\nMako==1.0.6\r\nMarkupSafe==1.0\r\nmultipledispatch==0.4.9\r\nnetworkx==1.11\r\nnumexpr==2.6.2\r\nnumpy==1.12.1\r\npackaging==16.8\r\npandas==0.18.1\r\npandas-datareader==0.3.0.post0\r\npatsy==0.4.1\r\npyparsing==2.2.0\r\npython-dateutil==2.6.0\r\npython-editor==1.0.3\r\npytz==2017.2\r\nrequests==2.13.0\r\nrequests-file==1.4.2\r\nrequests-ftp==0.3.1\r\nscipy==0.19.0\r\nsetuptools-scm==1.15.5\r\nsix==1.10.0\r\nsortedcontainers==1.5.7\r\nSQLAlchemy==1.1.9\r\nstatsmodels==0.8.0\r\ntables==3.4.2\r\ntoolz==0.8.2\r\nzipline==1.1.0\r\n\r\n\r\nNow that you know a little about me, let me tell you about the issue I am\r\nhaving:\r\n\r\n# Description of Issue\r\nI just ran the buyapple.py example that described on http://www.zipline.io/beginner-tutorial.html, but got some errors, can you help to check ?\r\n\r\n/home/kevinyuan/dev/zipline> bin/zipline ingest Downloading Bundle: quantopian-quandl [####################################] 100%\r\nWriting data to /home/kevinyuan/.zipline/data/quantopian-quandl/2017-05-01T16;36;49.048566.\r\n\r\n/home/kevinyuan/dev/zipline> bin/zipline run -f examples/buyapple.py -s 2000-1-1 -e 2001-12-31 [2017-05-01 16:33:28.023652] INFO: Loader: Cache at /home/kevinyuan/.zipline/data/^GSPC_benchmark.csv does not have data from 1990-01-02 00:00:00+00:00 to 2017-04-27 00:00:00+00:00. Downloading benchmark data for '^GSPC'.\r\n[2017-05-01 16:33:28.076307] ERROR: Loader: failed to cache the new benchmark returns Traceback (most recent call last):\r\nFile \"/share/dev/tools/lib/python3.5/urllib/request.py\", line 1240, in do_open\r\nh.request(req.get_method(), req.selector, req.data, headers)\r\nFile \"/share/dev/tools/lib/python3.5/http/client.py\", line 1083, in request\r\nself.send_request(method, url, body, headers)\r\nFile \"/share/dev/tools/lib/python3.5/http/client.py\", line 1128, in send_request\r\nself.endheaders(body)\r\nFile \"/share/dev/tools/lib/python3.5/http/client.py\", line 1079, in endheaders\r\nself._send_output(message_body)\r\nFile \"/share/dev/tools/lib/python3.5/http/client.py\", line 911, in _sendoutput\r\nself.send(msg)\r\nFile \"/share/dev/tools/lib/python3.5/http/client.py\", line 854, in send\r\nself.connect()\r\nFile \"/share/dev/tools/lib/python3.5/http/client.py\", line 1237, in connect\r\nserverhostname=server_hostname)\r\nFile \"/share/dev/tools/lib/python3.5/ssl.py\", line 376, in wrap_socket\r\ncontext=self)\r\nFile \"/share/dev/tools/lib/python3.5/ssl.py\", line 747, in __init_\r\nself.do_handshake()\r\nFile \"/share/dev/tools/lib/python3.5/ssl.py\", line 983, in do_handshake\r\nself.sslobj.do_handshake()\r\nFile \"/share/dev/tools/lib/python3.5/ssl.py\", line 628, in do_handshake\r\nself._sslobj.dohandshake()\r\nssl.SSLError: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c:645)\r\n\r\nDuring handling of the above exception, another exception occurred:\r\n\r\nTraceback (most recent call last):\r\nFile \"/home-tahoe-n2/kevinyuan/dev/zipline/lib/python3.5/site-packages/zipline/data/loader.py\", line 247, in ensure_benchmark_data\r\nlast_date,\r\nFile \"/home-tahoe-n2/kevinyuan/dev/zipline/lib/python3.5/site-packages/zipline/data/benchmarks.py\", line 59, in get_benchmark_returns\r\nsqueeze=True, # squeeze tells pandas to make this a Series\r\nFile \"/home-tahoe-n2/kevinyuan/dev/zipline/lib/python3.5/site-packages/pandas/io/parsers.py\", line 562, in parser_f\r\nreturn read(filepath_or_buffer, kwds)\r\nFile \"/home-tahoe-n2/kevinyuan/dev/zipline/lib/python3.5/site-packages/pandas/io/parsers.py\", line 301, in read\r\ncompression=kwds.get('compression', None))\r\nFile \"/home-tahoe-n2/kevinyuan/dev/zipline/lib/python3.5/site-packages/pandas/io/common.py\", line 308, in get_filepath_or_buffer\r\nreq = urlopen(str(filepath_or_buffer))\r\nFile \"/share/dev/tools/lib/python3.5/urllib/request.py\", line 162, in urlopen\r\nreturn opener.open(url, data, timeout)\r\nFile \"/share/dev/tools/lib/python3.5/urllib/request.py\", line 465, in open\r\nresponse = self.open(req, data)\r\nFile \"/share/dev/tools/lib/python3.5/urllib/request.py\", line 483, in _open\r\n'_open', req)\r\nFile \"/share/dev/tools/lib/python3.5/urllib/request.py\", line 443, in _callchain\r\nresult = func(*args)\r\nFile \"/share/dev/tools/lib/python3.5/urllib/request.py\", line 1283, in https_open\r\ncontext=self.context, check_hostname=self.check_hostname)\r\nFile \"/share/dev/tools/lib/python3.5/urllib/request.py\", line 1242, in doopen\r\nraise URLError(err)\r\nurllib.error.URLError: <urlopen error [SSL: CERTIFICATEVERIFY_FAILED] certificate verify failed (_ssl.c:645)>\r\nTraceback (most recent call last):\r\nFile \"/share/dev/tools/lib/python3.5/urllib/request.py\", line 1240, in doopen\r\nh.request(req.get_method(), req.selector, req.data, headers)\r\nFile \"/share/dev/tools/lib/python3.5/http/client.py\", line 1083, in request\r\nself.send_request(method, url, body, headers)\r\nFile \"/share/dev/tools/lib/python3.5/http/client.py\", line 1128, in send_request\r\nself.endheaders(body)\r\nFile \"/share/dev/tools/lib/python3.5/http/client.py\", line 1079, in endheaders\r\nself._send_output(message_body)\r\nFile \"/share/dev/tools/lib/python3.5/http/client.py\", line 911, in _sendoutput\r\nself.send(msg)\r\nFile \"/share/dev/tools/lib/python3.5/http/client.py\", line 854, in send\r\nself.connect()\r\nFile \"/share/dev/tools/lib/python3.5/http/client.py\", line 1237, in connect\r\nserverhostname=server_hostname)\r\nFile \"/share/dev/tools/lib/python3.5/ssl.py\", line 376, in wrap_socket\r\ncontext=self)\r\nFile \"/share/dev/tools/lib/python3.5/ssl.py\", line 747, in __init_\r\nself.do_handshake()\r\nFile \"/share/dev/tools/lib/python3.5/ssl.py\", line 983, in do_handshake\r\nself.sslobj.do_handshake()\r\nFile \"/share/dev/tools/lib/python3.5/ssl.py\", line 628, in do_handshake\r\nself._sslobj.dohandshake()\r\nssl.SSLError: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c:645)\r\n\r\nDuring handling of the above exception, another exception occurred:\r\n\r\nTraceback (most recent call last):\r\nFile \"bin/zipline\", line 11, in\r\nsys.exit(main())\r\nFile \"/home-tahoe-n2/kevinyuan/dev/zipline/lib/python3.5/site-packages/click/core.py\", line 722, in call\r\nreturn self.main(args, **kwargs)\r\nFile \"/home-tahoe-n2/kevinyuan/dev/zipline/lib/python3.5/site-packages/click/core.py\", line 697, in main\r\nrv = self.invoke(ctx)\r\nFile \"/home-tahoe-n2/kevinyuan/dev/zipline/lib/python3.5/site-packages/click/core.py\", line 1066, in invoke\r\nreturn process_result(sub_ctx.command.invoke(sub_ctx))\r\nFile \"/home-tahoe-n2/kevinyuan/dev/zipline/lib/python3.5/site-packages/click/core.py\", line 895, in invoke\r\nreturn ctx.invoke(self.callback, *ctx.params)\r\nFile \"/home-tahoe-n2/kevinyuan/dev/zipline/lib/python3.5/site-packages/click/core.py\", line 535, in invoke\r\nreturn callback(args, **kwargs)\r\nFile \"/home-tahoe-n2/kevinyuan/dev/zipline/lib/python3.5/site-packages/zipline/main.py\", line 97, in _\r\nreturn f(args, **kwargs)\r\nFile \"/home-tahoe-n2/kevinyuan/dev/zipline/lib/python3.5/site-packages/click/decorators.py\", line 17, in new_func\r\nreturn f(get_current_context(), *args, *kwargs)\r\nFile \"/home-tahoe-n2/kevinyuan/dev/zipline/lib/python3.5/site-packages/zipline/main.py\", line 240, in run\r\nenviron=os.environ,\r\nFile \"/home-tahoe-n2/kevinyuan/dev/zipline/lib/python3.5/site-packages/zipline/utils/run_algo.py\", line 132, in run\r\nenv = TradingEnvironment(asset_db_path=connstr)\r\nFile \"/home-tahoe-n2/kevinyuan/dev/zipline/lib/python3.5/site-packages/zipline/finance/trading.py\", line 101, in _init_\r\nself.bm_symbol,\r\nFile \"/home-tahoe-n2/kevinyuan/dev/zipline/lib/python3.5/site-packages/zipline/data/loader.py\", line 164, in load_market_data\r\ntrading_day,\r\nFile \"/home-tahoe-n2/kevinyuan/dev/zipline/lib/python3.5/site-packages/zipline/data/loader.py\", line 247, in ensure_benchmark_data\r\nlast_date,\r\nFile \"/home-tahoe-n2/kevinyuan/dev/zipline/lib/python3.5/site-packages/zipline/data/benchmarks.py\", line 59, in get_benchmark_returns\r\nsqueeze=True, # squeeze tells pandas to make this a Series\r\nFile \"/home-tahoe-n2/kevinyuan/dev/zipline/lib/python3.5/site-packages/pandas/io/parsers.py\", line 562, in parser_f\r\nreturn read(filepath_or_buffer, kwds)\r\nFile \"/home-tahoe-n2/kevinyuan/dev/zipline/lib/python3.5/site-packages/pandas/io/parsers.py\", line 301, in _read\r\ncompression=kwds.get('compression', None))\r\nFile \"/home-tahoe-n2/kevinyuan/dev/zipline/lib/python3.5/site-packages/pandas/io/common.py\", line 308, in get_filepath_or_buffer\r\nreq = _urlopen(str(filepath_or_buffer))\r\nFile \"/share/dev/tools/lib/python3.5/urllib/request.py\", line 162, in urlopen\r\nreturn opener.open(url, data, timeout)\r\nFile \"/share/dev/tools/lib/python3.5/urllib/request.py\", line 465, in open\r\nresponse = self.open(req, data)\r\nFile \"/share/dev/tools/lib/python3.5/urllib/request.py\", line 483, in open\r\n'_open', req)\r\nFile \"/share/dev/tools/lib/python3.5/urllib/request.py\", line 443, in _callchain\r\nresult = func(args)\r\nFile \"/share/dev/tools/lib/python3.5/urllib/request.py\", line 1283, in https_open\r\ncontext=self.context, check_hostname=self.check_hostname)\r\nFile \"/share/dev/tools/lib/python3.5/urllib/request.py\", line 1242, in doopen\r\nraise URLError(err)\r\nurllib.error.URLError: <urlopen error [SSL: CERTIFICATEVERIFY_FAILED] certificate verify failed (_ssl.c:645)>\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/quantopian/zipline/issues/comments/308257115","html_url":"https://github.com/quantopian/zipline/issues/1776#issuecomment-308257115","issue_url":"https://api.github.com/repos/quantopian/zipline/issues/1776","id":308257115,"user":{"login":"FreddieV4","id":8339018,"avatar_url":"https://avatars0.githubusercontent.com/u/8339018?v=3","gravatar_id":"","url":"https://api.github.com/users/FreddieV4","html_url":"https://github.com/FreddieV4","followers_url":"https://api.github.com/users/FreddieV4/followers","following_url":"https://api.github.com/users/FreddieV4/following{/other_user}","gists_url":"https://api.github.com/users/FreddieV4/gists{/gist_id}","starred_url":"https://api.github.com/users/FreddieV4/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/FreddieV4/subscriptions","organizations_url":"https://api.github.com/users/FreddieV4/orgs","repos_url":"https://api.github.com/users/FreddieV4/repos","events_url":"https://api.github.com/users/FreddieV4/events{/privacy}","received_events_url":"https://api.github.com/users/FreddieV4/received_events","type":"User","site_admin":false},"created_at":"2017-06-13T21:41:42Z","updated_at":"2017-06-13T21:41:42Z","body":"@ywang412 the default symbol that is passed in is `SPY` in the latest merge. If you've pip installed the latest master branch of zipline, or conda installed a [recent build](https://anaconda.org/Quantopian/zipline/files) of zipline, then the requests should be going out to Google Finance now.\r\n\r\nIn the URL you posted, `GSPC` is the symbol being searched for. Did you clone zipline and then `pip install` that local directory?"}}
{"actor":{"display_login":"FreddieV4"}}