Updated 2025-02-14
999
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 DISTINCT
e.topics[0] AS event_signature,
SUBSTRING(t.input_data, 1, 10) AS function_signature
FROM
ronin.core.fact_event_logs e
JOIN
ronin.core.fact_transactions t
ON
e.tx_hash = t.tx_hash
WHERE
e.topics[0] IN (
'0x8c5be1e5ebec7d5bd14f71427d1e84f3dd0314c0f7b2291e5b200ac8c7c3b925', -- Approval Event
'0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef' -- Transfer Event
)
AND e.contract_address = '0x24084ac7a1b412a13b5a39d2c259071987ce19fe'
ORDER BY event_signature;
/*
SELECT
e.tx_hash,
'0x' || SUBSTR(e.topics[1], 27) AS from_address,
'0x' || SUBSTR(e.topics[2], 27) AS to_address,
e.topics[0] AS event_signature,
ethereum.public.udf_hex_to_int(SUBSTRING(e.data, 3, 64)) AS amount,
SUBSTRING(t.input_data, 1, 10) AS function_signature
FROM
ronin.core.fact_event_logs e
JOIN
ronin.core.fact_transactions t
ON
e.tx_hash = t.tx_hash
WHERE
QueryRunArchived: QueryRun has been archived