Table description
Thesolana.blocks table contains the block data within Solana’s blockchain. It can be used to identify block activity and transaction changes over time.
Table Schema
| Column | Type | Description |
|---|---|---|
slot | BIGINT | The slot number of the block, used as the primary block identifier on Solana |
height | BIGINT | The block height (number of blocks since genesis) |
time | TIMESTAMP | The timestamp when the block was produced |
date | DATE | The date the block was produced |
hash | VARCHAR | The unique hash of the block |
total_transactions | INTEGER | Total number of transactions included in the block (vote + non-vote) |
successful_transactions | INTEGER | Number of transactions that completed successfully |
failed_transactions | INTEGER | Number of transactions that failed |
total_vote_transactions | INTEGER | Total number of validator vote transactions in the block |
total_non_vote_transactions | INTEGER | Total number of non-vote (user) transactions in the block |
successful_vote_transactions | INTEGER | Number of vote transactions that succeeded |
successful_non_vote_transactions | INTEGER | Number of non-vote transactions that succeeded |
failed_vote_transactions | INTEGER | Number of vote transactions that failed |
failed_non_vote_transactions | INTEGER | Number of non-vote transactions that failed |
parent_slot | BIGINT | The slot number of the parent block |
previous_block_hash | VARCHAR | The hash of the parent block |
num_reward_partitions | BIGINT | The number of reward partitions in this block |