# Bitcoin Transaction count Methodology

## 1. Overview

The Bitcoin transaction count metric measures the total number of unique transactions processed by the Bitcoin blockchain on a daily basis. This metric serves as a fundamental indicator of Bitcoin network activity and adoption, answering the business question "How many transactions occur on the Bitcoin network each day?" The calculation uses a simple aggregation approach that counts distinct transaction identifiers from Bitcoin blockchain data and aggregates them to daily time boundaries.

## 2. Data sources

The metric relies on the following raw data sources:
- **Bitcoin blockchain transaction data**: Complete record of all Bitcoin transactions including transaction identifiers, block timestamps, block heights, and transaction fees
- **Bitcoin block timestamps**: Precise timing information for when each transaction was included in a block, used for daily aggregation boundaries
- **Transaction metadata**: Bitcoin-specific transaction identifiers (`txid`) that uniquely identify each transaction on the network

## 3. Step-by-step calculation

### Component A: Raw transaction extraction
- **Purpose**: Extract and prepare Bitcoin transaction records for aggregation
- **Logic**: The calculation begins by accessing Bitcoin blockchain transaction data, extracting key fields including block timestamps for temporal grouping, transaction identifiers for counting, block heights for ordering, and transaction fees for completeness. The block timestamp field is the critical component as it determines which day each transaction belongs to for aggregation purposes.
- **Key fields**: `block_timestamp` for daily grouping, `txid` as the unique transaction identifier, `block_height` for blockchain ordering, and `fee` for transaction cost information

### Component B: Daily transaction aggregation
- **Purpose**: Count unique transactions per day and apply standard metric formatting
- **Logic**: Block timestamps are truncated to daily boundaries using day-level granularity, creating discrete daily time periods. Within each day, the system counts distinct transaction identifiers to determine the total number of unique transactions. Static metadata is applied including chain identification as Bitcoin, market sector classification as layer-1 blockchain, and business segment categorization as blockchain infrastructure. The product identifier is set to null as this represents network-wide activity rather than specific product usage.
- **Key fields**: `timestamp` truncated to daily boundaries, `transaction_count` as the distinct count of transaction identifiers, `chain_id` set to bitcoin, `market_sector_id` set to blockchains_l1

### Final aggregation
- **Combining components**: The daily transaction counts are processed through a finalization macro that validates the data schema, ensures temporal completeness, and applies gap-filling logic
- **Currency conversion**: No currency conversion is required as this metric counts transactions rather than monetary values
- **Time aggregation**: Daily boundaries are established by truncating block timestamps to day-level granularity, ensuring consistent daily reporting periods aligned with calendar days
- **Final calculation**: The final metric value represents the count of distinct transaction identifiers that occurred within each daily time period, with zero values filled for any missing days to maintain a continuous daily time series. Incremental processing ensures only recent data is recalculated based on monthly partition boundaries with appropriate lookback periods for data completeness.

*This methodology was automatically generated by Token Terminal's methodology analyzer.*

Confirmed transactions added to the blockchain.

Transaction count

Bitcoin

Miners process transactions and receive fees from users (supply-side fees).

Bitcoin is a distributed ledger for transfer and store of value (a blockchain). Bitcoin was founded by a pseudonym Satoshi Nakamoto and launched in 2009.

BTC holders own and govern the protocol. They currently do not take a cut of the total transaction fees paid by users (revenue).

BitcoinBTC

Transaction count

Transaction count

Competitive landscape