datavortexwilling-turquoise
Updated 2025-01-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
›
⌄
⌄
/*
SELECT ethereum.public.udf_hex_to_int(data)
FROM optimism.core.fact_event_logs
tx_hash = '0x2a726388d96373a7995b77c806d234ec2a2e4903e54949cccf2a87494b8d23ee'
*/
SELECT
DISTINCT l.event_index,
l.origin_from_address,
l.contract_address,
l.topics,
l.data,
ethereum.public.udf_hex_to_int(SUBSTRING(l.data, 3))AS converted_data,
l.origin_function_signature
FROM
optimism.core.fact_event_logs l
WHERE
l.tx_hash = '0x2a726388d96373a7995b77c806d234ec2a2e4903e54949cccf2a87494b8d23ee'
AND tx_status = 'SUCCESS'
AND event_index = 0;
--SELECT event_index FROM optimism.core.fact_event_logs
QueryRunArchived: QueryRun has been archived