EVENT_SIGNATURE | FUNCTION_SIGNATURE | |
|---|---|---|
1 | 0x8c5be1e5ebec7d5bd14f71427d1e84f3dd0314c0f7b2291e5b200ac8c7c3b925 | 0x095ea7b3 |
2 | 0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef | 0x9fe1ad01 |
3 | 0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef | 0xa91c6df4 |
4 | 0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef | 0x62001cf9 |
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
Last run: 3 months ago
4
337B
4s