Tutorials

Follow along with our many cryptocurrency and spreadsheet tutorials.

J C
78 articles in this collection
Written by John Young and Chris Ware
TokenAnalyst

Stablecoins Historical Exchange Balances

TokenAnalyst - Returns daily and hourly stablecoin balances of exchanges
J
Written by John Young
Updated over a week ago

Data Catalog

TokenAnalyst - Returns an array of supported possible values for a given parameter of a defined datasets in the data catalog
J
Written by John Young
Updated over a week ago

ETH Total Rewards

TokenAnalyst - Returns the daily coinbase rewards. The block_reward (incl. uncle rewards) is denominated ETH.
J
Written by John Young
Updated over a week ago

ETH Total Hashrate

TokenAnalyst - Returns the daily hashrate and blocks mined for a given day. The hashrate is denominated in TH/s and block_count is the to...
J
Written by John Young
Updated over a week ago

BTC Full Historical Balance

TokenAnalyst - This endpoint returns the full historical on-chain balance of Bitcoin exchanges.
J
Written by John Young
Updated over a week ago

Miners to Exchanges Full Historical Flows

TokenAnalyst - This endpoint returns the full historical flows from miners to exchanges that we have labelled.
J
Written by John Young
Updated over a week ago

Miner Full Historical Outflow

TokenAnalyst - This endpoint returns the outflow of a given token out of miner controlled wallets during the time period specified. Miner...
J
Written by John Young
Updated over a week ago

Miner Full Historical Inflow

TokenAnalyst - This endpoint returns the inflow of a given token into miner controlled wallets during the time period specified. Miner wa...
J
Written by John Young
Updated over a week ago

ERC20 Full Historical Flows Out Of Exchanges [Beta]

TokenAnalyst - This endpoint returns the outflow of ETH from exchange wallets. The avg_txn_value, outflow, and number_of_txns are calcula...
J
Written by John Young
Updated over a week ago

ERC20 Full Historical Flows Into Exchanges [Beta]

TokenAnalyst - This endpoint returns the inflow of ERC20 tokens into exchange wallets. The avg_txn_value, inflow, and number_of_txns are ...
J
Written by John Young
Updated over a week ago

Tether (Omni) Full Historical Top 10 Outflow Large Value Transactions

TokenAnalyst - This endpoint returns the top 10 transactions (in terms of total USDT sent) flowing out of exchange wallets for every day ...
J
Written by John Young
Updated over a week ago

Tether (Omni) Full Historical Top 10 Inflow Large Value Transactions

TokenAnalyst - This endpoint returns the top 10 transactions (in terms of total USDT sent) flowing into exchange wallets for every day th...
J
Written by John Young
Updated over a week ago

Stablecoins Full Historical Outflow from Exchanges [Beta]

TokenAnalyst - This endpoint returns the inflow of stablecoins into exchange wallets. The avg_txn_value, inflow, and number_of_txns are c...
J
Written by John Young
Updated over a week ago

Stablecoins Full Historical Inflow from Exchanges [Beta]

TokenAnalyst - This endpoint returns the inflow of stablecoins into exchange wallets. The avg_txn_value, inflow, and number_of_txns are c...
J
Written by John Young
Updated over a week ago

ETH Full Historical Top 10 Outflow Large Value Transactions

TokenAnalyst - This endpoint returns the top 10 transactions (in terms of total ETH sent) flowing out of exchange wallets for every day t...
J
Written by John Young
Updated over a week ago

ETH Full Historical Top 10 Inflow Large Value Transactions

TokenAnalyst - This endpoint returns the top 10 transactions (in terms of total ETH sent) flowing into exchange wallets for every day tha...
J
Written by John Young
Updated over a week ago

ETH Full Historical Flows Out Of Exchanges

TokenAnalyst - This endpoint returns the outflow of ETH from exchange wallets. The avg_txn_value, outflow, and number_of_txns are calcula...
J
Written by John Young
Updated over a week ago

ETH Full Historical Flows Into Exchanges

TokenAnalyst - This endpoint returns the inflow of ETH into exchange wallets. The avg_txn_value, inflow, and number_of_txns are calculate...
J
Written by John Young
Updated over a week ago

BTC Full Historical Top 10 Outflow Large Value Transactions

TokenAnalyst - This endpoint returns the top 10 transactions (in terms of total BTC sent) flowing out of exchange wallets for every day t...
J
Written by John Young
Updated over a week ago

BTC Full Historical Top 10 Inflow Large Value Transactions

TokenAnalyst - This endpoint returns the top 10 transactions (in terms of total BTC sent) flowing into exchange wallets for every day tha...
J
Written by John Young
Updated over a week ago

BTC Full Historical Outflows from Exchanges

TokenAnalyst - This endpoint returns the outflow of BTC from exchange wallets for as far back as we track. The average outflow is the ave...
J
Written by John Young
Updated over a week ago

BTC Full Historical Inflow to Exchanges

TokenAnalyst - This endpoint returns the inflow of BTC into exchange wallets for as far back as we track. The average inflow is the avera...
J
Written by John Young
Updated over a week ago

Stablecoin Active addresses

TokenAnalyst - This endpoint returns the active addresses of stabelecoin tokens for every day of their existence. An address is defined a...
J
Written by John Young
Updated over a week ago

Stablecoin On Chain Transaction Count

TokenAnalyst - This endpoint returns the number of token transfers on the Ethereum blockchain for the given stablecoin you select for eve...
J
Written by John Young
Updated over a week ago

Stablecoin On Chain Volume

TokenAnalyst - This endpoint returns the full historical on-chain volume of any of the stablecoins that we support.
J
Written by John Young
Updated over a week ago

Tether (Omni) Fees

TokenAnalyst - This endpoint returns the historical supply of Tether (usdt_omni) on the OMNI blockchain for every day of it's existence 2...
J
Written by John Young
Updated over a week ago

Tether (Omni) NVT

TokenAnalyst - This endpoint returns the NVT Ratio (Network Value to Transactions Ratio) for Tether (usdt_omni). This is the ratio of the...
J
Written by John Young
Updated over a week ago

Tether (ERC20) Supply

TokenAnalyst - This endpoint returns the historical supply of the Tether ERC20 token (usdt_erc20) on the Ethereum blockchain for every da...
J
Written by John Young
Updated over a week ago

Tether (Omni) Supply

TokenAnalyst - This endpoint returns the historical supply of Tether (usdt_omni) on the OMNI blockchain for every day of it's existence.
J
Written by John Young
Updated over a week ago

Tether (Omni) Active Addresses

TokenAnalyst - This endpoint returns the active addresses of Tether (usdt_omni) tokens for every day of it's existence since 2014-10-06. ...
J
Written by John Young
Updated over a week ago

Tether (Omni) On Chain Transaction Count

TokenAnalyst - This endpoint returns the daily number of Tether (usdt_omni) transactions on the full Omni blockchain for every day of it'...
J
Written by John Young
Updated over a week ago

Tether (Omni) On Chain Volume

TokenAnalyst - This endpoint returns the full historical on-chain volume of Tether on the OMNI blockchain since it went live on 2014-10-0...
J
Written by John Young
Updated over a week ago

ERC20 Active addresses

TokenAnalyst - This endpoint returns the active addresses of ERC20 tokens for every day of their existence. An address is defined as 'act...
J
Written by John Young
Updated over a week ago

ERC20 On Chain Transaction Count

TokenAnalyst - This endpoint returns the number of token transfers on the blockchain for the given token for every day since its existence.
J
Written by John Young
Updated over a week ago

ERC20 On Chain Volume

TokenAnalyst - This endpoint returns the full historical on-chain volume of any of the major ERC20 tokens that we support.
J
Written by John Young
Updated over a week ago

ETH Miner Rewards

TokenAnalyst - This endpoint returns the daily block rewards and uncle rewards by miner. The miner_daily_block_reward and miner_daily_unc...
J
Written by John Young
Updated over a week ago

ETH Miner Hashrate

TokenAnalyst - This endpoint returns the total and miner specifc hashrate and uncle rates. The total_daily_hashrate and the miner_daily_h...
J
Written by John Young
Updated over a week ago

ETH Fees

TokenAnalyst - This endpoint returns the total and average fees spent on the Ethereum network for every day of it's existence. The total_...
J
Written by John Young
Updated over a week ago

ETH NVT

TokenAnalyst - This endpoint returns the NVT Ratio (Network Value to Transactions Ratio) for ETH. This is the ratio of the Market Cap div...
J
Written by John Young
Updated over a week ago

ETH Supply

TokenAnalyst - This endpoint returns the historical supply of ETH on the Ethereum blockchain for every day of its existence.
J
Written by John Young
Updated over a week ago

ETH Active addresses

TokenAnalyst - This endpoint returns the active addresses on the Ethereum blockchain for every day of its existence. An address is define...
J
Written by John Young
Updated over a week ago

ETH On Chain Transaction Count

TokenAnalyst - This endpoint returns the number of transactions, where ETH value transferred was > 0, on the full historical Ethereum blo...
J
Written by John Young
Updated over a week ago

ETH On Chain Volume

TokenAnalyst - This endpoint returns the full historical on-chain volume of Ethereum since it went live in 2015. The volume is separated ...
J
Written by John Young
Updated over a week ago

BTC UTXO Supply Percentage

TokenAnalyst - This endpoint returns the proportion of the bitcoin supply on the specified date, held in unspent transaction outputs stra...
J
Written by John Young
Updated over a week ago

BTC UTXO Weighted Average Age

TokenAnalyst - For instance outputs in the category 12-18m are unspent outputs (UTXOs) from transactions that occurred 12-18m ago. Time i...
J
Written by John Young
Updated over a week ago

BTC UTXO Total Value

TokenAnalyst - This endpoint returns the total BTC value of the bitcoin supply at the specified date, held in unspent transaction outputs...
J
Written by John Young
Updated over a week ago

BTC UTXO Median Age

TokenAnalyst - This endpoint returns the median age of the bitcoin supply at the specified date, held in unspent transaction outputs stra...
J
Written by John Young
Updated over a week ago

BTC UTXO Count

TokenAnalyst - This endpoint returns the count of unspent transaction outputs (UTXOs) at the specified date, stratified by their age. For...
J
Written by John Young
Updated over a week ago

BTC UTXO Average Value

TokenAnalyst - This endpoint returns the average value of unspent transaction outputs (UTXOs) at the specified date, stratified by their ...
J
Written by John Young
Updated over a week ago

BTC UTXO Average Age

TokenAnalyst - This endpoint returns the average age of the bitcoin supply at the specified date, held in unspent transaction outputs str...
J
Written by John Young
Updated over a week ago

BTC Spent Outputs Profit Ratio

TokenAnalyst - This endpoint returns the historical spent outputs profit ratio (SOPR) as defined by Renato Shirakashi. The data starts fr...
J
Written by John Young
Updated over a week ago

BTC Miner Rewards

TokenAnalyst - This endpoint returns the daily coinbase rewards by miner (incl. txn fees). The miner_daily_block_reward is denomiated BTC.
J
Written by John Young
Updated over a week ago

BTC Miner Hashrate

TokenAnalyst - This endpoint returns the daily and miner specifc hashrates. The total_daily_hashrate and the miner_daily_hashrate are den...
J
Written by John Young
Updated over a week ago

BTC UTXO Age

TokenAnalyst - This endpoint returns the proportion of the current bitcoin supply held in unspent transaction outputs stratified by their...
J
Written by John Young
Updated over a week ago

BTC Fees

TokenAnalyst - This endpoint returns the total and average fees spent on the Bitcoin network for every day of it's existence. The total_f...
J
Written by John Young
Updated over a week ago

BTC NVT

TokenAnalyst - This endpoint returns the NVT Ratio (Network Value to Transactions Ratio) for BTC. This is the ratio of the Market Cap div...
J
Written by John Young
Updated over a week ago

BTC Supply

TokenAnalyst - This endpoint returns the historical supply of BTC on the Bitcoin blockchain for each day of its existence. This is the su...
J
Written by John Young
Updated over a week ago

BTC Active addresses

TokenAnalyst - This endpoint returns the daily number of active addresses on the Bitcoin blockchain for each day of its existence. An add...
J
Written by John Young
Updated over a week ago

BTC On Chain Transaction Count

TokenAnalyst - This endpoint returns the daily number of transactions on the full historical Bitcoin blockchain for every day since it's ...
J
Written by John Young
Updated over a week ago

BTC On Chain Volume

TokenAnalyst - This endpoint returns the full historical on-chain volume of Bitcoin since it's genesis in 2009. The volume is separated i...
J
Written by John Young
Updated over a week ago

TokenAnalyst data in Excel & Googlesheets using Cryptosheets

How to pull TokenAnalyst data into Excel
C
Written by Chris Ware
Updated over a week ago