Query editor
WITH tx AS (SELECTblock_time,block_number,hash,"from" AS from_address,"to" AS to_address,dataFROM ethereum.transactionsWHERE hash = 0xcc58adcf9d8410e8e8bf890e70fbc72c91eb5a8840416e4cbcab06f322fe554f),decoded AS (SELECTblock_time,block_number,hash,from_address,to_address,bytearray_substring(data, 1, 4) AS function_selector,bytearray_substring(data, 17, 20) AS owner,bytearray_substring(data, 49, 20) AS spender,bytearray_substring(data, 81, 20) AS token,bytearray_to_uint256(bytearray_substring(data, 101, 32)) AS value,bytearray_to_uint256(bytearray_substring(data, 133, 32)) AS deadline,bytearray_to_uint256(bytearray_substring(data, 165, 32)) AS v,bytearray_substring(data, 197, 32) AS r,bytearray_substring(data, 229, 32) AS sFROM tx)SELECT*,(value = power(2,256) - 1) AS is_unlimited_amount,(deadline = power(2,256) - 1) AS is_unlimited_time,(value = power(2,256) - 1AND deadline = power(2,256) - 1) AS is_forever_permit,CASEWHEN deadline = power(2,256) - 1 THEN NULLELSE from_unixtime(deadline)END AS deadline_timeFROM decoded;