Blockchain Applications

Lecture 1: Blockchains and Crypto Markets as Data

Lecture 1: Blockchains and Crypto Markets as Data

Daniel Traian PELE

Bucharest University of Economic Studies
IDA Institute Digital Assets
Blockchain Research Center
Master Blockchain for Business (MBB), FABIZ
23 November 2026

Lecture Question and Outline

Slide 2 in the PDF

The lecture starts from a manager's question: what can be learned from the data that blockchain applications produce? On public blockchains such as Bitcoin and Ethereum, every on-chain transfer and every fee is public, carries the time of its block and can be downloaded at no cost. Other information stays hidden: the owners behind the addresses, the trades that happen inside an exchange, and everything recorded on permissioned or privacy-preserving chains.

The route has five parts. The first describes what a blockchain records and what it leaves out. The second measures the market: coins, stablecoins, decentralised finance (DeFi) and exchange-traded funds (ETFs). The third reads on-chain activity through transactions, fees, security and value. The fourth lists the data sources and shows how to check a data set before using it. The fifth introduces the tools for growth, log scales and growth rates. Lecture 2 then turns the same prices into returns and studies their statistical behaviour.

In brief

  • Question: what can a manager learn from the data that blockchain applications produce?
    • on public blockchains (Bitcoin, Ethereum), every on-chain transfer and fee is public, carries a block time and is free to download
    • what stays hidden: owners behind addresses, trades inside exchanges, permissioned and privacy-preserving chains
  • Outline
    • what a blockchain records, and what it does not
    • the market in numbers: coins, stablecoins, decentralised finance (DeFi), exchange-traded funds (ETFs)
    • on-chain activity: transactions, fees, security, value
    • where the data come from, and how to check them before use
    • tools for growth: log scales and growth rates
  • Next lecture: the statistical behaviour of crypto prices

Learning Outcomes

Slide 3 in the PDF
  • Explain what a blockchain records and why the record is public
  • Name the main data sources (explorers, aggregators, dashboards) and what each measures
  • Describe the size and concentration of the crypto market with market value, shares and the Herfindahl–Hirschman index (HHI)
  • Read on-chain activity charts: transactions, fees, hash rate, market value
  • Run a data-quality check on a crypto data set before any analysis
  • Compute and interpret growth rates on a log scale

Abbreviations

Slide 4 in the PDF
AIC Akaike information criterion
AR(1) first-order autoregressive (process)
bn billion
BTC bitcoin, the coin of the Bitcoin network
CAGR compound annual growth rate
CBECI Cambridge Bitcoin Electricity Consumption Index
CC0 Creative Commons Zero (public-domain dedication)
CC BY Creative Commons Attribution licence
CRIX CRypto IndeX (Trimborn & Härdle (2018))
DeFi decentralised finance
EH/s exahashes (\(10^{18}\) hashes) per second
EODHD EOD (end-of-day) Historical Data, data vendor
ETF exchange-traded fund
ETH Ether, the coin of the Ethereum network
FABIZ Faculty of Business Administration in Foreign Languages, ASE
HHI Herfindahl–Hirschman index
IBIT iShares Bitcoin Trust, a spot Bitcoin ETF
IDA Institute Digital Assets
iid independent and identically distributed
MAD median absolute deviation
MBB Master Blockchain for Business
MFM Modelling Financial Markets (master course; Quantlet prefix)
NFT non-fungible token
S&P 500 Standard & Poor's 500 US stock index
SE standard error
SEC US Securities and Exchange Commission
SQL Structured Query Language
TVL total value locked
US United States
USD US dollar
USDC USD Coin, a stablecoin
USDT Tether, a stablecoin
UTC Coordinated Universal Time
XRP the coin of the XRP Ledger

Reading and Tools

Slide 5 in the PDF

The core reading is the survey by Härdle, Harvey & Reule (2020), Understanding Cryptocurrencies, which covers the technology, the markets and the econometrics of crypto assets. Three video units of the Quantinar course Blockchain Analytics accompany the lecture. The data are of two kinds: daily on-chain series of Bitcoin and Ethereum from November 2014 to October 2025, from the ETH Chronicles project of the Institute Digital Assets (IDA), and market data on market value, stablecoins, DeFi and ETFs up to 18 September 2026, from DefiLlama and from the data vendor EOD Historical Data (EODHD). The notebook of Lecture 1 in the course repository computes every number and chart of the lecture and runs in Google Colab.

In brief

The public can see that someone is sending an amount to someone else, but without information linking the transaction to anyone. This is similar to the level of information released by stock exchanges, where the time and size of individual trades, the “tape”, is made public, but without telling who the parties were.

— Nakamoto (2008)

A public blockchain is a database that anyone can download. Every transfer of coins, every fee and every call to a smart contract is written into a block, and every block carries a time stamp. For an analyst this is unusual: in most markets the records of payments and positions are held by banks, brokers and exchanges, and only summaries are published. On Bitcoin and Ethereum the raw record itself is public, from the first block onwards.

This does not mean that everything is visible. The owners behind the addresses are not recorded, most trading happens inside exchanges and never reaches the chain, and the reserves of a stablecoin issuer sit in a bank account, not on the ledger. The lecture therefore asks a practical question: what can a manager learn from the data that blockchain applications produce, and what must be checked before these data support a conclusion?

The answer is built in five steps. The lecture first describes what a block records and which quantities, such as the difficulty and the coin supply, follow from the protocol. It then measures the size and concentration of the market, the growth of stablecoins and decentralised finance (DeFi), and the arrival of exchange-traded funds (ETFs). It reads four daily on-chain series of Bitcoin and Ethereum from November 2014 to October 2025, checks the data sources and their errors, and finally measures growth on a log scale, with a trend regression that is tested one year after the end of the sample.

Four views of a blockchain, daily, November 2014 – 8 October 2025, all on log scales: transactions per day and average fee per transaction (30-day means), the Bitcoin hash rate in exahashes per second (EH/s), and the market value in billions of US dollars (USD). The spike in the Bitcoin market value in 2023 is a recording error, not a market event.
Four views of a blockchain, daily, November 2014 – 8 October 2025, all on log scales: transactions per day and average fee per transaction (30-day means), the Bitcoin hash rate in exahashes per second (EH/s), and the market value in billions of US dollars (USD). The spike in the Bitcoin market value in 2023 is a recording error, not a market event.

What you will be able to do

  • Explain what a blockchain records and why the record is public.
  • Name the main data sources (explorers, aggregators, dashboards) and what each measures.
  • Describe the size and concentration of the crypto market with market value, shares and the Herfindahl–Hirschman index (HHI).
  • Read on-chain activity charts: transactions, fees, hash rate, market value.
  • Run a data-quality check on a crypto data set before any analysis.
  • Compute and interpret growth rates on a log scale.

The Appendix holds optional worked examples and checks.

Lecture plan

  1. What a Blockchain RecordsThe ledger, blocks and consensus as data; proof of work in numbers; block times and difficulty adjustments; the supply rule and miner revenue; what is on-chain and what is not.
  2. The Market in NumbersMarket value and concentration, the CRIX index, stablecoins, DeFi and spot Bitcoin ETFs.
  3. On-Chain ActivityTransactions, fees, hash rate and market value of Bitcoin and Ethereum; fees and congestion; whether value follows activity.
  4. Data Sources and Data QualityExplorers, aggregators and dashboards; four typical errors in on-chain data; a checklist; coverage coin by coin.
  5. Growth on a Log ScaleLog scales, log returns and why they add up, the compound annual growth rate, the log-linear trend and its forecast one year later.
  6. SummaryThe main numbers of the lecture and four interpretation exercises.
  7. Appendix: Further MaterialWorked examples on mining, index construction, TVL and outlier detection; history and background.

What a Blockchain Records

A blockchain is usually described through its cryptography. For data analysis the relevant question is different: which quantities does each part of the system leave in the public record, and which quantities follow from the protocol rules without any estimation? The section answers it for the ledger, the block, the consensus rule, smart contracts and layer-2 networks, and works out two quantities exactly: the hash rate implied by the difficulty and the supply of bitcoin.

Recap: Information Recorded on the Ledger

Slide 6 in the PDF

Hashing and consensus are covered in earlier courses; here each piece is read as a source of data. The ledger of a public blockchain is one list of transactions, copied on thousands of computers called nodes. Because every node holds the same list, anybody can read it. Records outside this list are not part of it: permissioned chains, privacy mechanisms and trades settled off the chain.

A block is a batch of transactions with a time stamp. Each block contains the hash of the previous block, a short fingerprint computed from its content. Changing an old transaction would change that block's hash and break the link to every later block, so tampering is visible; this is what "tamper-evident" means. The time stamp of a block records when a transfer entered the ledger, which can differ from the moment the two parties agreed on the exchange.

The consensus rule decides who adds the next block. Under proof of work, used by Bitcoin, miners compete with computing power, and the difficulty of the puzzle and the network's hash rate appear in the data. Under proof of stake, used by Ethereum since 15 September 2022, validators lock coins as a deposit (the stake), which also appears in the data; according to ethereum.org: The Merge, the switch cut Ethereum's energy use by more than 99.9%. A smart contract is a program stored on the chain, and its calls, such as deposits, loans and swaps, are on-chain records. A layer-2 network bundles many transactions and settles them on Ethereum in one batch, so only the settlement reaches the main chain.

In brief

  • Hashing and consensus were covered in earlier courses; here: what each piece produces as data
  • Ledger: a public blockchain keeps one public list of transactions, copied on thousands of computers (nodes)
    • permissioned chains, privacy mechanisms and off-chain trades are not in this public record
  • Block: a batch of transactions with a timestamp; it carries the hash (fingerprint) of the previous block, so old records are tamper-evident
    • the block time is when the transfer was recorded, not the exact time of the economic exchange
  • Consensus: the rule that decides who adds the next block
    • proof of work (Bitcoin): difficulty and hash rate are in the data (next slide)
    • proof of stake (Ethereum since 15 September 2022): the stake is in the data; energy use fell by more than 99.9% ethereum.org: The Merge
  • Smart contract: a program stored on the chain; its calls (deposits, loans, swaps) are on-chain data
  • Layer 2: a network that bundles many transactions and settles them on Ethereum; only the settlement reaches the main chain

Proof of Work in Numbers

Slide 7 in the PDF

In proof of work a block is valid only if the hash of its header, combined with a number chosen by the miner (the nonce), falls below a target \(T\). The hash function \(H\) behaves like a draw from the integers \(0, \dots, 2^{256}-1\), so one try succeeds with probability \(p = T/2^{256}\). The number of tries until the first success has a geometric distribution with mean \(1/p = 2^{256}/T\). The protocol publishes this target in a scaled form, the difficulty \(D = T_{\max}/T\), where \(T_{\max} \approx 2^{224}\) is the largest allowed target; the expected number of tries per block is then \(D \cdot 2^{32}\).

Bitcoin aims at one block every 600 seconds on average. Dividing the expected number of tries by 600 gives the hashes the network must compute per second, the hash rate:

\[\hat H = \frac{D \cdot 2^{32}}{600} \ \text{hashes per second}\]
(1.1)

On 8 October 2025 the published difficulty was \(D = 1.508 \times 10^{14}\). With \(2^{32} \approx 4.295 \times 10^{9}\), formula (1.1) gives \(1.08 \times 10^{21}\) hashes per second, that is 1,080 exahashes per second (EH/s), where one exahash is \(10^{18}\) hashes. The computing power behind the network is therefore measured from one public number, without surveying the miners.

The difficulty is not fixed. Every 2,016 blocks, which take 20,160 minutes at the target pace, the protocol multiplies the difficulty by 20,160 divided by the minutes the last 2,016 blocks actually took. When miners add machines, blocks arrive faster than planned and the difficulty rises at the next adjustment; when they switch machines off, it falls. The Appendix compares formula (1.1) with the hash rate reported by the data provider.

In brief

  • A block is valid if the hash of its header with a number (nonce) is below a target \(T\):
    \[ H(\text{header} \,\|\, \text{nonce}) < T, \qquad H \sim \text{Uniform}\{0, \dots, 2^{256} - 1\} \]
  • One try succeeds with probability \(p = T/2^{256}\); tries until success are geometric:
    \[ \mathrm{E}[\text{tries}] = \frac{1}{p} = \frac{2^{256}}{T} = D \cdot 2^{32}, \qquad D = \frac{T_{\max}}{T},\ T_{\max} \approx 2^{224} \]
    • \(D\): the difficulty, published in every block
  • One block every 600 seconds on average, hence the network hash rate
    \[ \hat H = \frac{D \cdot 2^{32}}{600} \ \text{hashes per second} \]
    • 8 October 2025: \(D = 1.508 \times 10^{14}\), so \(\hat H = 1.508 \times 10^{14} \times 4.295 \times 10^{9}/600 = 1.08 \times 10^{21}\) = 1 080 EH/s (exahashes per second)
    • every 2 016 blocks: \(D_{\text{new}} = D_{\text{old}} \times 20\,160\text{ min} / \text{actual minutes}\)

Block Intervals and the 10-Minute Target

Slide 8 in the PDF

Daily on-chain series record the mean time between Bitcoin blocks and the difficulty in force. The left panel shows the block time as a 30-day mean, from November 2014 to 8 October 2025, against the protocol target of 10 minutes (dashed red line). The right panel is a histogram of the 291 difficulty adjustments found in the data: each bar counts the epochs of 2,016 blocks whose difficulty changed by a given percentage at the start of the epoch.

Over the whole sample the mean time between blocks was 9.86 minutes, which corresponds to 146.1 blocks a day instead of the 144 of the target; the daily mean was below 10 minutes on 59% of the days. The reason is visible in the right panel. The median adjustment is +3.0% and 74% of the adjustments are upward: the hash rate grew almost continuously, so blocks arrived early within each epoch and the next adjustment raised the difficulty. Because the protocol corrects only after 2,016 blocks, it is always one step behind a growing network.

The largest fall of the difficulty, −27.9%, came at the epoch starting on 4 July 2021, after China's ban on mining switched off a large part of the hash rate: on the Cambridge Bitcoin Electricity Consumption Index (CBECI) mining map, China's share of the hash rate falls to zero in July 2021. With fewer machines and an unchanged difficulty, blocks slowed down: the 30-day mean block time reached 13.4 minutes that month, the highest value in the sample, until the adjustment restored the pace.

In brief

Block Intervals and the 10-Minute Target
  • Left: daily mean time between Bitcoin blocks, 30-day mean, November 2014 – 8 October 2025; right: the 291 difficulty adjustments in the data (% change at each new epoch of 2 016 blocks)
  • Mean time between blocks 9.86 minutes: 146.1 blocks a day against the target of 144; below 10 minutes on 59% of the days
  • Median adjustment \(+3.0\%\); 74% of the adjustments go up: the hash rate keeps growing, blocks come early, and the difficulty catches up
  • Largest fall \(-27.9\%\) (epoch starting 4 July 2021, after China's mining ban; China's share of the hash rate fell to zero in July 2021, CBECI mining map); the 30-day mean block time reached 13.4 minutes that month
BA_L1_blocktime

Worked Example: One Difficulty Adjustment

Slide 9 in the PDF

The adjustment rule can be read backwards. Every 2,016 blocks the protocol sets \(D_{\text{new}} = D_{\text{old}} \times 20\,160/m\), where \(m\) is the number of minutes the last 2,016 blocks took and 20,160 minutes is what they would take at exactly 10 minutes each. Knowing the two difficulties is therefore enough to recover how long the previous epoch lasted.

The last adjustment in the data moved the difficulty from \(D_{\text{old}} = 1.4234 \times 10^{14}\), in force from 19 September 2025, to \(D_{\text{new}} = 1.5084 \times 10^{14}\), from 2 October 2025. The first step is the factor \(D_{\text{new}}/D_{\text{old}} = 1.5084/1.4234 = 1.0597\), a rise of 5.97%. The second step solves the rule for the minutes: \(m = 20{,}160/1.0597 = 19{,}024\) minutes, or 13.21 days instead of 14. The third step divides by the number of blocks: \(19{,}024/2{,}016 = 9.44\) minutes between blocks.

Daily mean block times give 9.52 minutes for 19 September to 1 October 2025. The small difference comes from the calendar: daily means cover whole days, while the epoch starts and ends inside a day. After the adjustment, the same hash rate needs 10 minutes per block again; if the hash rate keeps growing, the next epoch is early again.

In brief

  • Rule: every 2 016 blocks, \(D_{\text{new}} = D_{\text{old}} \times 20\,160 / m\), with \(m\) the minutes the last 2 016 blocks took
  • Data: \(D_{\text{old}} = 1.4234 \times 10^{14}\) (epoch from 19 September 2025), \(D_{\text{new}} = 1.5084 \times 10^{14}\) (from 2 October 2025)
  • Step 1: factor \(D_{\text{new}}/D_{\text{old}} = 1.5084/1.4234 = 1.0597\); the difficulty rises by 5.97%
  • Step 2: solve for the minutes, \(m = 20\,160/1.0597 = 19\,024\) minutes \(= 13.21\) days instead of 14
  • Step 3: mean time between blocks \(= 19\,024/2\,016 = 9.44\) minutes
    • daily mean block times give 9.52 minutes for 19 September – 1 October 2025; days do not start and end with the epoch
  • Reading: the new difficulty brings the same hash rate back to 10 minutes per block; if the hash rate keeps growing, the next epoch is early again

The Supply Rule

Slide 10 in the PDF

New bitcoins enter circulation as a reward to the miner of each block, the block subsidy. The subsidy depends only on the block height \(h\), the number of blocks since the first one: it started at 50 BTC and is halved every 210,000 blocks, roughly every four years. The subsidies so far have been 50, 25, 12.5, 6.25 and, since April 2024, 3.125 BTC. Written as a formula, \(s(h) = 50 \cdot 2^{-\lfloor h/210\,000 \rfloor}\) BTC, where \(\lfloor \cdot \rfloor\) rounds down to an integer.

Each period of 210,000 blocks adds half as many coins as the previous one, so the total supply is a geometric series:

\[S_\infty = 210\,000 \sum_{k=0}^{\infty} 50 \cdot 2^{-k} = 210\,000 \times 50 \times 2 = 21 \text{ million BTC}\]
(1.2)

The supply growth rate measures how fast the stock of coins grows. After the 2024 halving, 144 blocks a day add \(3.125 \times 144 \times 365 = 164{,}250\) BTC a year. With \(S_t = 20.09\) million BTC in circulation on 18 September 2026, the annual growth rate is \(164{,}250 / 20.09 \text{ million} = 0.82\%\). This is the growth of the coin stock, not consumer-price inflation, so it cannot be compared with a central bank's 2% inflation target.

Because the supply path is known in advance, it cannot explain price surprises: a halving is announced years before it happens, and market participants can take it into account.

In brief

  • Block subsidy at block height \(h\): \(\;s(h) = 50 \cdot 2^{-\lfloor h/210\,000 \rfloor}\) BTC
    • halved every 210 000 blocks, about four years: 50, 25, 12.5, 6.25, 3.125 (April 2024)
  • Total supply, a geometric series:
    \[ S_\infty = 210\,000 \sum_{k=0}^{\infty} 50 \cdot 2^{-k} = 210\,000 \times 50 \times 2 = 21 \text{ million BTC} \]
  • Annual supply growth rate after the 2024 halving:
    \[ g_S = \frac{3.125 \times 144 \times 365}{S_t} = \frac{164\,250}{20.09 \times 10^{6}} = 0.82\% \]
    • 144 blocks a day; \(S_t = 20.09\) million BTC (coins in circulation) on 18 September 2026
    • growth of the coin stock, not consumer-price inflation: not comparable with a central bank's 2% inflation target
  • The supply path is known in advance: it cannot explain price surprises

Miner Revenue: Block Subsidy and Fees

Slide 11 in the PDF
    Question for the room In the last 30 days of the data fees are 0.23% of miner revenue. The ▶ button applies one to four further halvings to the subsidy, with prices and fees unchanged. What fee share do the same 30 days reach after four more halvings (subsidy 0.195 BTC per block)?
    Answer

    3.61%. Four halvings divide the subsidy by 2⁴ = 16, from 53.5 to 3.3 USD million a day, while fees stay at 0.13 USD million a day; the fee share roughly doubles with each halving (0.47%, 0.93%, 1.84%, 3.61%) as long as fees are small. Even then fees do not carry the network: revenue falls from 53.7 to 3.4 USD million a day. In the 30 days to 17 January 2018, the highest fee share of the sample (17.9%), the same four halvings would give 78%.

    Miners are paid in two ways: the block subsidy, newly created bitcoins, and the fees attached to the transactions they include. Both can be measured from public data. Per day, the subsidy in USD is the number of blocks times the subsidy per block times the Bitcoin price, and the fees in USD are the number of transactions times the average fee. The number of blocks per day follows from the mean block time (\(1\,440\) minutes divided by the mean block time), the subsidy follows the halving dates of 9 July 2016, 11 May 2020 and 20 April 2024, and the price is the EODHD daily close.

    The left panel shows the two parts of miner revenue as 30-day means on a log scale; the right panel shows fees as a share of revenue. Fees were 10.4% of revenue in 2017, 4.0% in 2023 and 0.4% in 2025; the highest month was December 2017, at 15.7%, when blocks were full and users competed for space. In the 30 days to 8 October 2025 fees were only 0.23% of revenue: miners earned 53.7 million USD a day, almost all of it from the subsidy.

    This matters for the security of the network. The hash rate that protects Bitcoin is paid for by miner revenue, often called the security budget. Each halving cuts the subsidy in bitcoins by half, so the budget in USD holds up only if the price rises; once the subsidy becomes small, fees will have to carry the network.

    In brief

    • Miner revenue per day = subsidy (blocks \(\times\) subsidy \(\times\) price) + fees (transactions \(\times\) average fee); on-chain series to 8 October 2025, EODHD closes
    • Fees as a share of miner revenue: 10.4% in 2017, 4.0% in 2023, 0.4% in 2025; highest month December 2017 (15.7%)
    • 30 days to 8 October 2025: fees are 0.23% of revenue; miners earn 53.7 million USD a day, almost all of it from the subsidy
    • Each halving cuts the subsidy in BTC by half: the security budget depends on the price, and on fees once the subsidy is small
    BA_L1_fee_share

    Worked Example: One Day of Miner Revenue

    Slide 12 in the PDF

    The computation behind the chart can be done by hand for one day, 8 October 2025. The first step counts the blocks: the mean block time was 9.73 minutes, so the network produced \(1{,}440/9.73 = 148.0\) blocks. The second step values the subsidy: \(148.0 \times 3.125 = 462.5\) BTC, which at the close of 123,355 USD is 57.1 million USD.

    The third step values the fees: 427,326 transactions at an average fee of 0.350 USD give 0.150 million USD. The fourth step gives the fee share, \(0.150/(57.1 + 0.150) = 0.26\%\). On this day almost all of the miners' income was new coins.

    At the next halving the subsidy falls to 1.5625 BTC per block. With the same price and the same fees, revenue would fall from 57.2 to 28.7 million USD a day, and the fee share would only double, to 0.52%. Fees at today's level are far from replacing the subsidy; either the price or the demand for block space has to rise for the security budget to stay where it is.

    In brief

    • Bitcoin, 8 October 2025
    • Step 1, blocks: mean block time 9.73 minutes, so \(1\,440/9.73 = 148.0\) blocks
    • Step 2, subsidy: \(148.0 \times 3.125 = 462.5\) BTC; at the close of 123 355 USD, 57.1 million USD
    • Step 3, fees: 427 326 transactions \(\times\) 0.350 USD \(=\) 0.150 million USD
    • Step 4, fee share: \(0.150/(57.1 + 0.150) = 0.26\%\)
    • After the next halving (subsidy 1.5625 BTC), with the same price and fees
      • revenue falls from 57.2 to 28.7 million USD a day
      • the fee share doubles to 0.52%: still far from replacing the subsidy

    On-Chain and Off-Chain Information

    Slide 13 in the PDF

    The table divides the information about a public blockchain into two groups. On-chain, and so public, are every transfer with its sender address, receiver address, amount and time; the fees, block sizes and block times; the supply of each coin and token; the calls to smart contracts; and the mining or staking power. Off-chain, and so private or only partly known, are the identity of the owner of an address, the trades inside an exchange (which keeps its own internal ledger), the reserves that back a stablecoin, the prices on exchanges, where each venue has its own, and the business purpose of a transaction.

    Two consequences follow for analysis. First, addresses are pseudonymous: an address is not an entity such as an exchange or a fund, and an entity is not the economic owner, such as the exchange's client. Analytics firms group addresses into entities with clustering rules, and these groupings contain errors. Second, most trading takes place on centralised exchanges, off the chain. On-chain data therefore show settlement, the final transfer of coins, but not all of the trading behind it.

    In brief

    On-chain (public blockchains)Off-chain (private or partial)
    every transfer: sender address, receiver address, amount, timewho owns an address: names are not recorded
    fees paid, block size, block timetrades inside an exchange (one internal ledger)
    supply of each coin and tokenreserves backing a stablecoin
    smart-contract calls: deposits, loans, swapsprices on exchanges (each venue has its own)
    mining or staking power (hash rate, stake)the business purpose of a transaction
    • Addresses are pseudonymous: address \(\neq\) entity (an exchange, a fund) \(\neq\) economic owner (the client); analytics firms cluster addresses into entities, with errors
    • Most trading happens off-chain, on centralised exchanges: on-chain data show settlement, not all trading

    Section summary

    The ledger provides a complete and public record of transfers, fees, supply and computing power. Some quantities, such as the hash rate and the supply, follow from protocol rules and published numbers. Ownership, exchange trading and stablecoin reserves stay off the chain and must come from other sources.

    The Market in Numbers

    The section measures the size and structure of the crypto market with a few standard tools: market value, value shares, a concentration index and a market index. It then looks at three applications that brought crypto assets closer to traditional finance: stablecoins, decentralised finance and spot exchange-traded funds.

    Market Value of Five Selected Coins and Bitcoin's Share

    Slide 14 in the PDF
      Question for the room On 18 September 2026 Bitcoin holds 82.5% of the value of the five selected coins. What is the effective number of coins, 1/HHI, of this basket?
      Answer

      1.42. The shares are 82.5% (Bitcoin), 16.2% (Ethereum), 0.7% (Dogecoin), 0.4% (Cardano) and 0.2% (Litecoin); the HHI, the sum of the squared shares, is 0.71, and 1/0.71 = 1.42. The basket has five coins, but its value behaves like that of 1.42 coins of equal size. 1/0.825 = 1.21 would count Bitcoin alone; the Ethereum share adds 0.162² = 0.026 to the HHI.

      The market value of coin \(i\) on day \(t\) is its price in USD times the number of coins in circulation, \(M_{i,t} = P_{i,t} \times Q_{i,t}\). The chart stacks the market values of five coins with a public circulating supply: Bitcoin (BTC), Ether (ETH), Dogecoin (DOGE), Cardano (ADA) and Litecoin (LTC). These five are a selection, not the five largest coins of the market. The lower panel shows Bitcoin's share of the five-coin total.

      Together, the five coins were worth 1,970 billion USD on 18 September 2026; their peak was 3,135 billion on 6 October 2025. Bitcoin alone was worth 1.63 trillion USD, 82.5% of the basket, and its share has moved between 55.8% and 88.5% since 2018. This is Bitcoin's share of the basket, not of the whole crypto market, which contains many more coins.

      The chart also shows what drives the market value. The number of coins changes slowly, so the large swings in the stacked areas come almost entirely from prices.

      In brief

      • Market value of coin \(i\): \(M_{i,t} = P_{i,t} \times Q_{i,t}\), the price in USD times the coins in circulation
        • five selected coins with a public circulating supply (BTC, ETH, DOGE, ADA, LTC), not the five largest
        • together: 1 970 billion USD on 18 September 2026; peak 3 135 billion on 6 October 2025
        • Bitcoin: 1.63 trillion USD, 82.5% of this five-coin basket (55.8% to 88.5% since 2018); not its share of the whole market
      • The value moves with prices; supply changes slowly
      MFM_ch16_market_value

      Concentration of the Five-Coin Basket

      Slide 15 in the PDF

      A single number for concentration is the Herfindahl–Hirschman index (HHI), the measure competition authorities use for market concentration. With \(w_i\) the value share of coin \(i\) and \(N\) the number of coins,

      \[\mathrm{HHI} = \sum_{i=1}^{N} w_i^2, \qquad w_i = \frac{M_i}{\sum_j M_j}\]
      (1.3)

      The index ranges from \(1/N\), when all shares are equal, to 1, when one coin holds everything. Its inverse, \(1/\mathrm{HHI}\), is the effective number of coins: the number of equal-sized coins that would give the same concentration.

      The worked example uses shares of 82.5%, 15% and 2.5%. Squaring and adding gives \(0.681 + 0.023 + 0.001 = 0.70\), and the effective number is \(1/0.70 = 1.4\): these three coins are as concentrated as 1.4 coins of equal size. Squaring gives large shares much more weight than small ones, which is why the dominant coin decides the result.

      For the five selected coins on 18 September 2026, the HHI is 0.71 and the effective number 1.42. The value describes this basket only. Adding coins lowers the HHI: with eleven coins in September 2025 it was 0.58, as shown in the Appendix.

      In brief

      • Herfindahl–Hirschman index (HHI), the measure competition authorities use for market concentration
        \[ \mathrm{HHI} = \sum_{i=1}^{N} w_i^2, \qquad w_i = \frac{M_i}{\sum_j M_j} \]
        • \(w_i\): the value share of coin \(i\); \(N\): the number of coins
        • from \(1/N\) (equal shares) to 1 (one coin holds everything)
        • \(1/\mathrm{HHI}\): the effective number of coins
      • Worked example: shares 82.5%, 15% and 2.5%
        • \(\mathrm{HHI} = 0.825^2 + 0.15^2 + 0.025^2 = 0.681 + 0.023 + 0.001 = 0.70\)
        • effective number \(1/0.70 = 1.4\): these shares behave like 1.4 equal coins
      • The five selected coins (BTC, ETH, DOGE, ADA, LTC) on 18 September 2026: \(\mathrm{HHI} = 0.71\), effective number 1.42
        • a measure for this basket, not for the whole market; adding coins lowers it (eleven coins, September 2025: 0.58, Appendix)

      A Market Index: CRIX

      Slide 16 in the PDF
        Question for the room The ▶ button raises the number of constituents k of the second cap-weighted index from 1 to 4. How does its tracking error against the index of all five coins change?
        Answer

        It falls from 11.13% a year (Bitcoin alone) to 2.71% (top 2), 1.69% (top 3) and 0.90% (top 4). Bitcoin dominates the basket, but its share moved between 55.8% and 88.5% since 2018, so the Bitcoin-only index still departs from the five-coin index. The Akaike information criterion chooses k = 4. The tracking error measures the difference of the daily returns, not the volatility of the index: the five-coin index itself has a volatility of 65.7% a year.

        A market index summarises many prices in one series. CRIX, the CRypto IndeX of Trimborn & Härdle (2018), is value-weighted: each coin enters with its market value, so large coins move the index more. The number of coins in the index is not fixed in advance but chosen by a statistical rule, described in the Appendix.

        The chart applies the same construction to the five selected coins, rebalanced every month and set to 1,000 on 31 January 2018. Over \(T = 8.6\) years the index grew at a compound annual growth rate (CAGR), \((I_T/I_0)^{1/T} - 1\), of 21.4%, where \(I_0\) and \(I_T\) are the first and last index values. The annualised volatility of its daily returns, a measure of how much the returns vary, was 65.7%.

        An index built from coins that exist today suffers from survivorship bias. Coins that failed and disappeared are not in it, so its past returns are higher than what an investor could have earned by buying the index as it stood at each date.

        Lecture 3 returns to CRIX in full: how the index is constructed, the real CRIX data together with its volatility index, VCRIX, and nine other types of crypto indices.

        In brief

        • CRIX (CRypto IndeX) Trimborn & Härdle (2018): a value-weighted index of the largest coins; the number of coins is chosen by a statistical rule
        • Chart: the same construction on the five selected coins, monthly rebalancing, 1 000 on 31 January 2018
        • Five-coin index over \(T = 8.6\) years: compound annual growth rate (CAGR) \((I_T/I_0)^{1/T} - 1 = 21.4\%\); annualised volatility of daily returns 65.7%
        • Survivorship bias: an index of today's coins ignores the coins that died; past returns look better than an investor could have earned
        • Lecture 3: the full construction, the real CRIX data, its volatility index VCRIX, and nine other types of crypto indices
        MFM_ch16_crix

        Growth of Stablecoin Supply

        Slide 17 in the PDF
          Question for the room From 2 April 2022 to 19 August 2023 the supply of all USD stablecoins fell from 187 to 123 USD bn. How did the supply of Tether (USDT) change between the same dates?
          Answer

          It stayed about the same: 82.1 USD bn on 2 April 2022 and 82.8 USD bn on 19 August 2023. The fall came from the other issuers: USD Coin went from 52.2 to 25.4 USD bn and Dai from 9.2 to 3.9 USD bn. The issuers do not move in proportion, and the largest issuer did not account for the largest decline.

          A stablecoin is a token designed to keep a fixed price, usually 1 USD; Lectures 5 and 6 study how well they do so. According to DefiLlama, the total supply of stablecoins grew from 4.2 billion USD in January 2020 to 303 billion on 18 September 2026, about 73 times more.

          Two issuers dominate. Tether (USDT) had 183 billion USD in circulation, 61% of the total, and USD Coin (USDC) had 74 billion, 24%; together they hold 85%. The growth was not continuous: in 2022–2023 the supply fell from 187 to 123 billion USD, after the stablecoin TerraUSD collapsed and USDC briefly lost its peg to the dollar.

          In brief

          • Stablecoin: a token designed to keep a fixed price, usually 1 USD (Lectures 5 and 6)
          • Supply (DefiLlama): 4.2 billion USD in January 2020, 303 billion on 18 September 2026, about 73 times more
            • Tether (USDT) 183 billion (61%), USD Coin (USDC) 74 billion (24%): two issuers hold 85%
            • 2022–2023 dip: from 187 to 123 billion, after TerraUSD collapsed and USDC lost its peg
          MFM_ch16_stablecoins

          Stablecoin Issuers

          Slide 18 in the PDF
            Question for the room Between 1 April 2022 and 19 August 2023 the Tether share rose from 44.0% to 67.5% and the USD Coin share fell from 27.9% to 20.7%. What happened to the HHI of issuers?
            Answer

            It rose, from 0.282 to 0.500. Shares enter the index squared, so the largest share dominates it: 0.675² = 0.456 alone is above the April 2022 value. The two largest shares are enough to see the direction: in April 2022 the HHI could be at most 0.440² + 0.279² + 0.281² = 0.350, with all the remaining 28.1% held by a single issuer, and in August 2023 it is at least 0.456.

            The left panel shows the daily shares of Tether and USD Coin in all USD stablecoins from 2019 to 2026, and the dashed line their combined share; the right panel shows the HHI of the issuers, formula (1.3) applied to stablecoin supplies. Tether's share was 76.8% in January 2020, 44.0% in April 2022, 67.5% in August 2023 and 60.5% in September 2026; USD Coin's share at the same dates was 12.4%, 27.9%, 20.7% and 24.4%.

            The HHI at these four dates was 0.607, 0.282, 0.500 and 0.427. Concentration fell during the boom of 2021–2022, when USD Coin gained share from Tether, and rose again after USD Coin lost its peg in March 2023 (Lecture 5).

            In brief

            • Shares of all USD stablecoins (DefiLlama, daily, 2019–2026) and the HHI of issuers
            • Tether: 76.8% (January 2020), 44.0% (April 2022), 67.5% (August 2023), 60.5% (September 2026); USD Coin: 12.4%, 27.9%, 20.7%, 24.4%
            • HHI 0.607, 0.282, 0.500, 0.427: concentration fell during the 2021–2022 boom and rose again after the USDC depeg of March 2023 (Lecture 5)
            BA_L1_stablecoin_conc

            DeFi: Total Value Locked

            Slide 19 in the PDF
              Question for the room From the end of November 2021 to the end of September 2026, TVL fell from 174 to 88 USD bn. What does this chart allow us to conclude about the tokens deposited?
              Answer

              Not that half of the deposits left. TVL is the quantity of tokens times their price. With November 2021 as the base month, the Ether price falls to 0.56 of its level (4,632 to 2,611 USD) and TVL to 0.51 (174 to 88 USD bn). Most of the fall can come from lower prices; the chart alone cannot separate quantities from prices (the appendix of the lecture does this for a fixed-price TVL). Deposits did not rise either: TVL fell slightly more than the Ether price.

              Decentralised finance (DeFi) provides lending and trading through smart contracts, without a bank or broker. Its size is usually measured by the total value locked (TVL): the market value of the tokens deposited in DeFi protocols. According to DefiLlama, TVL was 0.6 billion USD in January 2020, reached 177 billion at its peak on 9 November 2021 and stood at 88 billion on 18 September 2026.

              The chart compares TVL with the Ether price, both as indices equal to 100 in January 2020 and on a log scale. TVL must be read with care. It is the quantity of tokens deposited times their prices, so it rises when token prices rise even if nobody deposits anything new, and the two lines in the chart move together. The Appendix estimates how much of the monthly variation in TVL comes from the Ether price.

              In brief

              • Total value locked (TVL): the value of tokens deposited in DeFi protocols (DefiLlama)
              • 0.6 billion USD in January 2020, 177 billion at the peak (9 November 2021), 88 billion today
              • Caution: TVL mixes deposits with token prices (Appendix)
              MFM_ch16_defi

              January 2024: Spot Bitcoin Exchange-Traded Funds

              Slide 20 in the PDF
                Question for the room Bitcoin and the ETF IBIT both start at 100 on 11 January 2024. Where is IBIT on 18 September 2026, compared with Bitcoin?
                Answer

                Slightly below: IBIT is at 172.8 and Bitcoin at 174.5, about 1% lower after 674 common trading days. The drift of ln(IBIT/Bitcoin), the slope of a linear trend in years, is −0.24% a year: the cost of holding Bitcoin through the fund. The fund holds the coins, so the two lines overlap, but not exactly; skipping weekends does not lift the ETF above Bitcoin, because both are compared on the same trading days.

                A spot exchange-traded fund (spot ETF) is a fund listed on a stock exchange that holds the asset itself, here bitcoins, rather than futures contracts on it. On 10 January 2024 the US Securities and Exchange Commission (SEC) approved 11 spot Bitcoin ETFs (SEC, 2024).

                The chart compares the price of Bitcoin with the share price of the ETF IBIT (iShares Bitcoin Trust), both set to 100 on 11 January 2024. The two lines overlap, which means the fund tracks the coin closely. The ETF is an off-chain application of an on-chain asset: pension funds and other investors that can hold only regulated securities can now hold Bitcoin through one.

                In brief

                • Spot ETF: an exchange-traded fund that holds the coins themselves SEC (2024)
                  • 10 January 2024: 11 spot Bitcoin ETFs approved in the US
                • Chart: Bitcoin and the ETF IBIT, both 100 on 11 January 2024; the two lines overlap
                • An off-chain application of an on-chain asset: pension funds can now hold Bitcoin through a regulated security
                MFM_ch16_etf

                Section summary

                Market value, shares and the HHI describe a market dominated by Bitcoin, with an effective number of coins below two in the selected basket. Stablecoin supply is concentrated in two issuers, TVL mixes deposits with prices, and an index of today's coins overstates past returns.

                On-Chain Activity

                The section reads four daily on-chain series for Bitcoin and Ethereum, transactions, fees, hash rate and market value, and asks whether the market value follows the activity on the network.

                Four Views of a Blockchain

                Slide 21 in the PDF
                  Question for the room With a 30-day mean, the Bitcoin fee peaks at 19.81 USD (13 January 2018). The ▶ button lengthens the window from 1 to 90 days. What happens to the highest Bitcoin fee in the fees panel?
                  Answer

                  It falls: from 92.37 USD with daily values to 28.75 USD (7 days), 19.81 USD (30 days) and 11.32 USD (90 days). A longer mean averages the peak days with calmer days, so the reported peak depends on the smoothing; the Ethereum peak falls from 37.88 to 19.39 USD. A quoted peak is only comparable with another peak smoothed in the same way.

                  The chart has four panels, each a daily series from November 2014 to 8 October 2025, from the ETH Chronicles project of the Institute Digital Assets (IDA). Bitcoin is in orange and Ethereum in purple. The top-left panel counts transactions per day and the top-right panel shows the average fee per transaction in USD, both as 30-day means; the bottom-left panel shows the Bitcoin hash rate in EH/s, and the bottom-right panel the market value in billions of USD.

                  All vertical axes are on log scales, where each step up multiplies the value by ten. This makes series that grew by factors of a thousand readable over the whole period; the section on log scales explains the reasoning. The red arrow in the market-value panel marks a recording error in the raw data, discussed in the section on data quality.

                  In brief

                  • Daily series, November 2014 – 8 October 2025, log scales; data: ETH Chronicles project (IDA)
                  BA_L1_onchain

                  Reading the Four Panels

                  Slide 22 in the PDF

                  Usage. Bitcoin recorded 93,112 transactions a day in January 2015 and 488,729 a day in September–October 2025 (30-day mean). Ethereum recorded 1.63 million a day, 3.3 times as many as Bitcoin. One possible reason is that smart contracts generate many small transactions, for example in trading and lending applications.

                  Fees. The average fee per transaction rises when the network is congested, because users bid for limited space in each block. The peaks were 19.81 USD for Bitcoin in January 2018 and 24.79 USD for Ethereum in November 2021. In October 2025 the averages were 0.27 USD for Bitcoin and 0.17 USD for Ethereum. For Ethereum, a possible explanation of the decline is that activity moved to layer-2 networks; the chart alone does not identify the cause.

                  Security. The Bitcoin hash rate rose from 0.30 to 1,079 EH/s, about 3,600 times. The cost of an attack, which requires a large share of this computing power, rose as well, but not in proportion: mining hardware became more efficient and energy prices changed. Value. On 8 October 2025 Bitcoin's market value was 2,442 billion USD and Ethereum's 620 billion.

                  In brief

                  • Usage: Bitcoin 93 112 transactions a day in January 2015, 488 729 in September–October 2025 (30-day mean)
                    • Ethereum: 1.63 million a day, 3.3 times Bitcoin; one possible reason: smart-contract use generates many small transactions
                  • Fees: average fee per transaction in USD, 30-day mean
                    • peaks in congestion: 19.81 USD (Bitcoin, January 2018), 24.79 USD (Ethereum, November 2021)
                    • October 2025: 0.27 USD (Bitcoin) and 0.17 USD (Ethereum)
                    • a possible explanation for Ethereum: activity moved to layer-2 networks; the chart alone does not identify the cause
                  • Security: the Bitcoin hash rate rose from 0.30 to 1 079 EH/s (exahashes per second), about 3 600 times
                    • the cost of an attack rose too, but not in proportion: hardware became more efficient and energy prices changed
                  • Value: Bitcoin 2 442 billion USD, Ethereum 620 billion on 8 October 2025

                  Block Utilisation and Transaction Fees

                  Slide 23 in the PDF

                  The fees panel showed that fees peak in some periods and fall in others. One explanation is congestion: a block can hold only a limited amount of data, and when more users want their transactions included, they offer higher fees to be served first. The chart tests this on monthly means: the horizontal axis is the mean size of a Bitcoin block, in thousands of bytes, and the vertical axis the average fee per transaction, on a log scale. Each of the 132 points is a month, coloured by year.

                  The points slope upward. The correlation of the logarithm of the fee with the logarithm of the block size is 0.65, and with the logarithm of transactions per day 0.63. In the quarter of months with the fullest blocks, at least 813 thousand bytes, the median fee was 1.88 USD; in the quarter with the emptiest blocks, at most 664 thousand bytes, it was 0.32 USD. December 2017, with blocks of 968 thousand bytes and an average fee of 16.63 USD, is the clearest case.

                  The chart shows an association of monthly averages, not a demand curve. Block size measures how much space was used, not how much users wanted; fees also depend on the price of Bitcoin, because they are quoted in USD, and on changes in the way transactions are written. The direction is nevertheless the one that the limited supply of block space predicts.

                  In brief

                  Block Utilisation and Transaction Fees
                  • One point per month, 132 months: Bitcoin mean block size (thousand bytes) and average fee per transaction (USD, log scale)
                  • Correlation of log fee with log block size 0.65; with log transactions per day 0.63
                  • Quarter of months with the fullest blocks (at least 813 thousand bytes): median fee 1.88 USD; emptiest quarter (at most 664): 0.32 USD
                  • Block space is limited, so users bid for it when demand is high (December 2017: 968 thousand bytes, 16.63 USD); an association of monthly means, not a demand curve
                  BA_L1_congestion

                  Market Value and Network Activity

                  Slide 24 in the PDF
                    Question for the room The ▶ button extends the sample month by month, from October 2016 to October 2025. Does the slope of the log-log line stay near the 3.6 of the full sample?
                    Answer

                    No. With the sample ending in October 2016 the slope is 0.95; it is 2.35 to October 2018, 3.28 to October 2021 and 3.59 to October 2025. The slope describes the association of two trending series over a given period; it is not a stable elasticity, and it is near the slope of 2 of Metcalfe's law only for samples ending in late 2017 or in 2018. Lecture 2 tests the relation formally.

                    The scatter plot puts the monthly mean of Bitcoin transactions per day on the horizontal axis and the monthly mean market value on the vertical axis, for 132 months; both axes are on log scales and the colour shows the year. On log axes, the correlation of the logarithms measures how closely the two series move together in percentage terms; it is 0.76.

                    The slope of a straight line fitted to the log values is 3.6. A slope on log-log axes is an elasticity: 1% more transactions goes with about 3.6% more market value. Network-value theories based on Metcalfe's law, which states that the value of a network grows with the square of the number of its users, predict a slope of 2.

                    The cloud of points is wide, however. In 2021–2025, the yellow and green points, the market value moved up and down without a matching change in activity. Two series that both trend upward can also look related without a direct link between them; Lecture 2 examines this problem.

                    In brief

                    • Monthly means, 132 months; both axes on log scales
                    • Correlation of the logs: 0.76
                    • Slope of the log-log line: 3.6
                      • 1% more transactions goes with about 3.6% more market value
                    • Network-value theories (Metcalfe's law) predict a slope of 2
                    • But the cloud is wide: in 2021–2025 value moved without more activity
                    • Two trending series can look related: Lecture 2 examines this
                    BA_L1_value_activity

                    Section summary

                    On-chain series show strong growth in usage, security and value, with fees that follow congestion. The link between activity and market value is positive but loose, and a correlation between two trending series is not evidence that one drives the other.

                    Data Sources and Data Quality

                    The numbers in this lecture come from public sources that differ in what they measure and how they compute it. The section lists the main sources, describes the kinds of errors that appear in crypto data, with examples from the series used in this lecture, and gives a checklist to find them.

                    Where the Data Come From

                    Slide 25 in the PDF

                    The table groups the sources by what they measure. Block explorers such as Etherscan and mempool.space show single transactions, addresses and contracts; they are used to check one transaction or one wallet. Aggregators such as CoinGecko, EODHD and Yahoo Finance combine prices, volumes and market values over many exchanges; they supply the returns, volatilities and correlations of Lectures 2 and 4. DefiLlama reports stablecoin supply, DeFi TVL and fees by protocol, used for stablecoins in Lectures 5 and 6. Dune lets users write Structured Query Language (SQL) queries on decoded blockchain tables, for custom on-chain measures. The Cambridge Bitcoin Electricity Consumption Index (CBECI) estimates the electricity used by Bitcoin mining, background for the energy cost of proof of work.

                    All five sources are free for daily series. They differ in the exchanges they cover, in the time at which the daily close is taken and in their definitions, so the same metric can differ from one provider to another. Providers also revise and relabel their series over time; an analyst therefore keeps a dated copy of every series used, so that the results can be reproduced.

                    In brief

                    SourceWhat it measuresUse in this course
                    Etherscan, mempool.spaceblock explorers: single transactions, addresses, contractscheck one transaction or one wallet
                    CoinGecko, EODHD, Yahoo Financeprices, volumes and market value aggregated over exchangesreturns, volatility, correlations (L2, L4)
                    DefiLlamastablecoin supply, DeFi TVL, fees by protocolstablecoins (L5, L6), DeFi
                    DuneStructured Query Language (SQL) queries on decoded blockchain tablescustom on-chain metrics
                    Cambridge Bitcoin Electricity Consumption Index (CBECI)electricity use of Bitcoin miningbackground: the energy cost of proof of work
                    • All five are free for daily series
                    • Sources differ in exchanges covered, close time and definitions: the same metric can differ across providers
                    • Providers revise and relabel series: keep a dated copy of every series analysed, so that results can be reproduced

                    Four Typical Errors in On-Chain Data

                    Slide 26 in the PDF

                    On-chain series reach the analyst through data providers that scrape blockchains and exchanges, merge sources and label the results. Each of these steps can introduce an error, and four kinds are common. The data used in this lecture contain an example of each.

                    A recording error is a value that cannot be right. In the lecture data the Bitcoin market value is more than 1,000 times too small on 11 days, from 27 August to 6 September 2023. On a linear scale the error hides among the large values; on a log scale it is a sharp drop and return (bottom-right panel of "Four Views of a Blockchain", red arrow). The usual treatment is to set such values to missing rather than to guess a correction.

                    A mislabelled series carries the wrong content under its name. In the lecture data the file labelled "transaction value" is identical, cell by cell, to the file labelled "transaction fee". Pairwise comparison of series reveals such copies; a series that duplicates another carries no information of its own and cannot be used.

                    A series that ends early has a last observation well before the others. The social-media counts in the lecture data stop on 14 March 2023; the last non-missing date of every series shows this, and any analysis that uses the series must end its sample there.

                    Missing values may be scattered or may grow until a series dies. The XRP transaction counts have 32% missing values since 2020 and none after November 2023; the share of missing values per year shows the pattern. A coin with such a gap is dropped from that series, while its other series, for example its market value, can still be used.

                    None of these errors stops a program from running. Each biases a result without any warning: a mean market value, a correlation or a growth rate computed on the uncorrected data is simply wrong.

                    In brief

                    • On-chain series are scraped, merged and relabelled by data providers; four kinds of error are common
                    ErrorExample in the lecture dataHow to detect itWhat to do
                    Recording errorBitcoin market value 1 000 times too small on 11 days, 27 August – 6 September 2023plot on a log scaleset the days to missing
                    Mislabelled seriesthe “transaction value” file equals the “transaction fee” filecompare series pairwisedo not use the series
                    Series that ends earlysocial-media counts stop on 14 March 2023last non-missing dateend the sample there
                    Missing valuesXRP transactions: 32% missing since 2020, none after November 2023share missing per yeardrop the coin from that series
                    • None of these errors stops a program from running; each biases a mean, a correlation or a growth rate without any warning

                    A Checklist Before Any Analysis

                    Slide 27 in the PDF

                    The checklist turns the four problems into routine steps. The calendar check asks whether there is one row per day, with no duplicate dates and no gaps; the daily Bitcoin series from 28 November 2014 to 8 October 2025, for example, has 3,968 days and no gaps. The coverage check records the first and last valid date of every series, and the missing-values check computes the share of missing values per series and per year. The units check asks whether a series is in USD or in coins, in billions or in units, per day or cumulative.

                    The outlier check plots every series on a log scale, where a jump by a factor of 100 stands out; such jumps are errors in the data, not news. The duplicates check looks for two identical series or a series copied into the wrong column. The source and definition check records which exchanges enter a price, at which time the daily close is taken and which set of addresses a measure covers. The coverage, missing-values, outlier and duplicates checks detect the four typical errors of the previous slide. The Appendix gives a formal rule for outliers.

                    In brief

                    1. Calendar: one row per day? duplicate dates? gaps? (Bitcoin, 28 November 2014 – 8 October 2025: 3 968 days, no gaps)
                    2. Coverage: first and last valid date of every series
                    3. Missing values: the share per series and per year
                    4. Units: USD or coins? billions or units? per day or cumulative?
                    5. Outliers: plot every series on a log scale; jumps of 100 times are errors, not news
                    6. Duplicates: two series that are identical, or a series copied into the wrong column
                    7. Source and definition: which exchanges, which close time, which address set
                    • Steps 2, 3, 5 and 6 detect the four typical errors of the previous slide

                    Coverage and Missing Values, Coin by Coin

                    Slide 28 in the PDF

                    The checklist asks for the coverage and the share of missing values of every series. The chart does both at once for the daily transaction counts: each row is a coin, each column a calendar year, and the number in a cell is the percentage of days of that year with no value (cells below 0.5% are left blank). The tickers are ETC for Ethereum Classic, BCH for Bitcoin Cash, ZEC for Zcash, BSV for Bitcoin SV and XMR for Monero. The first year starts on 28 November 2014 and the last ends on 8 October 2025.

                    Most gaps lie before the first value of a coin: Bitcoin Cash starts on 1 August 2017 and Bitcoin SV on 15 November 2018, when these chains split from Bitcoin. Once a series has started, it is almost complete: the share of missing days after the first value is between 0 and 0.2% for every coin except XRP. The XRP series misses 17.2% of the days after its start, with 9% missing in 2023 and no value at all in 2024 and 2025.

                    The consequence for an analysis is concrete. All 11 coins are observed together only from 15 November 2018 to 27 November 2023. A study that needs every coin on every day, a balanced panel, therefore has five years of data, not eleven; a study over the full period has to handle coins that enter and leave the sample.

                    In brief

                    Coverage and Missing Values, Coin by Coin
                    • Share of days with no value in the daily transaction counts, 11 coins by year (2014 from 28 November, 2025 to 8 October)
                      • ETC Ethereum Classic, BCH Bitcoin Cash, ZEC Zcash, BSV Bitcoin SV, XMR Monero
                    • Most gaps come before a coin's first value: BCH starts on 1 August 2017, BSV on 15 November 2018
                    • After its first value a coin misses 0–0.2% of the days, except XRP: 17.2%, with no value at all in 2024–2025
                    • All 11 coins are observed only from 15 November 2018 to 27 November 2023: a balanced panel is five years, not eleven
                    BA_L1_missing

                    Section summary

                    Free public sources cover most of what an analyst needs, but each has its own definitions and errors. Scaling errors, duplicated series, series that end early and growing gaps bias results without any warning; simple checks before the analysis find them.

                    Growth on a Log Scale

                    Crypto series grow by factors of hundreds or thousands, so the usual linear charts and percentage changes become hard to read. The section introduces the log scale and the log return, computes growth rates from two dates and from a trend regression, and tests the fitted trend on the year after the end of the sample.

                    Log Scales for Exponential Growth

                    Slide 29 in the PDF

                    On a linear axis a series that grows by a factor of 1,000 shows its early years as a flat line near zero. On a log scale, equal vertical distances mean equal ratios: the step from 1 to 10 has the same height as the step from 100 to 1,000, because both are a tenfold rise. A series that grows at a constant rate is therefore a straight line, and a change in its slope is a change in the growth rate.

                    The matching measure of change is the log return between two dates,

                    \[r = \ln\left(\frac{X_{\text{end}}}{X_{\text{start}}}\right)\]
                    (1.4)

                    Log returns add up over time: the log return of a year is the sum of its daily log returns. For small changes, \(r\) is close to the percentage change; for example, a rise from 100 to 101 gives \(r = \ln 1.01 \approx 0.00995\), close to 1%. The practical rule is to plot levels on a log scale and to analyse log returns, which Lecture 2 does.

                    In brief

                    • Crypto series grow by factors of 100 or 1 000: on a linear axis the early years are a flat line
                    • On a log scale, equal distances mean equal ratios
                      • 1 to 10 and 100 to 1 000 have the same height: both are a 10-fold rise
                      • a straight line means a constant growth rate
                    • Log return between two dates: \(r = \ln(X_{\text{end}}/X_{\text{start}})\)
                      • log returns add up over time: the return of a year is the sum of its daily log returns
                      • for small changes, \(r \approx\) the percentage change
                    • Rule: plot levels on a log scale, analyse log returns (Lecture 2)

                    One Series on a Linear and a Log Scale

                    Slide 30 in the PDF

                    The chart draws the same series twice: Bitcoin's market value, in monthly means from November 2014 to October 2025 (October covers 1–8 October), with the 11 erroneous days of 2023 excluded. The left panel uses a linear vertical axis, the right panel a log scale.

                    On the linear axis the first years almost vanish. January 2015, with a market value of 3.4 billion USD, is 0.14% of the October 2025 value of 2,421 billion USD; 54% of the months lie below a tenth of that value and look like a flat line near zero. The chart suggests that nothing happened before 2017, although the value grew about seventyfold between 2015 and the end of 2017.

                    On the log scale the dotted lines at 10, 100 and 1,000 billion USD are equally spaced, because each is ten times the previous one. Growth and falls of the same proportion now have the same height, wherever they happen. The fall from 256 billion USD in December 2017 to 65 billion in December 2018, −75%, is as visible as the booms of later years, while on the linear axis it is a small wiggle.

                    In brief

                    One Series on a Linear and a Log Scale
                    • Bitcoin market value, monthly means, November 2014 – October 2025 (October: 1–8 October), the 11 erroneous days of 2023 excluded
                    • Linear scale (left): January 2015, 3.4 billion USD, is 0.14% of the October 2025 value of 2 421 billion; 54% of the months sit below a tenth of that value and look flat
                    • Log scale (right): 10, 100 and 1 000 billion USD are equal steps; the fall from 256 (December 2017) to 65 billion (December 2018), \(-75\%\), is as visible as the later booms
                    BA_L1_logscale

                    Worked Example: Log Returns Add Up

                    Slide 31 in the PDF

                    Take three monthly means of Bitcoin's market value: 256.1 billion USD in December 2017, 64.8 billion in December 2018 and 403.1 billion in December 2020. The simple return of the first year is \(64.8/256.1 - 1 = -74.7\%\) and that of the next two years \(403.1/64.8 - 1 = +522.2\%\). Their sum, \(+447.5\%\), suggests a large gain, but the change from December 2017 to December 2020 is only \(403.1/256.1 - 1 = +57.4\%\). Simple returns do not add up over time.

                    Log returns do. Using formula (1.4), the first log return is \(\ln(64.8/256.1) = -1.375\) and the second \(\ln(403.1/64.8) = +1.828\). Their sum, \(+0.454\), equals \(\ln(403.1/256.1)\), the log return of the whole period, because the logarithm of a product is the sum of the logarithms. To return to a percentage change, take \(e^{0.454} - 1 = +57.4\%\), the same as the direct computation.

                    The rule follows: add log returns over time, average them, and convert to a percentage change only at the end. A fall of 74.7% followed by a rise of 522.2% is not a gain of 447.5%.

                    In brief

                    • Bitcoin market value, monthly means: 256.1 (December 2017), 64.8 (December 2018), 403.1 billion USD (December 2020)
                    • Simple returns: \(64.8/256.1 - 1 = -74.7\%\), then \(403.1/64.8 - 1 = +522.2\%\)
                      • their sum, \(+447.5\%\), is wrong: the two-year change is \(403.1/256.1 - 1 = +57.4\%\)
                    • Log returns: \(\ln(64.8/256.1) = -1.375\), then \(\ln(403.1/64.8) = +1.828\)
                      • their sum, \(+0.454\), equals \(\ln(403.1/256.1)\)
                      • back to a percentage change: \(e^{0.454} - 1 = +57.4\%\)
                    • Rule: add log returns over time; convert to a percentage change only at the end

                    Worked Example: the Growth Rate of Bitcoin Usage

                    Slide 32 in the PDF

                    The compound annual growth rate (CAGR) between two dates \(T\) years apart is the constant annual rate that turns the starting value into the final value:

                    \[g = \left(\frac{X_{\text{end}}}{X_{\text{start}}}\right)^{1/T} - 1\]
                    (1.5)

                    For Bitcoin transactions per day, in monthly means, \(X_{\text{start}} = 93{,}112\) in January 2015 and \(X_{\text{end}} = 506{,}379\) in September 2025, so \(T = 10.67\) years. The ratio is 5.44 and its logarithm 1.694. Dividing by \(T\) gives the average log growth per year, 0.159, and \(g = e^{0.159} - 1 = 17.2\%\) a year. The calculation through logarithms gives the same result as formula (1.5), because \((X_{\text{end}}/X_{\text{start}})^{1/T} = e^{\ln(X_{\text{end}}/X_{\text{start}})/T}\).

                    For the market value of Bitcoin in the same months, 3.4 and 2,251 billion USD, the ratio is 659 and \(g = 659^{1/10.67} - 1 = 83.8\%\) a year. Value grew much faster than usage.

                    A CAGR uses only the first and the last observation, so it depends on the two dates chosen: starting at a peak or at a trough changes the result. The next slide uses every month.

                    In brief

                    • Compound annual growth rate (CAGR) between two dates \(T\) years apart
                      \[ g = \left(\frac{X_{\text{end}}}{X_{\text{start}}}\right)^{1/T} - 1 \]
                    • Bitcoin transactions, monthly means: \(X_{\text{start}} = 93\,112\) (January 2015), \(X_{\text{end}} = 506\,379\) (September 2025), \(T = 10.67\) years
                      • ratio \(= 5.44\); \(\ln 5.44 = 1.694\); \(1.694/10.67 = 0.159\); \(g = e^{0.159} - 1 = 17.2\%\) a year
                    • Bitcoin market value, same months: 3.4 and 2 251 billion USD
                      • ratio \(= 659\); \(g = 659^{1/10.67} - 1 = 83.8\%\) a year: value grew much faster than usage
                    • Each CAGR depends on the two dates chosen; the next slide uses every month

                    The Log-Linear Trend Regression

                    Slide 33 in the PDF

                    A trend regression uses all observations. The logarithm of the series is regressed on time, measured in years:

                    \[\ln X_t = a + g\,t + u_t\]
                    (1.6)

                    The slope \(g\) is the continuous growth rate, and \(e^{g} - 1\) the corresponding annual growth rate. The standard error (SE) of \(\hat g\) is computed with the Newey–West method, which allows the errors \(u_t\) to be correlated over time (here with 12 lags); ordinary standard errors would be too small for series like these. The \(R^2\) is the share of the variance of \(\ln X_t\) explained by the trend.

                    The table reports the estimates for Bitcoin, monthly, 2014–2025. For transactions per day \(\hat g = 0.104\) (SE 0.021, \(R^2 = 0.62\)), an annual growth of 10.9%. For market value \(\hat g = 0.586\) (SE 0.055, \(R^2 = 0.88\)), an annual growth of 79.7%. They differ from the CAGRs of the worked example, 17.2% and 83.8%, which use only the two end points.

                    Whether value really grew faster than usage is tested directly. Regressing \(\ln(M_t/n_t)\), the log of market value \(M_t\) divided by transactions per day \(n_t\), on time estimates the difference of the two growth rates, \(g_M - g_n\): it is 0.482 (SE 0.052), so \(z = 9.3\), far beyond the usual critical values. The residuals, however, have a first-order autoregressive, AR(1), coefficient of 0.96: a deviation from the trend in one month is almost fully carried into the next, so deviations last for years. The test is then only as reliable as the assumption that a straight trend describes the series, and the result depends on the sample period.

                    In brief

                    • A CAGR uses only two dates; a trend regression uses all of them:
                      \[ \ln X_t = a + g\,t + u_t, \qquad t \text{ in years} \]
                      • \(g\): the continuous growth rate; annual growth \(e^{g} - 1\)
                      • SE: standard error of \(\hat g\), Newey–West (robust to autocorrelation, 12 lags); \(R^2\): share of the variance of \(\ln X_t\) explained by the trend
                    Bitcoin, monthly, 2014–2025\(\hat g\)SE\(R^2\)\(e^{\hat g} - 1\)
                    transactions per day\(0.104\)\(0.021\)\(0.62\)\(10.9\%\)
                    market value\(0.586\)\(0.055\)\(0.88\)\(79.7\%\)
                    • Difference, estimated directly from \(\ln(M_t/n_t) = a + (g_M - g_n)\,t + e_t\) (\(M_t\): market value; \(n_t\): transactions per day): \(0.482\) (SE \(0.052\)), \(z = 9.3\)
                      • but the residual AR(1) coefficient is 0.96: deviations from the trend persist for years; the test is only as good as the trend model
                    • The trend uses every month, unlike the CAGRs (17.2% and 83.8%), but it still depends on the sample period

                    Trend Lines on a Log Scale

                    Slide 34 in the PDF
                      Question for the room With the sample starting in November 2020 instead of November 2014, how does the estimated growth of Bitcoin's market value change?
                      Answer

                      It falls from 79.7% to 29.6% a year (ĝ = 0.260 instead of 0.586). The regression uses every month of the sample, but the sample still decides the result: the years of fastest growth, 2015–2017, drop out. Higher market values in the later years do not mean faster growth: the slope measures the change of the log level, not the level. Transactions grow 17.1% a year from November 2020, against 10.9% from November 2014.

                      The chart shows the monthly means of Bitcoin transactions per day and of the market value (in millions of USD), with the fitted log-linear trends as dashed lines. On the log scale each trend is a straight line, with slopes corresponding to 10.9% a year for transactions and 79.7% a year for market value.

                      The transactions stay close to their trend. The market value moves around its trend in long waves: it rises well above the trend in 2017–2018 and in 2021–2022 and falls back below it afterwards. These long waves are the persistent residuals measured by the AR(1) coefficient of 0.96.

                      In brief

                      • Monthly means and fitted log-linear trends: transactions grow 10.9% a year, market value 79.7% a year
                      • On a log scale a constant growth rate is a straight line; the market value moves around its trend in long waves (2017–2018, 2021–2022)
                      BA_L1_trend

                      Out-of-Sample Check of the Trend after One Year

                      Slide 35 in the PDF
                        Question for the room The ▶ button moves the forecast origin every three months, from October 2017 to October 2025 (33 origins). For how many origins does the realised value 12 months later lie outside the naive 95% band?
                        Answer

                        For 16 of the 33 origins (48%), every time below the band; a valid 95% band would miss about 5% of the time. The band is wide, from 0.26 to 3.8 times the forecast at the October 2025 origin, but it assumes independent residuals; the residuals have an AR(1) coefficient of 0.97, so deviations from the trend last for years and the band is far too narrow beyond a few months. At the October 2025 origin, the October 2026 value, 1,670 USD bn, lies just below the band, which starts at 1,770 USD bn.

                        A trend fitted to past data can be extended into the future, which gives a forecast. The chart extends the trend of the Bitcoin market value, 79.7% a year, from November 2025 to October 2026 (solid blue line) with a naive 95% band, and compares it with the market value in those months (red points). The market value is reconstructed as the EODHD price times an approximate supply, computed from the protocol rule at the block rate observed since 2009 (Appendix), because no observed monthly series is available for this period.

                        The table gives the comparison. The trend forecast rises from 3,918 billion USD in November 2025 to 6,706 billion in October 2026, while the reconstructed value falls from 1,920 to 1,670 billion (October 2026 covers 1–23 October). The ratio of the reconstructed value to the forecast drops from 0.49 to 0.25: one year after the end of the sample, the market value is a quarter of what the trend predicted, and it ends just below the naive 95% band.

                        The band is too narrow because it assumes that the residuals are independent and identically distributed (iid). The residuals are close to a random walk, with an AR(1) coefficient of 0.97, so the uncertainty grows with the horizon much faster than the iid band allows beyond a few months. A trend describes the past growth of a series; it is not a forecast of a price.

                        In brief

                        Bitcoin market value, USD bnNov 2025Feb 2026Jun 2026Sep 2026Oct 2026\(^{*}\)
                        trend forecast (79.7% a year)3 9184 5375 5166 3876 706
                        reconstructed (EODHD price \(\times\) approx. supply)1 9201 3761 2631 6171 670
                        reconstructed / forecast\(0.49\)\(0.30\)\(0.23\)\(0.25\)\(0.25\)

                        \(^{*}\) 1–23 October 2026. Supply from the protocol rule at the block rate observed since 2009 (Appendix), not an observed monthly series.
                        • One year on, the reconstructed market value is a quarter of the trend; it ends just below the naive 95% band
                        • Residuals are almost a random walk (first-order autoregressive (AR(1)) coefficient \(0.97\)): the independent and identically distributed (iid) band is far too narrow beyond a few months; a trend fits the past, it does not forecast a price
                        BA_L1_oos_trend

                        Section summary

                        Log scales turn constant growth into straight lines, and log returns add up over time. A CAGR depends on its two end dates, while a log-linear trend uses every observation but rests on the assumption of a stable trend; the forecast one year later shows how strongly persistent residuals limit such a model.

                        Summary

                        A public blockchain is a tamper-evident database whose security can be measured: from the published difficulty, formula (1.1) gives about 1,080 EH/s for Bitcoin in October 2025. The supply of bitcoin follows a known geometric rule, (1.2), with a cap of 21 million and a supply growth of 0.82% a year after 2024. The market is concentrated: the HHI of the five selected coins is 0.71, and two issuers hold 85% of all stablecoins.

                        Over 2014–2025, the log-linear trends give Bitcoin usage a growth of 10.9% a year and market value 79.7% a year; in this sample the difference is large (\(z = 9.3\)), but the residuals are very persistent, and the trend failed as a forecast one year later. Data must be checked before use, because one asset has several prices, series have gaps, and jumps by a factor of 100 are errors. Levels and trends describe the past; inference and forecasts need returns, the subject of Lecture 2.

                        In brief

                        • A blockchain is a public, tamper-evident database; its security can be measured: \(\hat H = D \cdot 2^{32}/600 \approx 1\,080\) EH/s for Bitcoin in October 2025
                        • Supply follows a known geometric rule: 21 million BTC, supply growth 0.82% a year after 2024
                        • Concentration: \(\mathrm{HHI} = 0.71\) for five selected coins (BTC, ETH, DOGE, ADA, LTC); two issuers hold 85% of stablecoins
                        • Log-linear trends, 2014–2025: Bitcoin usage grows 10.9% a year, market value 79.7% a year; in this sample the gap is large (\(z = 9.3\)), but residuals are very persistent
                        • Data must be checked before use: several prices for one asset, gaps, and jumps of 100 times that are errors, not news
                        • Levels and trends describe the past; inference and forecasts need returns: Lecture 2 turns the same prices into returns

                        Interpretation Exercises

                        Slide 37 in the PDF

                        The four exercises use the numbers of the lecture. Each asks for an interpretation in a few sentences: what a measure shows, what it does not show, and which additional data would answer the question.

                        In brief

                        1. Five selected coins (BTC, ETH, DOGE, ADA, LTC) have \(\mathrm{HHI} = 0.71\). A colleague says the crypto market is well diversified because thousands of coins exist. Comment, using the effective number of coins. What would you need to measure the concentration of the whole market? (Lecture 3 repeats the measure on ten coins.)
                        2. Trend regressions: \(\hat g = 0.104\) for transactions, \(0.586\) for market value; the difference is \(0.482\) (SE \(0.052\), \(z = 9.3\)), with residual AR(1) coefficient 0.96. What does the test tell you? Does it prove a bubble?
                        3. The Bitcoin hash rate grew about 3 600 times since 2014. What does this say about the cost of an attack, and what does it not say about the value of the network?
                        4. The 79.7% trend predicted 6 706 bn USD for October 2026; the reconstructed value (1–23 October) is 1 670 bn. The residual AR(1) coefficient is 0.97. Why was the forecast so far off, and why is the naive band misleading?

                        Appendix: Further Material

                        The Appendix holds optional material for self-study. It contains worked examples on mining, index construction, TVL and outlier detection, checks of the protocol formulas on the data, and background on the history of Bitcoin and Ethereum.

                        Appendix: Further Material

                        Slide 38 in the PDF
                        Optional material for self-study.
                        • Worked Example: a Miner with 1% of the Hash Rate
                        • Checking the Hash-Rate Formula on the Data
                        • The Supply Rule in Calendar Time
                        • Building a Market-Value Index
                        • Worked Example: the Divisor at a Rebalancing
                        • Share of TVL Explained by the Ether Price
                        • Worked Example: TVL Without New Deposits
                        • A Robust Outlier Rule
                        • The Outlier Rule on the Data
                        • Bitcoin and Ethereum: Milestones, 2008–2026
                        • The Supply Schedule
                        • Coins, Tokens and Smart Contracts
                        • Concentration Through Time
                        • Where the Value Is Locked
                        • Price Differences across Exchanges and the Daily Close

                        Worked Example: a Miner with 1% of the Hash Rate

                        Slide 39 in the PDF

                        Each block is won by a miner with a probability equal to its share of the hash rate, independently of earlier blocks. With 144 blocks a day and a share \(s = 1\%\), the number of blocks won in a day is approximately Poisson with mean \(\lambda = 144\,s = 1.44\). The probability of winning nothing is \(e^{-1.44} = 0.237\), and the probability of winning three or more is 0.176. On almost one day in four such a miner earns nothing, while its electricity costs continue. This variance of revenue is the reason for mining pools, in which miners combine their hash rate and share a smoother payout. The same model explains why exchanges wait for several confirmations (later blocks) before accepting a deposit: the chance that an attacker with a share \(q < 0.5\) rewrites the chain falls geometrically with the number of blocks.

                        In brief

                        • Each block is won by the miner with probability equal to its share of the hash rate, independently of the past
                        • Blocks won in a day by a miner with share \(s = 1\%\): approximately Poisson with mean \(\lambda = 144\,s = 1.44\)
                          \[ P(N = k) = e^{-\lambda}\frac{\lambda^k}{k!}, \qquad P(N = 0) = e^{-1.44} = 0.237, \qquad P(N \ge 3) = 0.176 \]
                        • Business reading
                          • on almost one day in four, a miner with 1% of the network earns nothing, although its costs (electricity) are fixed
                          • revenue variance is the reason for mining pools: miners share hash rate and receive a smoothed payout
                        • The same model explains why exchanges wait for several confirmations: the chance that an attacker with share \(q < 0.5\) catches up falls geometrically with the number of blocks

                        Checking the Hash-Rate Formula on the Data

                        Slide 40 in the PDF

                        The chart compares the hash rate reported in the data with the hash rate implied by formula (1.1) from the published difficulty, as monthly means from November 2014 to October 2025. The ratio of reported to implied hash rate has a mean of 1.029, a standard deviation of 0.042 and a range of 0.83 to 1.14. The reported series is itself an estimate based on block times, and the 3% gap reflects blocks arriving slightly faster than every 600 seconds.

                        In brief

                        Checking the Hash-Rate Formula on the Data
                        • Monthly means, November 2014 – October 2025: reported hash rate against \(D \cdot 2^{32}/600\) from the published difficulty
                        • Ratio reported/implied: mean 1.029, standard deviation 0.042, range 0.83–1.14
                        • The reported series is itself an estimate from block times: the 3% gap reflects blocks arriving slightly faster than every 600 seconds
                        BA_L1_hashrate_check

                        The Supply Rule in Calendar Time

                        Slide 41 in the PDF

                        At exactly 144 blocks a day, the supply rule gives 19,992,600 BTC on 24 October 2026. The actual supply on that date, from EODHD, was 20,102,728 BTC, 110,128 BTC or 0.55% more. Since height 840,000 the subsidy is 3.125 BTC, so the actual supply implies a block height of \(840{,}000 + (20{,}102{,}728 - 19{,}687{,}500)/3.125 = 972{,}873\). Over the 6,503 days since the first block this is 149.6 blocks a day, 3.9% faster than the target, because the difficulty adjusts only every 2,016 blocks and blocks come early while the hash rate grows. At 144 blocks a day the next halving, at height 1,050,000, falls around 11 April 2028. The rule is exact in blocks; its path in calendar time is a forecast with a small, one-sided error.

                        In brief

                        • At exactly 144 blocks a day, the supply rule gives \(19\,992\,600\) BTC on 24 October 2026
                        • Actual supply (EODHD, 24 October 2026): \(20\,102\,728\) BTC, i.e. 110 128 BTC (0.55%) more
                        • Block height implied by the actual supply, from the fourth epoch (subsidy 3.125 BTC since height 840 000):
                          \[ h = 840\,000 + \frac{20\,102\,728 - 19\,687\,500}{3.125} = 972\,873 \]
                        • Actual rate since the first block: \(972\,873 / 6\,503 \text{ days} = 149.6\) blocks a day, 3.9% faster than the target
                          • The difficulty adjusts only every 2 016 blocks; while the hash rate grows, blocks come early
                        • Next halving at height 1 050 000: at 144 blocks a day about 11 April 2028
                        • Lesson: the rule is exact in blocks, not in calendar time; the time path is a forecast with a small, one-sided error

                        Building a Market-Value Index

                        Slide 42 in the PDF

                        A value-weighted index of \(k\) coins divides their total market value by a divisor \(D_t\), \(I_t = \sum_{i=1}^{k} P_{i,t}Q_{i,t}/D_t\). When the constituents change at a rebalancing date, the divisor is rescaled by the ratio of the new to the old total market value, so the index does not jump. Trimborn & Härdle (2018) choose the number of coins \(k\) with a rule of the Akaike information criterion (AIC) type, shown in a stylised form on the slide: \(\hat\sigma^2_k\) is the variance of the difference between the return of the \(k\)-coin index and the return of the total market. More coins track the market better but cost more to replicate, and the criterion balances the two.

                        In brief

                        • Value-weighted index of \(k\) coins with a divisor \(D_t\):
                          \[ I_t = \frac{\sum_{i=1}^{k} P_{i,t}\,Q_{i,t}}{D_t} \]
                        • At a rebalancing date \(t^*\) the constituents change; the divisor keeps the index continuous:
                          \[ D_{t^*}^{\text{new}} = D_{t^*}^{\text{old}} \cdot \frac{\sum_{i \in \text{new}} P_{i,t^*}Q_{i,t^*}}{\sum_{i \in \text{old}} P_{i,t^*}Q_{i,t^*}} \]
                        • How many coins? Trimborn & Härdle (2018) choose \(k\) by an Akaike information criterion (AIC)-type rule (stylised form)
                          \[ \hat k = \arg\min_k \ \mathrm{AIC}(k) = n\ln\hat\sigma^2_k + 2k \]
                          • \(\hat\sigma^2_k\): the variance of the difference between the \(k\)-coin index return and the total-market return
                          • more coins track better but cost more to replicate; AIC balances the two

                        Worked Example: the Divisor at a Rebalancing

                        Slide 43 in the PDF

                        Before rebalancing, the index holds coins A and B with market values 800 and 200 billion USD, a divisor of 1 and an index value of 1,000. Coin C, with market value 100, enters on that day. The new divisor is \(1 \times 1{,}100/1{,}000 = 1.1\), and the index stays at \(1{,}100/1.1 = 1{,}000\): a change of constituents is not a return. On the next day the market values are 820, 190 and 110, a total of 1,120, so the index is \(1{,}120/1.1 = 1{,}018.2\), a return of 1.82%. Without the new divisor the index would have shown a false rise of 10% on the rebalancing day.

                        In brief

                        • Day \(t^*\), before rebalancing: coins A and B, market values 800 and 200 (USD bn); divisor \(D = 1\), index \(I = 1\,000\)
                        • Coin C (market value 100) enters the index at \(t^*\)
                          \[ D^{\text{new}} = 1 \times \frac{800 + 200 + 100}{800 + 200} = 1.1, \qquad I_{t^*} = \frac{1\,100}{1.1} = 1\,000 \]
                          • the index does not jump: a change of constituents is not a return
                        • Next day: A 820, B 190, C 110, total 1 120
                          \[ I_{t^* + 1} = \frac{1\,120}{1.1} = 1\,018.2, \qquad \text{return } +1.82\% \]
                        • Without the divisor update the index would have shown a false \(+10\%\) on the rebalancing day

                        Share of TVL Explained by the Ether Price

                        Slide 44 in the PDF

                        The regression relates the monthly log change of TVL to the monthly log change of the Ether price, \(\Delta\ln \mathrm{TVL}_t = a + b\,\Delta\ln P^{\mathrm{ETH}}_t + u_t\), with Newey–West standard errors. The coefficient \(b\) is the elasticity of TVL to the Ether price. Over 80 months the estimate is \(\hat b = 0.79\) (SE 0.066), with \(t = 12.0\), so the association is precisely estimated, and \(R^2 = 0.62\): Ether price changes account statistically for 62% of the variance of monthly TVL changes. Because TVL is the sum of prices times deposited quantities, \(\sum_j P_{j,t}N_{j,t}\), activity is better measured with quantities at fixed prices, \(\sum_j \bar P_j N_{j,t}\), with net flows or with fees.

                        In brief

                        • Monthly regression of log changes, Newey–West standard errors (SE):
                          \[ \Delta\ln \mathrm{TVL}_t = a + b\,\Delta\ln P^{\mathrm{ETH}}_t + u_t \]
                          • \(b\): the elasticity of TVL to the Ether price
                        • Estimates, 80 months: \(\hat b = 0.79\) (SE 0.066), \(R^2 = 0.62\)
                          • \(t = 12.0\): the association is precisely estimated
                          • \(R^2 = 0.62\): Ether price changes account statistically for 62% of the variance of monthly TVL changes
                        • Decomposition: \(\mathrm{TVL}_t = \sum_j P_{j,t}\,N_{j,t}\), prices times token quantities deposited
                          • activity is better measured with fixed-price quantities \(\sum_j \bar P_j N_{j,t}\), net flows or fees
                        MFM_ch16_defi

                        Worked Example: TVL Without New Deposits

                        Slide 45 in the PDF

                        A lending protocol holds 100 million USD, 60% in Ether and 40% in stablecoins. Ether rises by 50% and nobody deposits or withdraws. TVL becomes \(60 \times 1.5 + 40 = 130\) million USD, a rise of 30%, although activity did not change: TVL at fixed prices stays at 100. In this accounting example the elasticity of TVL to the Ether price is 0.6, the Ether share of the deposits. The market-wide estimate \(\hat b = 0.79\) is a different quantity: an association between monthly percentage changes of TVL and of the Ether price over 2020–2026, which also reflects flows that move with Ether and other token prices.

                        In brief

                        • A lending protocol holds 100 million USD: 60% in Ether, 40% in stablecoins
                        • Ether rises by 50%; nobody deposits or withdraws
                          \[ \mathrm{TVL}_{t+1} = 60 \times 1.5 + 40 = 130 \text{ million USD}, \qquad +30\% \]
                        • In this accounting example, the elasticity of TVL to the Ether price is \(0.6\): the Ether share of the deposits
                        • Fixed-price TVL \(\sum_j \bar P_j N_{j,t}\) stays at 100: activity did not change
                        • The market-wide \(\hat b = 0.79\) is a different object: an association between monthly percentage changes of TVL and of the Ether price, 2020–2026
                          • it mixes the asset composition of deposits, flows that move with Ether and other token prices; it is not the Ether share of deposits

                        A Robust Outlier Rule

                        Slide 46 in the PDF

                        A rule for outliers based on the mean and the standard deviation is itself distorted by the outliers it is meant to find. The robust version replaces them with the median and the median absolute deviation (MAD), computed in a centred window of 31 days around each date:

                        \[z_t = \frac{x_t - \mathrm{med}_t}{1.4826\,\mathrm{MAD}_t}, \qquad \mathrm{MAD}_t = \mathrm{med}_{s \in W_t}\,\big|x_s - \mathrm{med}_t\big|\]

                        Here \(x_t\) is the log market value, \(W_t\) the window and \(\mathrm{med}_t\) the median of \(x_s\) in the window; the factor 1.4826 makes \(1.4826\,\mathrm{MAD}\) equal to the standard deviation \(\sigma\) for data from the Normal distribution. For the Bitcoin market value in 2014–2025, the 11 erroneous days of 27 August – 6 September 2023 have \(|z_t|\) between 57 and 373, while the largest genuine move, on 17 December 2019, has \(|z_t| = 6.9\). A threshold of 10 flags exactly the 11 bad days; a threshold of 100 would miss the first two days of the error. Writing the rule down before looking at new data is more reliable than deleting points by eye.

                        In brief

                        • Mean and standard deviation are themselves distorted by outliers; use the median and the median absolute deviation (MAD)
                          \[ z_t = \frac{x_t - \mathrm{med}_t}{1.4826\,\mathrm{MAD}_t}, \qquad \mathrm{MAD}_t = \mathrm{med}_{s \in W_t}\,\big|x_s - \mathrm{med}_t\big| \]
                          • \(x_t\): the log market value; \(W_t\): the centred 31-day window; \(\mathrm{med}_t\): the median of \(x_s\) on \(W_t\)
                          • \(\mathrm{MAD}_t\) is computed in each window, around that window's own median
                          • \(1.4826\): makes \(1.4826\,\mathrm{MAD}\) equal to \(\sigma\) for Normal data
                        • Bitcoin market value, 2014–2025
                          • the 11 days of 27 August – 6 September 2023 have \(|z_t|\) between 57 and 373
                          • the largest genuine move has \(|z_t| = 6.9\) (17 December 2019): a threshold of 10 flags exactly the 11 bad days
                          • a threshold of 100 would miss 2 of them (the first two days of the error)
                        • A rule written down before looking at new data is better than deleting points by eye

                        The Outlier Rule on the Data

                        Slide 47 in the PDF

                        The left panel shows the raw Bitcoin market value with the flagged days; the right panel shows the robust \(|z_t|\) on a log scale. The usual threshold \(|z_t| > 3\) flags 46 of 3,968 days, and 35 of these are genuine market moves: crypto returns have heavy tails, so genuine moves often look extreme. A threshold of 10 flags exactly the 11 bad days, and in this sample any threshold between 6.9 and 57 separates the two groups.

                        In brief

                        The Outlier Rule on the Data
                        • Left: raw Bitcoin market value with the flagged days; right: robust \(|z_t|\) on a log scale
                        • The usual threshold \(|z_t| > 3\) flags 46 of 3 968 days, 35 of them genuine moves: heavy tails make genuine moves look extreme
                        • Threshold 10 flags exactly the 11 bad days; any threshold between 6.9 and 57 separates the two groups in this sample
                        BA_L1_mad

                        Bitcoin and Ethereum: Milestones, 2008–2026

                        Slide 48 in the PDF

                        On 31 October 2008 Nakamoto (2008) proposed "a peer-to-peer electronic cash system", in which users pay each other directly without a bank in the middle. The problem the design solves is double spending, paying twice with the same digital coin, without a central party that keeps the accounts. The first block followed on 3 January 2009 and the first exchange trades in 2010. In 2015 Ethereum added smart contracts, programs that run on the blockchain (Buterin, 2014). Stablecoins, tokenised funds, DeFi and exchange-traded funds are built on these two ideas.

                        In brief

                        • 31 October 2008: Nakamoto (2008) proposes “a peer-to-peer electronic cash system”
                          • peer-to-peer: users pay each other directly, without a bank in the middle
                          • the problem solved: double spending, i.e. paying twice with the same digital coin
                        • 3 January 2009: the first block; 2010: the first trades on exchanges
                        • 2015: Ethereum adds smart contracts, programs that run on the blockchain Buterin (2014)
                        • 2026: stablecoins, tokenised funds, DeFi and exchange-traded funds are all built on these two ideas

                        The Supply Schedule

                        Slide 49 in the PDF

                        The chart simulates the supply of bitcoin with the protocol rule and exactly 144 blocks a day; the dotted green lines mark the four halvings on this simulated calendar, at the end of 2012, 2016, 2020 and 2024. The actual halvings came earlier, in November 2012, July 2016, May 2020 and April 2024, because blocks arrived faster than every 10 minutes. The annual supply growth falls with each halving: 33.3% in 2013, 9.0% in 2017, 3.7% in 2021, 1.7% in 2025, 0.83% in 2026 and 0.4% in 2032, and 99% of the cap is reached in 2035. The simulation gives 19.98 million BTC on 18 September 2026, against an actual supply of 20.09 million.

                        In brief

                        The Supply Schedule
                        • Simulated calendar: the protocol rule with exactly 144 blocks a day; dotted green: the four halvings on this calendar (end of 2012, 2016, 2020, 2024)
                        • The actual halvings came earlier (November 2012, July 2016, May 2020, April 2024): blocks arrived faster than every 10 minutes
                        • Annual supply growth: 33.3% (2013), 9.0% (2017), 3.7% (2021), 1.7% (2025), 0.83% (2026), 0.4% (2032); 99% of the cap is reached in 2035
                        • The simulation gives 19.98 million BTC on 18 September 2026; the actual supply is 20.09 million
                        BA_L1_supply_schedule

                        Coins, Tokens and Smart Contracts

                        Slide 50 in the PDF

                        A coin is the native asset of a blockchain, such as BTC on Bitcoin and ETH on Ethereum; it pays the transaction fees, and the protocol can fix its supply, as with Bitcoin's cap of 21 million. A token is an asset issued by a smart contract on an existing chain: stablecoins such as USDT and USDC, governance tokens, and tokenised funds and bonds. Decentralised finance (DeFi) runs lending and trading through smart contracts, without a bank or broker. Each of these is an application of the blockchain, and each leaves a data trail on the chain.

                        In brief

                        • Coin: the native asset of a blockchain (BTC on Bitcoin, ETH on Ethereum)
                          • pays the fees; Bitcoin supply is capped at 21 million by the protocol
                        • Token: an asset issued by a smart contract on an existing chain
                          • stablecoins (USDT, USDC), governance tokens, tokenised funds and bonds
                        • DeFi (decentralised finance): lending and trading run by smart contracts, without a bank or broker
                        • Each of these is an application; each leaves a data trail on the chain
                        Coins, Tokens and Smart Contracts Vitalik Buterin, co-founder of Ethereum, 2015 Photo: John Phillips (2015); CC BY 2.0; Wikimedia Commons

                        Concentration Through Time

                        Slide 51 in the PDF

                        The chart computes the monthly HHI of 11 coins from the ETH Chronicles data, 2014–2025, with the 11 erroneous days removed. The HHI reached its maximum, 0.868, in December 2015, when Bitcoin dominated almost alone, and its minimum, 0.306, in January 2018, with a Bitcoin share of 47.1% and an effective number of 3.27 coins. In September 2025 the HHI was 0.581, with a Bitcoin share of 73.5% and an effective number of 1.72: after each boom in other coins, the market concentrated again in Bitcoin.

                        In brief

                        Concentration Through Time
                        • Monthly market-value shares of 11 coins (ETH Chronicles data, 2014–2025; the 11 erroneous days of 2023 excluded)
                        • HHI: 0.868 at its maximum (December 2015); 0.306 at its minimum (January 2018, Bitcoin share 47.1%, effective number 3.27)
                        • September 2025: HHI 0.581, Bitcoin share 73.5%, effective number 1.72: the market re-concentrated after each altcoin boom
                        BA_L1_hhi_coins

                        Where the Value Is Locked

                        Slide 52 in the PDF

                        The chart shows the TVL of the ten largest blockchains on 18 September 2026. Ethereum holds 49.8 billion USD, 57% of the total of 88 billion. Base and Arbitrum are layer-2 networks, which offer cheaper transactions and settle on Ethereum. One platform dominates, while applications spread to cheaper chains.

                        In brief

                        Where the Value Is Locked
                        • TVL by blockchain, ten largest, 18 September 2026: Ethereum 49.8 billion USD, 57% of 88 billion
                          • Base and Arbitrum are layer-2 networks (Recap slide): cheaper transactions that settle on Ethereum
                        • Business reading: one platform dominates, but applications spread to cheaper chains
                        MFM_ch16_defi

                        Price Differences across Exchanges and the Daily Close

                        Slide 53 in the PDF

                        A coin trades on hundreds of exchanges, each with its own order book and price, and a data provider averages them into one series; the choice of venues changes the series. Makarov & Schoar (2020) study 34 exchanges in 19 countries in 2017–2018 and find large and persistent price gaps between countries such as Korea, Japan and the US when capital controls block arbitrage, and much smaller gaps within a country. The market also never closes: it trades 365 days a year, so a "daily close" is a convention, usually midnight in Coordinated Universal Time (UTC). The S&P 500 closes at 16:00 New York time, so daily returns of a crypto asset and of the stock index do not cover the same hours.

                        In brief

                        • Hundreds of exchanges, each with its own order book and price
                          • a data provider averages them into one series; the choice of venues changes the series
                        • Makarov & Schoar (2020): 34 exchanges in 19 countries, 2017–2018
                          • large and persistent price gaps between countries (Korea, Japan, US) when capital controls block arbitrage
                          • much smaller gaps within a country
                        • The market never closes: 365 trading days a year
                          • a “daily close” is a convention, usually midnight UTC (Coordinated Universal Time)
                          • the S&P 500 closes at 16:00 New York time: daily returns of the two are not simultaneous

                        References