0xaimanUntitled Query
    Updated 2022-07-17
    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