boomer77nippy 4
Updated 2023-05-02
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
›
⌄
with raw as (
SELECT
nft_from_address as address,
'-1' as flow
FROM ethereum.core.ez_nft_transfers
where nft_address = lower('0x9674739124d69d555712a30e0a44de648f494219')
union all
select
nft_to_address as address,
'1' as flow
FROM ethereum.core.ez_nft_transfers
where nft_address = lower('0x9674739124d69d555712a30e0a44de648f494219')
)
select
address,
sum(flow) as holdings
from raw
group by address
having holdings > 0
order by 2 desc
Run a query to Download Data