Skip to content


The accounts table provides indexed views of all accounts created on a specific chain, including both externally-owned accounts (colloquially referred to as wallets) and contracts.


Name Description Type
address The address of the account. text
type The type of the account (wallet or contract). text
last_active_timestamp The date of the last transaction/trace sent from this address or date of contract creation (in ISO-8601 format). date-time
created_timestamp The date at which the account was first created (in ISO-8601 format). timestamp
creator_address The account creator (null if the account is not a contract). text


The following indexes are available for this table:

(created_timestamp, address)
(type, created_timestamp, address)
(creator_address, created_timestamp, address)

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.