topics[0] AS topic0,

'0x' || SUBSTR(topics[1], 27) AS caller,

'0x' || SUBSTR(topics[2], 27) AS owner,

'0x' || SUBSTR(topics[3], 27) AS asset,

ethereum.public.udf_hex_to_int(SUBSTRING(l.data, 3, 64)) AS amount,

ethereum.public.udf_hex_to_int(SUBSTRING(l.data, 67, 64)) AS shares,

l.block_timestamp AS block_timestamp,

l.tx_hash AS tx_hash,

l.origin_function_signature AS origin_function_signature,

l.origin_from_address AS origin_from_address,

l.origin_to_address AS origin_to_address,

l.event_index AS event_index,

l.contract_address AS contract_address,

topics[1] AS topic1,

topics[2] AS topic2,

topics[3] AS topic3,

l.data AS data

FROM swell.core.ez_decoded_event_logs l