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
Some NFTs may have non-standard transfer mechanisms and might not be included in the transfers table.
You can check the logic for the transfers table here. The level of detail of the transfers table will vary by chain.
Query recent NFT transfers for a specific addressThis query returns the most recent NFT transfers (both incoming and outgoing) for a specified address:
Copy
Ask AI
SELECT block_time, token_standard, CASE WHEN "from" = {{address}} THEN 'Outgoing' WHEN "to" = {{address}} THEN 'Incoming' END AS direction, contract_address, token_id, amountFROM nft.transfersWHERE ("from" = {{address}} OR "to" = {{address}}) AND block_time > now() - interval '30' dayORDER BY block_time DESCLIMIT 100
Calculate daily transfer volume for a specific NFT contractThis query calculates the daily transfer volume for a specific NFT contract:
Copy
Ask AI
SELECT block_date, COUNT(*) AS num_transfers, SUM(amount) AS total_amountFROM nft.transfersWHERE contract_address = {{contract_address}} AND block_time > now() - interval '30' day AND blockchain = 'ethereum'GROUP BY 1ORDER BY 1 DESC
Identify most active NFT contracts in the last 24 hoursThis query finds the most active NFT contracts by transfer count in the last 24 hours:
Copy
Ask AI
SELECT blockchain, contract_address, token_standard, COUNT(*) AS transfer_countFROM nft.transfersWHERE block_time > now() - interval '1' dayGROUP BY 1, 2, 3ORDER BY transfer_count DESCLIMIT 50