TX_HASH | BLOCK_NUMBER | BLOCK_TIMESTAMP | TX_POSITION | TRACE_INDEX | IDENTIFIER | ORIGIN_FROM_ADDRESS | ORIGIN_TO_ADDRESS | ORIGIN_FUNCTION_SIGNATURE | FROM_ADDRESS | TO_ADDRESS | AMOUNT | AMOUNT_PRECISE_RAW | AMOUNT_PRECISE | AMOUNT_USD | EZ_NATIVE_TRANSFERS_ID | INSERTED_TIMESTAMP | MODIFIED_TIMESTAMP | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 0xea535ae11e7796cc98d1408e50c0bf4451a7f6fad9cf4bb39c6594b55a0c7e74 | 41026397 | 2024-01-30 12:14:37.000 | 11 | 0 | CALL_ORIGIN | 0xcfd53555b8adeffccd73d9152a6f1a147f7fb107 | 0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30 | 0xb066ea7c | 0xcfd53555b8adeffccd73d9152a6f1a147f7fb107 | 0xb4315e873dbcf96ffd0acd8ea43f689d8c20fb30 | 0.545 | 545000000000000000 | 0.545 | 20.15 | 215314cf8bd195ab99432a0ebd8418af | 2024-02-02 12:49:49.854 | 2024-02-02 12:49:49.854 |
2 | 0x0e52645e306ab32981b9d3ef9a2b73110b580424b90a1c0480a94efbdddd478d | 41157166 | 2024-02-02 14:12:10.000 | 9 | 0 | CALL_ORIGIN | 0xcfd53555b8adeffccd73d9152a6f1a147f7fb107 | 0x45a01e4e04f14f7a4a6702c74187c5f6222033cd | 0x9fbf10fc | 0xcfd53555b8adeffccd73d9152a6f1a147f7fb107 | 0x45a01e4e04f14f7a4a6702c74187c5f6222033cd | 0.0120501991 | 12050199104907337 | 0.012050199104907337 | 0.43 | 38a3639b911f910815775c8a1dcfe27a | 2024-02-05 15:20:19.480 | 2024-02-05 15:20:19.480 |
Sandeshbungee+wormhole scam
Updated 2024-02-20
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 bridge_in as
(
select * from avalanche.core.ez_token_transfers
where 1=1
-- and tx_hash=lower('0x790ecb7ecafd8a9364d1a3b5d0114fba878f7e1ea0c5d4ef4544a86ce8450f83')
and origin_function_signature='0x57ecfd28'
and origin_to_address='0x8186359af5f57fbb40c6b14a588d2a59c0c29880'
and contract_address=lower('0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e')
and from_address='0x0000000000000000000000000000000000000000'
and ceil(amount)=11
and block_timestamp::date between '2024-01-23' and '2024-01-28'
),
swapped as
(
select * from avalanche.defi.ez_dex_swaps
where 1=1
and block_timestamp::date between '2024-01-23' and '2024-01-28'
and platform in ('sushiswap','uniswap-v3')
and origin_from_address in ( select distinct to_address from bridge_in)
),
rewarded as
(
select * from avalanche.core.ez_native_transfers
where 1=1
and to_address in ( select origin_from_address from swapped)
and amount=0.3
and origin_from_address=lower('0xC2f41b3a1FF28Fd2A6EeE76EE12e51482fcFd11F')
)
-- and tx_hash=lower('0x5d666cef8d23f7af0591c406f3f3040c8ae4057727c07066529385911d78a899')
,
next_transaction as
(
select nt.* from avalanche.core.ez_native_transfers nt
inner join rewarded r
on
r.to_address=nt.from_address
Last run: about 1 year ago
2
912B
10s