SELECT DISTINCT tx_hash,

left(input, 10) as function_sig

FROM berachain.testnet.fact_traces

WHERE to_address = LOWER('{{lp_address}}')

AND tx_succeeded = true

AND function_sig != '0x095ea7b3'

AND block_timestamp > '2024-06-12'

LIMIT 10

),

token_transfers AS (

SELECT

block_timestamp,

tx_hash,

from_address,

to_address,

utils.udf_hex_to_int(

CASE

WHEN to_address = LOWER('{{lp_address}}') THEN regexp_substr_all(SUBSTR(input, 11), '.{64}')[4]

ELSE COALESCE(NULLIF(regexp_substr_all(SUBSTR(input, 11), '.{64}')[2], ''), regexp_substr_all(SUBSTR(input, 11), '.{64}')[1])

END :: string

) as token_value

FROM

berachain.testnet.fact_traces

WHERE

tx_hash IN (SELECT tx_hash FROM relevant_txs)

AND to_address IN (

LOWER('{{token0}}'),

LOWER('{{token1}}'),

LOWER('{{lp_address}}')

)

AND tx_succeeded = true

SELECT