Query editor
SELECTdate_trunc('hour', block_time) + INTERVAL '1' minute * FLOOR(EXTRACT(minute FROM block_time) / 10) * 10 AS time,--from_utf8(substr(execution_payload_extra_data, 1)) as builder,casewhen from_utf8(substr(execution_payload_extra_data, 1)) like 'BuilderNet%' then 'BuilderNet'when from_utf8(substr(execution_payload_extra_data, 1)) like '%bloXroute%' then 'bloXroute'when from_utf8(substr(execution_payload_extra_data, 1)) like '%Quasar%' then 'Quasar'when from_utf8(substr(execution_payload_extra_data, 1)) like '%bobTheBuilder%' then 'bobTheBuilder'when from_utf8(substr(execution_payload_extra_data, 1)) like '%Titan%' then 'Titan Builder'when from_utf8(substr(execution_payload_extra_data, 1)) like '%Builder+%' then 'Builder+'when from_utf8(substr(execution_payload_extra_data, 1)) like 'beaverbuild%' then 'beaverbuild.org'else from_utf8(substr(execution_payload_extra_data, 1))end as builder,count(distinct tx_hash) AS tx_countFROM dex.sandwiched A JOIN beacon.blocks BON A.block_number = B.execution_payload_block_numberWHEREblock_time >= cast('2025-12-03 18:00:00' as timestamp)and block_time < cast('2025-12-04 08:00:00' as timestamp)GROUP BY 1,2