Exploring Options, Open Interest, and Volatility Data

Options contracts have become an increasingly liquid segment of crypytoasset derivatives. Coin Metrics currently offers options data through various endpoints in our Market Data Feed offering. Available endpoints include market greeks, implied volatility, contract prices, market quotes, open interest, and more.

Resources

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.

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

• The Coin Metrics API v4 website contains the full set of endpoints and data offered by Coin Metrics.

• The Coin Metrics Product Documentation gives detailed, conceptual explanations of the data that Coin Metrics offers.

• The API Spec contains a full list of functions.

File Download

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

381KB

MDF_options_exploration.ipynb

2MB

MDF_options_exploration.pdf

pdf

Notebook Setup

from os import environ
import pandas as pd
import numpy as np
import seaborn as sns
import logging
from datetime import date, timedelta
from coinmetrics.api_client import CoinMetricsClient
import logging
import calendar
from datetime import date
import matplotlib.ticker as mtick
import matplotlib.pyplot as plt
%matplotlib inline

sns.set_theme()
sns.set(rc={'figure.figsize':(18,8)})
sns.set_palette("YlGn",3)
sns.set_style("ticks", {"xtick.major.size":20,"ytick.major.size":20})
sns.set_style("whitegrid",{'axes.grid' : True,'grid.linestyle': '--', 'grid.color': '#b0b0b0','axes.edgecolor': 'white',
              'font.family': ['arial'],'axes.facecolor':'#4b5359'})

logging.basicConfig(
    format='%(asctime)s %(levelname)-8s %(message)s',
    level=logging.INFO,
    datefmt='%Y-%m-%d %H:%M:%S'
)

# We recommend privately storing your API key in your local environment.
try:
    api_key = environ["CM_API_KEY"]
    logging.info("Using API key found in environment")
except KeyError:
    api_key = ""
    logging.info("API key not found. Using community client")
client = CoinMetricsClient(api_key)

2024-02-13 13:17:42 INFO     Using API key found in environment

Query Examples

Retrieving Market Greeks

---

greeks_deribit = client.get_market_greeks(
    markets='deribit-BTC-30DEC22-*-option',
    limit_per_market=1
).to_dataframe()
greeks_deribit.head()

	market	time	database_time	vega	theta	rho	delta	gamma	exchange_time
0	deribit-BTC-30DEC22-10000-C-option	2022-05-11 14:09:00+00:00	2022-05-11 14:09:14.701194+00:00	12.95354	-2.40646	58.03478	0.97893	0.0	2022-05-11 14:09:13.336000+00:00
1	deribit-BTC-30DEC22-10000-P-option	2022-05-11 14:09:00+00:00	2022-05-11 14:09:14.701194+00:00	12.95354	-2.40646	-5.73063	-0.02107	0.0	2022-05-11 14:09:13.329000+00:00
2	deribit-BTC-30DEC22-100000-C-option	2021-12-30 08:02:00+00:00	2021-12-30 08:02:03.247339+00:00	158.05411	-14.17178	86.78939	0.24002	0.00001	2021-12-30 08:02:02.591000+00:00
3	deribit-BTC-30DEC22-100000-P-option	2021-12-30 08:02:00+00:00	2021-12-30 08:02:04.257489+00:00	156.75983	-13.9386	-914.15583	-0.76354	0.00001	2021-12-30 08:02:03.416000+00:00
4	deribit-BTC-30DEC22-11000-C-option	2022-11-16 09:06:00+00:00	2022-11-16 09:06:40.873351+00:00	9.65147	-11.41404	10.99731	0.90588	0.00003	2022-11-16 09:06:40.094000+00:00

Retrieving Market Quotes

---

quotes_deribit = client.get_market_quotes(
    markets='deribit-BTC-30DEC22-*-option',
    limit_per_market=1,
).to_dataframe()
quotes_deribit.head()

	market	time	coin_metrics_id	ask_price	ask_size	bid_price	bid_size
0	deribit-BTC-30DEC22-10000-C-option	2022-05-11 14:09:00+00:00	1652278140000000-0	0.0	0.0	0.0	0.0
1	deribit-BTC-30DEC22-10000-P-option	2022-05-11 14:09:00+00:00	1652278140000000-0	0.012	1.9	0.01	2.3
2	deribit-BTC-30DEC22-100000-C-option	2021-12-30 08:02:00+00:00	1640851320000000-0	0.0	0.0	0.0185	2.5
3	deribit-BTC-30DEC22-100000-P-option	2021-12-30 08:02:00+00:00	1640851320000000-0	0.0	0.0	0.0	0.0
4	deribit-BTC-30DEC22-11000-C-option	2022-11-16 09:06:00+00:00	1668589560000000-0	0.0	0.0	0.0	0.0

Retrieving Contract Prices

---

prices_deribit = client.get_market_contract_prices(
    markets='deribit-BTC-30DEC22-*-option',
    limit_per_market=1,
).to_dataframe()
prices_deribit.head()

	market	time	database_time	mark_price	index_price	exchange_time
0	deribit-BTC-30DEC22-10000-C-option	2022-05-11 14:09:00+00:00	2022-05-11 14:09:14.701194+00:00	0.695	31350.76	2022-05-11 14:09:13.336000+00:00
1	deribit-BTC-30DEC22-10000-P-option	2022-05-11 14:09:00+00:00	2022-05-11 14:09:14.701194+00:00	0.007	31350.76	2022-05-11 14:09:13.329000+00:00
2	deribit-BTC-30DEC22-100000-C-option	2021-12-30 08:02:00+00:00	2021-12-30 08:02:03.247339+00:00	0.069329	47033.61	2021-12-30 08:02:02.591000+00:00
3	deribit-BTC-30DEC22-100000-P-option	2021-12-30 08:02:00+00:00	2021-12-30 08:02:04.257489+00:00	1.034568	47034.05	2021-12-30 08:02:03.416000+00:00
4	deribit-BTC-30DEC22-11000-C-option	2022-11-16 09:06:00+00:00	2022-11-16 09:06:40.873351+00:00	0.3547	16744.61	2022-11-16 09:06:40.094000+00:00

Retrieving Open Interest

---

oi_deribit = client.get_market_open_interest(
    markets='deribit-BTC-30DEC22-*-option',
    limit_per_market=1,
).to_dataframe()
oi_deribit.head()

	market	time	contract_count	value_usd	database_time	exchange_time
0	deribit-BTC-30DEC22-10000-C-option	2022-05-11 14:09:00+00:00	0	0	2022-05-11 14:09:39.584165+00:00	2022-05-11 14:09:00+00:00
1	deribit-BTC-30DEC22-10000-P-option	2022-05-11 14:09:00+00:00	0	0	2022-05-11 14:09:39.584165+00:00	2022-05-11 14:09:00+00:00
2	deribit-BTC-30DEC22-100000-C-option	2021-12-30 08:02:00+00:00	0	0	2021-12-30 08:02:35.912527+00:00	2021-12-30 08:02:00+00:00
3	deribit-BTC-30DEC22-100000-P-option	2021-12-30 08:02:00+00:00	0	0	2021-12-30 08:02:37.918026+00:00	2021-12-30 08:02:00+00:00
4	deribit-BTC-30DEC22-11000-C-option	2022-11-16 09:06:00+00:00	0	0	2022-11-16 09:06:24.566250+00:00	2022-11-16 09:06:00+00:00

Plotting Options 'Volatility Smiles'

---

'Volatility smiles' are a popular options data visualization tool that help traders understand predicted asset volatility across various contract expiration dates. The 'smile' is plotted by mapping the strike price and implied volatility of a group of options with the same underlying asset and expiration date.

asset = 'btc'

Catalog Endpoint

The Coin Metrics API contains two types of catalog endpoints (Python client functions in paranthesis): the catalog (catalog_*) and catalog-all (catalog_full_*). The catalog endpoint displays the set of data available to your API key. The catalog-all endpoint displays the full set of data for CM Pro users.

Catalog objects return a list of dictionaries. For catalog_full_market_implied_volatility_v2, each element of the list is an option market that supports implied volatility data.

markets_deribit = client.catalog_full_market_implied_volatility_v2(
    exchange='deribit',
    market_type='option',
    base=asset,
    page_size=10000
).to_dataframe()

markets_deribit.sort_values(by='max_time')

	market	min_time	max_time
29064	deribit-BTC-2SEP21-53000-C-option	2021-09-01 13:24:00+00:00	2021-09-02 08:00:00+00:00
29049	deribit-BTC-2SEP21-45000-P-option	2021-09-01 13:24:00+00:00	2021-09-02 08:00:00+00:00
29048	deribit-BTC-2SEP21-45000-C-option	2021-09-01 13:24:00+00:00	2021-09-02 08:00:00+00:00
29046	deribit-BTC-2SEP21-44000-C-option	2021-09-01 13:24:00+00:00	2021-09-02 08:00:00+00:00
29045	deribit-BTC-2SEP21-43000-P-option	2021-09-01 13:24:00+00:00	2021-09-02 08:00:00+00:00
...	...	...	...
24053	deribit-BTC-27DEC24-61000-P-option	2024-01-02 11:29:00+00:00	2024-02-13 17:43:00+00:00
24054	deribit-BTC-27DEC24-62000-C-option	2024-01-08 22:41:00+00:00	2024-02-13 17:43:00+00:00
24055	deribit-BTC-27DEC24-62000-P-option	2024-01-08 22:41:00+00:00	2024-02-13 17:43:00+00:00
24049	deribit-BTC-27DEC24-59000-P-option	2024-01-02 03:35:00+00:00	2024-02-13 17:43:00+00:00
27297	deribit-BTC-29MAR24-26000-P-option	2023-03-30 08:03:00+00:00	2024-02-13 17:43:00+00:00

40442 rows × 3 columns

markets_deribit["min_time"] = pd.to_datetime(markets_deribit.min_time)
markets_deribit["max_time"] = pd.to_datetime(markets_deribit.max_time)

# Select contracts that are still trading as of yesterday
end_date = (date.today() - timedelta(days=1)).strftime("%Y-%m-%d") 
deribit_current = markets_deribit.loc[(markets_deribit["max_time"] >= end_date)]

Collect Contract Reference Data

ref_data = client.reference_data_markets(
    exchange = 'deribit',
    type = 'option',
    base = asset,
    page_size=10000
).to_dataframe()

ref_data.head()

	market	exchange	type	base	quote	pair	symbol	size_asset	strike	option_contract_type	is_european	contract_size	listing	expiration	settlement_price	status	order_amount_min	order_price_increment	order_taker_fee	order_maker_fee
0	deribit-BTC-10APR20-4750-C-option	deribit	option	btc	usd	btc-usd	BTC-10APR20-4750-C	btc	4750	call	True	1	2020-03-28T03:21:00.000000000Z	2020-04-10T08:00:00.000000000Z	6931.78	offline	0.1	0.0005	0.0004	0.0004
1	deribit-BTC-10APR20-4750-P-option	deribit	option	btc	usd	btc-usd	BTC-10APR20-4750-P	btc	4750	put	True	1	2020-03-28T03:21:00.000000000Z	2020-04-10T08:00:00.000000000Z	6931.78	offline	0.1	0.0005	0.0004	0.0004
2	deribit-BTC-10APR20-5000-C-option	deribit	option	btc	usd	btc-usd	BTC-10APR20-5000-C	btc	5000	call	True	1	2020-03-26T08:19:00.000000000Z	2020-04-10T08:00:00.000000000Z	6931.78	offline	0.1	0.0005	0.0004	0.0004
3	deribit-BTC-10APR20-5000-P-option	deribit	option	btc	usd	btc-usd	BTC-10APR20-5000-P	btc	5000	put	True	1	2020-03-26T08:19:00.000000000Z	2020-04-10T08:00:00.000000000Z	6931.78	offline	0.1	0.0005	0.0004	0.0004
4	deribit-BTC-10APR20-5250-P-option	deribit	option	btc	usd	btc-usd	BTC-10APR20-5250-P	btc	5250	put	True	1	2020-03-26T08:00:08.000000000Z	2020-04-10T08:00:00.000000000Z	6931.78	offline	0.1	0.0005	0.0004	0.0004

deribit_current = pd.merge(deribit_current, ref_data[['market','expiration','option_contract_type','strike']], on='market', how='left')

# Set max expiration date
max_expiry = (date.today() + timedelta(days=365)).strftime("%Y-%m-%d")
max_expiry = (pd.to_datetime(max_expiry)).strftime("%Y-%m-%d")
deribit_current = pd.DataFrame(deribit_current.loc[(deribit_current["expiration"] < max_expiry)])

deribit_current = deribit_current.sort_values(by=['expiration'])

deribit_current

	market	min_time	max_time	expiration	option_contract_type	strike
0	deribit-BTC-12FEB24-41000-C-option	2024-02-09 08:03:00+00:00	2024-02-12 08:00:00+00:00	2024-02-12T08:00:00.000000000Z	call	41000
36	deribit-BTC-12FEB24-48750-C-option	2024-02-11 08:03:00+00:00	2024-02-12 08:00:00+00:00	2024-02-12T08:00:00.000000000Z	call	48750
37	deribit-BTC-12FEB24-48750-P-option	2024-02-11 08:03:00+00:00	2024-02-12 08:00:00+00:00	2024-02-12T08:00:00.000000000Z	put	48750
38	deribit-BTC-12FEB24-49000-C-option	2024-02-09 08:03:00+00:00	2024-02-12 08:00:00+00:00	2024-02-12T08:00:00.000000000Z	call	49000
39	deribit-BTC-12FEB24-49000-P-option	2024-02-09 08:03:00+00:00	2024-02-12 08:00:00+00:00	2024-02-12T08:00:00.000000000Z	put	49000
...	...	...	...	...	...	...
557	deribit-BTC-27DEC24-120000-P-option	2023-12-28 08:02:00+00:00	2024-02-13 17:43:00+00:00	2024-12-27T08:00:00.000000000Z	put	120000
558	deribit-BTC-27DEC24-125000-C-option	2023-12-28 08:02:00+00:00	2024-02-13 17:43:00+00:00	2024-12-27T08:00:00.000000000Z	call	125000
559	deribit-BTC-27DEC24-125000-P-option	2023-12-28 08:02:00+00:00	2024-02-13 17:43:00+00:00	2024-12-27T08:00:00.000000000Z	put	125000
547	deribit-BTC-27DEC24-10000-P-option	2023-12-28 08:02:00+00:00	2024-02-13 17:43:00+00:00	2024-12-27T08:00:00.000000000Z	put	10000
579	deribit-BTC-27DEC24-28000-P-option	2023-12-28 18:57:00+00:00	2024-02-13 17:43:00+00:00	2024-12-27T08:00:00.000000000Z	put	28000

1008 rows × 6 columns

Retrieve Implied Volatility

iv_asset_contracts = client.get_market_implied_volatility(
    markets='deribit-*-option',
    start_time = end_date,
    limit_per_market=1,
    page_size=10000
).to_dataframe()

iv_asset_contracts = iv_asset_contracts.loc[iv_asset_contracts['market'].isin(deribit_current['market'].to_list())]
iv_asset_contracts

	market	time	database_time	iv_bid	iv_ask	iv_mark	exchange_time
0	deribit-BTC-12FEB24-41000-C-option	2024-02-12 00:00:00+00:00	2024-02-12 00:00:15.649992+00:00	0.0	0.0	0.677	2024-02-12 00:00:13.899000+00:00
1	deribit-BTC-12FEB24-41000-P-option	2024-02-12 00:00:00+00:00	2024-02-12 00:00:14.602653+00:00	0.0	2.1273	0.677	2024-02-12 00:00:13.900000+00:00
2	deribit-BTC-12FEB24-42000-C-option	2024-02-12 00:00:00+00:00	2024-02-12 00:00:03.599239+00:00	0.0	3.0076	0.6176	2024-02-12 00:00:02.821000+00:00
3	deribit-BTC-12FEB24-42000-P-option	2024-02-12 00:00:00+00:00	2024-02-12 00:00:03.599239+00:00	0.0	2.1175	0.6176	2024-02-12 00:00:00.808000+00:00
4	deribit-BTC-12FEB24-42500-C-option	2024-02-12 00:00:00+00:00	2024-02-12 00:00:12.040598+00:00	0.0	0.0	0.5786	2024-02-12 00:00:09.872000+00:00
...	...	...	...	...	...	...	...
1001	deribit-BTC-29MAR24-80000-P-option	2024-02-12 00:00:00+00:00	2024-02-12 00:00:16.038858+00:00	0.0	0.8866	0.6928	2024-02-12 00:00:13.898000+00:00
1002	deribit-BTC-29MAR24-85000-C-option	2024-02-12 00:00:00+00:00	2024-02-12 00:00:04.033371+00:00	0.7072	0.7288	0.7195	2024-02-12 00:00:03.827000+00:00
1003	deribit-BTC-29MAR24-85000-P-option	2024-02-12 00:00:00+00:00	2024-02-12 00:00:10.038068+00:00	0.0	0.8934	0.7194	2024-02-12 00:00:08.863000+00:00
1004	deribit-BTC-29MAR24-90000-C-option	2024-02-12 00:00:00+00:00	2024-02-12 00:00:04.033371+00:00	0.7248	0.7476	0.7409	2024-02-12 00:00:02.820000+00:00
1005	deribit-BTC-29MAR24-90000-P-option	2024-02-12 00:00:00+00:00	2024-02-12 00:00:11.038214+00:00	0.0	0.9518	0.7408	2024-02-12 00:00:09.870000+00:00

1006 rows × 7 columns

iv_only = iv_asset_contracts.drop(['time', 'database_time','iv_bid','iv_ask','exchange_time'], axis=1).drop_duplicates()
iv_only

	market	iv_mark
0	deribit-BTC-12FEB24-41000-C-option	0.677
1	deribit-BTC-12FEB24-41000-P-option	0.677
2	deribit-BTC-12FEB24-42000-C-option	0.6176
3	deribit-BTC-12FEB24-42000-P-option	0.6176
4	deribit-BTC-12FEB24-42500-C-option	0.5786
...	...	...
1001	deribit-BTC-29MAR24-80000-P-option	0.6928
1002	deribit-BTC-29MAR24-85000-C-option	0.7195
1003	deribit-BTC-29MAR24-85000-P-option	0.7194
1004	deribit-BTC-29MAR24-90000-C-option	0.7409
1005	deribit-BTC-29MAR24-90000-P-option	0.7408

1006 rows × 2 columns

merged = pd.merge(deribit_current, iv_only, on="market").drop_duplicates()

calls = pd.DataFrame(merged.loc[merged['option_contract_type'] == 'call'])

calls['expiration'] = pd.to_datetime(calls['expiration']).dt.strftime('%b %d, %Y')
calls = calls.dropna(subset=['strike'])
calls['strike'] = calls['strike'].astype('int64')
calls['iv_mark'] = calls['iv_mark'].astype('float64')
calls['expiration'] = calls['expiration'].astype('category')
calls = calls.dropna(subset=['strike', 'iv_mark'])
calls = calls[np.isfinite(calls['strike']) & np.isfinite(calls['iv_mark'])]
calls

	market	min_time	max_time	expiration	option_contract_type	strike	iv_mark
0	deribit-BTC-12FEB24-41000-C-option	2024-02-09 08:03:00+00:00	2024-02-12 08:00:00+00:00	Feb 12, 2024	call	41000	0.6770
1	deribit-BTC-12FEB24-48750-C-option	2024-02-11 08:03:00+00:00	2024-02-12 08:00:00+00:00	Feb 12, 2024	call	48750	0.3703
3	deribit-BTC-12FEB24-49000-C-option	2024-02-09 08:03:00+00:00	2024-02-12 08:00:00+00:00	Feb 12, 2024	call	49000	0.3908
5	deribit-BTC-12FEB24-49250-C-option	2024-02-11 08:14:00+00:00	2024-02-12 08:00:00+00:00	Feb 12, 2024	call	49250	0.4235
7	deribit-BTC-12FEB24-49500-C-option	2024-02-09 08:03:00+00:00	2024-02-12 08:00:00+00:00	Feb 12, 2024	call	49500	0.4815
...	...	...	...	...	...	...	...
994	deribit-BTC-27DEC24-105000-C-option	2023-12-28 08:02:00+00:00	2024-02-13 17:43:00+00:00	Dec 27, 2024	call	105000	0.6558
996	deribit-BTC-27DEC24-110000-C-option	2023-12-28 08:02:00+00:00	2024-02-13 17:43:00+00:00	Dec 27, 2024	call	110000	0.6580
998	deribit-BTC-27DEC24-115000-C-option	2023-12-28 08:02:00+00:00	2024-02-13 17:43:00+00:00	Dec 27, 2024	call	115000	0.6633
1000	deribit-BTC-27DEC24-120000-C-option	2023-12-28 08:02:00+00:00	2024-02-13 17:43:00+00:00	Dec 27, 2024	call	120000	0.6656
1002	deribit-BTC-27DEC24-125000-C-option	2023-12-28 08:02:00+00:00	2024-02-13 17:43:00+00:00	Dec 27, 2024	call	125000	0.6690

503 rows × 7 columns

calls = calls.sort_values(by='expiration')

calls.dtypes

market                       string[python]
min_time                datetime64[ns, UTC]
max_time                datetime64[ns, UTC]
expiration                         category
option_contract_type         string[python]
strike                                int64
iv_mark                             float64
dtype: object

l = sns.lineplot(data=calls, x="strike", y="iv_mark", hue='expiration')
l.set_xlabel("\nStrike Price", fontsize = 17)
l.set_ylabel("Implied Volatility \n", fontsize = 17)
l.set_xlim([0, calls['strike'].max()])

l.set_xticks(l.get_xticks().tolist())
l.set_xticklabels(['${:,.0f}'.format(x) for x in l.get_xticks().tolist()],fontsize=14)
l.set_yticks(l.get_yticks().tolist())
l.set_yticklabels(['{:.2f}'.format(y) for y in l.get_yticks().tolist()],fontsize=14)
plt.setp(l.get_yticklabels()[0], visible=False)    
leg = plt.legend(loc='upper right',ncol=2,fontsize=13.5)
for text in leg.get_texts():
    text.set_color("white")
l.set_title('\n' + asset.upper() + ' Volatility Smiles\n', fontsize = 25)
plt.suptitle('\n\n         Deribit Options by Expiration',fontsize=16);

Plotting Calls vs. Puts by Open Interest

options_oi = client.get_market_open_interest(
    markets='deribit-*-option',
    limit_per_market=1,
    paging_from='end',
    start_time=end_date,
    page_size=10000
).to_dataframe()

options_oi['value_usd'] = pd.to_numeric(options_oi['value_usd'])
options_oi = options_oi.loc[options_oi['value_usd'] > 0]

options_oi = options_oi.sort_values('value_usd',ascending=False)

oi_only = options_oi[['market','contract_count','value_usd']]

oi_only

	market	contract_count	value_usd
1356	deribit-ETH-23FEB24-2400-C-option	97938.0	256834569.96
972	deribit-BTC-29MAR24-50000-C-option	5204.3	254888763.251
992	deribit-BTC-29MAR24-60000-C-option	4830.8	236604371.64
1716	deribit-ETH-29MAR24-3000-C-option	86689.0	227343636.28
994	deribit-BTC-29MAR24-65000-C-option	4572.5	223940793.825
...	...	...	...
1511	deribit-ETH-27DEC24-6000-P-option	1.0	2622.57
1599	deribit-ETH-27SEP24-7500-P-option	1.0	2622.53
1593	deribit-ETH-27SEP24-6000-P-option	1.0	2622.52
1177	deribit-ETH-15FEB24-2200-P-option	1.0	2622.37
1737	deribit-ETH-29MAR24-5000-P-option	1.0	2622.27

1387 rows × 3 columns

asset_deribit_oi = deribit_current[['market','expiration','strike','option_contract_type']]

oi_merged = pd.merge(asset_deribit_oi, oi_only, on="market").drop_duplicates()

oi_merged

	market	expiration	strike	option_contract_type	contract_count	value_usd
0	deribit-BTC-12FEB24-48750-C-option	2024-02-12T08:00:00.000000000Z	48750	call	61.3	2959931.187
1	deribit-BTC-12FEB24-48750-P-option	2024-02-12T08:00:00.000000000Z	48750	put	4.7	226944.294
2	deribit-BTC-12FEB24-49000-C-option	2024-02-12T08:00:00.000000000Z	49000	call	141.1	6813157.422
3	deribit-BTC-12FEB24-49250-C-option	2024-02-12T08:00:00.000000000Z	49250	call	6.6	318687.732
4	deribit-BTC-12FEB24-49500-C-option	2024-02-12T08:00:00.000000000Z	49500	call	28.6	1380979.028
...	...	...	...	...	...	...
820	deribit-BTC-27DEC24-120000-P-option	2024-12-27T08:00:00.000000000Z	120000	put	1.3	63681.397
821	deribit-BTC-27DEC24-125000-C-option	2024-12-27T08:00:00.000000000Z	125000	call	37.9	1856453.805
822	deribit-BTC-27DEC24-125000-P-option	2024-12-27T08:00:00.000000000Z	125000	put	1.6	78372.704
823	deribit-BTC-27DEC24-10000-P-option	2024-12-27T08:00:00.000000000Z	10000	put	20.7	1013795.748
824	deribit-BTC-27DEC24-28000-P-option	2024-12-27T08:00:00.000000000Z	28000	put	132.1	6470647.695

825 rows × 6 columns

oi_merged.expiration = pd.to_datetime(oi_merged.expiration).dt.strftime('%b %d, %Y')
oi_merged

	market	expiration	strike	option_contract_type	contract_count	value_usd
0	deribit-BTC-12FEB24-48750-C-option	Feb 12, 2024	48750	call	61.3	2959931.187
1	deribit-BTC-12FEB24-48750-P-option	Feb 12, 2024	48750	put	4.7	226944.294
2	deribit-BTC-12FEB24-49000-C-option	Feb 12, 2024	49000	call	141.1	6813157.422
3	deribit-BTC-12FEB24-49250-C-option	Feb 12, 2024	49250	call	6.6	318687.732
4	deribit-BTC-12FEB24-49500-C-option	Feb 12, 2024	49500	call	28.6	1380979.028
...	...	...	...	...	...	...
820	deribit-BTC-27DEC24-120000-P-option	Dec 27, 2024	120000	put	1.3	63681.397
821	deribit-BTC-27DEC24-125000-C-option	Dec 27, 2024	125000	call	37.9	1856453.805
822	deribit-BTC-27DEC24-125000-P-option	Dec 27, 2024	125000	put	1.6	78372.704
823	deribit-BTC-27DEC24-10000-P-option	Dec 27, 2024	10000	put	20.7	1013795.748
824	deribit-BTC-27DEC24-28000-P-option	Dec 27, 2024	28000	put	132.1	6470647.695

825 rows × 6 columns

oi_merged_sum = oi_merged.groupby(
        ['expiration', 'option_contract_type']).value_usd.sum().reset_index()

oi_merged_sum

	expiration	option_contract_type	value_usd
0	Apr 26, 2024	call	746759409.804
1	Apr 26, 2024	put	362391927.898
2	Dec 27, 2024	call	327845484.001
3	Dec 27, 2024	put	76852459.777
4	Feb 12, 2024	call	61221827.396
5	Feb 12, 2024	put	53636084.351
6	Feb 13, 2024	call	60612528.457
7	Feb 13, 2024	put	55888112.274
8	Feb 14, 2024	call	62115453.667
9	Feb 14, 2024	put	47578321.782
10	Feb 15, 2024	call	15652452.769
11	Feb 15, 2024	put	19036582.686
12	Feb 16, 2024	call	486055096.137
13	Feb 16, 2024	put	407674392.781
14	Feb 23, 2024	call	1849252067.898
15	Feb 23, 2024	put	1101826630.192
16	Jun 28, 2024	call	1703153232.984
17	Jun 28, 2024	put	446922981.015
18	Mar 01, 2024	call	150328051.677
19	Mar 01, 2024	put	105881633.482
20	Mar 29, 2024	call	2641595742.536
21	Mar 29, 2024	put	1245411237.802
22	Sep 27, 2024	call	480871248.568
23	Sep 27, 2024	put	169771991.037

calls_oi = pd.DataFrame(oi_merged_sum.loc[oi_merged_sum['option_contract_type'] == 'call'])
puts_oi = pd.DataFrame(oi_merged_sum.loc[oi_merged_sum['option_contract_type'] == 'put'])

# Convert 'expiration' to datetime and extract month
calls_oi['expiration'] = pd.to_datetime(calls_oi['expiration'])
calls_oi['Expiration Month'] = calls_oi['expiration'].dt.month

puts_oi['expiration'] = pd.to_datetime(puts_oi['expiration'])
puts_oi['Expiration Month'] = puts_oi['expiration'].dt.month

# Group by 'expiration_month' and sum 'value_usd'
calls_oi_grouped = calls_oi.groupby('Expiration Month')['value_usd'].sum()
puts_oi_grouped = puts_oi.groupby('Expiration Month')['value_usd'].sum()

# Convert Series to DataFrame and reset index
calls_oi_df = calls_oi_grouped.reset_index()
puts_oi_df = puts_oi_grouped.reset_index()

# Replace month numbers with month names
calls_oi_df['Expiration Month'] = calls_oi_df['Expiration Month'].apply(lambda x: calendar.month_name[x])
puts_oi_df['Expiration Month'] = puts_oi_df['Expiration Month'].apply(lambda x: calendar.month_name[x])

calls_oi_df

	Expiration Month	value_usd
0	February	2534909426.324
1	March	2791923794.213
2	April	746759409.804
3	June	1703153232.984
4	September	480871248.568
5	December	327845484.001

# Add a new column to distinguish between calls and puts
calls_oi_df['type'] = 'calls'
puts_oi_df['type'] = 'puts'

# Concatenate the dataframes
df = pd.concat([calls_oi_df, puts_oi_df])
df = df.rename(columns={"value_usd": "Open Interest (USD)"})

# Plot the bars side by side
p = sns.barplot(data=df, x='Expiration Month', y='Open Interest (USD)', hue='type', palette=['green', 'red'])
p.set_title('\nBTC Options Open Interest (USD)\nby Expiration Month\n',fontsize=16)
# Format y-axis in billions
fmt = '${x:,.0f}B'
p.legend_.remove()

tick = mtick.FuncFormatter(lambda x, pos: '${:,.2f}B'.format(x*1e-9))
p.yaxis.set_major_formatter(tick)

2024-02-13 13:18:16 INFO     Using categorical units to plot a list of strings that are all parsable as floats or dates. If these strings should be plotted as numbers, cast to the appropriate data type before plotting.
2024-02-13 13:18:16 INFO     Using categorical units to plot a list of strings that are all parsable as floats or dates. If these strings should be plotted as numbers, cast to the appropriate data type before plotting.