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% $54.31 $56.6 $56.6 $56.6 2.3  (-14%) -0
WRB W. R. Berkley Corporation 2.3% $76.18 $75.0 $75.0 $74.9 10.5  (0%) 4
AHL Aspen Insurance Holdings Limited 2.3% $37.00 $39.4 $39.4 $41.0 4.4  (-9%) -1
AGO Assured Guaranty Ltd. 2.3% $41.41 $37.9 $37.9 $37.1 8.6  (-4%) 4
BRO Brown & Brown Inc. 2.3% $29.72 $29.3 $29.3 $28.6 3.3  (9%) 3
XL XL Group Ltd 2.3% $56.42 $56.3 $56.3 $56.2 5.0  (-2%) 1
L Loews Corporation 2.3% $50.33 $50.2 $50.2 $49.6 5.2  (-2%) 1
MKL Markel Corporation 2.2% $1,183.01 $1,156.9 $1,156.9 $1,125.2 6.7  (-2%) 4
AIZ Assurant Inc. 2.2% $105.95 $108.0 $108.0 $103.2 3.7  (-1%) 3
AFL Aflac Incorporated 2.2% $46.76 $44.7 $44.7 $44.6 3.7  (-8%) 2
ALL Allstate Corporation 2.2% $99.48 $95.3 $95.3 $93.8 2.7  (-1%) 2
PGR Progressive Corporation 2.2% $62.54 $60.2 $60.2 $60.7 2.0  (2%) 2
TMK Torchmark Corporation 2.2% $87.53 $85.7 $85.7 $84.7 4.6  (-2%) 2
AIG American International Group Inc. 2.2% $52.00 $54.0 $54.0 $54.1 4.2  (-12%) -1
FNF Fidelity National Financial Inc. - FNF Group 2.2% $39.87 $39.6 $39.6 $38.4 4.9  (-3%) 3
AFG American Financial Group Inc. 2.2% $111.64 $111.1 $111.1 $109.8 3.7  (57%) 1
AON Aon plc 2.2% $142.98 $144.9 $144.9 $141.7 2.4  (8%) 2
RNR RenaissanceRe Holdings Ltd. 2.2% $127.90 $127.2 $127.2 $124.8 2.4  (-17%) 2
AJG Arthur J. Gallagher & Co. 2.2% $71.36 $70.7 $70.7 $68.1 2.0  (5%) 2
RGA Reinsurance Group of America Incorporated 2.1% $141.49 $139.7 $139.7 $141.2 3.4  (4%) 2
MET MetLife Inc. 2.1% $46.12 $45.1 $45.1 $45.4 2.8  (-11%) 1
ORI Old Republic International Corporation 2.1% $21.60 $20.9 $20.9 $20.7 2.7  (26%) 2
HIG Hartford Financial Services Group Inc. 2.1% $52.20 $52.7 $52.7 $52.5 1.3  (-25%) 0
MMC Marsh & McLennan Companies Inc. 2.1% $84.02 $85.4 $85.4 $83.5 3.4  (-6%) 2
ATH Athene Holding Ltd. Class A 2.1% $49.31 $46.0 $46.0 $45.5 3.2  (-15%) 2
CB Chubb Limited 2.1% $137.08 $135.9 $135.9 $132.1 3.3  (30%) 2
PRU Prudential Financial Inc. 2.1% $99.94 $98.1 $98.1 $97.5 1.8  (-12%) 1
CINF Cincinnati Financial Corporation 2.1% $75.00 $72.7 $72.7 $70.5 4.0  (15%) 3
CNO CNO Financial Group Inc. 2.1% $21.53 $20.5 $20.5 $20.0 2.9  (-1%) 3
Y Alleghany Corporation 2.1% $627.81 $619.2 $619.2 $597.8 4.8  (-2%) 4
PFG Principal Financial Group Inc. 2.1% $55.64 $55.4 $55.4 $55.3 2.0  (-21%) 2
TRV Travelers Companies Inc. 2.1% $129.56 $128.1 $128.1 $127.1 2.1  (28%) 2
ACGL Arch Capital Group Ltd. 2.0% $30.34 $29.5 $29.5 $45.3 4.7  (11%) 1
BHF Brighthouse Financial Inc. 2.0% $42.64 $42.3 $42.3 $43.5 6.3  (-11%) 1
WLTW Willis Towers Watson Public Limited Company 2.0% $151.61 $156.6 $156.6 $155.2 3.0  (-13%) -1
RE Everest Re Group Ltd. 2.0% $215.21 $225.5 $225.5 $227.6 2.7  (8%) -1
FAF First American Financial Corporation 2.0% $56.91 $54.9 $54.9 $52.9 3.8  (-5%) 3
LNC Lincoln National Corporation 2.0% $66.69 $66.0 $66.0 $65.9 2.5  (-2%) 2
PRI Primerica Inc. 1.8% $117.75 $111.5 $111.5 $105.3 5.2  (4%) 5
UNM Unum Group 1.8% $36.02 $37.6 $37.6 $38.1 3.3  (18%) -1
THG Hanover Insurance Group Inc. 1.7% $124.56 $124.5 $124.5 $122.1 3.8  (-17%) 2
AEL American Equity Investment Life Holding Company 1.7% $36.01 $35.6 $35.6 $35.8 4.6  (-24%) 1
WTM White Mountains Insurance Group Ltd 1.6% $941.20 $918.1 $918.1 $912.1 4.2  (33%) 4
KMPR Kemper Corporation 1.4% $76.85 $76.0 $76.0 $76.3 4.1  (3%) 3
GNW Genworth Financial Inc. Class A 1.1% $4.44 $4.6 $4.6 $4.4 2.8  (-13%) 2
MCY Mercury General Corporation 1.1% $52.73 $47.5 $47.5 $46.9 10.7  (17%) 5
PRA ProAssurance Corporation 1.0% $44.60 $40.2 $40.2 $38.4 5.5  (19%) 4
RLI RLI Corp. 0.9% $75.17 $72.8 $72.8 $69.7 13.7  (1%) 5
SIGI Selective Insurance Group Inc. 0.8% $61.65 $59.3 $59.3 $58.1 3.6  (-4%) 3