Afonso_DiazGrouping balances
Updated 2024-03-22
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
transfer_in1 as(
select to_address as address,
sum(amount) as amount
from blast.core.ez_token_transfers
where to_address=origin_from_address
and contract_address=lower('0x4300000000000000000000000000000000000003') --USDB
--and tx_hash not in (select distinct tx_hash from blast.core.ez_token_transfers where origin_from_address=to_address)
group by 1),
transfer_in2 as(
select to_address as address,
sum(amount) as amount
from blast.core.ez_token_transfers
where contract_address=lower('0x4300000000000000000000000000000000000003') --USDB
and tx_hash not in (select distinct tx_hash from blast.core.ez_token_transfers where origin_from_address=to_address)
group by 1),
transfer_out as(
select
from_address as address,
sum(amount) as amount
from blast.core.ez_token_transfers
where (from_address=origin_to_address OR from_address=origin_from_address)
and contract_address=lower('0x4300000000000000000000000000000000000003') --USDB
group by 1),
all_ as (
select address,amount from transfer_in1
union all
select address,amount from transfer_in2
union all
select address,-1*amount from transfer_out
),
balance_table as(
QueryRunArchived: QueryRun has been archived