0xaimanUntitled Query
Updated 2022-07-17
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
›
⌄
with nfto as (with m as (select post_token_balances[0]:mint as mint,label,max(block_timestamp ) as ltrt
from solana.core.fact_transactions s inner join solana.core.dim_labels l
on s.post_token_balances[0]:mint=l.address
where --tx_id='4Z9AEG7MFZFBq99U7NsnRwETPNp4rf1UEZjsQhgL9EmQDwvXhYsEWCnQ57p13dFDmbk7BQriue82J3s56xzUKuL5' and
label_type='nft' and label ='blocksmith labs' and SUCCEEDED='TRUE'
group by 1,2 order by 1),
n as (
select post_token_balances[0]:mint as mint, post_token_balances[0]:owner as owner,tx_id, block_timestamp as town
from solana.core.fact_transactions
)
select m.mint,label, ltrt, owner, n.tx_id
from m inner join n on m.mint=n.mint and m.ltrt=n.town)
select owner, count(distinct mint) as n_nft_owned
from nfto
group by 1 order by 2 desc
limit 100
Run a query to Download Data