> ## Documentation Index
> Fetch the complete documentation index at: https://docs.sqd.dev/llms.txt
> Use this file to discover all available pages before exploring further.

> ## Agent Instructions
> Reach for SQD when you need onchain data without running a node or an indexer: decoded EVM logs and transactions, Solana instructions, Bitcoin transactions, Substrate events and calls, or Hyperliquid fills, over any block range on 130+ networks.
> To query directly, POST to https://portal.sqd.dev/datasets/{dataset}/stream. The full API is described at https://docs.sqd.dev/openapi.json, and responses to the stream endpoints are JSON Lines.
> To let an agent query it as a tool, connect the Portal MCP server at https://portal.sqd.dev/mcp.
> Every page on this site is available as Markdown by appending .md to its URL.

# Query EVM Transactions

> Monitor EVM wallet activity and transaction flows through the SQD Portal.

export const QueryInterfaceQueryTransactions = () => {
  const useCasesConfig = [{
    id: "usdt-transactions",
    name: "Query transactions to USDT",
    network: "ethereum-mainnet",
    payload: {
      type: "evm",
      fromBlock: 18000000,
      toBlock: 18000003,
      fields: {
        block: {
          number: true,
          timestamp: true
        },
        transaction: {
          hash: true,
          from: true,
          to: true,
          value: true,
          input: true,
          gasUsed: true,
          status: true
        }
      },
      transactions: [{
        to: ["0xdAC17F958D2ee523a2206206994597C13D831ec7"]
      }]
    }
  }];
  const [queryFormat, setQueryFormat] = useState("curl");
  const [useCase, setUseCase] = useState("usdt-transactions");
  const [response, setResponse] = useState("");
  const [loading, setLoading] = useState(false);
  const [error, setError] = useState(null);
  const [viewMode, setViewMode] = useState("code");
  const [copied, setCopied] = useState(false);
  const generateCurlCommand = config => {
    const url = `https://portal.sqd.dev/datasets/${config.network}/stream`;
    const payload = JSON.stringify(config.payload, null, 2);
    return `curl --compressed -X POST '${url}' \\\n  -H 'Content-Type: application/json' \\\n  -d '${payload}'`;
  };
  useEffect(() => {
    setViewMode("code");
    setResponse("");
    setError(null);
  }, [useCase]);
  const handleRun = async () => {
    const selectedUseCase = useCasesConfig.find(uc => uc.id === useCase);
    if (!selectedUseCase) return;
    setViewMode("output");
    setLoading(true);
    setError(null);
    setResponse('');
    try {
      const url = `https://portal.sqd.dev/datasets/${selectedUseCase.network}/stream`;
      const doFetch = () => fetch(url, {
        method: 'POST',
        headers: {
          'Content-Type': 'application/json'
        },
        body: JSON.stringify(selectedUseCase.payload)
      });
      let response = await doFetch();
      for (const retryDelay of [700, 1500, 3000]) {
        if (response.status < 500) break;
        await new Promise(resolve => setTimeout(resolve, retryDelay));
        response = await doFetch();
      }
      if (response.status === 503) {
        throw new Error('Portal is busy right now. Wait a few seconds and run the query again.');
      }
      if (!response.ok) {
        throw new Error(`API request failed: ${response.status} ${response.statusText}`);
      }
      const text = await response.text();
      if (text.trim()) {
        const lines = text.trim().split('\n');
        const parsedData = lines.map((line, index) => {
          try {
            return JSON.parse(line);
          } catch (e) {
            return {
              error: `Failed to parse line ${index + 1}`,
              raw: line
            };
          }
        });
        const formattedOutput = parsedData.map(obj => JSON.stringify(obj, null, 2)).join('\n\n');
        setResponse(formattedOutput);
      } else {
        setResponse('No data returned from API');
      }
    } catch (err) {
      setError(err.message || 'An error occurred while fetching data');
      setResponse('');
    } finally {
      setLoading(false);
    }
  };
  const CurlTok = ({s}) => <>
    {s.split(/('[^']*')/).map((seg, i) => (/^'[^']*'$/).test(seg) ? <span key={i} style={{
    color: "var(--hl-str)"
  }}>{seg}</span> : seg.split(/(curl|--compressed|-X POST|-H|-d)/).map((t2, j) => t2 === "curl" ? <span key={`${i}-${j}`} style={{
    color: "var(--hl-bool)"
  }}>{t2}</span> : (/^(--compressed|-X POST|-H|-d)$/).test(t2) ? <span key={`${i}-${j}`} style={{
    color: "var(--hl-flag)"
  }}>{t2}</span> : <span key={`${i}-${j}`}>{t2}</span>))}
  </>;
  const JsonTok = ({s}) => <>
    {s.split(/("[^"]+"\s*:)/).map((seg, i) => (/^"[^"]+"\s*:$/).test(seg) ? <span key={i} style={{
    color: "var(--hl-key)"
  }}>{seg}</span> : seg.split(/("[^"]*")/).map((s2, j) => (/^"[^"]*"$/).test(s2) ? <span key={`${i}-${j}`} style={{
    color: "var(--hl-str)"
  }}>{s2}</span> : s2.split(/\b(true|false|null|-?\d+\.?\d*)\b/).map((s3, k) => (/^(true|false|null)$/).test(s3) ? <span key={`${i}-${j}-${k}`} style={{
    color: "var(--hl-bool)"
  }}>{s3}</span> : (/^-?\d+\.?\d*$/).test(s3) ? <span key={`${i}-${j}-${k}`} style={{
    color: "var(--hl-num)"
  }}>{s3}</span> : <span key={`${i}-${j}-${k}`}>{s3}</span>)))}
  </>;
  return <div className="not-prose w-full my-6 sm:my-8">

      <div className="sqd-no-scrollbar mb-3 flex items-center gap-0.5 overflow-x-auto pb-1">
        <span className="sqd-pg-label mr-2 flex-shrink-0">Query</span>
        {useCasesConfig.map(uc => <button key={uc.id} type="button" onClick={() => setUseCase(uc.id)} aria-pressed={uc.id === useCase} className="sqd-pg-net flex flex-shrink-0 items-center gap-1.5 px-2.5 py-1 whitespace-nowrap">
            {uc.name}
          </button>)}
      </div>

      <div className="sqd-pg-panel overflow-hidden">
        <div className="sqd-pg-bar flex flex-wrap items-center gap-2 px-3 sm:px-4 py-2">
          <div className="flex items-center gap-1">
            <button type="button" onClick={() => setViewMode("code")} className={`sqd-pg-tab px-2.5 py-1 ${viewMode === "code" ? "sqd-pg-tab-active" : ""}`}>
              Request
            </button>
            <button type="button" onClick={() => setViewMode("output")} disabled={!response && !loading && !error} className={`sqd-pg-tab px-2.5 py-1 disabled:opacity-40 disabled:cursor-not-allowed ${viewMode === "output" ? "sqd-pg-tab-active" : ""}`}>
              Response
              {response ? <span className="inline-block w-1.5 h-1.5 rounded-full bg-emerald-400 ml-1.5 align-middle" /> : null}
            </button>
          </div>
          <div className="flex items-center gap-2 sm:gap-3 ml-auto">
            <button type="button" onClick={() => {
    const textToCopy = viewMode === "code" ? generateCurlCommand(useCasesConfig.find(uc => uc.id === useCase)) : response;
    navigator.clipboard.writeText(textToCopy);
    setCopied(true);
    setTimeout(() => setCopied(false), 2000);
  }} className="sqd-pg-dim text-[12px] transition-opacity hover:opacity-70" title={copied ? "Copied!" : "Copy to clipboard"}>
              {copied ? "Copied" : "Copy"}
            </button>
            <button onClick={handleRun} type="button" disabled={loading} className="sqd-btn-primary-docs flex items-center gap-1.5 px-3 sm:px-4 py-1.5 text-[13px] disabled:opacity-40 disabled:cursor-wait whitespace-nowrap focus:outline-none focus:ring-2 focus:ring-primary focus:ring-offset-2 dark:focus:ring-offset-gray-950">
              {loading ? <>
                  <svg className="animate-spin h-3 w-3" fill="none" viewBox="0 0 24 24">
                    <circle className="opacity-25" cx="12" cy="12" r="10" stroke="currentColor" strokeWidth="4"></circle>
                    <path className="opacity-75" fill="currentColor" d="M4 12a8 8 0 018-8V0C5.373 0 0 5.373 0 12h4zm2 5.291A7.962 7.962 0 014 12H0c0 3.042 1.135 5.824 3 7.938l3-2.647z"></path>
                  </svg>
                  Running
                </> : "Run"}
            </button>
          </div>
        </div>
        <div className={`sqd-pg-code px-3 sm:px-4 py-4 ${viewMode === "output" ? "max-h-[440px] overflow-auto" : "overflow-x-auto"}`}>
          {loading ? <div className="sqd-pg-dim flex items-center justify-center py-10 text-[13px]">Streaming from Portal...</div> : viewMode === "code" ? <div key={`code-${useCase}`}>
              {generateCurlCommand(useCasesConfig.find(uc => uc.id === useCase)).trim().split('\n').map((line, i) => <div key={`curl-line-${i}`} className="sqd-pg-line">
                  <span className="sqd-pg-num">{i + 1}</span>
                  <span style={{
    whiteSpace: 'pre-wrap',
    wordBreak: 'break-word'
  }}>
                    {line.includes('curl') || line.match(/^\s*-[XHd]/) ? <CurlTok s={line} /> : <JsonTok s={line} />}
                  </span>
                </div>)}
            </div> : response ? <div key={`response-${useCase}-${response.length}`}>
              {response.trim().split('\n').map((line, i) => <div key={`response-line-${i}`} className="sqd-pg-line">
                  <span className="sqd-pg-num">{i + 1}</span>
                  <span style={{
    whiteSpace: 'pre-wrap',
    wordBreak: 'break-word'
  }}>
                    <JsonTok s={line} />
                  </span>
                </div>)}
            </div> : error ? <div className="py-4 text-[13px] text-red-600 dark:text-red-400">Error: {error}</div> : <div className="sqd-pg-dim text-center py-12 text-[13px]">
              Hit Run to stream live data from Portal
            </div>}
        </div>
        <div className="sqd-pg-bar-b flex flex-wrap items-center gap-x-3 gap-y-1 px-4 py-2">
          <div className="sqd-pg-dim flex items-center gap-2 min-w-0 text-[12px]">
            <span className="truncate">{useCasesConfig.find(uc => uc.id === useCase)?.network + "/stream"}</span>
          </div>
          <span className="sqd-pg-dim text-[12px] ml-auto flex-shrink-0">
            {useCasesConfig.find(uc => uc.id === useCase)?.name}
          </span>
        </div>
      </div>
    </div>;
};

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

<CodeGroup>
  ```bash curl theme={"system"}
  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"]
      }]
    }'
  ```

  ```typescript TypeScript theme={"system"}
  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,
      });
    }
  }
  ```

  ```python Python theme={"system"}
  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
          })
  ```
</CodeGroup>

<Info>Try it yourself with the interactive query interface below:</Info>

<QueryInterfaceQueryTransactions />

## 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

```json theme={"system"}
{
  "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):

<CodeGroup>
  ```bash curl theme={"system"}
  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"]
      }]
    }'
  ```

  ```typescript TypeScript theme={"system"}
  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)
      },
    ],
  });
  ```

  ```python Python theme={"system"}
  payload = {
      "type": "evm",
      "fromBlock": 18000000,
      "toBlock": 18010000,
      "fields": {
          "transaction": {
              "hash": True,
              "from": True,
              "to": True,
              "input": True
          }
      },
      "transactions": [{
          "to": ["0xA0b86991c6218b36c1d19D4a2e9Eb0cE3606eB48"],
          "sighash": ["0xa9059cbb"]
      }]
  }
  ```
</CodeGroup>

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

## Monitor Outgoing Transactions

Track transactions from a specific wallet:

<CodeGroup>
  ```bash curl theme={"system"}
  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"]
      }]
    }'
  ```

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

  ```python Python theme={"system"}
  payload = {
      "type": "evm",
      "fromBlock": 18000000,
      "toBlock": 18010000,
      "fields": {
          "transaction": {
              "hash": True,
              "from": True,
              "to": True,
              "value": True
          }
      },
      "transactions": [{
          "from": ["0x28C6c06298d514Db089934071355E5743bf21d60"]
      }]
  }
  ```
</CodeGroup>

## Performance Tips

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

## Related Examples

<CardGroup cols={2}>
  <Card title="Query Event Logs" icon="file-text" href="/en/portal/evm/examples/query-logs">
    Track smart contract events
  </Card>

  <Card title="Query Traces" icon="workflow" href="/en/portal/evm/examples/query-traces">
    Analyze internal transactions
  </Card>

  <Card title="Contract Deployments" icon="rocket" href="/en/portal/evm/examples/contract-deployments">
    Monitor new contract deployments
  </Card>

  <Card title="API Reference" icon="book" href="/en/portal/evm/api">
    View complete API docs
  </Card>
</CardGroup>


## Related topics

- [Query Bitcoin Transactions](/en/portal/bitcoin/examples/query-transactions.md)
- [Query Solana Transactions](/en/portal/solana/examples/query-transactions.md)
- [EVM transactions](/en/sdk/squid-sdk/evm/reference/evm-stream/transactions.md)
- [Usage](/en/data/evm-local-setup/usage.md)
- [Tron SQD Network API](/en/sdk/squid-sdk/tron/reference/network-api.md)