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

XLI Conmponent Weighting

Ticker
Symbol
Company Name ETF Weight Close Price 10-Day 20-Day 50-Day Short Int Ratio Technical Score
BA Boeing Company 8.1% $362.42 $360.5 $360.5 $345.7 1.5  (-3%) 4
GE General Electric Company 5.6% $13.64 $14.2 $14.2 $14.1 3.1  (-5%) -1
MMM 3M Company 5.3% $203.63 $201.2 $201.2 $204.7 2.3  (21%) -1
HON Honeywell International Inc. 4.9% $151.20 $150.4 $150.4 $147.8 2.8  (1%) 1
UNP Union Pacific Corporation 4.7% $144.94 $144.3 $144.3 $138.9 3.6  (17%) 4
UTX United Technologies Corporation 4.0% $126.94 $126.7 $126.7 $124.3 3.9  (-3%) 1
CAT Caterpillar Inc. 3.9% $153.14 $155.3 $155.3 $151.6 2.0  (-4%) 1
UPS United Parcel Service Inc. Class B 3.5% $117.19 $116.4 $116.4 $112.8 4.3  (0%) 3
LMT Lockheed Martin Corporation 3.4% $310.59 $319.3 $319.3 $326.3 1.4  (8%) -1
FDX FedEx Corporation 2.7% $263.48 $254.7 $254.7 $248.9 3.3  (7%) 4
RTN Raytheon Company 2.6% $202.68 $210.8 $210.8 $212.8 2.3  (22%) -0
GD General Dynamics Corporation 2.4% $195.82 $202.7 $202.7 $207.1 1.8  (-5%) -1
NOC Northrop Grumman Corporation 2.4% $322.56 $330.3 $330.3 $333.5 1.2  (24%) -1
CSX CSX Corporation 2.4% $65.89 $65.0 $65.0 $61.5 3.1  (-14%) 4
ITW Illinois Tool Works Inc. 2.0% $148.89 $147.2 $147.2 $148.9 2.6  (11%) 0
DE Deere & Company 2.0% $150.18 $155.0 $155.0 $148.3 3.3  (11%) 1
EMR Emerson Electric Co. 1.9% $72.90 $72.6 $72.6 $70.5 2.1  (-1%) 2
NSC Norfolk Southern Corporation 1.8% $153.47 $153.0 $153.0 $145.7 4.3  (12%) 3
DAL Delta Air Lines Inc. 1.5% $54.90 $54.2 $54.2 $53.5 2.1  (-7%) 0
JCI Johnson Controls International plc 1.5% $34.89 $34.8 $34.8 $34.9 6.2  (22%) -1
WM Waste Management Inc. 1.5% $83.57 $83.0 $83.0 $83.0 2.8  (11%) 2
ETN Eaton Corp. Plc 1.4% $79.28 $78.9 $78.9 $77.4 3.4  (17%) 1
LUV Southwest Airlines Co. 1.3% $51.94 $51.3 $51.3 $52.7 1.9  (-12%) -2
ROP Roper Technologies Inc. 1.2% $283.21 $280.8 $280.8 $275.7 4.8  (-2%) 2
CMI Cummins Inc. 1.0% $141.89 $145.1 $145.1 $151.8 1.5  (-5%) -1
PH Parker-Hannifin Corporation 1.0% $171.91 $175.2 $175.2 $172.8 2.8  (42%) -1
FTV Fortive Corp. 1.0% $80.13 $76.3 $76.3 $75.3 2.8  (19%) 2
PCAR PACCAR Inc 1.0% $63.76 $64.5 $64.5 $65.3 3.9  (-1%) -2
COL Rockwell Collins Inc. 1.0% $137.88 $137.9 $137.9 $135.4 2.3  (-41%) 1
SWK Stanley Black & Decker Inc. 1.0% $142.29 $144.1 $144.1 $145.4 2.8  (-12%) -1
IR Ingersoll-Rand Plc 1.0% $91.91 $90.2 $90.2 $87.5 2.5  (31%) 3
ROK Rockwell Automation Inc. 1.0% $178.94 $179.0 $179.0 $175.0 2.8  (17%) 1
INFO IHS Markit Ltd. 0.8% $50.76 $50.6 $50.6 $50.0 4.2  (-2%) 2
AAL American Airlines Group Inc. 0.8% $43.08 $43.7 $43.7 $44.6 4.3  (3%) -1
HRS Harris Corporation 0.8% $149.95 $152.8 $152.8 $156.5 2.1  (-4%) -1
UAL United Continental Holdings Inc. 0.7% $73.02 $70.4 $70.4 $68.9 4.9  (-6%) 4
TXT Textron Inc. 0.7% $67.49 $67.4 $67.4 $64.4 3.7  (5%) 4
AME AMETEK Inc. 0.7% $74.84 $75.2 $75.2 $74.3 1.1  (14%) -1
VRSK Verisk Analytics Inc 0.7% $109.97 $107.5 $107.5 $106.3 3.0  (-4%) 3
TDG TransDigm Group Incorporated 0.7% $344.17 $336.5 $336.5 $327.1 10.2  (-9%) 5
CTAS Cintas Corporation 0.7% $191.56 $185.9 $185.9 $178.8 9.1  (2%) 5
RSG Republic Services Inc. 0.7% $69.23 $67.9 $67.9 $67.1 3.3  (-1%) 3
LLL L3 Technologies Inc 0.7% $197.76 $198.8 $198.8 $200.3 1.9  (5%) 0
GWW W.W. Grainger Inc. 0.6% $317.39 $311.1 $311.1 $297.0 8.3  (-3%) 5
FAST Fastenal Company 0.6% $52.79 $53.0 $53.0 $52.0 10.5  (-3%) 3
DOV Dover Corporation 0.6% $76.06 $78.6 $78.6 $85.7 1.4  (13%) -1
EFX Equifax Inc. 0.6% $125.34 $118.8 $118.8 $117.0 2.3  (-15%) 3
URI United Rentals Inc. 0.6% $164.46 $165.8 $165.8 $165.3 2.8  (15%) 0
XYL Xylem Inc. 0.6% $71.73 $71.8 $71.8 $73.4 3.3  (19%) -1
MAS Masco Corporation 0.5% $38.42 $38.0 $38.0 $38.6 2.2  (14%) -1
CHRW C.H. Robinson Worldwide Inc. 0.5% $90.43 $88.5 $88.5 $89.4 6.1  (-13%) 3
EXPD Expeditors International of Washington Inc. 0.5% $76.77 $75.0 $75.0 $69.3 4.2  (-18%) 4
KSU Kansas City Southern 0.5% $108.66 $109.0 $109.0 $109.1 2.4  (-1%) -0
HII Huntington Ingalls Industries Inc. 0.5% $219.95 $222.8 $222.8 $234.4 2.3  (-18%) -1
NLSN Nielsen Holdings Plc 0.5% $31.53 $30.7 $30.7 $31.4 5.1  (1%) 1
JBHT J.B. Hunt Transport Services Inc. 0.5% $129.65 $127.9 $127.9 $121.8 5.4  (-16%) 5
AOS A. O. Smith Corporation 0.4% $63.97 $63.9 $63.9 $63.6 3.6  (-5%) -1
FBHS Fortune Brands Home & Security Inc. 0.4% $56.80 $57.3 $57.3 $57.1 3.1  (14%) 0
SNA Snap-on Incorporated 0.4% $159.48 $153.6 $153.6 $149.6 15.6  (3%) 4
FLR Fluor Corporation 0.4% $48.89 $49.4 $49.4 $52.8 1.2  (26%) -1
ALK Alaska Air Group Inc. 0.4% $62.50 $60.7 $60.7 $62.0 2.7  (-17%) 0
RHI Robert Half International Inc. 0.3% $69.93 $65.9 $65.9 $62.7 4.4  (21%) 4
PNR Pentair plc 0.3% $43.78 $44.7 $44.7 $53.6 0.8  (14%) -1
ARNC Arconic Inc. 0.3% $18.00 $18.1 $18.1 $19.6 1.6  (1%) -2
ALLE Allegion PLC 0.3% $81.79 $79.3 $79.3 $80.2 5.0  (17%) 1
JEC Jacobs Engineering Group Inc. 0.3% $65.35 $64.9 $64.9 $61.9 1.9  (-1%) 3
FLS Flowserve Corporation 0.3% $41.54 $42.5 $42.5 $44.2 6.5  (-0%) 1
SRCL Stericycle Inc. 0.2% $64.21 $63.8 $63.8 $62.0 5.5  (-9%) 3
PWR Quanta Services Inc. 0.2% $35.92 $36.4 $36.4 $35.2 2.1  (52%) 2
AYI Acuity Brands Inc. 0.2% $120.77 $120.0 $120.0 $121.6 4.4  (-18%) 0