> ## 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          | `bitcoin.raw.blocks`  |
| Table Status        | Production-Ready      |
| Unique Key          | `timestamp`, `number` |
| Clustering Key(s)   | `timestamp::date`     |
| Search Optimization | `hash`                |

### Table Columns

| Column Name         | Data Type         | Description                                                                                                                                                                |
| ------------------- | ----------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| timestamp           | TIMESTAMP\_NTZ(9) | Timestamp of the block.                                                                                                                                                    |
| number              | NUMBER(38,0)      | Block number or block height.                                                                                                                                              |
| hash                | VARCHAR(66)       | Block hash.                                                                                                                                                                |
| confirmations       | NUMBER(38,0)      | The number of confirmations, or -1 if the block is not on the main chain. A confirmation indicates that a Bitcoin transaction has been added to a block on the blockchain. |
| version             | NUMBER(38,0)      | The block version.                                                                                                                                                         |
| merkle\_root        | VARCHAR(66)       | The root node of a Merkle tree, where leaves are transaction hashes.                                                                                                       |
| median\_time        | NUMBER(38,0)      | The median block time expressed in UNIX epoch time.                                                                                                                        |
| nonce               | VARCHAR(42)       | A 32-bit number that miners change to try to get a valid block hash.                                                                                                       |
| bits                | VARCHAR(42)       | The difficulty threshold specified in block header.                                                                                                                        |
| difficulty          | FLOAT             | The estimated amount of work done to find this block relative to the estimated amount of work done to find block 0.                                                        |
| chainwork           | VARCHAR(16777216) | Expected number of hashes required to produce the current chain.                                                                                                           |
| transaction\_count  | NUMBER(38,0)      | Total number of transactions in the block.                                                                                                                                 |
| previous\_blockhash | VARCHAR(66)       | The block hash of the previous block.                                                                                                                                      |
| next\_blockhash     | VARCHAR(66)       | The block hash of the next block, if applicable.                                                                                                                           |
| stripped\_size      | NUMBER(38,0)      | The block size excluding witness data.                                                                                                                                     |
| size                | NUMBER(38,0)      | Size of the block mined.                                                                                                                                                   |
| weight              | NUMBER(38,0)      | The block weight as defined in BIP 141.                                                                                                                                    |
| \_stg\_created\_at  | TIMESTAMP\_NTZ(9) | Data creation timestamp at staging level.                                                                                                                                  |
| \_created\_at       | TIMESTAMP\_NTZ(9) | Data creation timestamp.                                                                                                                                                   |
| \_updated\_at       | TIMESTAMP\_NTZ(9) | Timestamp of when the entry was last updated in the database.                                                                                                              |