Query editor
WITH ev AS (SELECT contract_address AS token, topic1, topic2FROM boba.logsWHERE topic0 IN (0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef, 0x8c5be1e5ebec7d5bd14f71427d1e84f3dd0314c0f7b2291e5b200ac8c7c3b925)),addrs AS (SELECT token, bytearray_substring(topic1, 13, 20) AS addr FROM evUNION ALLSELECT token, bytearray_substring(topic2, 13, 20) AS addr FROM ev)SELECT 'boba' AS blockchain, addr AS address, arbitrary(token) AS sample_tokenFROM addrsWHERE addr IN (SELECT address FROM boba.creation_traces)GROUP BY addr