# Base Active addresses (daily) Methodology

## 1. Overview

Active addresses daily measures the number of unique addresses that initiated at least one transaction on the Base network each day. This metric provides insight into the daily user activity and engagement on the Base layer-2 blockchain. The calculation uses HyperLogLog approximation for efficient distinct counting across large transaction volumes.

## 2. Data sources

- **Base transaction records**: Complete transaction data from the Base blockchain including transaction hashes, timestamps, and sender addresses
- **Block timestamps**: Timing information for when transactions were included in blocks on the Base network
- **Transaction sender addresses**: The `from_address` field from each transaction, representing the address that initiated the transaction

## 3. Step-by-step calculation

### Component A: User identification
- **Purpose**: Identifies and extracts unique users from Base blockchain transactions
- **Logic**: Extracts the `from_address` field from each Base transaction as the user address. All transaction senders are classified as 'Transaction sender' user type. Each record includes the block timestamp, transaction hash, and relevant metadata like chain identifier ('base'), market sector ('blockchains_l2'), and business segment ('blockchain')
- **Key fields**: `from_address` becomes `user_address`, `block_timestamp` for timing, `transaction_hash` for transaction identification

### Component B: Daily user aggregation
- **Purpose**: Calculates distinct daily active users with efficient approximate counting
- **Logic**: Truncates block timestamps to daily boundaries using day-level time truncation. For each day, identifies distinct user addresses and creates HyperLogLog sketches for scalable distinct counting. Preserves dimensional attributes including chain, user type, and product identifiers for downstream breakdowns
- **Key fields**: `timestamp` (truncated to day), `user_address` for distinct counting, dimensional attributes for categorization

### Component C: Dimensional aggregation
- **Purpose**: Creates multiple dimensional views of daily active users using HyperLogLog merging
- **Logic**: Uses HyperLogLog count initialization and merging functions to create approximate distinct counts across different dimensions. Generates breakdowns by project level (project_dbt_tag), chain level, user type, and product level. Each dimensional view maintains timestamp granularity while aggregating user counts appropriately
- **Key fields**: `user_dau` as the distinct user count, `dimensions` field indicating the breakdown type, relevant dimensional identifiers

### Final aggregation
- **Combining components**: Selects the daily active users from dimensional aggregations, specifically filtering for 'chain' and 'project_dbt_tag' dimensions to focus on relevant breakdowns
- **Metric transformation**: Renames `user_dau` field to `active_addresses_daily` to reflect the specific metric being calculated, as active addresses are defined as daily active users for blockchain protocols
- **Time aggregation**: Maintains daily timestamp boundaries established in earlier components, with each record representing one day's worth of active address activity
- **Final calculation**: The final active addresses daily value represents the approximate distinct count of addresses that initiated transactions on Base network for each calendar day, calculated using HyperLogLog approximation for computational efficiency

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

Unique active addresses over a fixed 24-hour window.

Active addresses (daily)

Base

Base batches users' transactions and submits them to Ethereum, paying a share of the transaction fees to Ethereum validators (expense).

Base is an Ethereum Layer 2 (L2) offering a secure, low-cost, builder-friendly way for anyone, anywhere, to build onchain.

Coinbase team owns and governs the protocol. Coinbase is a public company and its investors include Andreessen Horowitz, Vanguard Group, ARK Investment Management, etc.

Base

Active addresses (daily)

Active addresses (daily)

Competitive landscape

Chain breakdown