Overview

  • The data is provided by Coin Metrics under their Community Network Data plan.

  • All assets (coins and tokens) data are available for free. Data is updated every 6 hours. Historical data is also available.

  • Syntax is as simple as =CRYPTOFINANCE("COINMETRICS:BTC", "tx_count")

  • The following 74 assets are supported: ADA, AE, AION, ANT, BAT, BCH, BNB, BSV, BTC, BTG, BTM, CENNZ, CTXC, CVC, DAI, DASH, DCR, DGB, DOGE, DRGN, ELF, ENG, EOS, ETC, ETH, ETHOS, FUN, GAS, GNO, GNT, GUSD, ICN, ICX, KCS, KNC, LOOM, LRC, LSK, LTC, MAID, MANA, MTL, NAS, NEO, OMG, PAX, PAY, PIVX, POLY POWR, PPT, QASH, REP, RHOC, SALT, SNT, SRN, TRX, TUSD, USDC, USDT, VEN, VERI, VTC, WAVES, WTC, XEM, XLM, XMR, XRP, XVG, ZEC, ZIL, ZRX.

  • 16 data points are available: tx_volume_usd, adjusted_tx_volume_usd, tx_count, marketcap_usd, price_usd, exchange_volume_usd, realized_cap_usd, generated_coins, fees, active_addresses, average_difficulty, payment_count, median_tx_value_usd, median_fee, block_size, block_count.

Demo Sheets

ProTip Use FileMake a copy… to save a copy and be able to change content. Blue cells can be changed to visualize different assets and other network data.

Price to Transaction Count Correlation

Here is a sheet to visualize the price to transaction count correlation:

Bitcoin Price to Transaction Count Correlation

Comparing BTC, BCH, BSV Active Addresses

A sheet useful to measure actual usage, understand the adoption of the original chain and its main forks:

Bitcoin Price to Transaction Count Correlation

Bitcoin Transaction Count

Here is how to get Bitcoin transaction count over the last 24 hours:

=CRYPTOFINANCE("COINMETRICS:BTC", "tx_count")

Historical Bitcoin Transaction Count

This will return the number of transaction which have happened the January 12th 2019:

=CRYPTOFINANCE("COINMETRICS:BTC", "tx_count", "2019-01-12")

Bitcoin Active Addresses Count

Here is how to get the number of Bitcoin current number of active addresses:

=CRYPTOFINANCE("COINMETRICS:BTC", "active_addresses")

Historical Bitcoin Active Addresses Count

This will return the number of Bitcoin active addresses as of January 12th 2019:

=CRYPTOFINANCE("COINMETRICS:BTC", "active_addresses", "2019-01-12")

Going Further: More than Bitcoin, more data points

You can extend the syntaxes shown above for all supported assets and data points as listed in the Overview section.

When no data is available a hyphen (-) will be returned.