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.
|address||The address of the account.||
|type||The type of the account (
|last_active_timestamp||The date of the last transaction/trace sent from this address or date of contract creation (in ISO-8601 format).||
|created_timestamp||The date at which the account was first created (in ISO-8601 format).||
|creator_address||The account creator (
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.