> ## Documentation Index
> Fetch the complete documentation index at: https://docs.allium.so/llms.txt
> Use this file to discover all available pages before exploring further.

# Blocks 🌱

### Table Details

| Property          | Value                       |
| ----------------- | --------------------------- |
| Table Name        | `solana_testnet.raw.blocks` |
| Table Status      | Beta 🌱                     |
| Unique Key        | `slot`, `timestamp`         |
| Clustering Key(s) | `to_date("timestamp")`      |

### Table Columns

| Column Name                            | Data Type         | Description                                                                                    |
| -------------------------------------- | ----------------- | ---------------------------------------------------------------------------------------------- |
| slot                                   | NUMBER(38,0)      | The slot number this block was produced for. Slots are the fundamental unit of time in Solana. |
| height                                 | NUMBER(38,0)      | The block height (number of blocks beneath this block in the chain).                           |
| timestamp                              | TIMESTAMP\_NTZ(9) | Estimated production time of the block, as Unix timestamp.                                     |
| hash                                   | VARCHAR(16777216) | The unique identifier (blockhash) of this block.                                               |
| parent\_slot                           | NUMBER(38,0)      | The slot of this block's parent.                                                               |
| previous\_block\_hash                  | VARCHAR(16777216) | The hash of the parent block.                                                                  |
| transaction\_count                     | NUMBER(38,0)      | Total number of transactions in this block.                                                    |
| nonvoting\_transaction\_count          | NUMBER(38,0)      | Number of non-voting transactions (excluding consensus vote txs).                              |
| reward\_count                          | NUMBER(38,0)      | Number of reward records associated with this block.                                           |
| nonvoting\_success\_transaction\_count | NUMBER(38,0)      | Number of non-voting transactions that succeeded in this block.                                |
| success\_transaction\_count            | NUMBER(38,0)      | Total number of successful transactions in this block.                                         |
| \_created\_at                          | TIMESTAMP\_NTZ(9) | Timestamp of when the entry was created in the database.                                       |
| \_updated\_at                          | TIMESTAMP\_NTZ(9) | Timestamp of when the entry was last updated in the database.                                  |

### Related Docs

* [Solana Raw Blocks](/historical-data/supported-blockchains/solana/solana/raw/blocks)