BLOCK_TIMESTAMP | TX_TO | SUCCEEDED | ETH_AMOUNT | |
|---|---|---|---|---|
1 | 2024-12-09 19:30:26.000 | EiJkrMUUK6V8er7ecQmdpU41JFnetUjnYby6ZqELTk58 | TRUE | 0.002987964 |
2 | 2024-12-09 19:30:18.000 | C8ykp3gbLY4YdeS9rUzXjbJgsnsnTuzKjPDcoA5m3dCm | TRUE | 0.066987964 |
3 | 2024-12-09 19:27:40.000 | 6VU1eCwGc9KQb5DVavGkswyfktdiA4dRTuR12s8TWWkw | TRUE | 0.008607964 |
4 | 2024-12-09 19:26:28.000 | BHKcEoxm3uij2HSMBiDrFBAzHU84fSdq97abQFbHrRNe | TRUE | 0.149987964 |
5 | 2024-12-09 19:20:04.000 | 7aX7GqZSofSR8V9QJSQqaSZ16kUhgnE89H8zrx8atpMf | TRUE | 0.001987964 |
6 | 2024-12-09 19:14:31.000 | 2Ft56nAAa1WGoARgZkdX4ysfLcEVCo9uyk2Ton1ctiMH | TRUE | 0.137987964 |
7 | 2024-12-09 19:09:02.000 | Dh8QyDUnVBEG1YwA7qqW3Wak67acoG1DPZWNztqAspqT | TRUE | 0.414247964 |
8 | 2024-12-09 19:05:16.000 | FFQuAGBLUnyz4VasFysfS9P5Mmp73ktLfQSSB4YTxucP | TRUE | 0.269987964 |
9 | 2024-12-09 19:04:04.000 | 5iFsKZapF6P95jpN6XKP6Vb5XuKe41zUdnQYq6rTMJhD | TRUE | 0.119987964 |
10 | 2024-12-09 19:02:04.000 | CJge6YmskMrjUrgJQymgXz6dSWLsTysYatukJQ4bipp | TRUE | 0.028947964 |
11 | 2024-12-09 18:56:39.000 | 3VG3V5WeMAo96px9KBG8UEEMe4pPis2f5CPxQCTFnkSm | TRUE | 0.119987964 |
12 | 2024-12-09 18:45:25.000 | F24XuTtQhLPqZSphDHYtUSVWtKvqkRErqYDLCppA29mo | TRUE | 0.230837964 |
13 | 2024-12-09 18:45:02.000 | HrpvWNhs2MN5S9jFK9iJxC62dZNTquSeHrxTV7s7AqQa | TRUE | 0.189987964 |
14 | 2024-12-09 18:42:28.000 | Be7tCH84PQwpW2z88PwyxQRSv594tr23neF4JbucdUnq | TRUE | 0.144637964 |
15 | 2024-12-09 18:32:06.000 | 3paYKk7anc23Wo5hdwx3yrnnVusTitn3yqn1REDEkpeN | TRUE | 0.249987964 |
16 | 2024-12-09 18:30:01.000 | FWhj2xk3MxnnDqwWE1HHMxS19jzTBggSmehrXng4MQzP | TRUE | 0.122987964 |
17 | 2024-12-09 18:25:41.000 | 2b9xE7EsQLWsXydX51rmrb6CTjeYMYBcEZuXGPMrQn9p | TRUE | 0.043327964 |
18 | 2024-12-09 18:24:41.000 | ZAPY1kJuouEJLTAuTksbkgjrHDkzYvHP1RL3PyaZSi4 | TRUE | 0.053987964 |
19 | 2024-12-09 18:24:03.000 | 3SQkETgcpJ1MQhfoybvhFFtqR2sQBHMJmHfJKnAQVJ8A | TRUE | 0.044987964 |
20 | 2024-12-09 18:23:51.000 | D8czUcHtW9KDjuZDPv1CJJMqrBKpbKqDqaqbUjSb3HG9 | TRUE | 0.001987964 |
diggeronchainbridge275k
Updated 2025-03-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
SELECT
BLOCK_TIMESTAMP,
TX_TO,
SUCCEEDED,
(AMOUNT / POW(10, DECIMAL)) AS ETH_AMOUNT
FROM
eclipse.core.fact_transfers
WHERE
TX_FROM = 'CrfbABN2sSvmoZLu9eDDfXpaC2nHg42R7AXbHs9eg4S9'
AND SUCCEEDED = TRUE
AND BLOCK_TIMESTAMP <= '2024-12-09 19:30:26.000' -- Fetch transactions up to this timestamp
AND BLOCK_TIMESTAMP NOT IN (
SELECT BLOCK_TIMESTAMP
FROM eclipse.core.fact_transfers
WHERE TX_FROM = 'CrfbABN2sSvmoZLu9eDDfXpaC2nHg42R7AXbHs9eg4S9'
AND SUCCEEDED = TRUE
ORDER BY BLOCK_TIMESTAMP DESC
LIMIT 100000
) -- Exclude timestamps from the first 100K
ORDER BY
BLOCK_TIMESTAMP DESC
LIMIT 100000;
Last run: about 1 month ago
...
75629
7MB
7s