Query editor
-- RedSnapper (Ethereum) — revert selectors grouped (last 1 day)-- Contract: 0xac4c6e212a361c968f1725b4d055b47e63f80b75WITH failed_calls AS (SELECTblock_time,tx_hash,trace_address,outputFROM arbitrum.tracesWHERE to = 0xac4c6e212a361c968f1725b4d055b47e63f80b75AND call_type IN ('call','delegatecall','staticcall')AND success = FALSEAND block_time >= now() - interval '30' day),selectors AS (SELECTLOWER(CONCAT('0x', SUBSTR(TO_HEX(output), 1, 8))) AS selector,block_time,tx_hashFROM failed_callsWHERE output IS NOT NULLAND length(output) >= 4)SELECTselector,CASEWHEN selector = '0x08c379a0' THEN 'Error(string)'WHEN selector = '0x4e487b71' THEN 'Panic(uint256)'WHEN selector = '0x63ecb9f6' THEN 'MinimalOutputBalanceViolation(address,uint256)'WHEN selector = '0xa899aa13' THEN 'ClipperInvariant()'WHEN selector = '0x616876a5' THEN 'ClipperDataValidation()'WHEN selector = '0x8148fe06' THEN 'ClipperTradeHalted()'WHEN selector = '0xfb8f41b2' THEN 'ERC20InsufficientAllowance(address,uint256,uint256)'WHEN selector = '0xe450d38c' THEN 'ERC20InsufficientBalance(address,uint256,uint256)'WHEN selector = '0x8e7572da' THEN 'InvariantCheckFailed()'WHEN selector = '0x9a29b6fb' THEN 'ExpiredMessage()'WHEN selector = '0x96c6fd1e' THEN 'ERC20InvalidSender(address)'WHEN selector = '0x5dd58b8b' THEN 'TransferAmountExceedsBalance()'WHEN selector = '0x0661b792' THEN 'MaxSplaining(string reason)'WHEN selector = '0x13be252b' THEN 'InsufficientAllowance()'WHEN selector = '0xec442f05' THEN 'ERC20InvalidReceiver(address)'WHEN selector = '0xdee51a8a' THEN 'FluidSafeTransferError(uint256 errorId_)'ELSE NULLEND AS known_error,COUNT(*) AS revert_count,MIN(block_time) AS first_seen,MAX(block_time) AS last_seenFROM selectorsGROUP BY selectorORDER BY revert_count DESC, selector;