Tokens
The avalanche.tokens table provides indexed views of all tokens.
Columns
| Name | Type | Description |
|---|---|---|
| contract_address | text |
Contract address of the token. |
| created_timestamp | timestamp |
The token's timestamp of creation (in ISO-8601 format). |
| decimals | integer |
The number of decimals used by the token in user representations. |
| description | text |
The token's description. |
| external_url | text |
The token's website URL. |
| image_url | text |
The token's image URL. |
| last_refreshed | timestamp |
The timestamp at which the token was last refreshed by the Transpose backend (in ISO-8601 format). |
| name | text |
The token's name. |
| standard | text |
The token's standard (ERC-20 or ERC-777). |
| supply | numeric |
The token's total supply (tokens minted minus tokens burned). |
| symbol | text |
The token's symbol. |
| verified | boolean |
The token's verified status. |
| __updated_block_number | integer |
The block number at which the token's metadata was last updated. |
Indexes
| Index |
|---|
| standard, created_timestamp, contract_address |
| last_refreshed NULLS FIRST |
| name WHERE (name IS NOT NULL AND length(name <= 15) |
| symbol WHERE (symbol IS NOT NULL AND length(symbol <= 15) |
| created_timestamp, contract_address |
| contract_address |
| symbol WHERE (symbol IS NOT NULL AND length(symbol <= 15) |
| name WHERE (name IS NOT NULL AND length(name <= 15) |
| contract_address WHERE verified = true |
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.