aptos.move_resources

Aptos Move resource snapshots — on-chain state stored in Move structs by account.

Table description

The aptos.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

Table Sample