Query EVM Transactions

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

Use Case

Transaction queries help you:

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

Code Example

curl --compressed -X POST "https://portal.sqd.dev/datasets/ethereum-mainnet/stream" \
  -H 'Content-Type: application/json' \
  -d '{
    "type": "evm",
    "fromBlock": 18000000,
    "toBlock": 18010000,
    "fields": {
      "block": {
        "number": true,
        "timestamp": true
      },
      "transaction": {
        "hash": true,
        "from": true,
        "to": true,
        "value": true,
        "input": true,
        "gasUsed": true,
        "status": true
      }
    },
    "transactions": [{
      "to": ["0xdAC17F958D2ee523a2206206994597C13D831ec7"]
    }]
  }'

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

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

const TARGET_ADDRESS = "0xdAC17F958D2ee523a2206206994597C13D831ec7"; // USDT

const blocks = await dataSource.getBlocks({
  from: 18000000,
  to: 18010000,
  fields: {
    block: { number: true, timestamp: true },
    transaction: {
      hash: true,
      from: true,
      to: true,
      value: true,
      input: true,
      gasUsed: true,
      status: true,
    },
  },
  transactions: [
    {
      to: [TARGET_ADDRESS],
    },
  ],
});

// Process transactions
for (const block of blocks) {
  for (const tx of block.transactions) {
    console.log({
      blockNumber: block.header.number,
      txHash: tx.hash,
      from: tx.from,
      to: tx.to,
      value: tx.value,
      gasUsed: tx.gasUsed,
      success: tx.status === 1,
    });
  }
}

import requests
import json

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

payload = {
    "type": "evm",
    "fromBlock": 18000000,
    "toBlock": 18010000,
    "fields": {
        "block": {
            "number": True,
            "timestamp": True
        },
        "transaction": {
            "hash": True,
            "from": True,
            "to": True,
            "value": True,
            "input": True,
            "gasUsed": True,
            "status": True
        }
    },
    "transactions": [{
        "to": ["0xdAC17F958D2ee523a2206206994597C13D831ec7"]
    }]
}

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({
            "blockNumber": block['header']['number'],
            "txHash": tx['hash'],
            "from": tx['from'],
            "to": tx['to'],
            "value": tx['value'],
            "gasUsed": tx['gasUsed'],
            "success": tx['status'] == 1
        })

Try it yourself with the interactive query interface below:

Key Parameters

Parameter	Description
`from`	Filter transactions by sender address
`to`	Filter transactions by recipient address
`sighash`	Filter by function signature (first 4 bytes of input data)
`status`	Transaction status: 1 = success, 0 = failure
`value`	ETH amount transferred (in wei)
`input`	Transaction calldata
`gasUsed`	Actual gas consumed

Expected Output

{
  "header": {
    "number": 18000123,
    "timestamp": 1697544779
  },
  "transactions": [
    {
      "hash": "0x123...",
      "from": "0xa9d1e08c7793af67e9d92fe308d5697fb81d3e43",
      "to": "0xdac17f958d2ee523a2206206994597c13d831ec7",
      "value": "0",
      "input": "0xa9059cbb000000000000000000000000...",
      "gasUsed": "54234",
      "status": 1
    }
  ]
}

Filter by Function Signature

Query only specific function calls (e.g., ERC-20 transfer function):

curl --compressed -X POST "https://portal.sqd.dev/datasets/ethereum-mainnet/stream" \
  -H 'Content-Type: application/json' \
  -d '{
    "type": "evm",
    "fromBlock": 18000000,
    "toBlock": 18010000,
    "fields": {
      "transaction": {
        "hash": true,
        "from": true,
        "to": true,
        "input": true
      }
    },
    "transactions": [{
      "to": ["0xA0b86991c6218b36c1d19D4a2e9Eb0cE3606eB48"],
      "sighash": ["0xa9059cbb"]
    }]
  }'

const blocks = await dataSource.getBlocks({
  from: 18000000,
  to: 18010000,
  fields: {
    transaction: { hash: true, from: true, to: true, input: true },
  },
  transactions: [
    {
      to: ["0xA0b86991c6218b36c1d19D4a2e9Eb0cE3606eB48"], // USDC
      sighash: ["0xa9059cbb"], // transfer(address,uint256)
    },
  ],
});

payload = {
    "type": "evm",
    "fromBlock": 18000000,
    "toBlock": 18010000,
    "fields": {
        "transaction": {
            "hash": True,
            "from": True,
            "to": True,
            "input": True
        }
    },
    "transactions": [{
        "to": ["0xA0b86991c6218b36c1d19D4a2e9Eb0cE3606eB48"],
        "sighash": ["0xa9059cbb"]
    }]
}

Function signature is computed as keccak256("transfer(address,uint256)")[0:4]. The result is 0xa9059cbb.

Monitor Outgoing Transactions

Track transactions from a specific wallet:

curl --compressed -X POST "https://portal.sqd.dev/datasets/ethereum-mainnet/stream" \
  -H 'Content-Type: application/json' \
  -d '{
    "type": "evm",
    "fromBlock": 18000000,
    "toBlock": 18010000,
    "fields": {
      "transaction": {
        "hash": true,
        "from": true,
        "to": true,
        "value": true
      }
    },
    "transactions": [{
      "from": ["0x28C6c06298d514Db089934071355E5743bf21d60"]
    }]
  }'

const blocks = await dataSource.getBlocks({
  from: 18000000,
  to: 18010000,
  fields: {
    transaction: { hash: true, from: true, to: true, value: true },
  },
  transactions: [
    {
      from: ["0x28C6c06298d514Db089934071355E5743bf21d60"],
    },
  ],
});

payload = {
    "type": "evm",
    "fromBlock": 18000000,
    "toBlock": 18010000,
    "fields": {
        "transaction": {
            "hash": True,
            "from": True,
            "to": True,
            "value": True
        }
    },
    "transactions": [{
        "from": ["0x28C6c06298d514Db089934071355E5743bf21d60"]
    }]
}

Performance Tips

Combine filters: Use both from and to for bidirectional tracking
Filter by sighash: Reduces results to specific function calls
Request minimal fields: Omit input if you don’t need calldata
Check status: Filter failed transactions in post-processing if needed

Query Event Logs

Track smart contract events

Query Traces

Analyze internal transactions

Contract Deployments

Monitor new contract deployments

API Reference

View complete API docs

Overview

Portal API reference

Working with Portal API

Local Setup

Supported Networks

Use Case

Code Example

Key Parameters

Expected Output

Filter by Function Signature

Monitor Outgoing Transactions

Performance Tips

Query Event Logs

Query Traces

Contract Deployments

API Reference

​Use Case

​Code Example

​Key Parameters

​Expected Output

​Filter by Function Signature

​Monitor Outgoing Transactions

​Performance Tips

​Related Examples

Query Event Logs

Query Traces

Contract Deployments

API Reference

Use Case

Code Example

Key Parameters

Expected Output

Filter by Function Signature

Monitor Outgoing Transactions

Performance Tips

Related Examples