Skip to main content

Coin Metrics Options Data Aggregation

This notebook demonstrates basic functionality offered by the Coin Metrics Python API Client and Market Data Feed. Coin Metrics offers a vast assortment of data for hundreds of cryptoassets. The Python API Client allows for easy access to this data using Python without needing to create your own wrappers using requests and other such libraries.

Resources

To understand the data that Coin Metrics offers, feel free to peruse the resources below.

File Download

Download the entire notebook as either a jupyter notebook to run yourself or as a pdf from the two links below MDF_options_aggregation.ipynb MDF_options_aggregation.pdf

Notebook Setup

Set start and end time

OPTIONS CATALOG

To simplify some of the complexity around options contract size, we will investigate only options markets on Deribit, the largest options exchange by volume.

Filter out expired/inactive contracts

5 rows × 22 columns
376 rows × 22 columns

TRADE VOLUME

On Deribit, each option contract provides notional exposure to 1 unit of the underlying asset (i.e. 1 BTC or 1 ETH). To calculate options volume, we must multiply the ‘amount’ field (representing the number of contracts traded) by the USD price of the underlying asset.
10824 rows × 3 columns

Retrieve 1-minute Reference Rate

11520 rows × 1 columns

Calculate USD value of trades

10824 rows × 5 columns

OPEN INTEREST

Open interest represents the number of contracts that are currently outstanding and not settled for a specific derivatives market.

Split into Calls/Puts

2534 rows × 7 columns