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.

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