misaghlbSolana NFT Project Feature - bubblegoose ballers - holders
    Updated 2022-10-16
    with nfts as (
    SELECT * from solana.core.dim_labels
    where ADDRESS_NAME = 'bubblegoose ballers'
    ),
    raw as (
    SELECT
    TX_FROM as address,
    AMOUNT * -1 as flow
    FROM solana.core.fact_transfers
    where mint in (select address from nfts)
    union all

    select
    TX_TO as address,
    AMOUNT as flow
    FROM solana.core.fact_transfers
    where mint in (select address from nfts)

    )

    select
    address,
    sum(flow) as holdings
    from raw
    group by address
    having holdings > 0
    order by holdings DESC

    Run a query to Download Data