Query editor
SELECTbytearray_substring (topic1, 13, 20) AS contract_addressFROMarbitrum.logsWHEREblock_time >= TIMESTAMP '2023-01-01 00:00:00' -- we set date to this since some mainnet deployments happened before 2023AND block_time < TIMESTAMP '2024-01-01 00:00:00'AND contract_address = 0x4f92ae4960a6ac49fa88bcf9d6d4b8c53f626a55AND topic0 = 0xa802207d4c618b40db3b25b7b90e6f483e16b2c1f8d3610b15b345a718c6b41b