freemartianEther.fi Volume - Amount distribution
Updated 2024-01-10
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 deposits as (
select
tx_hash,
block_timestamp,
eth_from_address as depositor,
amount,
'ETH' as token
from ethereum.core.ez_eth_transfers
where eth_to_address = '0x7623e9dc0da6ff821ddb9ebaba794054e078f8c4'
and origin_function_signature = '0x98ea5fca'
--and eth_from_address = '0xe63df014b8481ecc14582ff09e88809b0ad4e5a9'
UNION
select
tx_hash,
block_timestamp,
from_address as depositor,
amount,
CASE
when contract_address = '0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0' then 'wstETH'
when contract_address = '0xac3e018457b222d93114458476f3e3416abbe38f' then 'sfrxETH'
when contract_address = '0xae78736cd615f374d3085123a210448e74fc6393' then 'rETH'
when contract_address = '0xbe9895146f7af43049ca1c1ae358b0541ea49704' then 'cbETH'
end as token
from ethereum.core.ez_token_transfers
where to_address = '0x7623e9dc0da6ff821ddb9ebaba794054e078f8c4'
and origin_function_signature = '0x47e7ef24'
--and from_address = '0xe63df014b8481ecc14582ff09e88809b0ad4e5a9'
),
withdraws as (
SELECT
tx_hash,
block_timestamp,
eth_to_address as withdrawer,
QueryRunArchived: QueryRun has been archived