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.