Cryptofinance
Open CryptowatchCreate AccountPricingContact Us
Search
⌃K
Links

Bitcoin and Cryptocurrency Network Data

Google Sheets & Excel
Airtable

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("BTC", "tx_count")
  • The following 74 assets are supported: 1INCH, AAVE, ADA, ALPHA, ANT, BAL, BAT, BCH, BNB, BNB_BC, BNB_ETH, BNB_MAINNET, BSV, BTC, BTG, BUSD, COMP, CRO, CRV, CVC, DAI, DASH, DCR, DGB, DGX, DOGE, DOT, DRGN, ELF, ENG, EOS, EOS_ETH, ETC, ETH, ETHOS, FTT, FUN, FXC, GAS, GNO, GNT, GRIN, GUSD, HBTC, HEDG, HT, HUSD, ICP, KCS, KNC, LEND, LEO_EOS, LEO_ETH, LINK, LOOM, LPT, LSK, LTC, MAID, MANA, MCO, MKR, NEO, NXM, OMG, PAX, PAXG, PAY, PERP, PIVX, POLY, POWR, PPT, QASH, REN, RENBTC, REP, SAI, SNT, SNX, SRM, SUSHI, SWRV, TRX, TRX_ETH, TUSD, UMA, UNI, USDC, USDK, USDT, USDT_ETH, USDT_OMNI, USDT_TRX, VTC, WAVES, WBTC, WETH, WNXM, WTC, XAUT, XEM, XLM, XMR, XRP, XTZ, XVG, YFI, ZEC, ZRX.
  • 16 data points are available: tx_volume_usd, adjusted_tx_volume_usd, tx_count, marketcap_usd, realized_cap_usd, generated_coins, fees, active_addresses, average_difficulty, payment_count, median_tx_value_usd, median_fee, block_size, block_count, circulating_supply, active_supply.
​

Bitcoin Transaction Count

Here is how to get Bitcoin transaction count over the last 24 hours:
=CRYPTOFINANCE("BTC", "tx_count")
​

Historical Bitcoin Transaction Count

This will return the number of transaction which have happened the January 12th 2019:
=CRYPTOFINANCE("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("BTC", "active_addresses")
​

Historical Bitcoin Active Addresses Count

This will return the number of Bitcoin active addresses as of January 12th 2019:
=CRYPTOFINANCE("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.
​

Demo Sheets (Gsheet Only)

ProTip — Use File › Make 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
Currently not available for Airtable. Coming soon...

​

Order Books Data - Previous
Market Order Book
Next
Max Supply
Last modified 21d ago