l.block_number,

l.block_timestamp,

l.origin_function_signature,

l.origin_from_address,

l.origin_to_address,

topics,

data,

c.symbol,

c.name,

c.decimals,

t.value,

t.VALUE_PRECISE

FROM berachain.testnet.fact_event_logs l

LEFT JOIN berachain.testnet.dim_contracts c ON lower(l.contract_address) = lower(c.address)

LEFT JOIN berachain.testnet.fact_transactions t ON l.block_number AND l.tx_hash = t.tx_hash

WHERE l.block_timestamp >= sysdate() - interval '7 days'

AND l.tx_hash = lower('0x77a4981fd378f69129c78d7907f4500db88cd80b2d8e48a70234e00bd3d4d840')