In this notebook, we'll take a look at data set , available on Quantopian. This dataset spans from January, 1990 through the current day. It contains the value for the index VIX, a measure of volatility in the S&P 500. We access this data via the API provided by Quandl. More details on this dataset can be found on Quandl's website.
To be clear, this is a single value for VIX each day.
There are two ways to access the data and you'll find both of them listed below. Just click on the section you'd like to read through.
One key caveat: we limit the number of results returned from any given expression to 10,000 to protect against runaway memory usage. To be clear, you have access to all the data server side. We are limiting the size of the responses back from Blaze.
With preamble in place, let's get started:
Partner datasets are available on Quantopian Research through an API service known as Blaze. Blaze provides the Quantopian user with a convenient interface to access very large datasets, in an interactive, generic manner.
Blaze provides an important function for accessing these datasets. Some of these sets are many millions of records. Bringing that data directly into Quantopian Research directly just is not viable. So Blaze allows us to provide a simple querying interface and shift the burden over to the server side.
It is common to use Blaze to reduce your dataset in size, convert it over to Pandas and then to use Pandas for further computation, manipulation and visualization.
Helpful links:
Once you've limited the size of your Blaze object, you can convert it to a Pandas DataFrames using:
from odo import odo
odo(expr, pandas.DataFrame)
Pipeline Overview
section of this notebook or head straight to Pipeline Overview¶# import the dataset
from quantopian.interactive.data.quandl import yahoo_index_vix as dataset
# Since this data is provided by Quandl for free, there is no _free version of this
# data set, as found in the premium sets. This import gets you the entirety of this data set.
# import data operations
from odo import odo
# import other libraries we will use
import pandas as pd
import matplotlib.pyplot as plt
# Let's use blaze to understand the data a bit using Blaze dshape()
dataset.dshape
dshape("""var * { open_: float64, high: float64, low: float64, close: float64, volume: float64, adjusted_close: float64, asof_date: datetime, timestamp: datetime }""")
# And how many rows are there?
# N.B. we're using a Blaze function to do this, not len()
dataset.count()
# Let's see what the data looks like. We'll grab the first three rows.
dataset[:3]
open_ | high | low | close | volume | adjusted_close | asof_date | timestamp | |
---|---|---|---|---|---|---|---|---|
0 | 19.750000 | 21.160000 | 19.540001 | 20.980000 | 0 | 20.980000 | 2016-02-23 | 2016-02-24 08:01:58.351899 |
1 | 22.280001 | 22.870001 | 20.260000 | 20.719999 | 0 | 20.719999 | 2016-02-24 | 2016-02-25 08:02:33.397136 |
2 | 20.540001 | 21.260000 | 19.100000 | 19.110001 | 0 | 19.110001 | 2016-02-25 | 2016-02-26 05:01:23.226761 |
Let's go over the columns:
We've done much of the data processing for you. Fields like timestamp
and sid
are standardized across all our Store Datasets, so the datasets are easy to combine. We have standardized the sid
across all our equity databases.
We can select columns and rows with ease. Let's go plot it for fun below. 6500 rows is small enough to just convert right over to Pandas.
# Convert it over to a Pandas dataframe for easy charting
vix_df = odo(dataset, pd.DataFrame)
vix_df.plot(x='asof_date', y='close')
plt.xlabel("As of Date (asof_date)")
plt.ylabel("Close Price")
plt.axis([None, None, 0, 100])
plt.title("VIX")
plt.legend().set_visible(False)
The only method for accessing partner data within algorithms running on Quantopian is via the pipeline API. Different data sets work differently but in the case of this data, you can add this data to your pipeline as follows:
Import the data set here
from quantopian.pipeline.data.quandl import yahoo_index_vix
Then in intialize() you could do something simple like adding the raw value of one of the fields to your pipeline:
pipe.add(yahoo_index_vix.close, 'close')
# Import necessary Pipeline modules
from quantopian.pipeline import Pipeline
from quantopian.research import run_pipeline
from quantopian.pipeline.factors import AverageDollarVolume
# For use in your algorithms
# Using the full dataset in your pipeline algo
from quantopian.pipeline.data.quandl import yahoo_index_vix
Now that we've imported the data, let's take a look at which fields are available for each dataset.
You'll find the dataset, the available fields, and the datatypes for each of those fields.
print "Here are the list of available fields per dataset:"
print "---------------------------------------------------\n"
def _print_fields(dataset):
print "Dataset: %s\n" % dataset.__name__
print "Fields:"
for field in list(dataset.columns):
print "%s - %s" % (field.name, field.dtype)
print "\n"
for data in (yahoo_index_vix,):
_print_fields(data)
print "---------------------------------------------------\n"
Here are the list of available fields per dataset: --------------------------------------------------- Dataset: yahoo_index_vix Fields: low - float64 high - float64 adjusted_close - float64 volume - float64 close - float64 open_ - float64 ---------------------------------------------------
Now that we know what fields we have access to, let's see what this data looks like when we run it through Pipeline.
This is constructed the same way as you would in the backtester. For more information on using Pipeline in Research view this thread: https://www.quantopian.com/posts/pipeline-in-research-build-test-and-visualize-your-factors-and-filters
# Let's see what this data looks like when we run it through Pipeline
# This is constructed the same way as you would in the backtester. For more information
# on using Pipeline in Research view this thread:
# https://www.quantopian.com/posts/pipeline-in-research-build-test-and-visualize-your-factors-and-filters
pipe = Pipeline()
pipe.add(yahoo_index_vix.open_.latest, 'open')
pipe.add(yahoo_index_vix.close.latest, 'close')
pipe.add(yahoo_index_vix.adjusted_close.latest, 'adjusted_close')
pipe.add(yahoo_index_vix.high.latest, 'high')
pipe.add(yahoo_index_vix.low.latest, 'low')
pipe.add(yahoo_index_vix.volume.latest, 'volume')
# The show_graph() method of pipeline objects produces a graph to show how it is being calculated.
pipe.show_graph(format='png')
# run_pipeline will show the output of your pipeline
pipe_output = run_pipeline(pipe, start_date='2013-11-01', end_date='2013-11-25')
pipe_output
adjusted_close | close | high | low | open | volume | ||
---|---|---|---|---|---|---|---|
2013-11-01 00:00:00+00:00 | Equity(2 [AA]) | 13.75 | 13.75 | 14.02 | 13.28 | 13.83 | 0 |
Equity(21 [AAME]) | 13.75 | 13.75 | 14.02 | 13.28 | 13.83 | 0 | |
Equity(24 [AAPL]) | 13.75 | 13.75 | 14.02 | 13.28 | 13.83 | 0 | |
Equity(25 [AA_PR]) | 13.75 | 13.75 | 14.02 | 13.28 | 13.83 | 0 | |
Equity(31 [ABAX]) | 13.75 | 13.75 | 14.02 | 13.28 | 13.83 | 0 | |
Equity(39 [DDC]) | 13.75 | 13.75 | 14.02 | 13.28 | 13.83 | 0 | |
Equity(41 [ARCB]) | 13.75 | 13.75 | 14.02 | 13.28 | 13.83 | 0 | |
Equity(52 [ABM]) | 13.75 | 13.75 | 14.02 | 13.28 | 13.83 | 0 | |
Equity(53 [ABMD]) | 13.75 | 13.75 | 14.02 | 13.28 | 13.83 | 0 | |
Equity(62 [ABT]) | 13.75 | 13.75 | 14.02 | 13.28 | 13.83 | 0 | |
Equity(64 [ABX]) | 13.75 | 13.75 | 14.02 | 13.28 | 13.83 | 0 | |
Equity(66 [AB]) | 13.75 | 13.75 | 14.02 | 13.28 | 13.83 | 0 | |
Equity(67 [ADSK]) | 13.75 | 13.75 | 14.02 | 13.28 | 13.83 | 0 | |
Equity(69 [ACAT]) | 13.75 | 13.75 | 14.02 | 13.28 | 13.83 | 0 | |
Equity(70 [VBF]) | 13.75 | 13.75 | 14.02 | 13.28 | 13.83 | 0 | |
Equity(76 [TAP]) | 13.75 | 13.75 | 14.02 | 13.28 | 13.83 | 0 | |
Equity(84 [ACET]) | 13.75 | 13.75 | 14.02 | 13.28 | 13.83 | 0 | |
Equity(86 [ACG]) | 13.75 | 13.75 | 14.02 | 13.28 | 13.83 | 0 | |
Equity(88 [ACI]) | 13.75 | 13.75 | 14.02 | 13.28 | 13.83 | 0 | |
Equity(99 [ACO]) | 13.75 | 13.75 | 14.02 | 13.28 | 13.83 | 0 | |
Equity(100 [IEP]) | 13.75 | 13.75 | 14.02 | 13.28 | 13.83 | 0 | |
Equity(106 [ACU]) | 13.75 | 13.75 | 14.02 | 13.28 | 13.83 | 0 | |
Equity(110 [ACXM]) | 13.75 | 13.75 | 14.02 | 13.28 | 13.83 | 0 | |
Equity(112 [ACY]) | 13.75 | 13.75 | 14.02 | 13.28 | 13.83 | 0 | |
Equity(114 [ADBE]) | 13.75 | 13.75 | 14.02 | 13.28 | 13.83 | 0 | |
Equity(117 [AEY]) | 13.75 | 13.75 | 14.02 | 13.28 | 13.83 | 0 | |
Equity(122 [ADI]) | 13.75 | 13.75 | 14.02 | 13.28 | 13.83 | 0 | |
Equity(128 [ADM]) | 13.75 | 13.75 | 14.02 | 13.28 | 13.83 | 0 | |
Equity(134 [SXCL]) | 13.75 | 13.75 | 14.02 | 13.28 | 13.83 | 0 | |
Equity(149 [ADX]) | 13.75 | 13.75 | 14.02 | 13.28 | 13.83 | 0 | |
... | ... | ... | ... | ... | ... | ... | ... |
2013-11-25 00:00:00+00:00 | Equity(45864 [CDX]) | 12.26 | 12.26 | 12.91 | 12.24 | 12.69 | 0 |
Equity(45865 [XNCR]) | 12.26 | 12.26 | 12.91 | 12.24 | 12.69 | 0 | |
Equity(45866 [ZU]) | 12.26 | 12.26 | 12.91 | 12.24 | 12.69 | 0 | |
Equity(45867 [EROS]) | 12.26 | 12.26 | 12.91 | 12.24 | 12.69 | 0 | |
Equity(45873 [IR_WI]) | 12.26 | 12.26 | 12.91 | 12.24 | 12.69 | 0 | |
Equity(45874 [ALLE]) | 12.26 | 12.26 | 12.91 | 12.24 | 12.69 | 0 | |
Equity(45875 [HFIN]) | 12.26 | 12.26 | 12.91 | 12.24 | 12.69 | 0 | |
Equity(45880 [CACQ]) | 12.26 | 12.26 | 12.91 | 12.24 | 12.69 | 0 | |
Equity(45882 [TKF_WD]) | 12.26 | 12.26 | 12.91 | 12.24 | 12.69 | 0 | |
Equity(45883 [IIF_WD]) | 12.26 | 12.26 | 12.91 | 12.24 | 12.69 | 0 | |
Equity(45885 [EGF_WD]) | 12.26 | 12.26 | 12.91 | 12.24 | 12.69 | 0 | |
Equity(45891 [OXFD]) | 12.26 | 12.26 | 12.91 | 12.24 | 12.69 | 0 | |
Equity(45892 [TLOG]) | 12.26 | 12.26 | 12.91 | 12.24 | 12.69 | 0 | |
Equity(45893 [VTL]) | 12.26 | 12.26 | 12.91 | 12.24 | 12.69 | 0 | |
Equity(45894 [RTGN]) | 12.26 | 12.26 | 12.91 | 12.24 | 12.69 | 0 | |
Equity(45895 [EMSH]) | 12.26 | 12.26 | 12.91 | 12.24 | 12.69 | 0 | |
Equity(45896 [AMZG]) | 12.26 | 12.26 | 12.91 | 12.24 | 12.69 | 0 | |
Equity(45902 [WBAI]) | 12.26 | 12.26 | 12.91 | 12.24 | 12.69 | 0 | |
Equity(45903 [GOMO]) | 12.26 | 12.26 | 12.91 | 12.24 | 12.69 | 0 | |
Equity(45904 [IPWR]) | 12.26 | 12.26 | 12.91 | 12.24 | 12.69 | 0 | |
Equity(45905 [GFIS]) | 12.26 | 12.26 | 12.91 | 12.24 | 12.69 | 0 | |
Equity(45906 [VNCE]) | 12.26 | 12.26 | 12.91 | 12.24 | 12.69 | 0 | |
Equity(45907 [RITT_W]) | 12.26 | 12.26 | 12.91 | 12.24 | 12.69 | 0 | |
Equity(45914 [EVGN]) | 12.26 | 12.26 | 12.91 | 12.24 | 12.69 | 0 | |
Equity(45915 [NVGS]) | 12.26 | 12.26 | 12.91 | 12.24 | 12.69 | 0 | |
Equity(48504 [ERUS]) | 12.26 | 12.26 | 12.91 | 12.24 | 12.69 | 0 | |
Equity(49010 [TBRA]) | 12.26 | 12.26 | 12.91 | 12.24 | 12.69 | 0 | |
Equity(49131 [OESX]) | 12.26 | 12.26 | 12.91 | 12.24 | 12.69 | 0 | |
Equity(49259 [ITUS]) | 12.26 | 12.26 | 12.91 | 12.24 | 12.69 | 0 | |
Equity(49523 [TLGT]) | 12.26 | 12.26 | 12.91 | 12.24 | 12.69 | 0 |
134806 rows × 6 columns
Taking what we've seen from above, let's see how we'd move that into the backtester.
# This section is only importable in the backtester
from quantopian.algorithm import attach_pipeline, pipeline_output
# General pipeline imports
from quantopian.pipeline import Pipeline
from quantopian.pipeline.factors import AverageDollarVolume
# Import the datasets available
# For use in your algorithms
# Using the full dataset in your pipeline algo
from quantopian.pipeline.data.quandl import yahoo_index_vix
def make_pipeline():
# Create our pipeline
pipe = Pipeline()
# Add pipeline factors
pipe.add(yahoo_index_vix.open_.latest, 'open')
pipe.add(yahoo_index_vix.close.latest, 'close')
pipe.add(yahoo_index_vix.adjusted_close.latest, 'adjusted_close')
pipe.add(yahoo_index_vix.high.latest, 'high')
pipe.add(yahoo_index_vix.low.latest, 'low')
pipe.add(yahoo_index_vix.volume.latest, 'volume')
return pipe
def initialize(context):
attach_pipeline(make_pipeline(), "pipeline")
def before_trading_start(context, data):
results = pipeline_output('pipeline')
Now you can take that and begin to use it as a building block for your algorithms, for more examples on how to do that you can visit our data pipeline factor library