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

# Block Rewards

### Table Details

| Property            | Value                                   |
| ------------------- | --------------------------------------- |
| Table Name          | `ethereum_hoodi.raw.block_rewards`      |
| Table Status        | Production-Ready                        |
| Unique Key          | `block_timestamp::date`, `block_number` |
| Clustering Key(s)   | `block_timestamp::date`                 |
| Search Optimization | `builder_address`, `proposer_index`     |

### Table Columns

| Column Name                     | Data Type         | Description                                                                                                                                                                               |
| ------------------------------- | ----------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| block\_number                   | NUMBER(38,0)      | Sequential number of the block that contains this record. Starts at 0 (genesis block) and increments by 1 for each new block.                                                             |
| block\_timestamp                | TIMESTAMP\_NTZ(9) | Timestamp (UTC) of the block that contains this record.                                                                                                                                   |
| has\_block\_reward              | BOOLEAN           | Boolean flag indicating that there is a block reward. This is only applicable for pre-merge.                                                                                              |
| block\_reward                   | VARCHAR(16777216) | Amount of block rewards to the miner in ETH.                                                                                                                                              |
| has\_uncle\_reward              | BOOLEAN           | Boolean flag indicating that there is a uncle reward. This is only applicable for pre-merge.                                                                                              |
| uncles\_reward                  | VARCHAR(16777216) | Amount of block uncle rewards in ETH. Note that it is possible to have more than one uncles rewards recipient.                                                                            |
| uncles\_reward\_transactions    | VARIANT           | The trace level transfers to the uncles reward recipient wrapped in JSON. There can be more than one uncles reward recipient.                                                             |
| base\_fee\_burnt                | VARCHAR(16777216) | The amount of base fees burnt in the block.                                                                                                                                               |
| builder\_priority\_fee\_reward  | VARCHAR(16777216) | Priority fee (tips) sent to the block builder (miner) recipient address in the block.                                                                                                     |
| builder\_direct\_reward         | VARCHAR(16777216) | Array of direct ETH transactions to the block producer in the block, which are assuemd to be builder's direct rewards.                                                                    |
| builder\_address                | VARCHAR(42)       | The address of the block builder (miner).                                                                                                                                                 |
| builder\_direct\_transactions   | VARIANT           | Direct amount of ETH transfers rewarded to the block builder (miner) in the block.                                                                                                        |
| has\_mev\_reward                | BOOLEAN           | Amount of MEV reward awarded in ETH.                                                                                                                                                      |
| proposer\_mev\_reward           | VARCHAR(16777216) | ETH value of MEV rewards paid to the block proposer (validator), extracted from MEV-boost relay data or direct payment transactions to the fee recipient address.                         |
| proposer\_fee\_recipient        | VARCHAR(42)       | Block proposer fee recipient address. This is the address that receives the MEV reward from the block builder.                                                                            |
| proposer\_payout\_transaction   | VARCHAR(66)       | Proposer's MEV reward payout transaction.                                                                                                                                                 |
| l1\_gas\_used                   | VARCHAR(16777216) | L1 gas used.                                                                                                                                                                              |
| l1\_gas\_limit                  | VARCHAR(16777216) | L1 gas limit of the block.                                                                                                                                                                |
| l1\_extra\_data                 | VARCHAR(16777216) | L1 extra data.                                                                                                                                                                            |
| l1\_block\_hash                 | VARCHAR(66)       | L1 block hash.                                                                                                                                                                            |
| slot\_number                    | NUMBER(38,0)      | Beacon Chain slot number.                                                                                                                                                                 |
| epoch                           | NUMBER(38,0)      | Epoch number. On Sui, epochs are \~24 hour periods used for validator rotation and staking rewards. On Solana, epochs are voting periods. On Cosmos, epoch is a governance/staking cycle. |
| proposer\_index                 | NUMBER(38,0)      | The index of validator in validator registry.                                                                                                                                             |
| pubkey                          | VARCHAR(16777216) | The validator's BLS public key, uniquely identifying them. 48-bytes, hex encoded with 0x prefix, case insensitive.                                                                        |
| graffiti                        | VARCHAR(16777216) | 32 byte field of arbitrary data. This field may contain any data included by the block proposer.                                                                                          |
| \_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.                                                                                                                             |
| \_changed\_since\_full\_refresh | BOOLEAN           | Indicates if the record has changed since the last full data refresh.                                                                                                                     |