with decode_data as (

select

-- INNER_INSTRUCTION HEX SIGNATURE: 0xe445a52e51cb9a1d

livequery.utils.udf_base58_to_hex(value:data) as inner_hex_data

, livequery.utils.udf_hex_to_base58('0x' || substr(inner_hex_data, 3 + 16 + 16, 64)) as amm

, livequery.utils.udf_hex_to_base58('0x' || substr(inner_hex_data, 3 + 16 + 16 + 64, 64)) as input_mint

, livequery.utils.udf_hex_to_int(to_char(reverse(to_binary(substr(inner_hex_data, 3 + 16 + 16 + 64 + 64, 16))))) as input_amount

, livequery.utils.udf_hex_to_base58('0x' || substr(inner_hex_data, 3 + 16 + 16 + 64 + 64 + 16, 64)) as output_mint

, livequery.utils.udf_hex_to_int(to_char(reverse(to_binary(substr(inner_hex_data, 3 + 16 + 16 + 64 + 64 + 16 + 64, 16))))) as output_amount

from solana.core.fact_events

, lateral flatten(input => inner_instruction:instructions)

where block_id = 269009550

and tx_id = '4GsnFLMhiQayxCSwaxXiF47yMcsZs7Fq4stLWVLN8Xz4JSHsSWjBuP4qYjCtPNa8YgRdnMjVP1oApB8ca2gwFkru'

-- Filter inner_instruction to get the JUP v6 inner event instruction data

and value:programId = 'JUP6LkbZbjS1jKKwapdHNy74zcZ3tLUZoi5QNyVTaV4'

*

exclude inner_hex_data

from decode_data