Query editor
WITHpass1 AS (SELECTtx_hash AS hash,block_time,swapper as user,'Uniswap Website: Uniswap X ON' AS frontend,'Uniswap X' AS metaaggregator,case when LENGTH(filler) > 30 THEN SUBSTR(filler, 1, 5) || '...' || SUBSTR(filler, LENGTH(filler) - 2, 3) else filler end as solver,filler AS solver_address,token_pair AS trade_pair,sent_amount AS trade_usdFROMquery_3050748-- dune.flashbots.result_uniswapx_txs_7d),-- ofaget_ofa as (selectone.hash,casewhen hash in (select distinctfrom_hex(CAST(json_extract(transactions, '$[0].hash') AS VARCHAR)) as user_txfrommevblocker.raw_bundles)and hash in (selecttx_hashfromquery_3023136 -- Flashbots Protect Dataset) then 'Flashbots Protect & MEV Blocker'when hash in (select distinctfrom_hex(CAST(json_extract(transactions, '$[0].hash') AS VARCHAR)) as user_txfrommevblocker.raw_bundles) then 'MEV Blocker'when hash in (selecttx_hashfromquery_3023136 -- Flashbots Protect Dataset) then 'Flashbots Protect'else nullend as OFAfrompass1 one),-- builderget_builder as (