articoloquintoUntitled Query
Updated 2022-07-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
select * from(
select sum("amount") as "amount", "address" from(
select sum(AMOUNT) as "amount", RECEIVER as "address"
from flipside_prod_db.algorand.transfers
where ASSET_ID = '571576867'
group by 2
union
select -sum(AMOUNT) as "amount", ASSET_SENDER as "address"
from flipside_prod_db.algorand.transfers
where ASSET_ID = '571576867'
group by 2)
group by 2)
where "amount" > 0
Run a query to Download Data