Query editor
-- Confirmed Glider portfolios (they pay Glider's integrator fee) vs everything the-- ten candidate bundlers bundle, same chain, same window.-- If the bundlers were Glider-exclusive the two sets would essentially coincide.WITH fee_txs AS (SELECT DISTINCT evt_tx_hash, evt_block_date FROM erc20_bnb.evt_transferWHERE "to" = 0x7c5bb330ea12806b2340d7ddba2c062b9c840728 AND evt_block_date >= DATE '2026-08-28'),legs AS (SELECT t.evt_tx_hash, t."from" AS sender, t."to" AS receiverFROM 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 FROM legsUNION ALL SELECT evt_tx_hash, receiver, 'in' FROM legs),confirmed_glider AS (SELECT DISTINCT addr AS vault FROM (SELECT evt_tx_hash, addr FROM rolesWHERE addr NOT IN (0x7c5bb330ea12806b2340d7ddba2c062b9c840728,0x7e2b68118307ec9669573905de52e394c36399c8,0x91f8aff3738825e8eb16fc6f6b1a7a4647bdb299,0xb33a6bdf4192ebd826ee14967c48f08d3b889fad,0x0000000000000000000000000000000000000000)GROUP BY 1,2 HAVING COUNT(DISTINCT role) = 2)),bundled AS (SELECT DISTINCT sender FROM erc4337_multichain.entrypoint_v0_7_evt_useroperationeventWHERE chain = 'bnb' AND evt_block_date >= DATE '2026-08-28'AND evt_tx_from IN (0xb1bcca2ac714a6eed7742866a2ec772394e9ea1a,0xe7538bfa89e46ce0a00b49d6724821e9806c5bf8,0x591dc14b5cd66c104bdeb17d5e2bc844ca3179ca,0x9d4c1c9e1f850f22e5940b8385aa5a580798e5de,0x6c9d96942e4dc17d558e13ce679d197ea9b579f1,0x57c5115fe9f1cffdf0607a9b9beefa56a9125870,0xb2f52cb5a2094a00101d91eeb65b85cb1d86431e,0xdb034a1485da0300175b07282f5a84af69c2493e,0x9c4bd019cf2f4ce5945afa82b807e412b820acfd,0xac7ca4b036b55399cc8a4826347750bb29b3e9fe))SELECT(SELECT COUNT(*) FROM confirmed_glider) AS confirmed_glider_vaults,(SELECT COUNT(*) FROM bundled) AS accounts_bundled_by_the_ten,(SELECT COUNT(*) FROM confirmed_glider c JOIN bundled b ON b.sender = c.vault) AS overlap,(SELECT COUNT(*) FROM confirmed_glider c LEFT JOIN bundled b ON b.sender = c.vault WHERE b.sender IS NULL) AS glider_not_bundled_by_the_ten