select * from todays_data inner join vw_todays_etf_holdings on todays_data.ticker_symbol = vw_todays_etf_holdings.ticker_symbol where etf_ticker = 'XSD' order by weighting desc

XSD Conmponent Weighting

Ticker
Symbol
Company Name ETF Weight Close Price 10-Day 20-Day 50-Day Short Int Ratio Technical Score
SPWR SunPower Corporation 3.9% $8.02 $8.4 $8.4 $8.5 7.5  (7%) -1
SMTC Semtech Corporation 3.9% $50.50 $47.4 $47.4 $44.2 4.5  (-5%) 4
IPHI Inphi Corporation 3.4% $36.05 $34.3 $34.3 $32.6 15.5  (-6%) 4
INTC Intel Corporation 3.4% $55.54 $55.3 $55.3 $53.6 3.6  (6%) 3
FSLR First Solar Inc. 3.4% $53.71 $62.6 $62.6 $68.0 2.0  (-8%) -1
SLAB Silicon Laboratories Inc. 3.2% $108.80 $106.6 $106.6 $99.9 6.1  (17%) 5
MPWR Monolithic Power Systems Inc. 3.2% $139.71 $133.5 $133.5 $125.9 5.1  (1%) 4
CREE Cree Inc. 3.2% $49.45 $47.4 $47.4 $43.4 9.5  (-7%) 5
AMD Advanced Micro Devices Inc. 3.2% $16.25 $14.3 $14.3 $12.2 4.0  (-3%) 4
ADI Analog Devices Inc. 3.1% $101.70 $98.1 $98.1 $93.7 5.1  (-2%) 5
TXN Texas Instruments Incorporated 3.1% $114.72 $113.4 $113.4 $107.8 2.8  (13%) 4
NVDA NVIDIA Corporation 3.1% $266.91 $255.5 $255.5 $242.4 0.9  (-7%) 4
AVGO Broadcom Inc. 3.0% $268.46 $252.6 $252.6 $243.5 2.0  (12%) 2
SYNA Synaptics Incorporated 3.0% $48.09 $43.6 $43.6 $44.2 8.9  (1%) 1
MTSI MACOM Technology Solutions Holdings Inc. 3.0% $24.99 $23.4 $23.4 $21.0 9.6  (-4%) 3
IDTI Integrated Device Technology Inc. 2.9% $34.82 $33.6 $33.6 $31.5 4.6  (-25%) 3
QRVO Qorvo Inc. 2.9% $83.65 $80.9 $80.9 $76.7 4.0  (-11%) 3
MXIM Maxim Integrated Products Inc. 2.9% $61.43 $59.8 $59.8 $58.0 2.8  (-29%) 2
MCHP Microchip Technology Incorporated 2.9% $102.57 $98.6 $98.6 $92.2 11.9  (-3%) 5
XLNX Xilinx Inc. 2.9% $70.43 $70.0 $70.0 $68.5 2.4  (4%) 1
MRVL Marvell Technology Group Ltd. 2.8% $21.76 $21.9 $21.9 $21.4 6.2  (-9%) 2
MU Micron Technology Inc. 2.8% $59.18 $59.4 $59.4 $53.8 2.0  (13%) 3
CRUS Cirrus Logic Inc. 2.8% $38.85 $38.1 $38.1 $38.2 6.2  (-1%) 0
ON ON Semiconductor Corporation 2.8% $25.89 $25.2 $25.2 $24.3 4.6  (21%) 3
CAVM Cavium Inc. 2.8% $84.62 $82.9 $82.9 $79.6 4.7  (6%) 2
CY Cypress Semiconductor Corporation 2.7% $17.69 $16.7 $16.7 $16.4 4.0  (-6%) 1
SWKS Skyworks Solutions Inc. 2.7% $101.97 $100.1 $100.1 $97.0 2.3  (-10%) 1
QCOM QUALCOMM Incorporated 2.7% $59.46 $58.9 $58.9 $55.6 1.9  (10%) 2
RMBS Rambus Inc. 2.5% $13.59 $13.6 $13.6 $13.6 7.7  (-10%) 3
MXL MaxLinear inc 2.5% $17.80 $18.8 $18.8 $20.9 5.0  (-10%) -2
DIOD Diodes Incorporated 1.7% $36.56 $35.0 $35.0 $32.4 6.6  (-8%) 4
POWI Power Integrations Inc. 1.7% $79.25 $75.5 $75.5 $71.8 8.5  (7%) 5
LSCC Lattice Semiconductor Corporation 1.2% $6.54 $5.9 $5.9 $5.6 3.6  (-11%) 3
CEVA CEVA Inc. 1.2% $35.00 $34.1 $34.1 $34.2 2.1  (1%) 1