Documentation Index
Fetch the complete documentation index at: https://docs.dune.com/llms.txt
Use this file to discover all available pages before exploring further.
Table description
Theaptos.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 |