> ## 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_cash.raw.blocks` |
| Table Status        | Production-Ready          |
| Unique Key          | `timestamp`, `number`     |
| Clustering Key(s)   | `to_date("timestamp")`    |
| 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 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                 | NUMBER(38,0)      | A 32-bit number that miners change to try to get a valid block hash.                                                                                               |
| bits                  | VARCHAR(16777216) | The difficulty threshold specified in the 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\_block\_hash | VARCHAR(66)       | The block hash of the previous block.                                                                                                                              |
| next\_block\_hash     | 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.                                                                                                                            |
| auxpow                | VARIANT           | Auxiliary proof-of-work data, when present (used for merged mining).                                                                                               |
| \_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.                                                                                                      |