freemartianETH Locked In Squeeth Contract
    Updated 2022-06-30
    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