Query editor
-- ForgottenETH: Exact Bytecode Clone Finder-- Finds contracts deployed with identical runtime bytecode to our 22 known contracts-- These are exact forks: same Solidity source compiled with the same compiler versionWITH known_contracts AS (SELECT ct.address as known_address, ct.code as known_code, n.name as known_nameFROM ethereum.creation_traces ctINNER JOIN (VALUES(0x2a0c0DBEcC7E4D658f48E01e3fA353F44050c208, 'IDEX v1'),(0x8d12A197cB00D4747a1fe03395095ce2A5CC6819, 'EtherDelta v2'),(0x1ce7ae555139c5ef5a57cc8d814a867ee6ee33d8, 'Token Store'),(0x373c55c277b866a69dc047cad488154ab9759466, 'EtherDelta v1'),(0x9a2d163ab40f88c625fd475e807bbc3556566f80, 'SingularX'),(0x4d55f76ce2dbbae7b48661bef9bd144ce0c9091b, 'Enclaves'),(0xbf29685856fae1e228878dfb35b280c0adcc3b05, 'Decentrex'),(0x04f062809b244e37e7fdc21d9409469c989c2342, 'Joyso'),(0xf4c27b8b002389864ac214cb13bfeef4cc5c4e8d, 'ETHEN'),(0x3c020e014069df790d4f4e63fd297ba4e1c8e51f, 'Bitcratic'),(0xd8d48e52f39ab2d169c8b562c53589e6c71ac4d3, 'EtherC'),(0xbf45f4280cfbe7c2d2515a7d984b8c71c15e82b7, 'EnclavesDex'),(0x4aea7cf559f67cedcad07e12ae6bc00f07e8cf65, 'EtherDelta v0'),(0x6090A6e47849629b7245Dfa1Ca21D94cd15878Ef, 'ENS Old Registrar'),(0x22a97c80d7e0a9ae616737e3b8b531248f4ef91d, 'Confideal'),(0xb59a226a2b8a2f2b0512baa35cc348b6b213b671, 'Neufund EtherToken'),(0xD76b5c2A23ef78368d8E34288B5b65D616B746aE, 'Bancor Old ETH Token'),(0x068696a3cf3c4676b65f1c9975dd094260109d02, 'DADA Collectible'),(0x60cd862c9c687a9de49aecdc3a99b74a4fc54ab6, 'MoonCatRescue'),(0xA62142888ABa8370742bE823c1782D17A0389Da1, 'Fomo3D Long'),(0x4e8ecf79ade5e2c49b9e30d795517a81e0bf00b8, 'Fomo3D Quick'),(0x52083b1a21a5abc422b1b0bce5c43ca86ef74cd1, 'Fomo3D Short')) AS n(addr, name) ON ct.address = n.addrWHERE ct.block_date >= DATE '2016-01-01'AND ct.block_date < DATE '2019-06-01')SELECTc.address as clone_address,c.block_time as deployed_at,c."from" as deployer,k.known_name as cloned_from_protocol,k.known_address as cloned_from_address,bytearray_length(c.code) as bytecode_size,COALESCE(lbl.namespace, '') as dune_namespace,COALESCE(lbl.name, '') as dune_contract_nameFROM ethereum.creation_traces cINNER JOIN known_contracts k ON c.code = k.known_codeLEFT JOIN ethereum.contracts lbl ON c.address = lbl.addressWHERE c.block_date >= DATE '2015-07-30'AND c.block_date < DATE '2024-01-01'AND c.address NOT IN (0x2a0c0DBEcC7E4D658f48E01e3fA353F44050c208,0x8d12A197cB00D4747a1fe03395095ce2A5CC6819,0x1ce7ae555139c5ef5a57cc8d814a867ee6ee33d8,0x373c55c277b866a69dc047cad488154ab9759466,0x9a2d163ab40f88c625fd475e807bbc3556566f80,0x4d55f76ce2dbbae7b48661bef9bd144ce0c9091b,0xbf29685856fae1e228878dfb35b280c0adcc3b05,0x04f062809b244e37e7fdc21d9409469c989c2342,0xf4c27b8b002389864ac214cb13bfeef4cc5c4e8d,0x3c020e014069df790d4f4e63fd297ba4e1c8e51f,0xd8d48e52f39ab2d169c8b562c53589e6c71ac4d3,