freemartianEtherFi Workspace
999
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
›
⌄
-- select * from ethereum.core.ez_token_transfers
-- where tx_hash = '0x6fd5098b2edc47e86c576090374174493126bb878285088e4a90a13eafe3545e'
with eth_deposit as (
select
tx_hash,
block_timestamp,
eth_from_address,
amount
from ethereum.core.ez_eth_transfers
where eth_to_address = '0x7623e9dc0da6ff821ddb9ebaba794054e078f8c4'
and origin_function_signature = '0x98ea5fca'),
eth_withdraw as (
select
tx_hash,
block_timestamp,
eth_to_address,
amount
from ethereum.core.ez_eth_transfers
where eth_to_address = '0x7623e9dc0da6ff821ddb9ebaba794054e078f8c4'
),
wstETH_deposit as (
select
tx_hash,
block_timestamp,
from_address,
amount
from ethereum.core.ez_token_transfers
where to_address = '0x7623e9dc0da6ff821ddb9ebaba794054e078f8c4'
and origin_function_signature = '0x47e7ef24'
and contract_address = '0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0'),
wstETH_withdraw as (
Run a query to Download Data