# OP Mainnet Active addresses (daily) Methodology

## 1. Overview

The Optimism active addresses daily metric measures the number of unique wallet addresses that initiated at least one transaction on the Optimism network within a 24-hour period. This metric serves as a key indicator of network activity and user engagement on the Optimism Layer 2 blockchain. The calculation identifies unique transaction senders (from addresses) on a daily basis, providing insight into the breadth of network participation rather than transaction volume.

## 2. Data sources

The calculation relies on the following raw data sources:
- **Optimism transaction records**: Complete transaction data from the Optimism blockchain including transaction metadata, sender and recipient addresses, timestamps, and execution details
- **Gas usage data**: Layer 2 gas consumption metrics and Layer 1 data availability costs specific to Optimism's rollup architecture
- **Transaction receipts**: Post-execution transaction data including gas usage confirmations and fee calculations

## 3. Step-by-step calculation

### Component A: Transaction data extraction
- **Purpose**: Extracts and standardizes all Optimism transaction records for analysis
- **Logic**: Retrieves all distinct transactions from Optimism blockchain data, capturing key fields including `block_timestamp`, `transaction_hash`, `from_address`, `to_address`, and gas-related metrics. Each transaction is standardized with chain identifier as 'optimism', market sector as 'blockchains_l1', and business segment as 'blockchain'. The token address is set to Optimism's WETH contract address `0x4200000000000000000000000000000000000006` for consistency
- **Key fields**: `block_timestamp` for temporal analysis, `from_address` as the unique user identifier, `transaction_hash` for deduplication, gas usage amounts for L1 and L2 layers

### Component B: Daily user identification  
- **Purpose**: Identifies unique daily active users from transaction sender addresses
- **Logic**: Groups transaction data by day using timestamp truncation to day granularity. Extracts distinct `from_address` values for each day, representing unique wallet addresses that initiated transactions. Each unique address is classified as user type 'Transaction sender'. The process includes incremental processing logic with configurable lookback days to ensure data freshness and handle late-arriving transactions
- **Key fields**: `timestamp` truncated to day boundary, `user_dau` containing unique from addresses, `user_type` classification, `chain` identifier

### Component C: HyperLogLog aggregation
- **Purpose**: Efficiently counts unique addresses across multiple dimensional breakdowns using probabilistic counting
- **Logic**: Creates HyperLogLog sketches with precision 15 for memory-efficient unique counting at scale. Generates separate aggregations for project-level (overall), chain-level, user-type level, and product-level breakdowns. Uses `hll_count.init()` to create initial sketches from user addresses, then applies `hll_count.merge_partial()` to combine sketches and `hll_count.extract()` to derive final unique counts. This approach allows for accurate unique counting without storing all individual addresses
- **Key fields**: `hll` sketches for probabilistic counting, `dimensions` indicating aggregation level, `user_dau` containing extracted unique counts

### Final aggregation
- **Combining components**: Selects only the 'chain' and 'project_dbt_tag' dimensional breakdowns from the multi-dimensional HyperLogLog results, filtering out user-type and product-level aggregations
- **Currency conversion**: Not applicable for this count-based metric
- **Time aggregation**: Daily boundaries established through timestamp truncation to day granularity, with zero-filling strategy applied for missing days to ensure continuous time series
- **Final calculation**: The `user_dau` field from the selected dimensions is directly renamed to `active_addresses_daily`, representing the count of unique wallet addresses that initiated transactions on Optimism for each day. Chain availability filtering is applied to ensure data quality and completeness.

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

Unique active addresses over a fixed 24-hour window.

Active addresses (daily)

OP Mainnet

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

OP Mainnet is an L2 smart contract platform for decentralized applications on Ethereum. OP Mainnet was founded by Jinglan Wang, Karl Floersch & Kevin Ho and launched in 2021.

Optimism team & investors own and govern the protocol. Optimism’s investors include Paradigm, a16z, IDEO CoLab Ventures, etc.

OP MainnetOP

Active addresses (daily)

Active addresses (daily)

Competitive landscape

Chain breakdown