NFT Transfers

The nft_transfers table provides indexed views of all transfers (mints, sends, and burns) for NFTs.

Columns

Name	Description	Type
contract_address	Contract address of the NFT's collection.	text
token_id	The token ID of the NFT.	numeric
timestamp	The timestamp of the transfer (in ISO-8601 format).	timestamp
block_number	The block number at which the transfer occurred.	integer
transaction_hash	The transaction hash at which the transfer occurred.	text
log_index	The log index at which the transfer occurred.	integer
category	The category of the NFT transfer (one of mint, send, burn).	text
operator_address	The address of the operator that performed the transfer (only for ERC-1155 NFTs).	text
from_address	The address of the sender.	text
to_address	The address of the receiver.	text
quantity	The quantity of the NFT transferred.	numeric
activity_id	A unique, sequential identifier for the transfer event.	numeric
__confirmed	Flag indicating whether the transfer has been confirmed.	boolean

Indexes

The following indexes are available for this table:

(__confirmed) WHERE __confirmed = false
(transaction_hash)
(timestamp, activity_id)
(from_address, timestamp, activity_id)
(to_address, timestamp, activity_id)
(contract_address, timestamp, activity_id)
(contract_address, token_id, timestamp, activity_id)

Got questions? Join our Discord

Discord is the primary home of the Transpose developer community. Join us to ask questions, share your work, and get help.