Accounts

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.

Columns

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

Indexes

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.