Query Solana Transactions

Retrieve all transactions sent by or to a specific address to track wallet activity, exchange flows, or program interactions.

Use Case

Transaction queries help you:

Track incoming transactions to wallets or exchanges
Monitor program interactions
Analyze transaction patterns
Build transaction history feeds

Code Example

curl --compressed -X POST "https://portal.sqd.dev/datasets/solana-mainnet/stream" \
  -H 'Content-Type: application/json' \
  -d '{
    "type": "solana",
    "fromBlock": 280000000,
    "toBlock": 280000003,
    "fields": {
      "block": {
        "number": true,
        "timestamp": true
      },
      "transaction": {
        "signatures": true,
        "feePayer": true,
        "err": true
      }
    },
    "transactions": [{}]
  }'

import { DataSource } from "@subsquid/portal-client";

const dataSource = new DataSource({
  network: "solana-mainnet",
});

const blocks = await dataSource.getBlocks({
  from: 280000000,
  to: 280000003,
  fields: {
    block: { number: true, timestamp: true },
    transaction: {
      signatures: true,
      feePayer: true,
      err: true,
    },
  },
  transactions: [{}],
});

// Process transactions
for (const block of blocks) {
  for (const tx of block.transactions) {
    console.log({
      slot: block.header.number,
      signatures: tx.signatures,
      feePayer: tx.feePayer,
      success: tx.err === null,
    });
  }
}

import requests
import json

url = "https://portal.sqd.dev/datasets/solana-mainnet/stream"
headers = {"Content-Type": "application/json"}

payload = {
    "type": "solana",
    "fromBlock": 280000000,
    "toBlock": 280000003,
    "fields": {
        "block": {
            "number": True,
            "timestamp": True
        },
        "transaction": {
            "signatures": True,
            "feePayer": True,
            "err": True
        }
    },
    "transactions": [{}]
}

response = requests.post(url, headers=headers, json=payload)

for line in response.text.strip().split('\n'):
    block = json.loads(line)
    for tx in block.get('transactions', []):
        print({
            "slot": block['header']['number'],
            "signatures": tx['signatures'],
            "feePayer": tx['feePayer'],
            "success": tx['err'] is None
        })

Try it yourself with the interactive query interface below:

Key Parameters

Parameter	Description
`feePayer`	Filter transactions by fee payer address
`signatures`	Transaction signatures (base58-encoded)
`err`	Transaction error (null if successful)

Expected Output

{
  "header": {
    "number": 259985000,
    "timestamp": 1697544779
  },
  "transactions": [
    {
      "signatures": ["5j7s8K9L..."],
      "feePayer": "9WzDXwBbmkg8ZTbNMqUxvQRAyrZzDsGYdLVL9zYtAWWM",
      "err": null
    }
  ]
}

Monitor Outgoing Transactions

Track transactions from a specific wallet:

curl --compressed -X POST "https://portal.sqd.dev/datasets/solana-mainnet/stream" \
  -H 'Content-Type: application/json' \
  -d '{
    "type": "solana",
    "fromBlock": 280000000,
    "toBlock": 280000003,
    "fields": {
      "transaction": {
        "signatures": true,
        "feePayer": true
      }
    },
    "transactions": [{}]
  }'

const blocks = await dataSource.getBlocks({
  from: 280000000,
  to: 280000003,
  fields: {
    transaction: { signatures: true, feePayer: true },
  },
  transactions: [
    {
      feePayer: ["9WzDXwBbmkg8ZTbNMqUxvQRAyrZzDsGYdLVL9zYtAWWM"],
    },
  ],
});

payload = {
    "type": "solana",
    "fromBlock": 280000000,
    "toBlock": 280000003,
    "fields": {
        "transaction": {
            "signatures": True,
            "feePayer": True
        }
    },
    "transactions": [{
        "feePayer": ["9WzDXwBbmkg8ZTbNMqUxvQRAyrZzDsGYdLVL9zYtAWWM"]
    }]
}

Performance Tips

Filter by fee payer: Reduces results to transactions from specific wallets
Request minimal fields: Omit unnecessary fields to improve performance
Check error status: Filter failed transactions in post-processing if needed
Use slot ranges: Process data in manageable batches

Query Instructions

Track program instructions

Query Logs

Retrieve program log messages

Token Transfers

Monitor SPL token activity

API Reference

View complete API docs

Overview

Portal API reference

Working with Portal API

Other data

Networks

Use Case

Code Example

Key Parameters

Expected Output

Monitor Outgoing Transactions

Performance Tips

Query Instructions

Query Logs

Token Transfers

API Reference

​Use Case

​Code Example

​Key Parameters

​Expected Output

​Monitor Outgoing Transactions

​Performance Tips

​Related Examples

Query Instructions

Query Logs

Token Transfers

API Reference

Use Case

Code Example

Key Parameters

Expected Output

Monitor Outgoing Transactions

Performance Tips

Related Examples