date_trunc('day', block_timestamp) as date,

sum(lp_value) as total_lp_value

(

select

block_timestamp,

tx_succeeded,

tx_hash,

from_address,

to_address,

trace_index,

input,

output,

left(input, 10) as function_sig,

regexp_substr_all(SUBSTR(input, 11), '.{64}') AS segmented,

livequery.utils.udf_hex_to_int(segmented [0] :: string) :: int as wei_value,

wei_value / pow(10, 18) as lp_value

from

berachain.testnet.fact_traces

where

from_address = '0xe3b9b72ba027fd6c514c0e5ba075ac9c77c23afa'

and function_sig = '0xa694fc3a'

and tx_succeeded = true

order by

block_timestamp desc

) subquery

group by

date_trunc('day', block_timestamp)

order by

date desc;