Hi John,

We've updated the API since then. You'll need to do something like .head() or .tail() instead.

Thanks!
Seong

Hi Seong,

Thanks for your answer! I don't quite get how I am supposed to access the data in research then. Say I intend to buy EventVestor dataset to look at price dynamics around earnings releases. How do I get dates of all such announcements if I am restricted to 10000 rows when using the dataset? I cannot express all my logic in blaze expressions simply because prices and volumes are in a separate dataset. Is there any way for me to get all the data or at least iterate through it in some way?

Thanks!

Hi John,

You aren't limited to 10000 rows when using the dataset. Mind sharing some of the code you are trying to run? Maybe I can help you out

Matt

Hi Matthew,

Say, my goal is to calculate median volume of an equity across a 30-day window before its earnings release. The only way I can get all the events for this is as follows in the attached notebook.

Is there any way to get access to all events?

Thank you very much for your assistance!

Hi John,

Sorry, I didn't realize you were using the interactive version of the dataset, which is indeed limited to 10000 rows.

A way to get around that is to use Pipeline instead. Pipeline isn't limited to a fixed amount of rows, although you may need to implement a function to run the pipeline in chunks in order to fit the memory constraints of research.

I wrote an example notebook which covers generating data in Pipeline, which you might want to check out. Also, if you're unfamiliar with pipeline you should definitely read the tutorial

Hope this helps!

Hi Matthew,

Ah, I see - Pipeline is the way. Still, how do I use datasets like "Share Repurchases" or "Issue Equity", which don't have a Pipeline available? If I purchase them, do I get only 10000 rows then?

Also, partner dataset Pipelines have been crashing in my backtests for a couple days already with an error:

ValueError: Bad response: Computation failed with message: AssertionError: File "/home/databazaar/.venv/lib/python3.4/site-packages/blaze/server/server.py", line 643, in compserver **compute_kwargs),  
...

Previously when I saw this message Quantopian acknowledged the problem on the status page and it was fixed fairly soon. Now I have been getting this message for a couple of days in a row and the status page looks like everything is working. Does anyone have any problems accessing partner data Pipelines or is it just me?

Thank you!

Hi John,

The limit on data in interactive mode isn't for 10K rows overall but rather 10K rows per query. That is currently the only want to access that data. You could break up your access into smaller queries somehow, depending upon your purposes.

On the "Bad response" error, that is something we started to see, intermittently yesterday and have been digging into the problem. It seems to be a less widespread problem and specific to our production environment. We'll keep at it today to try to solve it.

Thanks
Josh

Hi there,

Just posted a new thread on https://www.quantopian.com/posts/error-in-getting-ceo-change%60-in-research-gives-cparsererror-error-tokenizing-data wondering if this is related?

If so, wondering is there an example for pipeline version for quantopian.interactive.data.eventvestor.ceo_change (It seems like it is not mentioned in https://www.quantopian.com/data/eventvestor/ceo_change)?

Thanks,
boris

Found out about

from quantopian.pipeline.data.eventvestor import CEOChangeAnnouncements  

However, it still fails with some assertion error (see attached notebook) - any ideas? Thanks!

Bad response: Computation failed with message:  
AssertionError: names = ['event_id', 'asof_date', 'trade_date', 'symbol', 'event_type', 'event_headline', 'change_status', 'change_scenario', 'change_type', 'change_source', 'change_reason', 'in_ceoname', 'in_ceogender', 'out_ceoname', 'out_ceogender', 'effective_date', 'event_rating', 'timestamp', 'sid']  
expr._child.fields = ['event_id', 'trade_date', 'symbol', 'event_type', 'event_headline', 'change_status', 'change_scenario', 'change_type', 'change_source', 'change_reason', 'in_ceoname', 'in_ceogender', 'out_ceoname', 'out_ceogender', 'effective_date', 'event_rating', 'sid', 'asof_date', 'timestamp']  
  File "/home/databazaar/databazaar-clone/submodules/blaze/blaze/server/server.py", line 643, in compserver  
    **compute_kwargs),  
....

File "/home/databazaar/databazaar-clone/submodules/blaze/blaze/compute/sql.py", line 1040, in compute_up  
    'names = %r\nexpr._child.fields = %r' % (names, expr._child.fields)  

For the record - This is fixed according to https://www.quantopian.com/posts/quantpedia-trading-strategy-series-reversals-in-the-pead - retry the notebook it should work

heads up free data only available until 26 Nov 2016 -- you try a date after that, and will not get a meaningful error message other then:

Something went wrong. Sorry for the inconvenience. Try using the built-in debugger to analyze your code. If you would like help, send us an email.

or a timeout error.