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.
Table Details
| Property | Value |
|---|---|
| Table Name | solana_devnet.raw.blocks |
| Table Status | Beta 🌱 |
| Unique Key | slot |
| Clustering Key(s) | to_date("timestamp") |
| Search Optimization | slot, height, hash |
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. |
| _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. |