block_number,

block_timestamp,

tx_hash,

origin_function_signature,

origin_from_address,

origin_to_address,

contract_address,

c.symbol,

c.name,

c.decimals,

data,

utils.udf_hex_to_int(SUBSTR(DATA, 3, 64)) AS raw_amount_precise

from

berachain.testnet.fact_event_logs l

left join berachain.testnet.dim_contracts c ON lower(l.contract_address) = lower(c.address)

where block_timestamp >= sysdate() - interval '7 days'

and tx_hash = '0x3abf8261c185d1dbc3d5db8b01a45f011c8c9a191c4f45ba5710c96ab325ca14'

;