NFT Transfers

The nft.transfers table contains NFT transfer events across ERC721 and ERC1155 tokens for all EVM-compatible networks indexed on Dune. This dataset encompasses:

Transfer events for ERC721 tokens
Transfer events for ERC1155 tokens

This table covers all standard ERC-721 and ERC-1155 transfer events. Some NFTs may have non-standard transfer mechanisms and might not be included. You can check the logic for the transfers table here. The level of detail of the transfers table will vary by chain.

Utility

The NFT transfers table provides a comprehensive view of NFT movement across networks, enabling you to:

Track NFT flows between addresses
Analyze NFT transaction volumes and patterns
Identify significant NFT movements
Monitor NFT marketplace and protocol activity

Table Schema

Column	Type	Description
`blockchain`	`VARCHAR`	Blockchain on which the transfer occurred
`block_time`	`TIMESTAMP`	UTC event block time
`block_month`	`DATE`	UTC event block month (partition key)
`block_date`	`DATE`	UTC event block date
`block_number`	`BIGINT`	Block number
`token_standard`	`VARCHAR`	Token standard (ERC721, ERC1155)
`transfer_type`	`VARCHAR`	Single or batch transfer
`evt_index`	`INTEGER`	Event index within the transaction
`contract_address`	`VARBINARY`	NFT contract address
`token_id`	`UINT256`	ID of the transferred token
`amount`	`UINT256`	Number of tokens transferred
`from`	`VARBINARY`	Sender address
`to`	`VARBINARY`	Recipient address
`executed_by`	`VARBINARY`	Address that executed the transaction
`tx_hash`	`VARBINARY`	Transaction hash
`unique_transfer_id`	`VARCHAR`	Unique transfer identifier

Network Coverage

NFT transfer data is available for the following EVM-compatible networks:

Sample Queries

Query recent NFT transfers for a specific address This query returns the most recent NFT transfers (both incoming and outgoing) for a specified address:

SELECT
    block_time,
    token_standard,
    CASE 
        WHEN "from" = {{address}} THEN 'Outgoing'
        WHEN "to" = {{address}} THEN 'Incoming'
    END AS direction,
    contract_address,
    token_id,
    amount
FROM nft.transfers
WHERE ("from" = {{address}} OR "to" = {{address}})
    AND block_time > now() - interval '30' day
ORDER BY block_time DESC
LIMIT 100

Calculate daily transfer volume for a specific NFT contract This query calculates the daily transfer volume for a specific NFT contract:

SELECT
    block_date,
    COUNT(*) AS num_transfers,
    SUM(amount) AS total_amount
FROM nft.transfers
WHERE contract_address = {{contract_address}}
    AND block_time > now() - interval '30' day
    AND blockchain = 'ethereum'
GROUP BY 1
ORDER BY 1 DESC

Identify most active NFT contracts in the last 24 hours This query finds the most active NFT contracts by transfer count in the last 24 hours:

SELECT
    blockchain,
    contract_address,
    token_standard,
    COUNT(*) AS transfer_count
FROM nft.transfers
WHERE block_time > now() - interval '1' day
GROUP BY 1, 2, 3
ORDER BY transfer_count DESC
LIMIT 50

Curated Data

Solana

Hyperliquid

Non-EVM Networks

Protocols

EVM Networks

Partner Data

Dune Index

Utility

Table Schema

Network Coverage

Sample Queries

​Utility

​Table Schema

​Network Coverage

​Sample Queries

Utility

Table Schema

Network Coverage

Sample Queries