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.move_resources table stores information about the Move resources on the Aptos blockchain. Move resources are persistent data structures that are owned by user accounts and can represent various on-chain assets or states. This table includes details on the resource type, the account that owns it, and the resource’s data.
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) |
tx_hash | VARBINARY | Unique hash identifying the transaction |
tx_version | UINT256 | Global sequential version number of the transaction |
tx_gas_used | UINT256 | Amount of gas consumed by the transaction |
tx_vm_status | VARCHAR | Detailed status message returned by the Move VM |
tx_success | BOOLEAN | Whether the transaction executed successfully |
tx_state_change_hash | VARBINARY | Hash of all state changes produced by the transaction |
tx_event_root_hash | VARBINARY | Merkle root hash of all events emitted by the transaction |
tx_state_checkpoint_hash | VARBINARY | Hash of the state checkpoint after this transaction |
tx_accumulator_root_hash | VARBINARY | Root hash of the transaction accumulator after this transaction |
write_set_change_index | INTEGER | Index of this state change within the transaction’s write set |
write_set_change_type | VARCHAR | Type of write set change (e.g. write_resource, delete_resource) |
move_state_key_hash | VARBINARY | Hash of the state key affected by this change |
move_is_deletion | BOOLEAN | Whether this change represents a deletion of the resource |
move_data | VARCHAR | JSON-encoded data payload of the Move resource |
move_address | VARBINARY | Address of the account that owns this resource |
move_module_address | VARBINARY | Address of the module that defines this resource type |
move_resource_module | VARCHAR | Name of the module that defines this resource type |
move_resource_name | VARCHAR | Name of the resource struct type |
move_resource_generic_type_params | ARRAY(VARCHAR) | Generic type parameters applied to this resource instance |