# Active users (weekly) Methodology

## 1. Overview

Active users (weekly) is defined as the number of unique addresses from which transactions are initiated on Robinhood Chain within a 7-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 weekly, 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: Weekly active user aggregation

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

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

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

Active users (weekly)

Robinhood Chain

Active users (weekly)

Active users (weekly)

Chain breakdown