blocks table provides indexed views of all blocks mined and validated for a specified chain.
|block_number||The block's number||
|block_hash||The hash of all the block's contents.||
|timestamp||The block's timestamp (in ISO-8601 format).||
|parent_hash||The hash of the block's parent block.||
|size_bytes||The block's size (in bytes).||
|gas_limit||The maximum amount of gas that can be used in the block (in gas units).||
|gas_used||The amount of gas used in the block (in gas units).||
|transaction_count||The number of transactions in the block.||
|validator_address||The address of the validator who validated the block.||
|__confirmed||Flag indicating whether the block has been confirmed.||
The following indexes are available for this table:
(__confirmed) WHERE __confirmed = false (timestamp) (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.