aptos.user_transactions

Aptos user-initiated transactions — function calls, gas details, and sender information.

Table description

The aptos.user_transactions table specifically tracks transactions initiated by users of the Aptos blockchain. It includes details such as the sender, the type of transaction, and the gas used, providing insights into how users interact with the network and its smart contracts.

Table Schema

Column	Type	Description
block_height	BIGINT	Sequential number identifying the block’s position in the chain
block_date	DATE	Date of the block for daily aggregations
block_time	TIMESTAMP	Timestamp when the block was committed
block_hash	VARBINARY	Unique cryptographic hash identifying the block
block_first_version	UINT256	First transaction version included in the block
block_last_version	UINT256	Last transaction version included in the block
block_proposer	VARBINARY	Address of the validator that proposed the block
block_round	UINT256	Consensus round number for the block
block_epoch	UINT256	Epoch number during which the block was created
block_metadata_id	VARBINARY	Unique identifier for the block metadata event
block_failed_proposer_indices	ARRAY(INTEGER)	Indices of validators that failed to propose before this block
block_previous_block_votes_bitvec	ARRAY(SMALLINT)	Bit vector of validator votes on the previous block
tx_index	INTEGER	Position of the transaction within the block
tx_type	VARCHAR	Type of the transaction (always user_transaction for this table)
hash	VARBINARY	Unique hash identifying this transaction
version	UINT256	Global sequential version number assigned to this transaction
gas_used	UINT256	Amount of gas consumed by the transaction
vm_status	VARCHAR	Detailed status message returned by the Move VM after execution
success	BOOLEAN	Whether the transaction executed successfully
state_change_hash	VARBINARY	Hash of all state changes produced by the transaction
event_root_hash	VARBINARY	Merkle root hash of all events emitted by the transaction
state_checkpoint_hash	VARBINARY	Hash of the state checkpoint after this transaction
accumulator_root_hash	VARBINARY	Root hash of the transaction accumulator after this transaction
timestamp	UINT256	Unix timestamp of the transaction in microseconds
sender	VARBINARY	Address of the account that submitted the transaction
max_gas_amount	UINT256	Maximum gas units the sender is willing to pay
gas_unit_price	UINT256	Price per gas unit in octas (1 APT = 10^8 octas)
sequence_number	UINT256	Sender’s account sequence number at the time of this transaction
expiration_timestamp_secs	UINT256	Unix timestamp (seconds) after which the transaction expires
events_count	INTEGER	Number of events emitted by this transaction
changes_count	INTEGER	Number of state changes produced by this transaction
payload_type	VARCHAR	Type of transaction payload (e.g. entry_function_payload, script_payload)
entry_function_name	VARCHAR	Name of the entry function called (empty if script payload)
entry_function_module_name	VARCHAR	Module containing the entry function called
entry_function_module_address	VARBINARY	Address of the module containing the entry function
script_bytecode	VARBINARY	Compiled bytecode of the script payload (empty if entry function)
script_abi	VARCHAR	ABI definition of the script payload
type_arguments	ARRAY(VARCHAR)	Generic type arguments passed to the entry function or script
arguments	ARRAY(VARCHAR)	Arguments passed to the entry function or script

Table Sample