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

KIE Conmponent Weighting

Ticker
Symbol
Company Name ETF Weight Close Price 10-Day 20-Day 50-Day Short Int Ratio Technical Score
AXS Axis Capital Holdings Limited 2.4% $56.65 $57.5 $57.5 $57.4 2.5  (-16%) 0
WRB W. R. Berkley Corporation 2.3% $75.28 $77.0 $77.0 $75.5 11.3  (-3%) 3
AHL Aspen Insurance Holdings Limited 2.3% $42.45 $43.2 $43.2 $43.4 2.9  (-9%) -0
AGO Assured Guaranty Ltd. 2.3% $37.42 $36.4 $36.4 $36.4 6.1  (-13%) 4
BRO Brown & Brown Inc. 2.3% $28.33 $28.0 $28.0 $27.2 4.0  (-8%) 3
VR Validus Holdings Ltd. 2.3% $67.90 $67.7 $67.7 $67.6 2.3  (-0%) 2
XL XL Group Ltd 2.3% $56.20 $55.9 $55.9 $55.6 2.4  (12%) 2
L Loews Corporation 2.3% $49.61 $50.0 $50.0 $50.6 3.9  (-6%) -1
MKL Markel Corporation 2.2% $1,099.90 $1,118.3 $1,118.3 $1,134.3 5.0  (-6%) 0
AIZ Assurant Inc. 2.2% $95.76 $95.8 $95.8 $92.7 2.1  (-5%) 3
AFL Aflac Incorporated 2.2% $45.68 $45.5 $45.5 $45.1 4.0  (-3%) 1
ALL Allstate Corporation 2.2% $92.80 $94.2 $94.2 $95.6 3.8  (46%) -1
PGR Progressive Corporation 2.2% $61.89 $62.2 $62.2 $61.4 3.1  (23%) 2
TMK Torchmark Corporation 2.2% $84.20 $85.4 $85.4 $85.3 5.9  (-18%) 1
AIG American International Group Inc. 2.2% $54.80 $54.1 $54.1 $54.1 2.2  (24%) -1
FNF Fidelity National Financial Inc. - FNF Group 2.2% $38.21 $37.9 $37.9 $38.0 6.1  (6%) 1
AFG American Financial Group Inc. 2.2% $109.77 $110.7 $110.7 $111.3 2.7  (29%) -1
AON Aon plc 2.2% $140.21 $141.4 $141.4 $141.6 2.9  (-9%) 0
RNR RenaissanceRe Holdings Ltd. 2.2% $123.95 $125.1 $125.1 $130.2 2.6  (-19%) -1
AJG Arthur J. Gallagher & Co. 2.2% $65.98 $67.0 $67.0 $68.1 1.7  (-4%) -2
RGA Reinsurance Group of America Incorporated 2.1% $143.49 $149.7 $149.7 $151.3 3.6  (5%) -1
MET MetLife Inc. 2.1% $46.77 $47.2 $47.2 $47.0 1.9  (-5%) -1
ORI Old Republic International Corporation 2.1% $20.99 $21.1 $21.1 $21.0 3.9  (-23%) 0
HIG Hartford Financial Services Group Inc. 2.1% $53.08 $52.9 $52.9 $52.6 2.1  (20%) 1
MMC Marsh & McLennan Companies Inc. 2.1% $81.94 $81.4 $81.4 $81.6 4.3  (25%) -1
ATH Athene Holding Ltd. Class A 2.1% $46.59 $46.1 $46.1 $47.2 2.0  (27%) -2
CB Chubb Limited 2.1% $130.10 $132.5 $132.5 $134.1 2.7  (9%) -2
PRU Prudential Financial Inc. 2.1% $98.75 $99.7 $99.7 $102.0 1.5  (-15%) -2
CINF Cincinnati Financial Corporation 2.1% $68.92 $70.3 $70.3 $71.6 5.0  (-3%) -1
CNO CNO Financial Group Inc. 2.1% $19.98 $20.1 $20.1 $20.9 2.8  (24%) -2
Y Alleghany Corporation 2.1% $581.61 $580.1 $580.1 $583.5 2.1  (59%) -1
PFG Principal Financial Group Inc. 2.1% $56.26 $57.4 $57.4 $58.7 2.6  (-9%) -1
TRV Travelers Companies Inc. 2.1% $128.86 $130.0 $130.0 $132.1 2.4  (-9%) -1
ACGL Arch Capital Group Ltd. 2.0% $81.13 $80.4 $80.4 $80.6 2.7  (3%) 2
BHF Brighthouse Financial Inc. 2.0% $45.26 $47.1 $47.1 $49.0 6.0  (16%) -1
WLTW Willis Towers Watson Public Limited Company 2.0% $156.04 $154.9 $154.9 $152.2 1.9  (10%) 1
RE Everest Re Group Ltd. 2.0% $226.00 $227.3 $227.3 $234.8 2.9  (18%) -1
FAF First American Financial Corporation 2.0% $51.90 $53.0 $53.0 $53.6 4.3  (29%) -1
LNC Lincoln National Corporation 2.0% $68.05 $68.5 $68.5 $69.1 2.0  (48%) -1
PRI Primerica Inc. 1.8% $101.10 $99.6 $99.6 $97.3 4.4  (-14%) 2
UNM Unum Group 1.8% $38.83 $38.8 $38.8 $42.2 1.7  (26%) -1
THG Hanover Insurance Group Inc. 1.7% $120.20 $120.5 $120.5 $119.0 3.3  (-14%) 3
AEL American Equity Investment Life Holding Company 1.7% $35.95 $34.6 $34.6 $31.6 4.1  (6%) 3
WTM White Mountains Insurance Group Ltd 1.6% $910.00 $902.1 $902.1 $877.5 0.9  (64%) 4
KMPR Kemper Corporation 1.4% $77.25 $78.3 $78.3 $69.8 8.1  (4%) 5
GNW Genworth Financial Inc. Class A 1.1% $4.71 $3.8 $3.8 $3.3 2.9  (-41%) 4
MCY Mercury General Corporation 1.1% $47.36 $47.8 $47.8 $47.3 8.4  (15%) 3
PRA ProAssurance Corporation 1.0% $37.85 $39.2 $39.2 $42.6 1.3  (-10%) -1
RLI RLI Corp. 0.9% $68.99 $67.6 $67.6 $65.6 17.0  (-5%) 5
SIGI Selective Insurance Group Inc. 0.8% $57.80 $57.4 $57.4 $58.1 1.3  (-41%) 1