Updated 2025-01-09
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
›
⌄
SELECT
ethereum.public.udf_hex_to_int(SUBSTRING(l.topics [1], 27, 64)) AS nonce,
'0x' || SUBSTR(l.topics [2], 27) AS receiver,
'0x' || SUBSTR(l.topics [3], 27) AS asset,
ethereum.public.udf_hex_to_int(SUBSTRING(l.data, 3, 64)) AS Amount,
ethereum.public.udf_hex_to_int(SUBSTRING(l.data, 67, 64)) AS shareAmount,
ethereum.public.udf_hex_to_int(SUBSTRING(l.data, 131, 64)) AS depositTimestamp,
ethereum.public.udf_hex_to_int(SUBSTRING(l.data, 195, 64)) AS shareLockPeriodAtTimeOfDeposit,
l.block_timestamp AS block_time,
l.block_number AS block_number,
l.tx_hash AS t_hash,
l.contract_address AS contract_address,
l.topics [0] AS topic0,
l.topics [1] AS topic1,
l.topics [2] AS topic2,
l.topics [3] AS topic3,
l.data AS data,
l.tx_hash AS tx_hash
FROM
ethereum.core.fact_event_logs l
WHERE
l.contract_address IN (
LOWER('0xcbc0d2838256919e55eb302ce8c46d7ee0e9d807'),
LOWER('0x07951756b68427e7554AB4c9091344cB8De1Ad5a') --etherfi
)
AND l.topics [0] = '0xe96d7872363f475d18b2f5390caaa5eaa96b2d38e42c62afe4ac08ebd2b13c3a' --deposit events on etherfi
AND DATE_TRUNC('day', l.block_timestamp) > '2024-12-24 00:00:00';
QueryRunArchived: QueryRun has been archived