Query editor
-- Stage-1 (light, fixed slice 2026-09-21..2026-10-21): ERC-4626 vaults that call a general-purpose aggregator router (polygon).-- n_txs = permissionless proxy (non-gating). Deposit-topic set; asset() liveness filtered in Stage-2.with vaults as (select distinct contract_address as vaultfrom polygon.logswhere topic0 = 0xdcbc1c05240f31ff3ad067ef1ee35ce4997762752e3a095284754544f4c709d7and block_time between timestamp '2026-09-21' and timestamp '2026-10-21')select t."from" as vault, count(*) as router_calls, count(distinct t.to) as distinct_routers,count(distinct t.tx_hash) as n_txs, max(t.block_time) as last_seenfrom polygon.traces tjoin vaults v on v.vault = t."from"where t.to in (0x111111125421ca6dc452d289314280a0f8842a65, 0x1111111254eeb25477b68fb85ed929f73a960582,0x1111111254fb6c44bac0bed2854e76f90643097d, 0x6131b5fae19ea4f9d964eac0408e4408b66337b5,0xdef171fe48cf0115b1d80b88dc8eab59176fee57, 0x6a000f20005980200259b80c5102003040001068,0xdef1c0ded9bec7f1a1670819833240f027b25eff, 0x9008d19f58aabd9ed0d60971565aa8510560ab41,0x6352a56caadc4f1e25cd6c75970fa768a3304e64, 0xbbbbbbb520d69a9775e85b458c58c648259fad5f)and t.call_type = 'call' and t.successand t.block_time between timestamp '2026-09-21' and timestamp '2026-10-21'group by 1 order by router_calls desc limit 200;