block_timestamp,

tx_hash,

livequery.utils.udf_hex_to_int(

regexp_substr_all(SUBSTR(input, 11), '.{64}') [0] :: string

) :: int / pow(10, 18) as lp_value

berachain.testnet.fact_traces

from_address = '0x38d2a764185197484f744c0baa06a38a2ee31876'

AND left(input, 10) = '0xa694fc3a'

AND tx_succeeded = true

AND block_timestamp BETWEEN '2024-08-21'

AND '2024-08-22'

ORDER BY lp_value DESC