Token Transfers
The optimism.token_transfers tables provides indexed views of all transfers (mints, sends, and burns) for tokens.
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 token transfer (one of mint, send, or burn). |
| contract_address | text |
Contract address of the token. |
| 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-777 tokens). |
| quantity | numeric |
The quantity of tokens transferred. |
| timestamp | timestamp |
The timestamp of the transfer (in ISO-8601 format). |
| to_address | text |
The address of the receiver. |
| transaction_hash | text |
The transaction hash at which the transfer occurred. |
| __block_number | integer |
The block number at which the event took place in. |
| __confirmed | boolean |
Flag indicating whether the transfer has been confirmed. |
| __last_modified | timestamp |
The date at which this row was last updated (in ISO-8601 format). |
Indexes
| Index |
|---|
| to_address, timestamp, activity_id |
| from_address, timestamp, activity_id |
| contract_address, timestamp, activity_id |
| timestamp, activity_id |
| transaction_hash |
| __confirmed WHERE __confirmed = false |
| 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.