Query editor
WITH transfer AS (SELECTt."from",t."to",t.hash,l.contract_address,'Transfer' AS event_name,l.block_time,l.block_number,l.tx_hash,l.topic0 AS event_signature,bytearray_substring(l.topic1, 13, 20) AS from_address,bytearray_substring(l.topic2, 13, 20) AS to_address,bytearray_to_uint256(bytearray_substring(l.data, 1, 32)) AS value,NULL AS vault,NULL AS recipient,NULL AS user,NULL AS pocketId,NULL AS amountUnderlying,NULL AS amountOverlying,NULL AS sharesFROM base.logs lLEFT JOIN base.transactions tON l.tx_hash = t.hashWHERE l.topic0 = 0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3efAND l.contract_address IN (0x4e99472385a2522aa292b008Da294a78F420A367,0xD29D6E24946a8e9B55797F5A4EF34EEB0E73a15A,0xecAc9C5F704e954931349Da37F60E39f515c11c1,0x447B9948464593e1235601157063c495b115e02e)),burned_vault AS (SELECTt."from",t."to",t.hash,l.contract_address,'Burned_Vault' AS event_name,l.block_time,l.block_number,l.tx_hash,l.topic0 AS event_signature,NULL AS from_address,NULL AS to_address,NULL AS value,bytearray_substring(l.topic1, 1, 32) AS vault,bytearray_substring(l.topic2, 13, 20) AS recipient,NULL AS user,NULL AS pocketId,NULL AS amountUnderlying,NULL AS amountOverlying,NULL AS sharesFROM base.logs lLEFT JOIN base.transactions tON l.tx_hash = t.hashWHERE l.topic0 = 0x6ab368f832c266c8eb942b84fbcaa20aedc24a699d2a05fae2568028733b1d09AND l.contract_address IN (0x4e99472385a2522aa292b008Da294a78F420A367,