NFT Owners

The nft_owners table provides indexed views of all current owners and current owner balances for NFTs.

Ownership and balances are only updated once the underlying transaction causing the change in ownership/balance is confirmed by the network (roughly ~10 minutes on all chains).

Looking for NFT balances at a specific point in time? Check out our historical_nft_owners table to query balance and ownership data at a particular timestamp. Or, for historical native token balances, check out our historical_native_token_owners table. Or, for historical token balances, check out our historical_token_owners table.

Columns

Name	Description	Type
contract_address	Contract address of the NFT's collection.	text
token_id	The token ID of the NFT.	numeric
owner_address	The address of the owner.	text
balance	The owner's balance of the NFT.	numeric

Indexes

The following indexes are available for this table:

(owner_address, contract_address, token_id)
(contract_address, token_id, balance DESC, owner_address)

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.