# Linea Active addresses (daily) Methodology

## 1. Overview

Daily Active Addresses measures the number of unique addresses that initiated at least one transaction on the Linea blockchain within a 24-hour period. This metric serves as a key indicator of network activity and user engagement. The calculation uses HyperLogLog probabilistic data structures to efficiently count distinct addresses across multiple dimensional breakdowns while maintaining accuracy at scale.

## 2. Data sources

- **Linea transaction records**: Raw blockchain transaction data containing transaction hashes, block timestamps, and sender addresses (`from_address`)
- **Chain availability configuration**: Metadata defining data availability periods and quality thresholds for the Linea chain

## 3. Step-by-step calculation

### Component A: User fact extraction
- **Purpose**: Extract and standardize user addresses from raw Linea transactions
- **Logic**: Each transaction record is processed to identify the sender address (`from_address`) as a user. The system casts timestamps and addresses to appropriate data types, assigns chain metadata ("linea", "blockchains_l2" market sector, "blockchain" business segment), and classifies all senders as "Transaction sender" user types. Each sender address represents a potential active address for the day they initiated transactions.
- **Key fields**: `block_timestamp` for temporal boundaries, `from_address` as the unique user identifier, and `transaction_hash` for transaction-level granularity

### Component B: Daily user aggregation with HyperLogLog
- **Purpose**: Count distinct active users per day using probabilistic data structures
- **Logic**: Transaction timestamps are truncated to day boundaries using `timestamp_trunc`. For each day, unique user addresses are processed through HyperLogLog initialization with precision parameter 15, creating compact sketches that enable efficient distinct counting. The system groups by timestamp, chain, user type, and other dimensional attributes while maintaining the HLL sketch for each combination.
- **Key fields**: `timestamp` (truncated to day), `user_address` converted to `user_dau` in HLL sketches, and dimensional grouping fields

### Component C: Multi-dimensional aggregation
- **Purpose**: Create breakdowns across different analytical dimensions
- **Logic**: The daily HLL sketches are aggregated into four dimensional views: project-level (combining all data under 'project_dbt_tag'), chain-level (grouping by 'chain'), user-type-level (grouping by user classification), and product-level (grouping by product). Each breakdown uses HLL merge operations to combine sketches while preserving distinct count accuracy. The system then extracts final counts from merged HLL sketches using `hll_count.extract`.
- **Key fields**: `dimensions` field indicating breakdown type, `chain_id` for chain-specific views, `user_type` for user classification, and `user_dau` containing the distinct count

### Component D: Active addresses finalization
- **Purpose**: Transform user DAU into active addresses metric
- **Logic**: The system selects user DAU values specifically for 'chain' and 'project_dbt_tag' dimensions and renames the `user_dau` field to `active_addresses_daily`. This semantic transformation reflects that transaction senders are considered active addresses on blockchain networks.
- **Key fields**: `active_addresses_daily` as the renamed metric value, maintaining timestamp and dimensional grouping

### Final aggregation
- **Combining components**: The various dimensional breakdowns are unioned together to provide multiple analytical views of the same underlying distinct address counts
- **Currency conversion**: Not applicable for address counting metrics
- **Time aggregation**: Daily boundaries are enforced through timestamp truncation to day granularity, with incremental processing looking back one day plus a configurable lookback period for data consistency
- **Final calculation**: The final active addresses count represents the exact number of distinct addresses that initiated transactions on the Linea blockchain within each 24-hour period, calculated using HyperLogLog for computational efficiency and accuracy

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

Unique active addresses over a fixed 24-hour window.

Active addresses (daily)

Linea

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

Linea is an L2 smart contract platform for decentralized applications on Ethereum. Linea was founded by the ConsenSys team and launched in 2023.

ConsenSys team owns and governs the protocol. ConsenSys's investors include ParaFi Capital, Microsoft, Coinbase Ventures, etc.

LineaLINEA

Active addresses (daily)

Active addresses (daily)

Competitive landscape

Chain breakdown