Skip to content

Tokens

The tokens table provides indexed views of all tokens for a specified chain.

Columns

Name Description Type
contract_address Contract address of the token. text
created_timestamp The token's timestamp of creation (in ISO-8601 format). timestamp
standard The token's standard (ERC-20 or ERC-777). text
supply The token's total supply (tokens minted minus tokens burned). numeric
last_refreshed The timestamp at which the token was last refreshed by the Transpose backend (in ISO-8601 format). timestamp
name The token's name. text
symbol The token's symbol. text
decimals The number of decimals used by the token in user representations. integer
description The token's description. text
external_url The token's website URL. text
image_url The token's image URL. text
verified Met a minimum on-chain liquidity threshold of $1M. boolean

Indexes

The following indexes are available for this table:

(verified) WHERE verified = true
(last_refreshed ASC NULLS FIRST)
(created_timestamp, contract_address)
(standard, created_timestamp, contract_address)
(symbol) WHERE symbol IS NOT NULL AND LENGTH(symbol) <= 15
GIST (symbol gist_trgm_ops) WHERE symbol IS NOT NULL AND LENGTH(symbol) <= 15
(name) WHERE name IS NOT NULL AND LENGTH(name) <= 15
GIST (name gist_trgm_ops) WHERE name IS NOT NULL AND LENGTH(name) <= 15

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.