Skip to main content
The ethereum.raw.block_rewards model 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
    • MEV rewards are identified using the following logic:
      • If the last transaction of the block is sent from the block builder (miner), this is assumed to be an MEV payout
      • If the last transaction of the block is sent to the withdrawal address of the validator that proposed the block, this is also captured as an MEV payout
    • Example: 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

Unique key: block_number
Column NameDescriptionExample
block_numberThe block number.17,828,815
block_timestampThe unix timestamp for when the block was collated.2023-08-02 17:30:47
has_block_rewardBoolean flag indicating that there is a block reward pre-merge.FALSE
block_rewardAmount of block rewards to the miner in ETH.0
has_uncle_rewardBoolean flag indicating that there is a uncle reward pre-merge.FALSE
uncles_rewardAmount of block uncle rewards in ETH. Note that it is possible to have more than one uncles rewards recipient.0
uncles_reward_transactionsThe trace level transfers to the uncles reward recipient wrapped in JSON.NULL
base_fee_burntETH burnt from base fee gas amount.0.4084471863
builder_priority_fee_rewardPriority fee (tips) to the block builder (miner) recipient address.0.02960400525
builder_direct_rewardDirect ETH transfers rewarded to the block builder (miner) in the block.0.0002492600004
builder_addressBlock builder (miner) address.0xdafea492d9c6733ae3d56b7ed1adb60692c98bc5
builder_direct_transactionsArray of direct ETH transactions to the block producer in the block, assumed to be builder’s direct rewards.[{"amount":"0.000249260000412","eth_from_address":"0x0c3de458b51a11da7d4616f42f66c861e3859d3e","transaction_from_address":"0x26fd09c8b44af53df38a9bad41d5abc55a1786af","transaction_hash":"0xf766b52...","transaction_to_address":"0x0c3d...","usd_amount":"0.45555"}]
has_mev_rewardBoolean flag indicating whether there is an MEV reward, sent from the miner to the block proposer fee recipient in the last transaction of the block.TRUE
proposer_mev_rewardProposer’s MEV reward sent from the block builder.0.02926816803
proposer_fee_recipientBlock proposer fee recipient address.0x388c818ca8b9251b393131c08a736a67ccb19297
proposer_payout_transactionProposer’s MEV reward payout transaction.0x4186fa75972f93882acf7c9630eaee05c21132fba8d97a0826dc78b1e1cf1464
l1_gas_usedL1 gas used.15,435,342
l1_gas_limitL1 gas limit of the block.30,000,000
l1_extra_dataL1 extra data.0x496c6c756d696e61746520446d6f63726174697a6520447374726962757465
l1_block_hashL1 block hash.0x69b5ed627b2a16c7e13446b6cab4159ef1e850a4f9d64b66a31225d2e24b4d2f
slot_numberBeacon Chain slot number.7,014,452
epochBeacon Chain epoch number.219,201
proposer_indexValidator Index of the block proposer on Beacon Chain.277,565
pubkeyPubkey of the validator proposing this block.0xb7be38a5fcc9400c3c4b7dace7c0ae75ca76d47ce0e8de5177e38786b8bf71c5b03889ab3c4c436b731f4df01f398b78
graffiti32-byte field of arbitrary data included by the block proposer.0x0000000000000000000000000000000000000000000000000000000000000000