website

twitter

Infrastructure

Trojan

# Trojan Active users (daily) Methodology

## 1. Overview

Daily Active Users (DAU) for Trojan measures the number of distinct users who performed fee-generating trading activities on the Trojan protocol each day. This metric identifies active traders by tracking unique transaction signers who sent SOL transfers to Trojan's fee collection address, providing a direct measure of daily user engagement with the trading platform.

## 2. Data sources

- **Solana native SOL transfers**: Parsed Solana blockchain native SOL transfer events organized by recipient address
- **Solana transaction data**: Solana blockchain transaction records including transaction signers, timestamps, and transaction IDs
- **Solana block data**: Block timestamp information for temporal aggregation

## 3. Step-by-step calculation

### Component A: Fee transaction identification
- **Purpose**: Identify all trading activities that generate fees paid to Trojan
- **Logic**: Filter Solana native SOL transfers to include only those sent to Trojan's designated fee collection address (`9yMwSPk9mrXSN7yDHUuZurAh1sjbJsfpUqjZ7SvVtdco`). Extract the transaction signer as the user identifier, along with block timestamp, transaction ID, and transfer amount. Standardize the chain identifier as 'solana' and token address as SOL's canonical address (`So11111111111111111111111111111111111111112`)
- **Key fields**: `transaction_signer` (user identifier), `block_timestamp` (transaction timing), `amount` (fee amount), `transaction_id` (unique transaction reference)

### Component B: Daily user aggregation
- **Purpose**: Count distinct active users per day
- **Logic**: Truncate block timestamps to daily boundaries to establish daily time periods. Apply distinct operation on the combination of daily timestamp and transaction signer address to ensure each user is counted only once per day, regardless of how many fee-generating transactions they performed. Classify all identified users with the user type 'Trader' since they are identified through trading activity that generates fees
- **Key fields**: `timestamp` (daily boundary), `signer` (unique user address), `user_type` (set to 'Trader')

### Final aggregation
- **Combining components**: No additional aggregation is performed - the metric maintains individual user records per day
- **Currency conversion**: Not applicable - this is a user count metric
- **Time aggregation**: Daily boundaries are established by truncating block timestamps to day granularity
- **Final calculation**: The final DAU count is the distinct number of `signer` addresses per daily `timestamp` period, where each signer represents one active user who performed fee-generating trading activities on that day

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

Unique revenue-generating users over a fixed 24-hour window.

Trojan

Active users (daily)

Active users (daily)

Competitive landscape