Skip to main content

Asset Transfers

Updated on
Nov 17, 2026

Asset Transfers provides structured transfer history for an account. You can build a custom query from EVM tables in SQL Explorer, run that query through the SQL API, request curated account history through Explorer API, or extract transfers from a Stream with your own filter.

The Explorer API's qn_getAssetTransfers method covers native, ERC-20, ERC-721, and ERC-1155 transfers, plus internal transfers of native value made by contract calls. It returns the sender, recipient, asset, amount, transaction, and block for each matching transfer. See the chain-specific method reference for the full parameter and response schema.

SQL Explorer and Explorer API use the same underlying indexed data through different interfaces. In SQL Explorer, query the EVM tables for the transfer data you need. Explorer API provides qn_getAssetTransfers, an optimized JSON-RPC method that assembles a curated response. With Streams, write a filter over block, receipt, and trace data to extract transfers.

Network and access coverage​

MainnetSQL ExplorerSQL APIExplorer API
Ethereum✓✓✓
BNB Smart Chain✓✓✓
Arc✓✓✓
Robinhood Chain✓✓✓
Elysium✓✓✓
Base✓✓✓
Arbitrum One✓✓✓

EVM indexed data extends back to each supported network's genesis block. The SQL Explorer and SQL API networks above match the EVM query catalog. Explorer API method references are listed in its section below; the Base and Arbitrum One references are pending. Streams requires a custom filter and its supported networks and composite datasets should be checked separately in Streams supported chains and EVM data sources.

Choose an access method​

  • SQL Explorer: Build a custom transfer query from the available EVM tables in the dashboard.
  • SQL API: Run any SQL Explorer query programmatically over REST.
  • Explorer API: Request curated account transfer history through qn_getAssetTransfers on a chain endpoint.
  • Streams: Deliver transfers extracted from block, receipt, and trace data by a custom filter.

The worked examples below are intentionally scoped: the SQL example retrieves native transfers, and the Streams filter selects receipts containing ERC-20 events. qn_getAssetTransfers is the ready-made method covering all transfer types listed above.

SQL Explorer​

This example finds the 25 largest Ethereum native-currency transfers in the latest 1,000 blocks, including internal (trace-level) native transfers. Use the EVM token and log tables for ERC-20 or NFT transfers.

  1. Sign in to the Quicknode Dashboard and open SQL Explorer. Your account needs access to the EVM tables.
  2. Open Tables and inspect evm_native_transfers, evm_blocks, and evm_native_currencies in the EVM schema. These tables provide the fields used in this example.
  3. Select the pre-built Largest native transfers query from EVM Queries, or paste the same query below into the SQL editor. It filters on ethereum-mainnet and a recent block range to limit the data scanned.
  4. Select Run. In Results, check the transaction hash, sender, recipient, amount, and is_internal value. The query orders by amount and returns the largest transfers in the selected range. For a wallet's full history, build a query filtered by account address.
  5. Edit the query for your use case, then Save it or select API to generate a programmatic request.
WITH
(SELECT max(number) FROM evm_blocks WHERE network = 'ethereum-mainnet') AS head,
(SELECT symbol FROM evm_native_currencies FINAL WHERE network = 'ethereum-mainnet') AS native_symbol,
(SELECT decimals FROM evm_native_currencies FINAL WHERE network = 'ethereum-mainnet') AS native_decimals
SELECT
block_number,
block_datetime,
evm_hash_pretty(transaction_hash) AS transaction_hash,
evm_address_pretty(from_address) AS sender,
evm_address_pretty(to_address) AS recipient,
amount / exp10(native_decimals) AS amount_native,
native_symbol,
is_internal,
call_type
FROM evm_native_transfers FINAL
WHERE network = 'ethereum-mainnet' AND block_number > head - 1000
ORDER BY amount DESC
LIMIT 25

To run this query on another supported chain, replace every ethereum-mainnet value in it with the corresponding SQL network value:

ChainSQL network value
Ethereumethereum-mainnet
BNB Smart Chainbsc
Basebase-mainnet
Arbitrum Onearbitrum-mainnet
Arcarc-mainnet
Robinhood Chainrobinhood-mainnet
Elysiumelysium-mainnet

The EVM query catalog also includes Recent ERC-20 transfers and Token transfer history examples. The latter follows one token. For NFT transfers or an account-wide history, inspect the EVM schema and build the query you need. See Getting Started with SQL Explorer for the dashboard workflow.