website

twitter

discord

github

Blockchains (L1)

Berachain

# Berachain Median transaction fee Methodology

## 1. Overview

The transaction fee median metric measures the median cost paid by users to execute transactions on the Berachain blockchain. This metric provides insight into typical transaction costs, filtering out extreme values that might skew average calculations. The calculation processes individual transaction fees from blockchain data, aggregates them daily, and converts the results to USD for standardized reporting.

## 2. Data sources

The calculation draws from several key data sources:
- **Berachain transaction records**: Raw blockchain transaction data containing gas usage, gas prices, sender/receiver addresses, and transaction hashes
- **Berachain block records**: Block-level data including timestamps, block numbers, and base fees per gas for EIP-1559 context  
- **End-of-day price feeds**: Token price data for the native BERA token (represented by address `0x6969696969696969696969696969696969696969`) to enable USD conversion
- **Token metadata**: Information about the Berachain native token including symbol and decimal precision

## 3. Step-by-step calculation

### Component A: Transaction data extraction
- **Purpose**: Collect raw transaction data and enrich with block-level context
- **Logic**: Extract key fields from Berachain transaction records including `transaction_hash`, `from_address`, `to_address`, `gas_used`, `gas_price`, and `max_priority_fee_per_gas`. Join this data with corresponding block records to add `base_fee_per_gas` information. All transactions are tagged with the native BERA token address and symbol for downstream processing.
- **Key fields**: `block_timestamp` for temporal grouping, `gas_used` and `gas_price` for fee calculation, `base_fee_per_gas` for EIP-1559 context

### Component B: Individual fee calculation  
- **Purpose**: Calculate the actual fee paid for each transaction
- **Logic**: For each transaction, compute the total fee by multiplying `gas_used` by `gas_price`. Convert the result from wei to BERA by dividing by 1e18. This gives the fee amount in native BERA tokens that each user paid for their transaction.
- **Key fields**: `fee_amount` representing the transaction cost in BERA tokens, `block_timestamp` for temporal aggregation

### Component C: Daily median calculation
- **Purpose**: Aggregate individual transaction fees to daily median values
- **Logic**: Group all transactions by day using timestamp truncation to daily boundaries. For each day, calculate the median fee using the `APPROX_QUANTILES` function with 100 buckets, selecting the 50th percentile (median). This approach efficiently handles large transaction volumes while providing accurate median estimates.
- **Key fields**: `timestamp` truncated to day level, `transaction_fee_median` as the median fee in BERA

### Final aggregation
- **Combining components**: The daily median values are passed through Token Terminal's standardization process
- **Currency conversion**: BERA amounts are converted to USD using end-of-day price feeds through the `convert_to_usd_and_correct_decimals` macro, with decimal correction disabled since the fees are already in proper BERA units
- **Time aggregation**: Data is aggregated at daily grain with timestamps truncated to day boundaries  
- **Final calculation**: The final metric represents the median transaction fee in USD for each day, with missing data points filled with zeros using the `fill_zeros` strategy. Chain availability filters ensure data quality and completeness.

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

BerachainBERA

Median transaction fee

Median transaction fee

Competitive landscape