Query editor
-- A Glider rebalance swap pays the integrator fee to 0x7c5bb330...-- Inside that same transaction the portfolio sells one token and receives another,-- so the portfolio is the address appearing on BOTH sides of the transfer set.-- This identifies Glider vaults with no assumption about bundlers or agents.-- Window kept short: the free engine has a 2-minute limit.WITH fee_txs AS (SELECT DISTINCT evt_tx_hash, evt_block_dateFROM erc20_bnb.evt_transferWHERE "to" = 0x7c5bb330ea12806b2340d7ddba2c062b9c840728AND evt_block_date >= DATE '2026-08-28'),legs AS (SELECT t.evt_tx_hash, t."from" AS sender, t."to" AS receiver, t.evt_block_timeFROM erc20_bnb.evt_transfer tJOIN fee_txs f ON t.evt_tx_hash = f.evt_tx_hash AND t.evt_block_date = f.evt_block_dateWHERE t.evt_block_date >= DATE '2026-08-28'),roles AS (SELECT evt_tx_hash, sender AS addr, 'out' AS role, evt_block_time FROM legsUNION ALLSELECT evt_tx_hash, receiver, 'in', evt_block_time FROM legs),both_sides AS (SELECT evt_tx_hash, addr AS vault, MIN(evt_block_time) AS evt_block_timeFROM rolesWHERE addr NOT IN (0x7c5bb330ea12806b2340d7ddba2c062b9c840728,0x7e2b68118307ec9669573905de52e394c36399c8,0x0000000000000000000000000000000000000000)GROUP BY 1,2HAVING COUNT(DISTINCT role) = 2)SELECT vault,COUNT(DISTINCT evt_tx_hash) AS n_fee_swaps,MIN(evt_block_time) AS first_seen,MAX(evt_block_time) AS last_seenFROM both_sidesGROUP BY 1ORDER BY n_fee_swaps DESC