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,sent_amount AS trade_usd,token_pair AS trade_pairFROMquery_3050748-- dune.flashbots.result_uniswapx_txs_7d),-- liquidity src for solver-type fillersliquidity as (-- if tx hash is in dex.trades, solver sourced dex liquidityselectone.hash,null as aggregator,casewhen dt.project ='uniswap' then concat('Uniswap V', dt.version)when dt.project = '0x API' and maker is not null then null -- 0x API logs PMM trades in dex.tradeswhen dt.project = '1inch LOP' then '1inch Limit Orders'else CONCAT(UPPER(SUBSTRING(dt.project, 1, 1)),SUBSTRING(dt.projectFROM2))end as liquidity_src,case when dt.project = '0x API' then coalesce(mm.name || ' PMM', 'Other PMM') else null end as pmm,dt.token_pair as token_pair,dt.amount_usd as amount_usd,dt.version as dt_versionfrompass1 onejoin dex.trades dt on (one.hash = dt.tx_hash)left join query_2812729 mm on mm.address = dt.maker-- if tx hash is in dex_aggregator.trades, solver pinged aggregator APIunion allselectone.hash,casewhen da.project = 'DODO' then 'DODO Router'when da.project = 'paraswap' then 'Paraswap Router'when da.project = '1inch' then '1inch Router'when da.project = '0x API' then '0x API Router'when da.project = 'bebop' then 'Bebop Router'else da.projectend as aggregator,case when (da.project = '1inch Limit Order Protocol'and lower(da.version) not like '%rfq%') then '1inch Limit Orders' else null end as liquidity_src,case