Historical aggregations

Historical aggregations are computed across days, weeks, and months - ideal for PnL analysis, smart wallet tracking, market research, and portfolio insights.

These are designed for:

• Dashboards

• Quantitative research

• Risk & compliance workflows

• Backtesting trading strategies

Historical aggregation examples

Realized & Unrealized PnL per wallet

• Entry and exit price

• Time of trade

• Fee inclusion

• Final position value

Top wallets by PnL

• Daily / weekly / monthly ranking

• Wallet age / trade count / total profit

• Profit % and ROI distribution

Wallet token usage

• % volume per token

• Tokens traded

• Number of interactions per token

Wallet activity overview

• Tx count (24h, 7d, 30d)

• Avg trade frequency

• SOL/USD volume

• Unique tokens traded

Token price dynamics

• Live + historical prices

• Delta over 1m, 5m, 1h, 24h

• Moving averages

Wallet volume & activity

• Buy/sell count and ratio

• Volume windows

• Unique counterparties (optional)

Token creator analytics

• Creator wallet balance over time

• Authority transfers

• Sniper detection (bought in same block)

• Early exits

Holder-level token stats

• % of holders at profit/loss

• Volume in profit/loss

• Time-since-buy segmentation

Max possible unrealized PnL

• Avg entry price vs token ATH

• Held token volume

• Time-windowed unrealized gain max

Smart wallet signals

• Tagging: ROI, consistency, size

• Smart wallet trades per token

• Overlap with user activity