aster2709blast_tvl_eth
    Updated 2025-01-07
    select sum(amount) as tvl from (
    select amount from blast.core.ez_token_transfers
    where contract_address = '0x4300000000000000000000000000000000000004'
    and to_address = '0xffc0555ec5f5c44a6b529cef94b9055799696272'
    union all
    select -amount from blast.core.ez_token_transfers
    where contract_address = '0x4300000000000000000000000000000000000004'
    and from_address = '0xffc0555ec5f5c44a6b529cef94b9055799696272'
    union all
    select amount from blast.core.ez_token_transfers
    where contract_address = '0x4300000000000000000000000000000000000004'
    and to_address = '0xe2f4a2845d4183f7913ec66945b20e4c0c15daff'
    union all
    select -amount from blast.core.ez_token_transfers
    where contract_address = '0x4300000000000000000000000000000000000004'
    and from_address = '0xe2f4a2845d4183f7913ec66945b20e4c0c15daff') x


    QueryRunArchived: QueryRun has been archived