Block Reward

ethereum.raw.block_rewards provides enriched block-level data of the various types of protocol-level rewards to the miners (block builder) and block proposers (validator), pre and most-merge.

Update: 2024-05-20

  • This table is updated to include pre-merge block-level rewards.

  • All columns with ETH values (rewards) in this table are kept in string format to retain precision.

Block-level ETH rewards on Ethereum can be separated into various types:

  • Miner (block builder)

    • Pre-merge

      • Block rewards from protocol emissions.

        • For each block, the miner is rewarded with a finite amount of Ether on top of the fees paid.

      • Uncle rewards

        • Uncles reward is valid but rejected as it is not on the longest chain which is the working mechanism of the blockchain.

    • Transaction priority fee

    • Direct transfers from transaction senders to block builder

  • Proposer (MEV post-merge)

    • amount of MEV reward received by the block proposer, and the corresponding index of the validator that proposed the block

    • Corresponds to transfer from builder to proposer in the last transaction of the block: https://etherscan.io/block/19900222#mevinfo

Sample Query

Examine block-level rewards by reward type on Ethereum over time.

select 
    date_trunc('week', block_timestamp) as date, 
    sum(block_reward) as block_reward,
    sum(uncles_reward) as uncles_reward,
    sum(builder_priority_fee_reward) as builder_priority_fee_reward,
    sum(builder_direct_reward) as builder_direct_reward,
    sum(proposer_mev_reward) as proposer_mev_reward
from ethereum.raw.block_rewards
group by all

Table Columns

Column Name
Description
Example

block_number

The block number.

17,828,815

block_timestamp

The unix timestamp for when the block was collated.

2023-08-02 17:30:47

has_block_reward

Boolean flag indicating that there is a block reward pre-merge.

FALSE

block_reward

Amount of block rewards to the miner in ETH.

0

has_uncle_reward

Boolean flag indicating that there is a uncle reward pre-merge.

FALSE

uncles_reward

Amount of block uncle rewards in ETH. Note that it is possible to have more than one uncles rewards recipient.

0

uncles_reward_transactions

The trace level transfers to the uncles reward recipient wrapped in JSON.

NULL

base_fee_burnt

ETH burnt from base fee gas amount.

0.4084471863

builder_priority_fee_reward

Priority fee (tips) to the block builder (miner) recipient address.

0.02960400525

builder_direct_reward

Direct ETH transfers rewarded to the block builder (miner) in the block.

0.0002492600004

builder_address

Block builder (miner) address.

0xdafea492d9c6733ae3d56b7ed1adb60692c98bc5

builder_direct_transactions

Array of direct ETH transactions to the block producer in the block, which are assuemd to be builder's direct rewards.

[ { "amount": "0.000249260000412", "eth_from_address": "0x0c3de458b51a11da7d4616f42f66c861e3859d3e", "transaction_from_address": "0x26fd09c8b44af53df38a9bad41d5abc55a1786af", "transaction_hash": "0xf766b525bdfee22dd4ab5216a3a3d8dd0771bb59b8e384e2371700bf72b5cb17", "transaction_to_address": "0x0c3de458b51a11da7d4616f42f66c861e3859d3e", "usd_amount": "0.45555256195297944" } ]

has_mev_reward

Boolean flag indicating whether there an MEV reward, sent from the miner to the block proposer fee recipient in the last transaction of the block.

TRUE

proposer_mev_reward

Proposer's MEV reward sent from the block builder.

0.02926816803

proposer_fee_recipient

Block proposer fee recipient address.

0x388c818ca8b9251b393131c08a736a67ccb19297

proposer_payout_transaction

Proposer's MEV reward payout transaction.

0x4186fa75972f93882acf7c9630eaee05c21132fba8d97a0826dc78b1e1cf1464

l1_gas_used

L1 gas used.

15,435,342

l1_gas_limit

L1 gas limit of the block.

30,000,000

l1_extra_data

L1 extra data.

0x496c6c756d696e61746520446d6f63726174697a6520447374726962757465

l1_block_hash

L1 block hash.

0x69b5ed627b2a16c7e13446b6cab4159ef1e850a4f9d64b66a31225d2e24b4d2f

slot_number

Beacon Chain slot number.

7,014,452

epoch

Beacon Chain epoch number.

219,201

proposer_index

Validator Index of the block proposer on Beacon Chain.

277,565

pubkey

Pubkey of thevalidator proposing this block

0xb7be38a5fcc9400c3c4b7dace7c0ae75ca76d47ce0e8de5177e38786b8bf71c5b03889ab3c4c436b731f4df01f398b78

graffiti

32 byte field of arbitrary data. This field may contain any data included by the block proposer.

0x0000000000000000000000000000000000000000000000000000000000000000

Last updated