Skip to content

Tokens

The goerli.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 True if the contract address has been verified by Transpose.
__updated_block_number integer The block number at which the token's data was last updated.

Indexes

Index
verified WHERE verified = true
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)

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.