Query editor
with census as (select ct.address as vault from polygon.creation_traces ctwhere ct.code is not nulland bytearray_position(ct.code, 0x38d52e0f) > 0 and bytearray_position(ct.code, 0x01e1d114) > 0and bytearray_position(ct.code, 0xba087652) > 0 and bytearray_position(ct.code, 0xc6e6f592) > 0and bytearray_position(ct.code, 0x4cdad506) > 0group by 1)select t."from" as vault, count(*) as ext_calls, count(distinct t.to) as distinct_callees,count(distinct bytearray_substring(t.input,1,4)) as distinct_selectors,count(distinct t.tx_hash) as n_txs, max(t.block_time) as last_seenfrom polygon.traces t join census c on c.vault = t."from"where t.call_type='call' and t.success and t.block_time > now() - interval '30' dayand t.to <> t."from" and length(t.input) >= 100and bytearray_substring(t.input,1,4) not in (0xa9059cbb,0x23b872dd,0x095ea7b3,0x70a08231,0xd0e30db0,0x2e1a7d4d)group by 1 having count(distinct t.to) >= 3order by distinct_callees desc, ext_calls desc limit 100;