Solana Wallet Transaction Analysis

Description

The client needed detailed analytics for specific wallets on the Solana network, including purchase and sale history, volumes, entries/exits, profitability, and token market cap.

Standard block explorers (e.g., Solscan) and third-party services provided only basic data without deep structuring, and many metrics (like market cap or sequential trade analysis over time) were not available out-of-the-box.

The goal was to automatically collect all necessary information, merge it into a single table, and prepare it for analytics and detection of wallet behavior patterns.

Solution

I developed a module for full transaction analysis of Solana wallets that:

• Collects the complete purchase and sale history of tokens via RPC nodes;
• Identifies the token for each transaction, operation type (buy/sell), amount, price, and trade volume;
• Calculates additional metrics:
  • average entry price;
  • unrealized/realized profit;
  • total positions per token;
• Merges data into a structured table, synchronized by timestamps, to analyze trades and market state in a single context.

Result

The solution allows:

• Full view of wallet transactions: all buys, sells, volumes, profitability, and position dynamics;
• Analysis of wallet behavior in the context of token market cap changes;
• Use of data for trading, whale analysis, finding promising wallets, and building analytical models.

The system works autonomously, provides stable output under high load, and produces data fully ready for further analysis.