Skip to content


The blocks table provides indexed views of all blocks mined and validated for a specified chain.


Name Description Type
block_number The block's number integer
block_hash The hash of all the block's contents. text
timestamp The block's timestamp (in ISO-8601 format). timestamp
parent_hash The hash of the block's parent block. text
size_bytes The block's size (in bytes). numeric
gas_limit The maximum amount of gas that can be used in the block (in gas units). numeric
gas_used The amount of gas used in the block (in gas units). numeric
transaction_count The number of transactions in the block. integer
__confirmed Flag indicating whether the block has been confirmed. boolean


The following indexes are available for this table:

(__confirmed) WHERE __confirmed = false
(validator_address, block_number)
(validator_address, timestamp)

Got questions? Join our Discord

Discord is the primary home of the Transpose developer community. Join us to ask questions, share your work, and get help.