kiacryptoUntitled Query
Updated 2022-07-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
with holders as (
select tx_to as address, '+1' as hold_count
from solana.core.fact_transfers join solana.core.dim_labels on address = mint
where label = 'portals'
union all
select tx_from as address, '-1' as hold_count
from solana.core.fact_transfers join solana.core.dim_labels on address = mint
where label = 'portals'
)
select address, sum(hold_count) as NFTs_count
from holders
group by 1
order by 2 asc
Run a query to Download Data