Tutorials

Follow along with our many cryptocurrency and spreadsheet tutorials.

John Young avatar C
77 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
John Young avatar
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
John Young avatar
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.
John Young avatar
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...
John Young avatar
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.
John Young avatar
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.
John Young avatar
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...
John Young avatar
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...
John Young avatar
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...
John Young avatar
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 ...
John Young avatar
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 ...
John Young avatar
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...
John Young avatar
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...
John Young avatar
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...
John Young avatar
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...
John Young avatar
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...
John Young avatar
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...
John Young avatar
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...
John Young avatar
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...
John Young avatar
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...
John Young avatar
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...
John Young avatar
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...
John Young avatar
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...
John Young avatar
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...
John Young avatar
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.
John Young avatar
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...
John Young avatar
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...
John Young avatar
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...
John Young avatar
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.
John Young avatar
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. ...
John Young avatar
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'...
John Young avatar
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...
John Young avatar
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...
John Young avatar
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.
John Young avatar
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.
John Young avatar
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...
John Young avatar
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...
John Young avatar
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_...
John Young avatar
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...
John Young avatar
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.
John Young avatar
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...
John Young avatar
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...
John Young avatar
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 ...
John Young avatar
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...
John Young avatar
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...
John Young avatar
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...
John Young avatar
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...
John Young avatar
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...
John Young avatar
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 ...
John Young avatar
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...
John Young avatar
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...
John Young avatar
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.
John Young avatar
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...
John Young avatar
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...
John Young avatar
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...
John Young avatar
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...
John Young avatar
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...
John Young avatar
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...
John Young avatar
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 ...
John Young avatar
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...
John Young avatar
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