Documentation Index
Fetch the complete documentation index at: https://docs.dune.com/llms.txt
Use this file to discover all available pages before exploring further.
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 |