Skip to main content

​
Table description

The aptos.blocks table represents the blocks in the Aptos blockchain. A block is a collection of transactions, and is identified by a unique block identifier. Each block contains a timestamp and a reference to the previous block hash, forming a chain of blocks. The block structure is crucial for the blockchain’s integrity and security, ensuring a verifiable and tamper-evident ledger.

​
Table Schema

ColumnTypeDescription
block_heightBIGINTSequential number identifying the block’s position in the chain
timeTIMESTAMPTimestamp when the block was proposed and committed
block_dateDATEDate of the block, truncated from the timestamp for daily aggregations
block_hashVARBINARYUnique cryptographic hash identifying this block
first_versionUINT256The first transaction version included in this block
last_versionUINT256The last transaction version included in this block
proposerVARBINARYAddress of the validator that proposed this block
roundUINT256Consensus round number in which this block was produced
epochUINT256Epoch number during which this block was created
metadata_idVARBINARYUnique identifier for the block metadata event
failed_proposer_indicesARRAY(INTEGER)Indices of validators that failed to propose before this block was finalized
previous_block_votes_bitvecARRAY(SMALLINT)Bit vector indicating which validators voted on the previous block
transactions_countINTEGERTotal number of transactions included in this block

​
Table Sample