Skip to main content

Investigating Transactions, Tokens, and Analyzing Interactions

PRISM Explorer provides powerful tools for in-depth blockchain analysis on the Solana network. This use case focuses on investigating transactions, and tracking token movements.

Key Capabilities​

  1. Transaction Investigation

    • Trace the flow of funds across multiple hops
    • Identify patterns in transaction behavior
    • Analyze transaction volumes and frequencies

  2. Token Movement Tracking

    • Monitor the distribution and circulation of specific tokens
    • Track large token transfers and whale activity
    • Analyze token velocity and holder behavior

Example Queries​

  1. Trace all transactions involving a specific address in the last 7 days:

    SELECT * FROM transactions
    WHERE (from_address = 'specific_address' OR to_address = 'specific_address')
    AND block_timestamp >= NOW() - INTERVAL 7 DAY

  2. Identify the top 10 most active smart contracts by transaction count:

    SELECT program_id, COUNT(*) as tx_count
    FROM instructions
    GROUP BY program_id
    ORDER BY tx_count DESC
    LIMIT 10