# Active users (monthly) Methodology

## 1. Overview

Active users (monthly) is defined as the number of unique addresses from which transactions are initiated on Robinhood Chain within a 30-day rolling window. This metric is utilized to evaluate user adoption, network engagement, and overall activity within the Robinhood Chain ecosystem. By aggregating distinct transaction senders monthly, the growth and utility of the network are assessed.

## 2. Data sources

- **Blockchain events**: Transaction records containing sender addresses and block timestamps, covering Robinhood Chain

## 3. Step-by-step calculation

### Component A: Robinhood Chain transaction sender extraction

- **Purpose**: Extract transaction sender addresses and timestamps from Robinhood Chain transactions
- **Logic**: Transaction records are parsed from the Robinhood Chain transactions table. For each transaction, the block timestamp, transaction hash, and sender address are extracted. The sender address is classified under the user type "Transaction sender" and mapped to the Robinhood Chain product
- **Key fields**: `block_timestamp` (timing), `from_address` (user address), `transaction_hash` (transaction identifier)

### Component B: Monthly active user aggregation

- **Purpose**: Calculate the monthly count of distinct active users
- **Logic**: The extracted transaction sender addresses are aggregated per 30-day window using the block timestamp truncated to monthly granularity. Duplicate addresses within the same 30-day window are removed to isolate distinct active users (monthly) per 30-day window. The final dataset is filtered to ensure chain availability and freshness standards are met
- **Key fields**: `block_timestamp` (monthly truncation), `user_address` (distinct user identification)

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

Unique revenue-generating users over a rolling 30-day window.

Active users (monthly)

Robinhood Chain

Active users (monthly)

Active users (monthly)

Chain breakdown