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.transactions table contains information about all transactions on the Aptos blockchain, including both user-initiated and system transactions. Transactions are the actions that modify the state of the blockchain, such as transfers of tokens or the execution of smart contracts. Each transaction is uniquely identified and linked to the block in which it was included.
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 (e.g. user_transaction, block_metadata, state_checkpoint) |
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 |
events_count | INTEGER | Number of events emitted by this transaction |
changes_count | INTEGER | Number of state changes produced by this transaction |