Compid = 168468Number Of Rows Found :1
Compid Found :168468 Tic Found :AFBI
FINALAFBI | 168468
Split info : 1
START
ratioBigStringPieces :
reportDateBigStringPieces :
SELECT current13Fpositions. *
FROM `current13Fpositions` , all13ffilings, institutionciklist
WHERE compid =168468 AND current13Fpositions.linkID = all13ffilings.entryId and all13ffilings.institutionid = institutionciklist.institutionid and institutionciklist.alive = 'yes' AND reportDate >= '2024-03-31'
Number Of Rows Found :21
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies1
newHoldingTotalValue208
newHoldingTotalShares12576
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld12576
totalSharesValue208
totalPostionChange12576
totalValueChange208
totalHolders1
COMPID168468
TICAFBI
CIK0001823406
SHSOUT
NAMEAffinity Bancshares, Inc.
SECTOR999999
CUSIP00832E103
PRICE
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies2
newHoldingTotalValue209
newHoldingTotalShares12618
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld12618
totalSharesValue209
totalPostionChange12618
totalValueChange209
totalHolders2
COMPID168468
TICAFBI
CIK0001823406
SHSOUT
NAMEAffinity Bancshares, Inc.
SECTOR999999
CUSIP00832E103
PRICEmust have stayed the same
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies2
newHoldingTotalValue209
newHoldingTotalShares12618
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 38
unchangedHoldingTotalShares 64840
totalSharesHeld77458
totalSharesValue1282
totalPostionChange12618
totalValueChange247
totalHolders3
COMPID168468
TICAFBI
CIK0001823406
SHSOUT
NAMEAffinity Bancshares, Inc.
SECTOR999999
CUSIP00832E103
PRICE
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies2
newHoldingTotalValue209
newHoldingTotalShares12618
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-6
oldDecreaseHoldingTotalShares-610
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 38
unchangedHoldingTotalShares 64840
totalSharesHeld104848
totalSharesValue1723
totalPostionChange12008
totalValueChange241
totalHolders4
COMPID168468
TICAFBI
CIK0001823406
SHSOUT
NAMEAffinity Bancshares, Inc.
SECTOR999999
CUSIP00832E103
PRICE
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies2
newHoldingTotalValue209
newHoldingTotalShares12618
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-5
oldDecreaseHoldingTotalShares-992
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 38
unchangedHoldingTotalShares 64840
totalSharesHeld116519
totalSharesValue1916
totalPostionChange11626
totalValueChange242
totalHolders5
COMPID168468
TICAFBI
CIK0001823406
SHSOUT
NAMEAffinity Bancshares, Inc.
SECTOR999999
CUSIP00832E103
PRICE
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies2
newHoldingTotalValue209
newHoldingTotalShares12618
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue-9
oldDecreaseHoldingTotalShares-1289
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 38
unchangedHoldingTotalShares 64840
totalSharesHeld117103
totalSharesValue1926
totalPostionChange11329
totalValueChange238
totalHolders6
COMPID168468
TICAFBI
CIK0001823406
SHSOUT
NAMEAffinity Bancshares, Inc.
SECTOR999999
CUSIP00832E103
PRICE
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies2
newHoldingTotalValue209
newHoldingTotalShares12618
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue-9
oldDecreaseHoldingTotalShares-1289
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue39
oldIncreaseHoldingTotalShares355
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 38
unchangedHoldingTotalShares 64840
totalSharesHeld175320
totalSharesValue2889
totalPostionChange11684
totalValueChange277
totalHolders7
COMPID168468
TICAFBI
CIK0001823406
SHSOUT
NAMEAffinity Bancshares, Inc.
SECTOR999999
CUSIP00832E103
PRICE
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies2
newHoldingTotalValue209
newHoldingTotalShares12618
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue-9
oldDecreaseHoldingTotalShares-1289
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue75
oldIncreaseHoldingTotalShares1129
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 38
unchangedHoldingTotalShares 64840
totalSharesHeld214932
totalSharesValue3545
totalPostionChange12458
totalValueChange313
totalHolders8
COMPID168468
TICAFBI
CIK0001823406
SHSOUT
NAMEAffinity Bancshares, Inc.
SECTOR999999
CUSIP00832E103
PRICE
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies2
newHoldingTotalValue209
newHoldingTotalShares12618
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue-9
oldDecreaseHoldingTotalShares-1289
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue116
oldIncreaseHoldingTotalShares3212
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 38
unchangedHoldingTotalShares 64840
totalSharesHeld227610
totalSharesValue3755
totalPostionChange14541
totalValueChange354
totalHolders9
COMPID168468
TICAFBI
CIK0001823406
SHSOUT
NAMEAffinity Bancshares, Inc.
SECTOR999999
CUSIP00832E103
PRICE
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies2
newHoldingTotalValue209
newHoldingTotalShares12618
oldDecreaseHoldingTotalCompanies4
oldDecreaseHoldingTotalValue-73
oldDecreaseHoldingTotalShares-6139
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue116
oldIncreaseHoldingTotalShares3212
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 38
unchangedHoldingTotalShares 64840
totalSharesHeld250149
totalSharesValue4128
totalPostionChange9691
totalValueChange290
totalHolders10
COMPID168468
TICAFBI
CIK0001823406
SHSOUT
NAMEAffinity Bancshares, Inc.
SECTOR999999
CUSIP00832E103
PRICE
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies2
newHoldingTotalValue209
newHoldingTotalShares12618
oldDecreaseHoldingTotalCompanies5
oldDecreaseHoldingTotalValue-74
oldDecreaseHoldingTotalShares-6188
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue116
oldIncreaseHoldingTotalShares3212
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 38
unchangedHoldingTotalShares 64840
totalSharesHeld250213
totalSharesValue4129
totalPostionChange9642
totalValueChange289
totalHolders11
COMPID168468
TICAFBI
CIK0001823406
SHSOUT
NAMEAffinity Bancshares, Inc.
SECTOR999999
CUSIP00832E103
PRICEmust have stayed the same
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies2
newHoldingTotalValue209
newHoldingTotalShares12618
oldDecreaseHoldingTotalCompanies5
oldDecreaseHoldingTotalValue-74
oldDecreaseHoldingTotalShares-6188
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue116
oldIncreaseHoldingTotalShares3212
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 56
unchangedHoldingTotalShares 96340
totalSharesHeld281713
totalSharesValue4650
totalPostionChange9642
totalValueChange307
totalHolders12
COMPID168468
TICAFBI
CIK0001823406
SHSOUT
NAMEAffinity Bancshares, Inc.
SECTOR999999
CUSIP00832E103
PRICE
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies2
newHoldingTotalValue209
newHoldingTotalShares12618
oldDecreaseHoldingTotalCompanies5
oldDecreaseHoldingTotalValue-74
oldDecreaseHoldingTotalShares-6188
oldIncreaseHoldingTotalCompanies4
oldIncreaseHoldingTotalValue156
oldIncreaseHoldingTotalShares3911
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 56
unchangedHoldingTotalShares 96340
totalSharesHeld331317
totalSharesValue5471
totalPostionChange10341
totalValueChange347
totalHolders13
COMPID168468
TICAFBI
CIK0001823406
SHSOUT
NAMEAffinity Bancshares, Inc.
SECTOR999999
CUSIP00832E103
PRICEmust have stayed the same
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies2
newHoldingTotalValue209
newHoldingTotalShares12618
oldDecreaseHoldingTotalCompanies5
oldDecreaseHoldingTotalValue-74
oldDecreaseHoldingTotalShares-6188
oldIncreaseHoldingTotalCompanies4
oldIncreaseHoldingTotalValue156
oldIncreaseHoldingTotalShares3911
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue 202
unchangedHoldingTotalShares 347900
totalSharesHeld582877
totalSharesValue9634
totalPostionChange10341
totalValueChange493
totalHolders14
COMPID168468
TICAFBI
CIK0001823406
SHSOUT
NAMEAffinity Bancshares, Inc.
SECTOR999999
CUSIP00832E103
PRICEmust have stayed the same
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies2
newHoldingTotalValue209
newHoldingTotalShares12618
oldDecreaseHoldingTotalCompanies5
oldDecreaseHoldingTotalValue-74
oldDecreaseHoldingTotalShares-6188
oldIncreaseHoldingTotalCompanies4
oldIncreaseHoldingTotalValue156
oldIncreaseHoldingTotalShares3911
unchangedHoldingTotalCompanies 4
unchangedHoldingTotalValue 202
unchangedHoldingTotalShares 347900
totalSharesHeld582877
totalSharesValue9634
totalPostionChange10341
totalValueChange493
totalHolders15
COMPID168468
TICAFBI
CIK0001823406
SHSOUT
NAMEAffinity Bancshares, Inc.
SECTOR999999
CUSIP00832E103
PRICE
liquidatedTotalCompanies1
liquidatedTotalValue-242
liquidatedTotalShares-15175
newHoldingTotalCompanies2
newHoldingTotalValue209
newHoldingTotalShares12618
oldDecreaseHoldingTotalCompanies5
oldDecreaseHoldingTotalValue-74
oldDecreaseHoldingTotalShares-6188
oldIncreaseHoldingTotalCompanies4
oldIncreaseHoldingTotalValue156
oldIncreaseHoldingTotalShares3911
unchangedHoldingTotalCompanies 4
unchangedHoldingTotalValue 202
unchangedHoldingTotalShares 347900
totalSharesHeld582877
totalSharesValue9634
totalPostionChange-4834
totalValueChange251
totalHolders15
COMPID168468
TICAFBI
CIK0001823406
SHSOUT
NAMEAffinity Bancshares, Inc.
SECTOR999999
CUSIP00832E103
PRICEmust have stayed the same
liquidatedTotalCompanies1
liquidatedTotalValue-242
liquidatedTotalShares-15175
newHoldingTotalCompanies2
newHoldingTotalValue209
newHoldingTotalShares12618
oldDecreaseHoldingTotalCompanies5
oldDecreaseHoldingTotalValue-74
oldDecreaseHoldingTotalShares-6188
oldIncreaseHoldingTotalCompanies4
oldIncreaseHoldingTotalValue156
oldIncreaseHoldingTotalShares3911
unchangedHoldingTotalCompanies 5
unchangedHoldingTotalValue 206
unchangedHoldingTotalShares 355900
totalSharesHeld590877
totalSharesValue9766
totalPostionChange-4834
totalValueChange255
totalHolders16
COMPID168468
TICAFBI
CIK0001823406
SHSOUT
NAMEAffinity Bancshares, Inc.
SECTOR999999
CUSIP00832E103
PRICE
liquidatedTotalCompanies1
liquidatedTotalValue-242
liquidatedTotalShares-15175
newHoldingTotalCompanies2
newHoldingTotalValue209
newHoldingTotalShares12618
oldDecreaseHoldingTotalCompanies6
oldDecreaseHoldingTotalValue117
oldDecreaseHoldingTotalShares-11442
oldIncreaseHoldingTotalCompanies4
oldIncreaseHoldingTotalValue156
oldIncreaseHoldingTotalShares3911
unchangedHoldingTotalCompanies 5
unchangedHoldingTotalValue 206
unchangedHoldingTotalShares 355900
totalSharesHeld1065559
totalSharesValue17622
totalPostionChange-10088
totalValueChange446
totalHolders17
COMPID168468
TICAFBI
CIK0001823406
SHSOUT
NAMEAffinity Bancshares, Inc.
SECTOR999999
CUSIP00832E103
PRICE
liquidatedTotalCompanies1
liquidatedTotalValue-242
liquidatedTotalShares-15175
newHoldingTotalCompanies2
newHoldingTotalValue209
newHoldingTotalShares12618
oldDecreaseHoldingTotalCompanies7
oldDecreaseHoldingTotalValue111
oldDecreaseHoldingTotalShares-12244
oldIncreaseHoldingTotalCompanies4
oldIncreaseHoldingTotalValue156
oldIncreaseHoldingTotalShares3911
unchangedHoldingTotalCompanies 5
unchangedHoldingTotalValue 206
unchangedHoldingTotalShares 355900
totalSharesHeld1076300
totalSharesValue17800
totalPostionChange-10890
totalValueChange440
totalHolders18
COMPID168468
TICAFBI
CIK0001823406
SHSOUT
NAMEAffinity Bancshares, Inc.
SECTOR999999
CUSIP00832E103
PRICE
liquidatedTotalCompanies1
liquidatedTotalValue-242
liquidatedTotalShares-15175
newHoldingTotalCompanies2
newHoldingTotalValue209
newHoldingTotalShares12618
oldDecreaseHoldingTotalCompanies7
oldDecreaseHoldingTotalValue111
oldDecreaseHoldingTotalShares-12244
oldIncreaseHoldingTotalCompanies5
oldIncreaseHoldingTotalValue182
oldIncreaseHoldingTotalShares4143
unchangedHoldingTotalCompanies 5
unchangedHoldingTotalValue 206
unchangedHoldingTotalShares 355900
totalSharesHeld1114030
totalSharesValue18425
totalPostionChange-10658
totalValueChange466
totalHolders19
COMPID168468
TICAFBI
CIK0001823406
SHSOUT
NAMEAffinity Bancshares, Inc.
SECTOR999999
CUSIP00832E103
PRICEmust have stayed the same
liquidatedTotalCompanies1
liquidatedTotalValue-242
liquidatedTotalShares-15175
newHoldingTotalCompanies2
newHoldingTotalValue209
newHoldingTotalShares12618
oldDecreaseHoldingTotalCompanies7
oldDecreaseHoldingTotalValue111
oldDecreaseHoldingTotalShares-12244
oldIncreaseHoldingTotalCompanies5
oldIncreaseHoldingTotalValue182
oldIncreaseHoldingTotalShares4143
unchangedHoldingTotalCompanies 6
unchangedHoldingTotalValue 213
unchangedHoldingTotalShares 370127
totalSharesHeld1128257
totalSharesValue18659
totalPostionChange-10658
totalValueChange473
totalHolders20
COMPID168468
TICAFBI
CIK0001823406
SHSOUT
NAMEAffinity Bancshares, Inc.
SECTOR999999
CUSIP00832E103
PRICE
virgina 0
virgina2 0
SELECT * from sectors where level3num = '999999'Number Of Rows Found :1
The Sector is N/A
CRAIG TOTAL SHARES VALE : 18659
MKCAP0/n/ninsert into institSumNewHoldings values(
Null,
'0001823406',
'168468',
'Affinity Bancshares, Inc.',
'AFBI',
'',
'00832E103',
'',
'0',
'999999',
'N/A',
'0',
'1',
'-242',
'-15175',
'2',
'209',
'12618',
'7',
'111',
'-12244',
'5',
'182',
'4143',
'1128257',
'18659',
'-10658',
'473',
'20',
'6',
'213',
'370127',
'0',
'0',
'0',
'0',
'',
'',
'',
'0',
NULL, NULL,NULL)
OKbye