Token Transfers
The token_transfers
tables provides indexed views of all transfers (mints, sends, and burns) for tokens.
Columns
Name | Description | Type |
---|---|---|
contract_address | Contract address of the token. | text |
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 token transfer (one of mint , send , or burn ). |
text |
operator_address | The address of the operator that performed the transfer (only for ERC-777 tokens). | text |
from_address | The address of the sender. | text |
to_address | The address of the receiver. | text |
quantity | The quantity of tokens 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)
(contract_address, timestamp, activity_id)
(from_address, timestamp, activity_id)
(to_address, 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.