value

-- , instruction:data as ins_data

-- , utils.udf_base58_to_hex(ins_data) as hex_data

-- , substr(hex_data, 3, 16) as evt_hex

, utils.udf_base58_to_hex(value:data) as hex_data

, substr(hex_data, 3, 16) as inner_evt_hex

, substr(hex_data, 3 + 16, 16) as inner_evt_hex_2

, utils.udf_hex_to_base58('0x' || substr(hex_data, 3 + 16 + 16, 64)) as custody_key

, utils.udf_hex_to_base58('0x' || substr(hex_data, 3 + 16 + 16 + 64, 64)) as pool_key

--, substr(hex_data, 3 + 16 + 16 + 64 + 64, 16) AS step1

, utils.udf_hex_to_int(to_char(reverse(to_binary(substr(hex_data, 3 + 16 + 16 + 64 + 64, 16))))) AS lp_amount_in -- Amount of JLP Burned

, utils.udf_hex_to_int(to_char(reverse(to_binary(substr(hex_data, 3 + 16 + 16 + 64 + 64 + 16, 16))))) AS remove_amount_usd

, utils.udf_hex_to_int(to_char(reverse(to_binary(substr(hex_data, 3 + 16 + 16 + 64 + 64 + 16 + 16, 16))))) AS fee_bps

, utils.udf_hex_to_int(to_char(reverse(to_binary(substr(hex_data, 3 + 16 + 16 + 64 + 64 + 16 + 16 + 16 , 16))))) AS remove_token_amount

, utils.udf_hex_to_int(to_char(reverse(to_binary(substr(hex_data, 3 + 16 + 16 + 64 + 64 + 16 + 16 + 16 + 16, 16))))) AS token_amount_after_fee

, utils.udf_hex_to_int(to_char(reverse(to_binary(substr(hex_data, 3 + 16 + 16 + 64 + 64 + 16 + 16 + 16 + 16 + 16, 32))))) AS post_pool_amount_usd

, b.instruction

, b.inner_instruction

, b.block_timestamp

, b.block_id

, b.tx_id

from solana.core.fact_events b