Skip to main content

Table description

Stores basic information about Peaq blocks, with one record per block, including the block hash and statistics on the number of extrinsics, events, and transfers contained in each block. This table is partitioned by year, month, and day for efficient querying. Each block record includes metadata such as block number, specification version, relay chain block number, block hashes (hash, parent hash, state root, extrinsics root), block author information, and counts of various operations (extrinsics, events, transfers, traces).

Column Descriptions

ColumnDescriptionType
yearThe year when the block was created, used for partitioning.int
monthThe month when the block was created, used for partitioning.int
dayThe day when the block was created, used for partitioning.int
block_timeThe timestamp when the block was created.timestamp
numberThe block number (sequence number) of the block.long
spec_versionThe specification version of the runtime when this block was created.long
relay_block_numberThe block number of the relay chain block associated with this block.long
hashThe hash of the current block, in binary format.binary
parent_hashThe hash of the parent block, in binary format.binary
state_rootThe Merkle root of the state trie after applying all transactions in this block.binary
extrinsics_rootThe Merkle root of the extrinsics included in this block.binary
author_ss58The SS58-encoded address of the block author (validator) in human-readable format.string
author_pub_keyThe public key of the block author (validator) in binary format.binary
relay_state_rootThe state root of the relay chain associated with this block.binary
extrinsic_countThe number of extrinsics (transactions) included in this block.long
event_countThe number of events emitted in this block.long
transfer_countThe number of transfers executed in this block.long
trace_countThe number of traces generated in this block.long
_updated_atThe time when the block record was last updated.timestamp
_ingested_atThe time when the block data was ingested into the system.timestamp

Table Sample