BLOCK_TIMESTAMP | TO_ADDRESS | SUCCEEDED | ETH_AMOUNT | |
|---|---|---|---|---|
1 | 2025-03-20 03:37:36.000 | EiFmFjfbpgkpEdm3W74ZfjBPkwFEK6oGa5ecHXpHD7rE | TRUE | 33.45 |
2 | 2025-03-20 03:37:14.000 | Cr9Hvcymgsfz1Dx9LfYkaouACU2PYYbZyiwThj5o98hc | TRUE | 15 |
3 | 2025-03-20 03:37:07.000 | Cr9Hvcymgsfz1Dx9LfYkaouACU2PYYbZyiwThj5o98hc | TRUE | 15 |
4 | 2025-03-20 03:36:52.000 | Cr9Hvcymgsfz1Dx9LfYkaouACU2PYYbZyiwThj5o98hc | TRUE | 15 |
5 | 2025-03-20 03:36:36.000 | Cr9Hvcymgsfz1Dx9LfYkaouACU2PYYbZyiwThj5o98hc | TRUE | 15 |
6 | 2025-03-18 22:20:15.000 | EiFmFjfbpgkpEdm3W74ZfjBPkwFEK6oGa5ecHXpHD7rE | TRUE | 3.3 |
7 | 2025-03-18 22:15:11.000 | Cr9Hvcymgsfz1Dx9LfYkaouACU2PYYbZyiwThj5o98hc | TRUE | 10 |
8 | 2025-03-18 22:14:48.000 | Cr9Hvcymgsfz1Dx9LfYkaouACU2PYYbZyiwThj5o98hc | TRUE | 10 |
9 | 2025-03-18 22:14:38.000 | Cr9Hvcymgsfz1Dx9LfYkaouACU2PYYbZyiwThj5o98hc | TRUE | 20 |
diggeronchainslow-emerald
Updated 2025-03-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
SELECT
t.BLOCK_TIMESTAMP,
COALESCE(l.LABEL, t.TX_TO) AS TO_ADDRESS, -- Use domain name if available, otherwise raw address
t.SUCCEEDED,
(t.AMOUNT / POW(10, t.DECIMAL)) AS ETH_AMOUNT
FROM
eclipse.core.fact_transfers t
LEFT JOIN
eclipse.core.dim_labels l
ON
t.TX_TO = l.ADDRESS
AND l.LABEL_TYPE = 'domain_name' -- Filter for domain name labels
WHERE
t.TX_FROM = 'EgaNJBshfsHyy9jZm9HULYey3gHgAqySuBtfT2pbZFEP'
AND t.SUCCEEDED = TRUE
ORDER BY
t.BLOCK_TIMESTAMP DESC
Last run: about 1 month ago
9
752B
2s