Query editor
WITHmerge_blocks_pretable AS (SELECTblock.*FROMethereum.blocks AS blockWHEREnumber >= 15537394),txs_per_block AS (SELECTmerge_blocks_pretable."number",COUNT(*) AS total_txnsFROMmerge_blocks_pretableINNER JOIN ethereum.transactions AS tx ON tx.block_number = merge_blocks_pretable."number"GROUP BY1),merge_blocks AS (SELECTmerge_blocks_pretable.*,total_txnsFROMmerge_blocks_pretableINNER JOIN txs_per_block ON txs_per_block."number" = merge_blocks_pretable."number"),mev_boost_blocks AS (SELECTblock.*,tx."to" AS validator_address,tx.value / CAST((POWER(10, 18)) AS DOUBLE) AS paymentFROMmerge_blocks AS blockINNER JOIN ethereum.transactions AS tx ON tx.block_number = block."number"AND tx."from" = block.minerAND tx."index" = block.total_txns - 1),mev_boost_blocks_pct AS (SELECTDATE_TRUNC('day', merge_blocks."time") AS time,COUNT(mev_boost_blocks.number) / CAST(COUNT(merge_blocks.number) AS DOUBLE) AS mev_boost_block_pct,SUM(mev_boost_blocks.payment) AS validator_paymentFROMmerge_blocksLEFT JOIN mev_boost_blocks ON mev_boost_blocks.number = merge_blocks.numberGROUP BY1)SELECT*FROMmev_boost_blocks_pct /* 0xa1dead01...6289ef27f *//* 0x81babeec...3dbc8e80f *//* 0x81beef03...cb7bcb994f *//* 0xa1defa73...81ff84fc1b */