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

ITA Conmponent Weighting

Ticker
Symbol
Company Name ETF Weight Close Price 10-Day 20-Day 50-Day Short Int Ratio Technical Score
BA BOEING 10.9% $343.72 $352.9 $352.9 $350.5 1.6  (6%) 0
UTX UNITED TECHNOLOGIES CORP 7.6% $134.24 $132.5 $132.5 $128.6 3.9  (23%) 4
LMT LOCKHEED MARTIN CORP 7.0% $315.71 $319.8 $319.8 $312.7 1.3  (-8%) 1
RTN RAYTHEON 6.3% $196.10 $197.6 $197.6 $199.9 2.0  (-6%) -1
NOC NORTHROP GRUMMAN CORP 5.8% $291.43 $307.6 $307.6 $314.8 1.1  (18%) -1
GD GENERAL DYNAMICS CORP 5.8% $192.57 $195.3 $195.3 $194.8 1.9  (1%) -1
COL ROCKWELL COLLINS INC 3.9% $136.89 $137.4 $137.4 $136.8 5.7  (-9%) 2
TXT TEXTRON INC 3.6% $66.21 $67.0 $67.0 $67.0 2.5  (17%) 0
TDG TRANSDIGM GROUP INC 3.6% $359.38 $364.0 $364.0 $350.7 11.4  (-10%) 4
HRS HARRIS CORP 3.5% $164.57 $155.3 $155.3 $151.1 2.6  (4%) 2
LLL L3 TECHNOLOGIES INC 3.1% $210.93 $206.7 $206.7 $200.7 3.1  (-4%) 3
HII HUNTINGTON INGALLS INDUSTRIES INC 2.6% $236.65 $230.1 $230.1 $223.7 5.1  (-5%) 4
SPR SPIRIT AEROSYSTEMS INC CLASS A 2.6% $87.74 $88.6 $88.6 $87.2 6.6  (-13%) 4
BWXT BWX TECHNOLOGIES INC 2.3% $62.74 $64.7 $64.7 $64.6 2.6  (-19%) -1
TDY TELEDYNE TECHNOLOGIES INC 2.2% $232.00 $217.3 $217.3 $209.1 2.3  (27%) 4
HXL HEXCEL CORP 2.1% $69.54 $68.7 $68.7 $69.0 8.0  (5%) 3
CW CURTISS WRIGHT CORP 2.0% $131.59 $128.3 $128.3 $125.7 3.3  (11%) 0
ARNC ARCONIC INC 2.0% $20.77 $20.0 $20.0 $18.5 2.4  (1%) 3
KLXI KLX INC 1.7% $72.88 $72.8 $72.8 $72.5 4.4  (-4%) 2
HEI HEICO CORP 1.5% $77.00 $76.6 $76.6 $82.8 7.3  (-7%) 1
ROLL RBC BEARINGS INC 1.4% $140.00 $139.3 $139.3 $133.6 4.4  (20%) 4
AAXN AXON ENTERPRISE INC 1.4% $59.33 $69.2 $69.2 $66.8 5.4  (-29%) 2
AJRD AEROJET ROCKETDYNE HOLDINGS INC 1.2% $35.83 $31.3 $31.3 $30.3 8.2  (5%) 5
ESL ESTERLINE TECHNOLOGIES CORP 1.2% $86.65 $81.9 $81.9 $76.9 2.3  (5%) 4
AVAV AEROVIRONMENT INC 1.1% $79.01 $74.7 $74.7 $67.9 7.4  (-6%) 5
CUB CUBIC CORP 1.0% $71.15 $68.8 $68.8 $68.1 13.7  (-4%) 3
AIR AAR CORP 1.0% $46.62 $46.5 $46.5 $46.8 4.1  (-13%) 1
RGR STURM RUGER INC 0.9% $57.40 $55.8 $55.8 $57.8 19.6  (-3%) 0
TGI TRIUMPH GROUP INC 0.9% $23.75 $19.9 $19.9 $20.2 12.6  (-1%) 3
MRCY MERCURY SYSTEMS INC 0.9% $49.02 $43.5 $43.5 $40.2 12.3  (1%) 4
KTOS KRATOS DEFENSE AND SECURITY SOLUTI 0.8% $13.06 $12.9 $12.9 $12.1 14.1  (-8%) 5
ATRO ASTRONICS CORP 0.7% $44.59 $40.2 $40.2 $38.2 17.2  (-5%) 5
AOBC AMERICAN OUTDOOR BRANDS CORP 0.7% $9.58 $10.0 $10.0 $11.5 3.1  (-6%) -1
WAIR WESCO AIRCRAFT HOLDINGS INC 0.7% $13.95 $12.2 $12.2 $11.8 14.3  (-7%) 5
EGL ENGILITY HOLDINGS INC 0.6% $33.61 $34.5 $34.5 $32.3 2.7  (-5%) 3