Compid = 166930Number Of Rows Found :1
Compid Found :166930 Tic Found :TMDV
FINALTMDV | 166930
Split info : 1
START
ratioBigStringPieces :
reportDateBigStringPieces :
SELECT current13Fpositions. *
FROM `current13Fpositions` , all13ffilings, institutionciklist
WHERE compid =166930 AND current13Fpositions.linkID = all13ffilings.entryId and all13ffilings.institutionid = institutionciklist.institutionid and institutionciklist.alive = 'yes' AND reportDate >= '2024-03-31'
Number Of Rows Found :11
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies1
newHoldingTotalValue0
newHoldingTotalShares1
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld1
totalSharesValue0
totalPostionChange1
totalValueChange0
totalHolders1
COMPID166930
TICTMDV
CIK9000006446
SHSOUT9000
NAMEProshares Russell Us Dividend Growers Etf
SECTOR999999
CUSIP74347G507
PRICEmust have stayed the same
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies1
newHoldingTotalValue0
newHoldingTotalShares1
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld1
totalSharesValue0
totalPostionChange1
totalValueChange0
totalHolders2
COMPID166930
TICTMDV
CIK9000006446
SHSOUT9000
NAMEProshares Russell Us Dividend Growers Etf
SECTOR999999
CUSIP74347G507
PRICE
liquidatedTotalCompanies1
liquidatedTotalValue0
liquidatedTotalShares-1
newHoldingTotalCompanies1
newHoldingTotalValue0
newHoldingTotalShares1
oldDecreaseHoldingTotalCompanies0
oldDecreaseHoldingTotalValue0
oldDecreaseHoldingTotalShares0
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld1
totalSharesValue0
totalPostionChange0
totalValueChange0
totalHolders2
COMPID166930
TICTMDV
CIK9000006446
SHSOUT9000
NAMEProshares Russell Us Dividend Growers Etf
SECTOR999999
CUSIP74347G507
PRICE
liquidatedTotalCompanies1
liquidatedTotalValue0
liquidatedTotalShares-1
newHoldingTotalCompanies1
newHoldingTotalValue0
newHoldingTotalShares1
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-27
oldDecreaseHoldingTotalShares-815
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld8495
totalSharesValue409
totalPostionChange-815
totalValueChange-27
totalHolders3
COMPID166930
TICTMDV
CIK9000006446
SHSOUT9000
NAMEProshares Russell Us Dividend Growers Etf
SECTOR999999
CUSIP74347G507
PRICE
liquidatedTotalCompanies1
liquidatedTotalValue0
liquidatedTotalShares-1
newHoldingTotalCompanies1
newHoldingTotalValue0
newHoldingTotalShares1
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-34
oldDecreaseHoldingTotalShares-952
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld8671
totalSharesValue417
totalPostionChange-952
totalValueChange-34
totalHolders4
COMPID166930
TICTMDV
CIK9000006446
SHSOUT9000
NAMEProshares Russell Us Dividend Growers Etf
SECTOR999999
CUSIP74347G507
PRICE
liquidatedTotalCompanies1
liquidatedTotalValue0
liquidatedTotalShares-1
newHoldingTotalCompanies1
newHoldingTotalValue0
newHoldingTotalShares1
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-34
oldDecreaseHoldingTotalShares-952
oldIncreaseHoldingTotalCompanies1
oldIncreaseHoldingTotalValue161
oldIncreaseHoldingTotalShares2883
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld28241
totalSharesValue1360
totalPostionChange1931
totalValueChange127
totalHolders5
COMPID166930
TICTMDV
CIK9000006446
SHSOUT9000
NAMEProshares Russell Us Dividend Growers Etf
SECTOR999999
CUSIP74347G507
PRICE
liquidatedTotalCompanies1
liquidatedTotalValue0
liquidatedTotalShares-1
newHoldingTotalCompanies1
newHoldingTotalValue0
newHoldingTotalShares1
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-34
oldDecreaseHoldingTotalShares-952
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue290
oldIncreaseHoldingTotalShares4388
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld71464
totalSharesValue3444
totalPostionChange3436
totalValueChange256
totalHolders6
COMPID166930
TICTMDV
CIK9000006446
SHSOUT9000
NAMEProshares Russell Us Dividend Growers Etf
SECTOR999999
CUSIP74347G507
PRICEmust have stayed the same
liquidatedTotalCompanies1
liquidatedTotalValue0
liquidatedTotalShares-1
newHoldingTotalCompanies1
newHoldingTotalValue0
newHoldingTotalShares1
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-34
oldDecreaseHoldingTotalShares-952
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue290
oldIncreaseHoldingTotalShares4388
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 68
totalSharesHeld71532
totalSharesValue3447
totalPostionChange3436
totalValueChange256
totalHolders7
COMPID166930
TICTMDV
CIK9000006446
SHSOUT9000
NAMEProshares Russell Us Dividend Growers Etf
SECTOR999999
CUSIP74347G507
PRICE
liquidatedTotalCompanies1
liquidatedTotalValue0
liquidatedTotalShares-1
newHoldingTotalCompanies1
newHoldingTotalValue0
newHoldingTotalShares1
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue-86
oldDecreaseHoldingTotalShares-2058
oldIncreaseHoldingTotalCompanies2
oldIncreaseHoldingTotalValue290
oldIncreaseHoldingTotalShares4388
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 68
totalSharesHeld71539
totalSharesValue3447
totalPostionChange2330
totalValueChange204
totalHolders8
COMPID166930
TICTMDV
CIK9000006446
SHSOUT9000
NAMEProshares Russell Us Dividend Growers Etf
SECTOR999999
CUSIP74347G507
PRICE
liquidatedTotalCompanies1
liquidatedTotalValue0
liquidatedTotalShares-1
newHoldingTotalCompanies1
newHoldingTotalValue0
newHoldingTotalShares1
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue-86
oldDecreaseHoldingTotalShares-2058
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue302
oldIncreaseHoldingTotalShares4481
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 68
totalSharesHeld77285
totalSharesValue3724
totalPostionChange2423
totalValueChange216
totalHolders9
COMPID166930
TICTMDV
CIK9000006446
SHSOUT9000
NAMEProshares Russell Us Dividend Growers Etf
SECTOR999999
CUSIP74347G507
PRICE
liquidatedTotalCompanies1
liquidatedTotalValue0
liquidatedTotalShares-1
newHoldingTotalCompanies2
newHoldingTotalValue255
newHoldingTotalShares5284
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue-86
oldDecreaseHoldingTotalShares-2058
oldIncreaseHoldingTotalCompanies3
oldIncreaseHoldingTotalValue302
oldIncreaseHoldingTotalShares4481
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 68
totalSharesHeld82568
totalSharesValue3979
totalPostionChange7706
totalValueChange471
totalHolders10
COMPID166930
TICTMDV
CIK9000006446
SHSOUT9000
NAMEProshares Russell Us Dividend Growers Etf
SECTOR999999
CUSIP74347G507
PRICE
virgina 0.92
virgina2 0.09
SELECT * from sectors where level3num = '999999'Number Of Rows Found :1
The Sector is N/A
CRAIG TOTAL SHARES VALE : 3979
MKCAP0/n/ninsert into institSumNewHoldings values(
Null,
'9000006446',
'166930',
'Proshares Russell Us Dividend Growers Etf',
'TMDV',
'',
'74347G507',
'9000',
'0.92',
'999999',
'N/A',
'0',
'1',
'0',
'-1',
'2',
'255',
'5284',
'3',
'-86',
'-2058',
'3',
'302',
'4481',
'82568',
'3979',
'7706',
'471',
'10',
'2',
'0',
'68',
'0.09',
'NULL',
'3581.1',
'3581.1',
'',
'',
'',
'0',
NULL, NULL,NULL)
OKbye