Compid = 168509Number Of Rows Found :1
Compid Found :168509 Tic Found :CRKN
FINALCRKN | 168509

Split info : 1

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

Number Of Rows Found :22

liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares2373
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0

totalSharesHeld9452
totalSharesValue1
totalPostionChange2373
totalValueChange0
totalHolders1
COMPID168509
TICCRKN
CIK0001761696
SHSOUT13250
NAMECrown Electrokinetics Corp.
SECTOR999999
CUSIP228339305
PRICEmust have stayed the same

liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares2373
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 14

totalSharesHeld9466
totalSharesValue1
totalPostionChange2373
totalValueChange0
totalHolders2
COMPID168509
TICCRKN
CIK0001761696
SHSOUT13250
NAMECrown Electrokinetics Corp.
SECTOR999999
CUSIP228339305
PRICEmust have stayed the same

liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares2373
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 14

totalSharesHeld9466
totalSharesValue1
totalPostionChange2373
totalValueChange0
totalHolders3
COMPID168509
TICCRKN
CIK0001761696
SHSOUT13250
NAMECrown Electrokinetics Corp.
SECTOR999999
CUSIP228339305
PRICE

liquidatedTotalCompanies1
liquidatedTotalValue-6
liquidatedTotalShares-37898
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares2373
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 14

totalSharesHeld9466
totalSharesValue1
totalPostionChange-35525
totalValueChange-6
totalHolders3
COMPID168509
TICCRKN
CIK0001761696
SHSOUT13250
NAMECrown Electrokinetics Corp.
SECTOR999999
CUSIP228339305
PRICE

liquidatedTotalCompanies1
liquidatedTotalValue-6
liquidatedTotalShares-37898
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares2591
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 14

totalSharesHeld9707
totalSharesValue1
totalPostionChange-35307
totalValueChange-6
totalHolders4
COMPID168509
TICCRKN
CIK0001761696
SHSOUT13250
NAMECrown Electrokinetics Corp.
SECTOR999999
CUSIP228339305
PRICEmust have stayed the same

liquidatedTotalCompanies1
liquidatedTotalValue-6
liquidatedTotalShares-37898
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares2591
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 18

totalSharesHeld9711
totalSharesValue1
totalPostionChange-35307
totalValueChange-6
totalHolders5
COMPID168509
TICCRKN
CIK0001761696
SHSOUT13250
NAMECrown Electrokinetics Corp.
SECTOR999999
CUSIP228339305
PRICE

liquidatedTotalCompanies1
liquidatedTotalValue-6
liquidatedTotalShares-37898
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue1
oldIncreaseHoldingTotalShares34345
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 18

totalSharesHeld60560
totalSharesValue4
totalPostionChange-3553
totalValueChange-5
totalHolders6
COMPID168509
TICCRKN
CIK0001761696
SHSOUT13250
NAMECrown Electrokinetics Corp.
SECTOR999999
CUSIP228339305
PRICE

liquidatedTotalCompanies2
liquidatedTotalValue-12
liquidatedTotalShares-81817
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue1
oldIncreaseHoldingTotalShares34345
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 18

totalSharesHeld60560
totalSharesValue4
totalPostionChange-47472
totalValueChange-11
totalHolders6
COMPID168509
TICCRKN
CIK0001761696
SHSOUT13250
NAMECrown Electrokinetics Corp.
SECTOR999999
CUSIP228339305
PRICE

liquidatedTotalCompanies3
liquidatedTotalValue-24
liquidatedTotalShares-162181
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue1
oldIncreaseHoldingTotalShares34345
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 18

totalSharesHeld60560
totalSharesValue4
totalPostionChange-127836
totalValueChange-23
totalHolders6
COMPID168509
TICCRKN
CIK0001761696
SHSOUT13250
NAMECrown Electrokinetics Corp.
SECTOR999999
CUSIP228339305
PRICE

liquidatedTotalCompanies3
liquidatedTotalValue-24
liquidatedTotalShares-162181
newHoldingTotalCompanies1
newHoldingTotalValue2
newHoldingTotalShares40408
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue1
oldIncreaseHoldingTotalShares34345
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 18

totalSharesHeld100968
totalSharesValue6
totalPostionChange-87428
totalValueChange-21
totalHolders7
COMPID168509
TICCRKN
CIK0001761696
SHSOUT13250
NAMECrown Electrokinetics Corp.
SECTOR999999
CUSIP228339305
PRICE

liquidatedTotalCompanies3
liquidatedTotalValue-24
liquidatedTotalShares-162181
newHoldingTotalCompanies2
newHoldingTotalValue3
newHoldingTotalShares61329
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue1
oldIncreaseHoldingTotalShares34345
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 18

totalSharesHeld121889
totalSharesValue7
totalPostionChange-66507
totalValueChange-20
totalHolders8
COMPID168509
TICCRKN
CIK0001761696
SHSOUT13250
NAMECrown Electrokinetics Corp.
SECTOR999999
CUSIP228339305
PRICE

liquidatedTotalCompanies3
liquidatedTotalValue-24
liquidatedTotalShares-162181
newHoldingTotalCompanies3
newHoldingTotalValue4
newHoldingTotalShares65079
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue1
oldIncreaseHoldingTotalShares34345
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 18

totalSharesHeld125639
totalSharesValue8
totalPostionChange-62757
totalValueChange-19
totalHolders9
COMPID168509
TICCRKN
CIK0001761696
SHSOUT13250
NAMECrown Electrokinetics Corp.
SECTOR999999
CUSIP228339305
PRICE

liquidatedTotalCompanies3
liquidatedTotalValue-24
liquidatedTotalShares-162181
newHoldingTotalCompanies3
newHoldingTotalValue4
newHoldingTotalShares65079
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-1
oldDecreaseHoldingTotalShares-2500
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue1
oldIncreaseHoldingTotalShares34345
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 18

totalSharesHeld139239
totalSharesValue9
totalPostionChange-65257
totalValueChange-20
totalHolders10
COMPID168509
TICCRKN
CIK0001761696
SHSOUT13250
NAMECrown Electrokinetics Corp.
SECTOR999999
CUSIP228339305
PRICE

liquidatedTotalCompanies3
liquidatedTotalValue-24
liquidatedTotalShares-162181
newHoldingTotalCompanies3
newHoldingTotalValue4
newHoldingTotalShares65079
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-32
oldDecreaseHoldingTotalShares-192729
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue1
oldIncreaseHoldingTotalShares34345
unchangedHoldingTotalCompanies 3
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 18

totalSharesHeld181761
totalSharesValue12
totalPostionChange-255486
totalValueChange-51
totalHolders11
COMPID168509
TICCRKN
CIK0001761696
SHSOUT13250
NAMECrown Electrokinetics Corp.
SECTOR999999
CUSIP228339305
PRICEmust have stayed the same

liquidatedTotalCompanies3
liquidatedTotalValue-24
liquidatedTotalShares-162181
newHoldingTotalCompanies3
newHoldingTotalValue4
newHoldingTotalShares65079
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-32
oldDecreaseHoldingTotalShares-192729
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue1
oldIncreaseHoldingTotalShares34345
unchangedHoldingTotalCompanies 4
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 179

totalSharesHeld181922
totalSharesValue12
totalPostionChange-255486
totalValueChange-51
totalHolders12
COMPID168509
TICCRKN
CIK0001761696
SHSOUT13250
NAMECrown Electrokinetics Corp.
SECTOR999999
CUSIP228339305
PRICEmust have stayed the same

liquidatedTotalCompanies3
liquidatedTotalValue-24
liquidatedTotalShares-162181
newHoldingTotalCompanies3
newHoldingTotalValue4
newHoldingTotalShares65079
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-32
oldDecreaseHoldingTotalShares-192729
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue1
oldIncreaseHoldingTotalShares34345
unchangedHoldingTotalCompanies 5
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 2957

totalSharesHeld184700
totalSharesValue12
totalPostionChange-255486
totalValueChange-51
totalHolders13
COMPID168509
TICCRKN
CIK0001761696
SHSOUT13250
NAMECrown Electrokinetics Corp.
SECTOR999999
CUSIP228339305
PRICE

liquidatedTotalCompanies3
liquidatedTotalValue-24
liquidatedTotalShares-162181
newHoldingTotalCompanies4
newHoldingTotalValue5
newHoldingTotalShares84148
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-32
oldDecreaseHoldingTotalShares-192729
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue1
oldIncreaseHoldingTotalShares34345
unchangedHoldingTotalCompanies 5
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 2957

totalSharesHeld203769
totalSharesValue13
totalPostionChange-236417
totalValueChange-50
totalHolders14
COMPID168509
TICCRKN
CIK0001761696
SHSOUT13250
NAMECrown Electrokinetics Corp.
SECTOR999999
CUSIP228339305
PRICE

liquidatedTotalCompanies3
liquidatedTotalValue-24
liquidatedTotalShares-162181
newHoldingTotalCompanies5
newHoldingTotalValue6
newHoldingTotalShares96352
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-32
oldDecreaseHoldingTotalShares-192729
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue1
oldIncreaseHoldingTotalShares34345
unchangedHoldingTotalCompanies 5
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 2957

totalSharesHeld215973
totalSharesValue14
totalPostionChange-224213
totalValueChange-49
totalHolders15
COMPID168509
TICCRKN
CIK0001761696
SHSOUT13250
NAMECrown Electrokinetics Corp.
SECTOR999999
CUSIP228339305
PRICE

liquidatedTotalCompanies4
liquidatedTotalValue-54
liquidatedTotalShares-368802
newHoldingTotalCompanies5
newHoldingTotalValue6
newHoldingTotalShares96352
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-32
oldDecreaseHoldingTotalShares-192729
oldIncreaseHoldingTotalCompanies4
oldIncreaseHoldingTotalValue3
oldIncreaseHoldingTotalShares73814
unchangedHoldingTotalCompanies 7
unchangedHoldingTotalValue -1
unchangedHoldingTotalShares 15211

totalSharesHeld273299
totalSharesValue18
totalPostionChange-391365
totalValueChange-78
totalHolders18
COMPID168509
TICCRKN
CIK0001761696
SHSOUT13250
NAMECrown Electrokinetics Corp.
SECTOR999999
CUSIP228339305
PRICE
virgina 2.06

virgina2 -2.95
SELECT * from sectors where level3num = '999999'Number Of Rows Found :1
The Sector is N/A

CRAIG TOTAL SHARES VALE : 18

MKCAP0/n/ninsert into institSumNewHoldings values( Null, '0001761696', '168509', 'Crown Electrokinetics Corp.', 'CRKN', '', '228339305', '13250', '2.06', '999999', 'N/A', '0', '4', '-54', '-368802', '5', '6', '96352', '2', '-32', '-192729', '4', '3', '73814', '273299', '18', '-391365', '-78', '18', '7', '-1', '15211', '-2.95', '-531', 'NULL', '-531', '', '', '', '0', NULL, NULL,NULL) OKbye