Compid = 173912Number Of Rows Found :1
Compid Found :173912 Tic Found :LUX
FINALLUX | 173912
Split info : 1
START
ratioBigStringPieces :
reportDateBigStringPieces :
SELECT current13Fpositions. *
FROM `current13Fpositions` , all13ffilings, institutionciklist
WHERE compid =173912 AND current13Fpositions.linkID = all13ffilings.entryId and all13ffilings.institutionid = institutionciklist.institutionid and institutionciklist.alive = 'yes' AND reportDate >= '2024-03-31'
Number Of Rows Found :9
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies0
newHoldingTotalValue0
newHoldingTotalShares0
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-785
oldDecreaseHoldingTotalShares-33728
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld10439
totalSharesValue268
totalPostionChange-33728
totalValueChange-785
totalHolders1
COMPID173912
TICLUX
CIK9000009768
SHSOUT9000
NAMETema Luxury Etf
SECTOR999999
CUSIP87975E305
PRICE
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies1
newHoldingTotalValue767
newHoldingTotalShares29857
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-785
oldDecreaseHoldingTotalShares-33728
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld40296
totalSharesValue1035
totalPostionChange-3871
totalValueChange-18
totalHolders2
COMPID173912
TICLUX
CIK9000009768
SHSOUT9000
NAMETema Luxury Etf
SECTOR999999
CUSIP87975E305
PRICE
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies2
newHoldingTotalValue769
newHoldingTotalShares29932
oldDecreaseHoldingTotalCompanies1
oldDecreaseHoldingTotalValue-785
oldDecreaseHoldingTotalShares-33728
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld40371
totalSharesValue1037
totalPostionChange-3796
totalValueChange-16
totalHolders3
COMPID173912
TICLUX
CIK9000009768
SHSOUT9000
NAMETema Luxury Etf
SECTOR999999
CUSIP87975E305
PRICE
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies2
newHoldingTotalValue769
newHoldingTotalShares29932
oldDecreaseHoldingTotalCompanies2
oldDecreaseHoldingTotalValue-880
oldDecreaseHoldingTotalShares-38630
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld52275
totalSharesValue1343
totalPostionChange-8698
totalValueChange-111
totalHolders4
COMPID173912
TICLUX
CIK9000009768
SHSOUT9000
NAMETema Luxury Etf
SECTOR999999
CUSIP87975E305
PRICE
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies2
newHoldingTotalValue769
newHoldingTotalShares29932
oldDecreaseHoldingTotalCompanies3
oldDecreaseHoldingTotalValue-881
oldDecreaseHoldingTotalShares-38687
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld52300
totalSharesValue1344
totalPostionChange-8755
totalValueChange-112
totalHolders5
COMPID173912
TICLUX
CIK9000009768
SHSOUT9000
NAMETema Luxury Etf
SECTOR999999
CUSIP87975E305
PRICE
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies2
newHoldingTotalValue769
newHoldingTotalShares29932
oldDecreaseHoldingTotalCompanies4
oldDecreaseHoldingTotalValue-886
oldDecreaseHoldingTotalShares-40116
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 0
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld67986
totalSharesValue1747
totalPostionChange-10184
totalValueChange-117
totalHolders6
COMPID173912
TICLUX
CIK9000009768
SHSOUT9000
NAMETema Luxury Etf
SECTOR999999
CUSIP87975E305
PRICEmust have stayed the same
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies2
newHoldingTotalValue769
newHoldingTotalShares29932
oldDecreaseHoldingTotalCompanies4
oldDecreaseHoldingTotalValue-886
oldDecreaseHoldingTotalShares-40116
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 1
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 0
totalSharesHeld67986
totalSharesValue1747
totalPostionChange-10184
totalValueChange-117
totalHolders7
COMPID173912
TICLUX
CIK9000009768
SHSOUT9000
NAMETema Luxury Etf
SECTOR999999
CUSIP87975E305
PRICEmust have stayed the same
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies2
newHoldingTotalValue769
newHoldingTotalShares29932
oldDecreaseHoldingTotalCompanies4
oldDecreaseHoldingTotalValue-886
oldDecreaseHoldingTotalShares-40116
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 125
totalSharesHeld68111
totalSharesValue1750
totalPostionChange-10184
totalValueChange-117
totalHolders8
COMPID173912
TICLUX
CIK9000009768
SHSOUT9000
NAMETema Luxury Etf
SECTOR999999
CUSIP87975E305
PRICE
liquidatedTotalCompanies0
liquidatedTotalValue0
liquidatedTotalShares0
newHoldingTotalCompanies3
newHoldingTotalValue974
newHoldingTotalShares37932
oldDecreaseHoldingTotalCompanies4
oldDecreaseHoldingTotalValue-886
oldDecreaseHoldingTotalShares-40116
oldIncreaseHoldingTotalCompanies0
oldIncreaseHoldingTotalValue0
oldIncreaseHoldingTotalShares0
unchangedHoldingTotalCompanies 2
unchangedHoldingTotalValue 0
unchangedHoldingTotalShares 125
totalSharesHeld76111
totalSharesValue1955
totalPostionChange-2184
totalValueChange88
totalHolders9
COMPID173912
TICLUX
CIK9000009768
SHSOUT9000
NAMETema Luxury Etf
SECTOR999999
CUSIP87975E305
PRICE
virgina 0.85
virgina2 -0.02
SELECT * from sectors where level3num = '999999'Number Of Rows Found :1
The Sector is N/A
CRAIG TOTAL SHARES VALE : 1955
MKCAP0/n/ninsert into institSumNewHoldings values(
Null,
'9000009768',
'173912',
'Tema Luxury Etf',
'LUX',
'',
'87975E305',
'9000',
'0.85',
'999999',
'N/A',
'0',
'0',
'0',
'0',
'3',
'974',
'37932',
'4',
'-886',
'-40116',
'0',
'0',
'0',
'76111',
'1955',
'-2184',
'88',
'9',
'2',
'0',
'125',
'-0.02',
'-391',
'NULL',
'-391',
'',
'',
'',
'0',
NULL, NULL,NULL)
OKbye