Query editor
-- Glider Model B vaults: ERC-4337 accounts whose UserOps are bundled by Glider's-- own bundler fork. Decoded EntryPoint tables expose evt_tx_from (the bundler),-- so no join to the transactions table is needed.-- All EntryPoint versions are unioned because chain coverage differs per version.WITH ops AS (SELECT chain, sender, evt_block_time, paymaster FROM erc4337_multichain.entrypoint_evt_useroperationeventWHERE evt_tx_from IN (0xb1bcca2ac714a6eed7742866a2ec772394e9ea1a,0xe7538bfa89e46ce0a00b49d6724821e9806c5bf8,0x591dc14b5cd66c104bdeb17d5e2bc844ca3179ca,0x9d4c1c9e1f850f22e5940b8385aa5a580798e5de,0x6c9d96942e4dc17d558e13ce679d197ea9b579f1,0x57c5115fe9f1cffdf0607a9b9beefa56a9125870,0xb2f52cb5a2094a00101d91eeb65b85cb1d86431e,0xdb034a1485da0300175b07282f5a84af69c2493e,0x9c4bd019cf2f4ce5945afa82b807e412b820acfd,0xac7ca4b036b55399cc8a4826347750bb29b3e9fe)UNION ALLSELECT chain, sender, evt_block_time, paymaster FROM erc4337_multichain.entrypoint_v0_6_evt_useroperationeventWHERE evt_tx_from IN (0xb1bcca2ac714a6eed7742866a2ec772394e9ea1a,0xe7538bfa89e46ce0a00b49d6724821e9806c5bf8,0x591dc14b5cd66c104bdeb17d5e2bc844ca3179ca,0x9d4c1c9e1f850f22e5940b8385aa5a580798e5de,0x6c9d96942e4dc17d558e13ce679d197ea9b579f1,0x57c5115fe9f1cffdf0607a9b9beefa56a9125870,0xb2f52cb5a2094a00101d91eeb65b85cb1d86431e,0xdb034a1485da0300175b07282f5a84af69c2493e,0x9c4bd019cf2f4ce5945afa82b807e412b820acfd,0xac7ca4b036b55399cc8a4826347750bb29b3e9fe)UNION ALLSELECT chain, sender, evt_block_time, paymaster FROM erc4337_multichain.entrypoint_v0_7_evt_useroperationeventWHERE evt_tx_from IN (0xb1bcca2ac714a6eed7742866a2ec772394e9ea1a,0xe7538bfa89e46ce0a00b49d6724821e9806c5bf8,0x591dc14b5cd66c104bdeb17d5e2bc844ca3179ca,0x9d4c1c9e1f850f22e5940b8385aa5a580798e5de,0x6c9d96942e4dc17d558e13ce679d197ea9b579f1,0x57c5115fe9f1cffdf0607a9b9beefa56a9125870,0xb2f52cb5a2094a00101d91eeb65b85cb1d86431e,0xdb034a1485da0300175b07282f5a84af69c2493e,0x9c4bd019cf2f4ce5945afa82b807e412b820acfd,0xac7ca4b036b55399cc8a4826347750bb29b3e9fe)UNION ALLSELECT chain, sender, evt_block_time, paymaster FROM erc4337_multichain.entrypoint_v0_9_evt_useroperationeventWHERE evt_tx_from IN (0xb1bcca2ac714a6eed7742866a2ec772394e9ea1a,0xe7538bfa89e46ce0a00b49d6724821e9806c5bf8,0x591dc14b5cd66c104bdeb17d5e2bc844ca3179ca,0x9d4c1c9e1f850f22e5940b8385aa5a580798e5de,0x6c9d96942e4dc17d558e13ce679d197ea9b579f1,0x57c5115fe9f1cffdf0607a9b9beefa56a9125870,0xb2f52cb5a2094a00101d91eeb65b85cb1d86431e,0xdb034a1485da0300175b07282f5a84af69c2493e,0x9c4bd019cf2f4ce5945afa82b807e412b820acfd,0xac7ca4b036b55399cc8a4826347750bb29b3e9fe))SELECT chain, sender AS vault,COUNT(*) AS n_actions,MIN(evt_block_time) AS first_seen,MAX(evt_block_time) AS last_seen,COUNT(DISTINCT paymaster) AS n_paymastersFROM opsWHERE sender <> 0x0000000000000000000000000000000000000000GROUP BY 1,2