date_trunc('day', block_timestamp) as date,

sum(bgt_value) as total_bgt_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(output, 3, len(output)), '.{64}') AS segmented_output,

utils.udf_hex_to_int('s2c', segmented_output [0] :: string) :: bigint as amount0,

amount0 / pow(10, 18) as bgt_value,

from

berachain.testnet.fact_traces

where

from_address = '0x2e8410239bb4b099ee2d5683e3ef9d6f04e321cc'

and function_sig = '0xc00007b0'

and tx_succeeded = true

order by

block_timestamp desc

) subquery

group by

date_trunc('day', block_timestamp)

order by

date desc;