flipside

    Crazy Goose Flock Holders
    m0rt3zaCrazy Goose Flock Holders
    Updated 2022-06-09
    SELECT address, COUNT(*) as asset_count, ntile(100) over (ORDER BY asset_count)
    FROM flipside_prod_db.algorand.account_asset
    WHERE asset_id IN (
    -- list of verified CGF NFTs asset_id
    SELECT asset_id
    FROM flipside_prod_db.algorand.asset
    WHERE asset_name LIKE 'CGF%' AND
    asset_deleted = FALSE AND
    closed_at IS NULL AND
    creator_address LIKE 'GOOSE%'

    ) AND
    amount > 0 AND
    asset_closed = FALSE AND
    asset_last_removed IS NULL
    GROUP BY address
    ORDER BY asset_count DESC
    Run a query to Download Data