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

Blocks are the building blocks of blockchains and rollups.

A block contains transactions which will alter the state of an EVM system incrementally. Transaction within a block can only be executed one after the other, not in parallel.

<Info>
  Several columns may only be applicable for specific EVM-compatible blockchains. The list of columns present in the table is not exhaustive.
</Info>

### Table Columns

Unique Key: `number`

| Column Name                      | Data Type         | Description                                                                                                                                    |
| -------------------------------- | ----------------- | ---------------------------------------------------------------------------------------------------------------------------------------------- |
| timestamp                        | TIMESTAMP\_NTZ(9) | The unix timestamp for when the block was collated.                                                                                            |
| number                           | BIGINT            | The length of the chain, in blocks.                                                                                                            |
| hash                             | VARCHAR           | Unique identifier of a block.                                                                                                                  |
| parent\_hash                     | VARCHAR           | Unique identifier of the block preceding this block, also known as the parent block.                                                           |
| nonce                            | VARCHAR           | The hash of the generated proof-of-work. null if pending.                                                                                      |
| sha3\_uncles                     | VARCHAR           | An array of uncle hashes.                                                                                                                      |
| logs\_bloom                      | VARCHAR           | The bloom filter for the logs of the block.                                                                                                    |
| transactions\_root               | VARCHAR           | The root of the transaction trie of the block.                                                                                                 |
| state\_root                      | VARCHAR           | The root of the final state trie of the block.                                                                                                 |
| receipts\_root                   | VARCHAR           | The root of the receipts trie of the block.                                                                                                    |
| miner                            | VARCHAR           | The address of the beneficiary to whom the mining rewards were given.                                                                          |
| difficulty                       | BIGINT            | The integer of the difficulty for this block.                                                                                                  |
| total\_difficulty                | VARCHAR           | The integer of the total difficulty of the chain until this block.                                                                             |
| size                             | BIGINT            | The size of the block, in bytes, as determined by the gas\_limit.                                                                              |
| extra\_data                      | VARCHAR           | The "extra data" field of this block.                                                                                                          |
| gas\_limit                       | BIGINT            | Gas limit of the current block.                                                                                                                |
| gas\_used                        | BIGINT            | Total gas used in the block.                                                                                                                   |
| transaction\_count               | BIGINT            | Number of transactions included in this block.                                                                                                 |
| base\_fee\_per\_gas              | BIGINT            | Post London Upgrade (EIP1559), this represents the minimum gas\_used required for a transaction to be included in a block. Represented in wei. |
| send\_root                       | VARCHAR           | The root hash of send operations.                                                                                                              |
| blob\_gas\_used                  | BIGINT            | Total blob gas used by all blob transactions in the block. Introduced in EIP-4844 (Dencun upgrade) for proto-danksharding.                     |
| excess\_blob\_gas                | BIGINT            | The excess blob gas from the previous block, used to calculate blob gas price.                                                                 |
| parent\_beacon\_block\_root      | VARCHAR           | The root of the parent beacon block, linking execution layer blocks to consensus layer blocks.                                                 |
| withdrawals\_root                | VARCHAR           | Root hash of the withdrawals list in the block; part of the block header introduced in Ethereum post-merge for validator withdrawals.          |
| withdrawals                      | VARIANT           | List of validator withdrawals (from the beacon chain) included in the block                                                                    |
| requests\_hash                   | VARCHAR           | Hash of execution requests included in the block. Used by some EVM-compatible chains for cross-chain communication and execution requests.     |
| l1\_block\_number                | BIGINT            | The L1 block associated with the given block. For example, for L2s, this may be the Ethereum L1 block where the L2 batch was posted.           |
| send\_count                      | BIGINT            | The number of send operations                                                                                                                  |
| shared\_gas\_limit               | BIGINT            | The shared gas limit across all transaction types in the block, used by chains with multiple gas limit configurations.                         |
| main\_block\_general\_gas\_limit | BIGINT            | The gas limit for general transactions in the main block, separate from specialized transaction types.                                         |
| timestamp\_millis                | BIGINT            | The block timestamp in milliseconds since Unix epoch, providing higher precision than the standard second-level timestamp.                     |
| timestamp\_millis\_part          | BIGINT            | The millisecond component of the block timestamp, representing the fractional part when timestamp is in seconds.                               |
| \_extra\_fields                  | VARIANT           | Any additional fields that aren't explicitly defined                                                                                           |
| \_created\_at                    | TIMESTAMP\_NTZ(9) | Timestamp when the record was created.                                                                                                         |
| \_updated\_at                    | TIMESTAMP\_NTZ(9) | Timestamp when the record was last updated.                                                                                                    |
