Skip to content

Token Owners

The token_owners table provides indexed views of all current owners and current owner balances for tokens.

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 token balances at a specific point in time? Check out our historical_token_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 NFT balances, check out our historical_nft_owners table.

Columns

Name Description Type
contract_address Contract address of the token. text
owner_address The address of the owner. text
balance The owner's balance for the token. numeric

Indexes

The following indexes are available for this table:

(owner_address, contract_address)
(contract_address, 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.