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% $343.72 $352.9 $352.9 $350.5 1.6  (6%) 0
GE General Electric Company 5.6% $12.94 $13.3 $13.3 $13.5 1.7  (2%) -2
MMM 3M Company 5.3% $204.78 $204.0 $204.0 $201.5 2.5  (-5%) 2
HON Honeywell International Inc. 4.9% $153.96 $153.5 $153.5 $150.0 1.9  (16%) 2
UNP Union Pacific Corporation 4.7% $148.76 $145.2 $145.2 $144.1 4.6  (-9%) 3
UTX United Technologies Corporation 4.0% $134.24 $132.5 $132.5 $128.6 3.9  (23%) 4
CAT Caterpillar Inc. 3.9% $138.52 $139.5 $139.5 $143.0 1.1  (-12%) -1
UPS United Parcel Service Inc. Class B 3.5% $120.87 $115.8 $115.8 $113.9 3.4  (7%) 4
LMT Lockheed Martin Corporation 3.4% $315.71 $319.8 $319.8 $312.7 1.3  (-8%) 1
FDX FedEx Corporation 2.7% $244.80 $239.0 $239.0 $243.3 2.3  (-16%) 1
RTN Raytheon Company 2.6% $196.10 $197.6 $197.6 $199.9 2.0  (-6%) -1
GD General Dynamics Corporation 2.4% $192.57 $195.3 $195.3 $194.8 1.9  (1%) -1
NOC Northrop Grumman Corporation 2.4% $291.43 $307.6 $307.6 $314.8 1.1  (18%) -1
CSX CSX Corporation 2.4% $72.17 $69.5 $69.5 $66.9 2.2  (61%) 4
ITW Illinois Tool Works Inc. 2.0% $138.51 $140.9 $140.9 $142.7 1.4  (-2%) -2
DE Deere & Company 2.0% $139.83 $140.5 $140.5 $144.5 1.8  (-18%) -1
EMR Emerson Electric Co. 1.9% $74.05 $70.8 $70.8 $70.9 2.3  (-11%) 2
NSC Norfolk Southern Corporation 1.8% $171.69 $165.3 $165.3 $158.0 2.9  (6%) 4
DAL Delta Air Lines Inc. 1.5% $55.34 $53.0 $53.0 $52.8 2.5  (-9%) 2
JCI Johnson Controls International plc 1.5% $37.33 $36.3 $36.3 $35.1 6.6  (11%) 4
WM Waste Management Inc. 1.5% $90.14 $86.6 $86.6 $84.3 2.5  (-11%) 4
ETN Eaton Corp. Plc 1.4% $81.71 $79.5 $79.5 $78.3 3.8  (-6%) 4
LUV Southwest Airlines Co. 1.3% $58.99 $55.4 $55.4 $53.1 1.9  (5%) 3
ROP Roper Technologies Inc. 1.2% $295.47 $290.5 $290.5 $283.5 2.6  (-1%) 4
CMI Cummins Inc. 1.0% $142.02 $138.2 $138.2 $138.3 1.7  (-13%) 2
PH Parker-Hannifin Corporation 1.0% $170.99 $165.3 $165.3 $165.1 1.6  (-14%) 2
FTV Fortive Corp. 1.0% $80.24 $79.0 $79.0 $77.8 4.1  (20%) 3
PCAR PACCAR Inc 1.0% $64.31 $63.9 $63.9 $63.3 3.1  (-8%) 1
COL Rockwell Collins Inc. 1.0% $136.89 $137.4 $137.4 $136.8 5.7  (-9%) 2
SWK Stanley Black & Decker Inc. 1.0% $141.85 $141.3 $141.3 $139.5 1.7  (73%) 2
IR Ingersoll-Rand Plc 1.0% $96.51 $94.3 $94.3 $91.9 1.4  (21%) 4
ROK Rockwell Automation Inc. 1.0% $175.91 $176.0 $176.0 $174.0 2.8  (10%) 1
INFO IHS Markit Ltd. 0.8% $54.19 $53.3 $53.3 $52.0 5.1  (-5%) 3
AAL American Airlines Group Inc. 0.8% $37.92 $38.1 $38.1 $40.0 4.3  (-10%) 0
HRS Harris Corporation 0.8% $164.57 $155.3 $155.3 $151.1 2.6  (4%) 2
UAL United Continental Holdings Inc. 0.7% $82.75 $79.2 $79.2 $74.4 2.5  (6%) 4
TXT Textron Inc. 0.7% $66.21 $67.0 $67.0 $67.0 2.5  (17%) 0
AME AMETEK Inc. 0.7% $76.66 $75.2 $75.2 $74.3 2.7  (12%) 2
VRSK Verisk Analytics Inc 0.7% $116.70 $113.5 $113.5 $110.6 5.2  (-5%) 5
TDG TransDigm Group Incorporated 0.7% $359.38 $364.0 $364.0 $350.7 11.4  (-10%) 4
CTAS Cintas Corporation 0.7% $211.40 $203.5 $203.5 $194.8 5.1  (-0%) 5
RSG Republic Services Inc. 0.7% $73.18 $70.9 $70.9 $69.6 4.1  (21%) 4
LLL L3 Technologies Inc 0.7% $210.93 $206.7 $206.7 $200.7 3.1  (-4%) 3
GWW W.W. Grainger Inc. 0.6% $351.66 $335.4 $335.4 $320.2 4.0  (-15%) 4
FAST Fastenal Company 0.6% $57.51 $56.6 $56.6 $53.4 8.3  (0%) 5
DOV Dover Corporation 0.6% $82.42 $79.4 $79.4 $77.1 2.6  (43%) 3
EFX Equifax Inc. 0.6% $128.40 $126.6 $126.6 $125.1 2.8  (-16%) 2
URI United Rentals Inc. 0.6% $150.76 $150.6 $150.6 $154.6 2.0  (-7%) -1
XYL Xylem Inc. 0.6% $76.69 $71.3 $71.3 $70.1 3.9  (-2%) 3
MAS Masco Corporation 0.5% $39.12 $38.9 $38.9 $38.4 2.2  (9%) 2
CHRW C.H. Robinson Worldwide Inc. 0.5% $94.75 $91.6 $91.6 $89.1 7.1  (1%) 4
EXPD Expeditors International of Washington Inc. 0.5% $73.25 $74.3 $74.3 $74.5 6.9  (5%) 2
KSU Kansas City Southern 0.5% $115.68 $112.0 $112.0 $109.3 2.0  (-8%) 4
HII Huntington Ingalls Industries Inc. 0.5% $236.65 $230.1 $230.1 $223.7 5.1  (-5%) 4
NLSN Nielsen Holdings Plc 0.5% $22.15 $26.4 $26.4 $29.1 3.6  (20%) -2
JBHT J.B. Hunt Transport Services Inc. 0.5% $121.71 $120.7 $120.7 $124.0 1.9  (-13%) -1
AOS A. O. Smith Corporation 0.4% $58.13 $59.2 $59.2 $60.7 3.1  (9%) -2
FBHS Fortune Brands Home & Security Inc. 0.4% $55.96 $56.1 $56.1 $55.9 1.5  (-17%) 1
SNA Snap-on Incorporated 0.4% $171.55 $167.6 $167.6 $162.3 6.4  (1%) 5
FLR Fluor Corporation 0.4% $56.14 $51.3 $51.3 $50.0 4.8  (13%) 3
ALK Alaska Air Group Inc. 0.4% $63.75 $62.2 $62.2 $62.0 3.4  (7%) 2
RHI Robert Half International Inc. 0.3% $79.48 $73.1 $73.1 $69.6 4.7  (2%) 4
PNR Pentair plc 0.3% $43.68 $43.5 $43.5 $43.4 2.4  (31%) 1
ARNC Arconic Inc. 0.3% $20.77 $20.0 $20.0 $18.5 2.4  (1%) 3
ALLE Allegion PLC 0.3% $82.56 $80.6 $80.6 $79.6 6.2  (-2%) 3
JEC Jacobs Engineering Group Inc. 0.3% $72.56 $67.8 $67.8 $66.2 4.1  (-12%) 4
FLS Flowserve Corporation 0.3% $48.87 $43.4 $43.4 $42.0 10.9  (-8%) 3
SRCL Stericycle Inc. 0.2% $61.58 $67.2 $67.2 $65.6 6.0  (14%) 1
PWR Quanta Services Inc. 0.2% $34.70 $33.9 $33.9 $34.6 2.9  (-16%) 1
AYI Acuity Brands Inc. 0.2% $135.17 $133.8 $133.8 $126.7 11.0  (-2%) 4