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% $362.42 $360.5 $360.5 $345.7 1.5  (-3%) 4
UTX UNITED TECHNOLOGIES CORP 7.6% $126.94 $126.7 $126.7 $124.3 3.9  (-3%) 1
LMT LOCKHEED MARTIN CORP 7.0% $310.59 $319.3 $319.3 $326.3 1.4  (8%) -1
RTN RAYTHEON 6.3% $202.68 $210.8 $210.8 $212.8 2.3  (22%) -0
NOC NORTHROP GRUMMAN CORP 5.8% $322.56 $330.3 $330.3 $333.5 1.2  (24%) -1
GD GENERAL DYNAMICS CORP 5.8% $195.82 $202.7 $202.7 $207.1 1.8  (-5%) -1
COL ROCKWELL COLLINS INC 3.9% $137.88 $137.9 $137.9 $135.4 2.3  (-41%) 1
TXT TEXTRON INC 3.6% $67.49 $67.4 $67.4 $64.4 3.7  (5%) 4
TDG TRANSDIGM GROUP INC 3.6% $344.17 $336.5 $336.5 $327.1 10.2  (-9%) 5
HRS HARRIS CORP 3.5% $149.95 $152.8 $152.8 $156.5 2.1  (-4%) -1
LLL L3 TECHNOLOGIES INC 3.1% $197.76 $198.8 $198.8 $200.3 1.9  (5%) 0
HII HUNTINGTON INGALLS INDUSTRIES INC 2.6% $219.95 $222.8 $222.8 $234.4 2.3  (-18%) -1
SPR SPIRIT AEROSYSTEMS INC CLASS A 2.6% $88.28 $87.2 $87.2 $83.8 3.4  (11%) 3
BWXT BWX TECHNOLOGIES INC 2.3% $65.91 $67.4 $67.4 $67.4 1.7  (-36%) 0
TDY TELEDYNE TECHNOLOGIES INC 2.2% $206.75 $204.1 $204.1 $197.2 1.4  (-6%) 4
HXL HEXCEL CORP 2.1% $71.10 $71.5 $71.5 $68.6 8.0  (5%) 4
CW CURTISS WRIGHT CORP 2.0% $129.32 $130.3 $130.3 $132.3 3.0  (29%) -1
ARNC ARCONIC INC 2.0% $18.00 $18.1 $18.1 $19.6 1.6  (1%) -2
KLXI KLX INC 1.7% $71.92 $73.1 $73.1 $72.9 0.8  (-30%) 1
HEI HEICO CORP 1.5% $92.56 $93.0 $93.0 $90.9 8.1  (-11%) 5
ROLL RBC BEARINGS INC 1.4% $129.83 $126.6 $126.6 $123.1 3.9  (-2%) 2
AAXN AXON ENTERPRISE INC 1.4% $63.67 $63.3 $63.3 $52.5 5.2  (-13%) 5
AJRD AEROJET ROCKETDYNE HOLDINGS INC 1.2% $29.83 $29.4 $29.4 $28.8 8.4  (-1%) 4
ESL ESTERLINE TECHNOLOGIES CORP 1.2% $73.40 $74.8 $74.8 $74.1 3.7  (19%) 1
AVAV AEROVIRONMENT INC 1.1% $59.25 $58.5 $58.5 $56.2 8.7  (-4%) 5
CUB CUBIC CORP 1.0% $67.70 $70.0 $70.0 $67.1 5.7  (0%) 3
AIR AAR CORP 1.0% $47.95 $46.3 $46.3 $45.4 7.0  (2%) 5
RGR STURM RUGER INC 0.9% $60.25 $61.0 $61.0 $58.4 10.1  (-12%) 3
TGI TRIUMPH GROUP INC 0.9% $21.15 $22.3 $22.3 $23.8 10.9  (-5%) -1
MRCY MERCURY SYSTEMS INC 0.9% $36.65 $36.9 $36.9 $38.5 4.7  (-2%) 0
KTOS KRATOS DEFENSE AND SECURITY SOLUTI 0.8% $11.51 $11.3 $11.3 $11.0 8.2  (-12%) 4
ATRO ASTRONICS CORP 0.7% $38.36 $36.2 $36.2 $36.4 5.2  (18%) 1
AOBC AMERICAN OUTDOOR BRANDS CORP 0.7% $12.60 $12.3 $12.3 $11.5 5.8  (-18%) 5
WAIR WESCO AIRCRAFT HOLDINGS INC 0.7% $11.50 $11.5 $11.5 $10.8 5.8  (1%) 5
EGL ENGILITY HOLDINGS INC 0.6% $29.07 $30.9 $30.9 $28.4 3.2  (2%) 2