Updated 2025-02-06
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
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
⌄
SELECT * from ethereum.core.ez_decoded_event_logs
where tx_hash = '0x1b4bdcb04d95098359eacbe571ccbce73319f4a72e0e2db04b384dcb9201b8db'
and origin_to_address = '0x3a23f943181408eac424116af7b7790c94cb97a5'
limit 300
/*
SELECT
-- Extract user-related data from topics
'0x' || SUBSTR(topics[1], 27) AS caller, -- User who initiated the transaction (address)
'0x' || SUBSTR(topics[2], 27) AS owner, -- Owner involved in the transaction (address)
'0x' || SUBSTR(topics[3], 27) AS asset, -- Asset being involved (address)
-- Amount and shares from the data field (as integers)
ethereum.public.udf_hex_to_int(SUBSTRING(l.data, 3, 64)) AS amount, -- Amount field (first 32 bytes)
ethereum.public.udf_hex_to_int(SUBSTRING(l.data, 67, 64)) AS shares, -- Shares field (second 32 bytes)
-- Other relevant data points
l.block_timestamp AS block_timestamp, -- Transaction timestamp
l.tx_hash AS tx_hash, -- Transaction hash
l.origin_function_signature AS origin_function_signature, -- Origin function signature
l.origin_from_address AS origin_from_address, -- Originating address for the transaction
l.origin_to_address AS origin_to_address, -- Destination address for the transaction
-- Event details and additional metadata
l.event_index AS event_index, -- Event index within the transaction
QueryRunArchived: QueryRun has been archived