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% $7.32 $7.4 $7.4 $7.7 9.2  (6%) -1
SMTC Semtech Corporation 3.9% $51.35 $49.7 $49.7 $49.4 4.2  (14%) 3
IPHI Inphi Corporation 3.4% $33.65 $33.4 $33.4 $33.9 8.5  (-4%) 0
INTC Intel Corporation 3.4% $50.14 $50.8 $50.8 $52.2 3.3  (-0%) -2
FSLR First Solar Inc. 3.4% $54.45 $53.5 $53.5 $54.3 2.4  (-20%) 0
SLAB Silicon Laboratories Inc. 3.2% $97.30 $100.5 $100.5 $103.3 2.9  (25%) 0
MPWR Monolithic Power Systems Inc. 3.2% $139.69 $138.1 $138.1 $137.3 2.7  (-26%) 2
CREE Cree Inc. 3.2% $51.25 $47.7 $47.7 $47.3 16.7  (-12%) 5
AMD Advanced Micro Devices Inc. 3.2% $19.10 $17.8 $17.8 $16.4 1.9  (4%) 4
ADI Analog Devices Inc. 3.1% $97.74 $97.5 $97.5 $98.3 3.8  (-2%) 0
TXN Texas Instruments Incorporated 3.1% $114.34 $114.0 $114.0 $113.5 3.3  (21%) 2
NVDA NVIDIA Corporation 3.1% $256.46 $251.7 $251.7 $252.9 1.5  (-4%) 2
AVGO Broadcom Inc. 3.0% $216.58 $215.4 $215.4 $239.1 1.3  (69%) -2
SYNA Synaptics Incorporated 3.0% $48.17 $49.2 $49.2 $48.6 15.6  (0%) 2
MTSI MACOM Technology Solutions Holdings Inc. 3.0% $23.88 $23.0 $23.0 $23.6 27.3  (-4%) 0
IDTI Integrated Device Technology Inc. 2.9% $36.55 $35.0 $35.0 $34.2 4.8  (-16%) 3
QRVO Qorvo Inc. 2.9% $85.51 $82.9 $82.9 $82.0 6.4  (-5%) 4
MXIM Maxim Integrated Products Inc. 2.9% $63.06 $61.3 $61.3 $60.6 2.3  (2%) 4
MCHP Microchip Technology Incorporated 2.9% $98.08 $94.9 $94.9 $96.4 18.8  (3%) 4
XLNX Xilinx Inc. 2.9% $73.43 $70.6 $70.6 $69.1 1.9  (5%) 3
MRVL Marvell Technology Group Ltd. 2.8% $21.69 $21.7 $21.7 $21.6 1.7  (-36%) 2
MU Micron Technology Inc. 2.8% $52.26 $54.3 $54.3 $55.9 1.5  (-4%) -0
CRUS Cirrus Logic Inc. 2.8% $43.05 $41.5 $41.5 $39.7 6.6  (-16%) 4
ON ON Semiconductor Corporation 2.8% $21.92 $23.1 $23.1 $23.8 3.9  (-9%) -2
CY Cypress Semiconductor Corporation 2.7% $17.69 $17.3 $17.3 $16.9 3.0  (-4%) 4
SWKS Skyworks Solutions Inc. 2.7% $94.33 $97.0 $97.0 $98.5 2.8  (-3%) -1
QCOM QUALCOMM Incorporated 2.7% $65.08 $61.6 $61.6 $59.6 1.3  (7%) 4
RMBS Rambus Inc. 2.5% $12.64 $12.9 $12.9 $13.1 4.2  (-27%) -2
MXL MaxLinear inc 2.5% $18.30 $17.2 $17.2 $17.4 11.8  (-3%) 2
DIOD Diodes Incorporated 1.7% $37.95 $37.3 $37.3 $36.4 6.3  (6%) 4
POWI Power Integrations Inc. 1.7% $72.95 $74.4 $74.4 $75.7 6.1  (9%) 1
LSCC Lattice Semiconductor Corporation 1.2% $7.66 $7.1 $7.1 $6.6 1.3  (-5%) 4
CEVA CEVA Inc. 1.2% $29.70 $31.2 $31.2 $32.0 6.0  (0%) -1