ADDRESS | TX_HASH | BLOCK_TIMESTAMP | FROM_ADDRESS | TO_ADDRESS | |
|---|---|---|---|---|---|
1 | 0xf89d7b9c864f589bbf53a82105107622b35eaa40 | 0x3502d729191749b7750d47b52b7d438713b7b5af942cb7b61e0f0423d26dbf0e | 2025-02-21 10:08:59.000 | 0xf89d7b9c864f589bbf53a82105107622b35eaa40 | 0x7958b7084368d821b64591dc84f109de376d8a46 |
2 | 0xf89d7b9c864f589bbf53a82105107622b35eaa40 | 0x9bf19e99cfa05971e802cacaee9461cfb4769ba2a0dcfb0368b52ce625023367 | 2025-02-21 15:53:11.000 | 0xf89d7b9c864f589bbf53a82105107622b35eaa40 | 0xe3d816713995cbe86ed244029c0c76d3bfa8e239 |
kamilclBybit addresses ETH
Updated 2025-02-22
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
›
⌄
WITH cl_addresses AS (
SELECT
DISTINCT -- Added DISTINCT to avoid duplicates
d.ADDRESS AS address
FROM
ethereum.core.ez_decoded_traces tr
JOIN ethereum.core.dim_contracts d ON d.CREATED_TX_HASH = tr.TX_HASH
WHERE
FROM_ADDRESS = '0xd2c82f2e5fa236e114a81173e375a73664610998'
AND TO_ADDRESS = '0xffa397285ce46fb78c588a9e993286aac68c37cd'
AND TYPE = 'CALL'
AND IDENTIFIER = 'CALL_ORIGIN'
AND TRACE_STATUS = 'SUCCESS'
AND FUNCTION_NAME = 'createForwarder'
)
SELECT
lb.ADDRESS,
TX_HASH,
BLOCK_TIMESTAMP,
FROM_ADDRESS,
TO_ADDRESS
FROM
ethereum.core.ez_native_transfers AS tr
JOIN ethereum.core.dim_labels AS lb ON tr.FROM_ADDRESS = lb.ADDRESS
WHERE
FROM_ADDRESS IN (
SELECT
ADDRESS
FROM
ethereum.core.dim_labels
WHERE
LABEL = 'bybit'
AND LABEL_TYPE = 'cex'
)
AND TO_ADDRESS IN (
SELECT
Last run: 2 months ago
2
465B
72s