aster2709blast_tvl_eth
Updated 2025-01-07Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
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