Query editor
WITH proxy_contracts AS (SELECTaddress,code,LENGTH(code) as code_length,CASEWHEN LOWER(CAST(code AS VARCHAR)) LIKE '%363d3d373d3d3d363d73%' AND LENGTH(code) < 120THEN true ELSE falseEND as is_minimal_proxy,CASEWHEN LOWER(CAST(code AS VARCHAR)) LIKE '%363d3d373d3d3d363d73%' AND LENGTH(code) < 120THEN '0x' || SUBSTRING(LOWER(CAST(code AS VARCHAR)),POSITION('363d3d373d3d3d363d73' IN LOWER(CAST(code AS VARCHAR))) + 20,40)ELSE NULLEND as minimal_proxy_impl,CASEWHEN LENGTH(code) > 200AND (CAST(code AS VARCHAR) LIKE '%3659cfe6%' OR CAST(code AS VARCHAR) LIKE '%4f1ef286%')THEN true ELSE falseEND as is_upgradeable_proxy,CASEWHEN LENGTH(code) > 200 AND CAST(code AS VARCHAR) LIKE '%5c60da1b%'THEN true ELSE falseEND as has_implementation_getter,CASEWHEN CAST(code AS VARCHAR) LIKE '%8129fc1c%' OR CAST(code AS VARCHAR) LIKE '%c4d66de8%' OR CAST(code AS VARCHAR) LIKE '%1459457a%'THEN true ELSE falseEND as has_initializer,CASEWHEN CAST(code AS VARCHAR) LIKE '%5cffe9de%' OR CAST(code AS VARCHAR) LIKE '%ab9c4b5d%'THEN true ELSE falseEND as has_flashloan,CASEWHEN CAST(code AS VARCHAR) LIKE '%ff%' AND LENGTH(code) > 500THEN true ELSE falseEND as has_selfdestruct,CASEWHEN CAST(code AS VARCHAR) LIKE '%f4%' AND LENGTH(code) > 200THEN true ELSE falseEND as has_delegatecall,CASEWHEN CAST(code AS VARCHAR) LIKE '%128acb08%' OR CAST(code AS VARCHAR) LIKE '%022c0d9f%' OR CAST(code AS VARCHAR) LIKE '%7ff36ab5%'THEN true ELSE falseEND as has_swap,CASEWHEN CAST(code AS VARCHAR) LIKE '%e8eda9df%' OR CAST(code AS VARCHAR) LIKE '%69328dec%' OR CAST(code AS VARCHAR) LIKE '%a415bcad%'