> ## 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

All blocks, starting from genesis.

### Table Details

| Property            | Value                     |
| ------------------- | ------------------------- |
| Table Name          | `rootstock.raw.blocks`    |
| Table Status        | Production-Ready          |
| Unique Key          | `number`                  |
| Clustering Key(s)   | `to_date("timestamp")`    |
| Search Optimization | `number`, `hash`, `miner` |

### Table Columns

| Column Name                                    | Data Type         | Description                                                                                                                                    |
| ---------------------------------------------- | ----------------- | ---------------------------------------------------------------------------------------------------------------------------------------------- |
| timestamp                                      | TIMESTAMP\_NTZ(9) | The unix timestamp for when the block was collated.                                                                                            |
| number                                         | NUMBER(38,0)      | The length of the chain, in blocks.                                                                                                            |
| hash                                           | VARCHAR(66)       | Unique identifier of a block.                                                                                                                  |
| parent\_hash                                   | VARCHAR(66)       | Unique identifier of the block preceding this block, also known as the parent block.                                                           |
| nonce                                          | VARCHAR(42)       | The hash of the generated proof-of-work. null if pending.                                                                                      |
| sha3\_uncles                                   | VARCHAR(66)       | An array of uncle hashes.                                                                                                                      |
| logs\_bloom                                    | VARCHAR(16777216) | The bloom filter for the logs of the block.                                                                                                    |
| transactions\_root                             | VARCHAR(66)       | The root of the transaction trie of the block.                                                                                                 |
| state\_root                                    | VARCHAR(66)       | The root of the final state trie of the block.                                                                                                 |
| receipts\_root                                 | VARCHAR(66)       | The root of the receipts trie of the block.                                                                                                    |
| miner                                          | VARCHAR(42)       | The address of the beneficiary to whom the mining rewards were given.                                                                          |
| difficulty                                     | NUMBER(38,0)      | The integer of the difficulty for this block.                                                                                                  |
| total\_difficulty                              | VARCHAR(66)       | The integer of the total difficulty of the chain until this block.                                                                             |
| size                                           | NUMBER(38,0)      | The size of the block, in bytes, as determined by the gas\_limit.                                                                              |
| extra\_data                                    | VARCHAR(16777216) | The "extra data" field of this block.                                                                                                          |
| gas\_limit                                     | NUMBER(38,0)      | Gas limit of the current block.                                                                                                                |
| gas\_used                                      | NUMBER(38,0)      | Total gas used in the block.                                                                                                                   |
| transaction\_count                             | NUMBER(38,0)      | Number of transactions included in this block.                                                                                                 |
| base\_fee\_per\_gas                            | NUMBER(38,0)      | Post London Upgrade (EIP1559), this represents the minimum gas\_used required for a transaction to be included in a block. Represented in wei. |
| bitcoin\_merged\_mining\_coinbase\_transaction | VARCHAR(16777216) | The coinbase transaction of the Bitcoin block that was used to merge-mine this Rootstock block.                                                |
| bitcoin\_merged\_mining\_header                | VARCHAR(16777216) | The Bitcoin block header of the block that was used to merge-mine this Rootstock block.                                                        |
| bitcoin\_merged\_mining\_merkle\_proof         | VARCHAR(16777216) | The Merkle proof that links the Bitcoin block's Merkle root to the coinbase transaction containing the Rootstock block's merge-mining tag.     |
| cumulative\_difficulty                         | NUMBER(38,0)      | The total accumulated difficulty of the Rootstock chain up to and including this block.                                                        |
| hash\_for\_merged\_mining                      | VARCHAR(16777216) | A hash derived from the Rootstock block header fields that Bitcoin miners commit to in the merge-mining coinbase transaction.                  |
| minimum\_gas\_price                            | NUMBER(38,0)      | The minimum gas price required for a transaction to be included in this block, in wei.                                                         |
| paid\_fees                                     | NUMBER(38,0)      | The total amount of transaction fees paid by all transactions included in this block, in wei.                                                  |
| \_created\_at                                  | TIMESTAMP\_NTZ(9) | Timestamp when the record was created.                                                                                                         |
| \_updated\_at                                  | TIMESTAMP\_NTZ(9) | Timestamp when the record was last updated.                                                                                                    |

### Related Docs

* [EVM Raw Blocks](/historical-data/supported-blockchains/evm/core-schemas/raw/blocks)