![](\"https://5264302.fs1.hubspotusercontent-na1.net/hubfs/5264302/Demo%20Asset%20Resources/Demo%20Covers/CM-Demo-hourly_metrics-Cover.png\")
"
]
},
{
"cell_type": "markdown",
"id": "89eb16ba-bd1b-45d4-8712-5c2fb4cd2782",
"metadata": {},
"source": [
"## Resources\n",
"This notebook demonstrates basic functionality offered by the Coin Metrics Python API Client and Network Data Pro.\n",
"\n",
"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.\n",
"\n",
"To understand the data that Coin Metrics offers, feel free to peruse the resources below.\n",
"\n",
"- The [Coin Metrics API v4](https://docs.coinmetrics.io/api/v4) website contains the full set of endpoints and data offered by Coin Metrics.\n",
"- The [Coin Metrics Product Documentation](https://docs.coinmetrics.io/info) gives detailed, conceptual explanations of the data that Coin Metrics offers.\n",
"- The [API Spec](https://docs.coinmetrics.io/python-api-client/reference) contains a full list of functions."
]
},
{
"cell_type": "markdown",
"id": "06730858-745f-46f8-a214-bbf39688b3be",
"metadata": {},
"source": [
"### Notebook Setup"
]
},
{
"cell_type": "code",
"execution_count": 1,
"id": "0a61aa94-e083-4921-96c7-7afa1467e8b3",
"metadata": {},
"outputs": [],
"source": [
"from os import environ\n",
"import pandas as pd\n",
"import numpy as np\n",
"import seaborn as sns\n",
"import logging\n",
"from datetime import date, datetime, timedelta\n",
"from coinmetrics.api_client import CoinMetricsClient\n",
"import logging\n",
"import matplotlib.pyplot as plt\n",
"import matplotlib\n",
"from matplotlib.ticker import FuncFormatter\n",
"import warnings\n",
"%matplotlib inline"
]
},
{
"cell_type": "code",
"execution_count": 2,
"id": "e2960161-c675-4672-9ee0-2c58a2919936",
"metadata": {},
"outputs": [],
"source": [
"logging.basicConfig(\n",
" format='%(asctime)s %(levelname)-8s %(message)s',\n",
" level=logging.INFO,\n",
" datefmt='%Y-%m-%d %H:%M:%S'\n",
")\n",
"matplotlib.rcParams['font.family'] = 'arial'"
]
},
{
"cell_type": "code",
"execution_count": 3,
"id": "6f0ef85f-ac93-490d-b3f2-88961ad93eef",
"metadata": {},
"outputs": [
{
"name": "stderr",
"output_type": "stream",
"text": [
"2024-10-04 11:52:04 INFO Using API key found in environment\n"
]
}
],
"source": [
"# We recommend privately storing your API key in your local environment.\n",
"try:\n",
" api_key = environ[\"CM_API_KEY\"]\n",
" logging.info(\"Using API key found in environment\")\n",
"except KeyError:\n",
" api_key = \"\"\n",
" logging.info(\"API key not found. Using community client\")\n",
"client = CoinMetricsClient(api_key)"
]
},
{
"cell_type": "markdown",
"id": "cd6107e4-5d86-4b4b-a381-6a7c574e4bad",
"metadata": {},
"source": [
"# Hourly Metrics"
]
},
{
"cell_type": "markdown",
"id": "6869a873-d9a4-44e8-9279-603e68f826df",
"metadata": {},
"source": [
"Coin Metrics is pleased to announce the release of a new set of hourly metrics for **Network Data Pro**. This feature unlocks a new level granularity for our existing suite of on-chain metrics. \n",
"\n",
"Previously, our Network Data Pro offering provided both Daily (EOD) and Block-by-Block (BBB) aggregations of on-chain metrics. Now, users have the ability to capture on-chain activity at an intermediate frequency, providing timely insights into metrics like Active Address Count, Transaction Fees, and more."
]
},
{
"cell_type": "markdown",
"id": "0c43bbdd-cb1b-44d3-8ff7-6d6ff81a01d4",
"metadata": {},
"source": [
"### Retrieve Hourly Metrics Catalog"
]
},
{
"cell_type": "code",
"execution_count": 4,
"id": "5822c994-1f9d-4830-92ee-aa5e47f466b7",
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"['AdrActBlobCnt',\n",
" 'AdrActBlobContRecCnt',\n",
" 'AdrActBlobRecCnt',\n",
" 'AdrActBlobSendCnt',\n",
" 'AdrActCnt',\n",
" 'AdrActRecCnt',\n",
" 'AdrActSentCnt',\n",
" 'AssetCompletionTime',\n",
" 'BlkCnt',\n",
" 'BlkHgt',\n",
" 'BlkIntMean',\n",
" 'BlkSizeByte',\n",
" 'BlobARBSizeByte',\n",
" 'BlobBASESizeByte',\n",
" 'BlobCnt',\n",
" 'BlobContCnt',\n",
" 'BlobInscrCnt',\n",
" 'BlobL2SizeByte',\n",
" 'BlobMeanCnt',\n",
" 'BlobOPSizeByte',\n",
" 'BlobSizeAllTimeByte',\n",
" 'BlobSizeByte',\n",
" 'BlobUniqCnt',\n",
" 'DiffLast',\n",
" 'FeeBlobARBMeanNtv',\n",
" 'FeeBlobARBMeanUSD',\n",
" 'FeeBlobARBTotNtv',\n",
" 'FeeBlobARBTotUSD',\n",
" 'FeeBlobBASEMeanNtv',\n",
" 'FeeBlobBASEMeanUSD',\n",
" 'FeeBlobBASETotNtv',\n",
" 'FeeBlobBASETotUSD',\n",
" 'FeeBlobByteMeanNtv',\n",
" 'FeeBlobByteMeanUSD',\n",
" 'FeeBlobL2MeanNtv',\n",
" 'FeeBlobL2MeanUSD',\n",
" 'FeeBlobL2TotNtv',\n",
" 'FeeBlobL2TotUSD',\n",
" 'FeeBlobMeanNtv',\n",
" 'FeeBlobMeanUSD',\n",
" 'FeeBlobMedNtv',\n",
" 'FeeBlobMedUSD',\n",
" 'FeeBlobOPMeanNtv',\n",
" 'FeeBlobOPMeanUSD',\n",
" 'FeeBlobOPTotNtv',\n",
" 'FeeBlobOPTotUSD',\n",
" 'FeeBlobTotNtv',\n",
" 'FeeBlobTotUSD',\n",
" 'FeeBlobTxMeanNtv',\n",
" 'FeeBlobTxMeanUSD',\n",
" 'FeeMeanNtv',\n",
" 'FeeMeanUSD',\n",
" 'FeeMedNtv',\n",
" 'FeeMedUSD',\n",
" 'FeePrioMeanNtv',\n",
" 'FeePrioMeanUSD',\n",
" 'FeePrioMedNtv',\n",
" 'FeePrioMedUSD',\n",
" 'FeePrioTotNtv',\n",
" 'FeePrioTotUSD',\n",
" 'FeeTotNtv',\n",
" 'FeeTotUSD',\n",
" 'PriceBTC',\n",
" 'PriceUSD',\n",
" 'ROI1yr',\n",
" 'ROI30d',\n",
" 'RevNtv',\n",
" 'RevUSD',\n",
" 'SplyBurntNtv',\n",
" 'SplyBurntUSD',\n",
" 'StakingAPRNominal',\n",
" 'StakingAPYNominal',\n",
" 'TxBlobARBCnt',\n",
" 'TxBlobBASECnt',\n",
" 'TxBlobCnt',\n",
" 'TxBlobContCnt',\n",
" 'TxBlobInscrCnt',\n",
" 'TxBlobL2Cnt',\n",
" 'TxBlobMeanCnt',\n",
" 'TxBlobOPCnt',\n",
" 'TxCnt',\n",
" 'TxTfrCnt',\n",
" 'TxTfrValMeanNtv',\n",
" 'TxTfrValMeanUSD',\n",
" 'TxTfrValMedNtv',\n",
" 'TxTfrValMedUSD',\n",
" 'TxTfrValNtv',\n",
" 'TxTfrValUSD',\n",
" 'ValidatorAPRNominal',\n",
" 'ValidatorAPYNominal']"
]
},
"execution_count": 4,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"asset_metrics_reference = client.reference_data_asset_metrics(page_size=10000).to_dataframe()\n",
"list_metrics_nd = list(asset_metrics_reference.loc[asset_metrics_reference['product']=='Network Data', 'metric'])\n",
"\n",
"asset_metrics_catalog = client.catalog_asset_metrics_v2(\n",
" assets='eth', \n",
" metrics=list_metrics_nd, \n",
" page_size=10000\n",
").to_list()\n",
"\n",
"\n",
"list_hourly_metrics_nd = []\n",
"for asset in asset_metrics_catalog:\n",
" for metric in asset['metrics']:\n",
" if 'frequencies' in metric.keys():\n",
" for frequency in metric.get('frequencies'):\n",
" if '1h' in frequency.values():\n",
" list_hourly_metrics_nd.append(metric['metric'])\n",
"\n",
"# # alternatively, use this dataframe. note this is only doable starting coinmetrics-api-client version 2024.10.4.15\n",
"# asset_metrics_catalog = client.catalog_asset_metrics_v2(page_size=10000).to_dataframe()\n",
"# list_hourly_metrics_nd = list(asset_metrics_catalog.loc[asset_metrics_catalog.frequency=='1h', 'metric'].unique())"
]
},
{
"cell_type": "markdown",
"id": "6aa5656c-c063-40b7-9d87-55f0b0328a5b",
"metadata": {},
"source": [
"# Example Analyses"
]
},
{
"cell_type": "code",
"execution_count": 6,
"id": "e3d80216-a3ee-494d-89c8-2b6c61b8c76b",
"metadata": {},
"outputs": [],
"source": [
"start = datetime.utcnow() - timedelta(days=7)"
]
},
{
"cell_type": "markdown",
"id": "b0b2e936-cbab-4ba4-8f99-5dae25be5ff5",
"metadata": {},
"source": [
"## ETH Fee Burn vs. Tx Count"
]
},
{
"cell_type": "markdown",
"id": "0db5c5dc-d0d3-4eea-8cf4-48f98ed238ba",
"metadata": {},
"source": [
"First, we'll examine the relationship between Ethereum's transaction count (**TxCnt**) and the amount of ETH being \"burned,\" or removed from circulation (**SplyBurntNtv**). \n",
"\n",
"Since the introduction of EIP-1559, Ethereum has segmented gas fees into two separate fees: the \"base fee\" and the \"priority tip.\" While the priority tip is rewarded to validators, the base fee is burnt. Over the long-term, this has enabled ETH to offer a deflationary monetary policy, with periods of high transaction activity permanently destroying units of ETH and lowering the total circulating supply. \n",
"\n",
"For more details on the impact of EIP-1559, check out [**State of the Network #166: Ethereum After EIP-1559**](https://coinmetrics.substack.com/p/state-of-the-network-issue-166)"
]
},
{
"cell_type": "code",
"execution_count": 7,
"id": "a61aac69-19aa-4fcc-8393-928c8d8391e2",
"metadata": {},
"outputs": [],
"source": [
"fee_burn_and_tx_metrics = client.get_asset_metrics(\n",
" assets='eth',\n",
" metrics=['TxCnt','SplyBurntNtv'],\n",
" start_time = start,\n",
" frequency='1h'\n",
").to_dataframe()"
]
},
{
"cell_type": "code",
"execution_count": 8,
"id": "c6b3abe4-a5e7-4685-a7f6-5e59e6fb499d",
"metadata": {},
"outputs": [],
"source": [
"fee_burn_and_tx_metrics['time'] = pd.to_datetime(fee_burn_and_tx_metrics['time'])"
]
},
{
"cell_type": "code",
"execution_count": 9,
"id": "bf37f911-07aa-48ff-8e54-831a2fb3bd3f",
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"| \n", " | SplyBurntNtv | \n", "TxCnt | \n", "
|---|---|---|
| time | \n", "\n", " | \n", " |
| 2024-09-27 17:00:00+00:00 | \n", "-70.397819 | \n", "53103 | \n", "
| 2024-09-27 18:00:00+00:00 | \n", "-50.973631 | \n", "52695 | \n", "
| 2024-09-27 19:00:00+00:00 | \n", "-129.348614 | \n", "49882 | \n", "
| 2024-09-27 20:00:00+00:00 | \n", "-64.472321 | \n", "52184 | \n", "
| 2024-09-27 21:00:00+00:00 | \n", "-39.452127 | \n", "50770 | \n", "
| ... | \n", "... | \n", "... | \n", "
| 2024-10-04 11:00:00+00:00 | \n", "-19.116498 | \n", "48958 | \n", "
| 2024-10-04 12:00:00+00:00 | \n", "-27.192417 | \n", "49215 | \n", "
| 2024-10-04 13:00:00+00:00 | \n", "-39.860415 | \n", "49662 | \n", "
| 2024-10-04 14:00:00+00:00 | \n", "-48.651027 | \n", "51090 | \n", "
| 2024-10-04 15:00:00+00:00 | \n", "-58.644727 | \n", "51400 | \n", "
167 rows × 2 columns
\n", "| \n", " | asset | \n", "BlkIntMean | \n", "FeeMedUSD | \n", "
|---|---|---|---|
| time | \n", "\n", " | \n", " | \n", " |
| 2024-09-27 17:00:00+00:00 | \n", "btc | \n", "16.208333 | \n", "1.289085 | \n", "
| 2024-09-27 18:00:00+00:00 | \n", "btc | \n", "5.725 | \n", "1.061119 | \n", "
| 2024-09-27 19:00:00+00:00 | \n", "btc | \n", "12.443333 | \n", "0.405089 | \n", "
| 2024-09-27 20:00:00+00:00 | \n", "btc | \n", "5.090909 | \n", "0.317237 | \n", "
| 2024-09-27 21:00:00+00:00 | \n", "btc | \n", "10.326667 | \n", "0.339649 | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "
| 2024-10-04 10:00:00+00:00 | \n", "btc | \n", "8.87619 | \n", "0.126917 | \n", "
| 2024-10-04 11:00:00+00:00 | \n", "btc | \n", "5.666667 | \n", "0.183543 | \n", "
| 2024-10-04 12:00:00+00:00 | \n", "btc | \n", "15.95 | \n", "0.208127 | \n", "
| 2024-10-04 13:00:00+00:00 | \n", "btc | \n", "5.711667 | \n", "0.175143 | \n", "
| 2024-10-04 14:00:00+00:00 | \n", "btc | \n", "10.697222 | \n", "0.320860 | \n", "
166 rows × 3 columns
\n", "