Compid = 151571Number Of Rows Found :1
Compid Found :151571 Tic Found :FBRC
FINALFBRC | 151571

Split info : 1



START
ratioBigStringPieces :
reportDateBigStringPieces :
SELECT current13Fpositions. * FROM `current13Fpositions` , all13ffilings, institutionciklist WHERE compid =151571 AND current13Fpositions.linkID = all13ffilings.entryId and all13ffilings.institutionid = institutionciklist.institutionid and institutionciklist.alive = 'yes' AND reportDate >= '2024-03-31'

Number Of Rows Found :1must have stayed the same


liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 1


totalSharesHeld1
totalSharesValue0
totalPostionChange0
totalValueChange0
totalHolders1
COMPID151571
TICFBRC
CIK0001371446
SHSOUT11327
NAMEFBR Capital Markets Corp
SECTOR302001
CUSIP30247C400
PRICE
virgina 0

virgina2 0
SELECT * from sectors where level3num = '302001'Number Of Rows Found :1
The Sector is Asset Management

CRAIG TOTAL SHARES VALE : 0

MKCAP0/n/ninsert into institSumNewHoldings values( Null, '0001371446', '151571', 'FBR Capital Markets Corp', 'FBRC', '', '30247C400', '11327', '0', '302001', 'Asset Management', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '1', '1', '0', '1', '0', '0', '0', '0', '', '', '', '0', NULL, NULL,NULL) OKbye