Skip to content

Nft Transfers

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

Columns

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

Indexes

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

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.