Query editor
withfills_with_tx_fill_number as (SELECTROW_NUMBER() OVER (PARTITION BYtx_hashORDER BYevt_index) as tx_fill_number,*FROM query_3099960-- dune.flashbots.result_liquidity_version_dex_base_table),fills_first_last AS (SELECTCASEWHEN a.taker_token = c.maker_tokenAND a.taker_token_amount_raw = c.maker_token_amount_raw THEN 0ELSE 1END AS taker_consider_flag,CASEWHEN a.maker_token = b.taker_tokenAND a.maker_token_amount_raw = b.taker_token_amount_raw THEN 0ELSE 1END AS maker_consider_flag,SUM(CASEWHEN a.maker_token = b.taker_tokenAND a.maker_token_amount_raw = b.taker_token_amount_raw THEN 0ELSE 1END) OVER (PARTITION BYa.tx_hashORDER BYa.evt_index DESC) hop_count,a.*FROMfills_with_tx_fill_number aLEFT JOIN fills_with_tx_fill_number b ON (a.tx_hash = b.tx_hashAND a.tx_fill_number = b.tx_fill_number - 1)LEFT JOIN fills_with_tx_fill_number c ON (a.tx_hash = c.tx_hashAND a.tx_fill_number = c.tx_fill_number + 1)),deduped_bridge_fills as (SELECTtx_hash,MAX(evt_index) AS evt_index,MAX(CASEWHEN taker_consider_flag = 0 THEN NULLELSE taker_tokenEND) AS taker_token,MAX(