Skip to main content

Table description

The aptos.events table captures the events that are emitted by smart contracts on the Aptos blockchain. Events are used to log significant actions and changes in smart contracts, such as token transfers or updates to contract states. Each event is linked to the transaction that triggered it, providing a detailed audit trail of contract interactions.

Table Schema

ColumnTypeDescription
block_heightBIGINTSequential number identifying the block’s position in the chain
block_dateDATEDate of the block for daily aggregations
block_timeTIMESTAMPTimestamp when the block was committed
block_hashVARBINARYUnique cryptographic hash identifying the block
block_first_versionUINT256First transaction version included in the block
block_last_versionUINT256Last transaction version included in the block
block_proposerVARBINARYAddress of the validator that proposed the block
block_roundUINT256Consensus round number for the block
block_epochUINT256Epoch number during which the block was created
block_metadata_idVARBINARYUnique identifier for the block metadata event
block_failed_proposer_indicesARRAY(INTEGER)Indices of validators that failed to propose before this block
block_previous_block_votes_bitvecARRAY(SMALLINT)Bit vector of validator votes on the previous block
tx_indexINTEGERPosition of the transaction within the block
tx_typeVARCHARType of the transaction (e.g. user_transaction, block_metadata)
tx_hashVARBINARYUnique hash identifying the transaction that emitted this event
tx_versionUINT256Global sequential version number of the transaction
tx_gas_usedUINT256Amount of gas consumed by the transaction
tx_vm_statusVARCHARDetailed status message returned by the Move VM after execution
tx_successBOOLEANWhether the transaction executed successfully
tx_state_change_hashVARBINARYHash of all state changes produced by the transaction
tx_event_root_hashVARBINARYMerkle root hash of all events emitted by the transaction
tx_state_checkpoint_hashVARBINARYHash of the state checkpoint after this transaction
tx_accumulator_root_hashVARBINARYRoot hash of the transaction accumulator after this transaction
event_indexINTEGERPosition of this event within the transaction’s event list
event_typeVARCHARFully qualified Move type identifier of the event (e.g. 0x1::coin::WithdrawEvent)
guid_account_addressVARBINARYAccount address associated with the event’s globally unique identifier
guid_creation_numberUINT256Creation number of the event handle, unique per account
event_sequence_numberUINT256Sequence number of this event within its event handle
dataVARCHARJSON-encoded payload of the event containing event-specific fields

Table Sample