freemartianETH Locked In Squeeth Contract
Updated 2022-06-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with deposits as (
select eth_from_address, sum(amount) as deposit
from ethereum.core.ez_eth_transfers
where eth_to_address = '0x64187ae08781b09368e6253f9e94951243a493d5'
and Identifier = 'CALL_ORIGIN'
group by eth_from_address),
withdraws as (
select eth_to_address, sum(amount) as withdraw
from ethereum.core.ez_eth_transfers
where eth_from_address = '0x64187ae08781b09368e6253f9e94951243a493d5'
and Identifier = 'CALL_18'
group by eth_to_address)
select sum(d.deposit - w.withdraw) as TVL
from deposits d inner join withdraws w on w.eth_to_address = d.eth_from_address
Run a query to Download Data