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

KRE Conmponent Weighting

Ticker
Symbol
Company Name ETF Weight Close Price 10-Day 20-Day 50-Day Short Int Ratio Technical Score
SIVB SVB Financial Group 2.2% $316.49 $319.8 $319.8 $294.3 1.9  (-4%) 2
TCBI Texas Capital Bancshares Inc. 2.1% $100.05 $99.5 $99.5 $97.7 7.3  (-1%) 4
CFR Cullen/Frost Bankers Inc. 2.0% $113.58 $116.7 $116.7 $113.6 3.9  (-30%) 3
EWBC East West Bancorp Inc. 2.0% $70.18 $71.1 $71.1 $67.8 3.2  (11%) 3
ZION Zions Bancorporation 1.9% $55.45 $56.7 $56.7 $55.5 11.9  (3%) 2
STL Sterling Bancorp 1.9% $24.60 $24.8 $24.8 $23.9 10.2  (17%) 2
PACW PacWest Bancorp 1.9% $54.25 $54.4 $54.4 $52.5 5.6  (-5%) 4
FITB Fifth Third Bancorp 1.9% $30.84 $31.4 $31.4 $32.2 2.6  (1%) -1
FRC First Republic Bank 1.9% $100.06 $100.5 $100.5 $96.3 13.0  (2%) 4
CIT CIT Group Inc. 1.9% $51.34 $52.3 $52.3 $52.6 3.8  (-5%) -2
BBT BB&T Corporation 1.9% $52.44 $54.1 $54.1 $53.5 3.0  (-15%) -1
SNV Synovus Financial Corp. 1.9% $55.73 $55.2 $55.2 $53.1 3.8  (-7%) 4
CMA Comerica Incorporated 1.8% $95.18 $96.8 $96.8 $96.3 3.6  (4%) -1
RF Regions Financial Corporation 1.8% $18.62 $18.9 $18.9 $18.8 1.8  (-1%) -1
STI SunTrust Banks Inc. 1.8% $68.89 $69.1 $69.1 $68.2 4.7  (-1%) 1
MTB M&T Bank Corporation 1.8% $174.71 $177.4 $177.4 $180.6 2.9  (25%) -1
PBCT People's United Financial Inc. 1.8% $18.79 $18.8 $18.8 $18.6 6.6  (-11%) 2
FHN First Horizon National Corporation 1.8% $19.10 $19.0 $19.0 $18.9 2.9  (-25%) 1
KEY KeyCorp 1.8% $20.53 $20.2 $20.2 $20.0 1.5  (-20%) 1
OZRK Bank of The Ozarks 1.8% $48.72 $48.6 $48.6 $47.9 16.6  (-5%) 2
HBAN Huntington Bancshares Incorporated 1.8% $15.42 $15.3 $15.3 $15.0 1.4  (-12%) 2
CFG Citizens Financial Group Inc. 1.8% $41.40 $41.6 $41.6 $41.8 2.2  (3%) -3
PNC PNC Financial Services Group Inc. 1.8% $141.84 $146.9 $146.9 $147.2 2.8  (-2%) -1
BPOP Popular Inc. 1.7% $46.51 $46.7 $46.7 $45.8 4.4  (-16%) 2
WAL Western Alliance Bancorporation 1.7% $61.88 $61.8 $61.8 $60.1 3.6  (7%) 2
UMPQ Umpqua Holdings Corporation 1.7% $23.95 $24.0 $24.0 $23.4 2.7  (-25%) 3
BKU BankUnited Inc. 1.7% $43.77 $43.0 $43.0 $41.3 3.2  (3%) 4
SBNY Signature Bank 1.6% $126.06 $129.2 $129.2 $131.2 3.7  (4%) -2
WBS Webster Financial Corporation 1.6% $66.04 $65.6 $65.6 $61.9 14.5  (3%) 5
FNB F.N.B. Corporation 1.4% $13.79 $13.7 $13.7 $13.4 6.5  (-5%) 2
TCF TCF Financial Corporation 1.4% $26.36 $26.5 $26.5 $25.1 3.0  (-22%) 3
PB Prosperity Bancshares Inc.(R) 1.4% $72.02 $74.1 $74.1 $73.6 8.9  (-9%) 1
IBKC IBERIABANK Corporation 1.4% $80.55 $81.1 $81.1 $78.8 2.4  (43%) 1
ISBC Investors Bancorp Inc 1.4% $13.38 $13.5 $13.5 $13.5 4.7  (0%) -1
WTFC Wintrust Financial Corporation 1.4% $94.34 $94.8 $94.8 $92.2 2.8  (-15%) 3
CBSH Commerce Bancshares Inc. 1.4% $65.51 $65.5 $65.5 $64.1 11.4  (-4%) 4
ASB Associated Banc-Corp 1.3% $28.10 $27.9 $27.9 $26.6 4.9  (26%) 4
PNFP Pinnacle Financial Partners Inc. 1.3% $65.50 $66.5 $66.5 $65.3 8.7  (-7%) 3
VLY Valley National Bancorp 1.3% $12.65 $12.9 $12.9 $12.6 6.2  (-5%) 2
BXS BancorpSouth Bank 1.1% $34.00 $34.4 $34.4 $33.4 10.3  (33%) 4
UBSI United Bankshares Inc. 1.0% $36.75 $36.8 $36.8 $35.5 20.1  (-4%) 4
HOMB Home BancShares Inc. 1.0% $22.71 $23.3 $23.3 $23.2 12.0  (-0%) 0
BOH Bank of Hawaii Corporation 0.9% $85.47 $86.2 $86.2 $84.9 8.2  (1%) 3
CHFC Chemical Financial Corporation 0.8% $58.64 $57.6 $57.6 $56.3 8.2  (-6%) 4
UMBF UMB Financial Corporation 0.8% $78.02 $78.5 $78.5 $76.9 6.3  (5%) 4
MBFI MB Financial Inc. 0.8% $49.71 $49.6 $49.6 $45.4 8.8  (6%) 5
FULT Fulton Financial Corporation 0.7% $17.05 $17.5 $17.5 $17.4 4.9  (15%) -0
FMBI First Midwest Bancorp Inc. 0.7% $26.42 $26.4 $26.4 $25.5 3.3  (-21%) 4
SFNC Simmons First National Corporation Class A 0.7% $31.70 $32.0 $32.0 $30.5 5.0  (6%) 2
SSB South State Corporation 0.6% $89.25 $90.3 $90.3 $88.3 12.0  (-4%) 3
FBP First Bancorp 0.6% $7.77 $7.9 $7.9 $7.4 1.9  (14%) 3
UCBI United Community Banks Inc. 0.6% $33.13 $33.2 $33.2 $32.7 3.5  (10%) 1
ONB Old National Bancorp 0.6% $18.50 $18.3 $18.3 $17.7 4.1  (-9%) 4
CATY Cathay General Bancorp 0.6% $42.48 $42.8 $42.8 $41.4 3.0  (-9%) 2
CSFL CenterState Bank Corporation 0.6% $30.45 $31.3 $31.3 $29.7 3.1  (53%) 2
GBCI Glacier Bancorp Inc. 0.6% $39.79 $40.0 $40.0 $38.9 23.4  (2%) 2
UBSH Union Bankshares Corporation 0.6% $40.48 $41.3 $41.3 $39.3 6.0  (13%) 4
PPBI Pacific Premier Bancorp Inc. 0.6% $40.65 $41.7 $41.7 $41.0 7.5  (35%) -0
BOKF BOK Financial Corporation 0.6% $102.09 $103.3 $103.3 $102.5 5.6  (-2%) 2
CBU Community Bank System Inc. 0.6% $60.18 $60.6 $60.6 $58.1 16.7  (3%) 4
BANC Banc of California Incorporated 0.6% $19.75 $19.6 $19.6 $19.1 18.7  (-15%) 3
FFIN First Financial Bankshares Inc. 0.6% $53.40 $53.6 $53.6 $51.2 36.9  (0%) 4
FCB FCB Financial Holdings Inc. Class A 0.5% $60.15 $61.2 $61.2 $58.7 4.0  (-11%) 3
COLB Columbia Banking System Inc. 0.5% $43.10 $43.3 $43.3 $42.8 6.9  (7%) 2
CADE Cadence Bancorporation Class A 0.5% $29.87 $29.7 $29.7 $29.1 4.3  (79%) 3
ABCB Ameris Bancorp 0.5% $56.50 $56.5 $56.5 $54.5 9.3  (8%) 4
FFBC First Financial Bancorp. 0.5% $32.55 $32.3 $32.3 $31.2 4.0  (-4%) 4
FHB First Hawaiian Inc. 0.5% $30.51 $29.6 $29.6 $28.6 0.7  (-8%) 4
GWB Great Western Bancorp Inc. 0.5% $44.16 $44.1 $44.1 $42.2 8.4  (12%) 4
EGBN Eagle Bancorp Inc. 0.4% $61.60 $61.9 $61.9 $60.6 4.1  (-5%) 2
HTH Hilltop Holdings Inc. 0.4% $22.94 $23.5 $23.5 $23.3 2.0  (14%) -2
LTXB LegacyTexas Financial Group Inc. 0.4% $42.45 $43.1 $43.1 $42.7 6.6  (35%) -1
BANR Banner Corporation 0.4% $60.17 $60.2 $60.2 $58.4 4.0  (1%) 4
TRMK Trustmark Corporation 0.4% $32.63 $32.8 $32.8 $32.0 13.5  (8%) 4
FRME First Merchants Corporation 0.4% $47.16 $46.4 $46.4 $44.5 3.4  (-7%) 4
HOPE Hope Bancorp Inc. 0.4% $18.20 $18.4 $18.4 $18.1 3.4  (16%) 1
BHLB Berkshire Hills Bancorp Inc. 0.4% $41.85 $40.5 $40.5 $39.1 5.3  (14%) 5
CVBF CVB Financial Corp. 0.4% $23.46 $23.5 $23.5 $23.0 20.7  (3%) 2
FIBK First Interstate BancSystem Inc. Class A 0.4% $43.15 $43.8 $43.8 $41.9 4.4  (34%) 3
SASR Sandy Spring Bancorp Inc. 0.4% $42.15 $42.2 $42.2 $40.8 1.8  (-14%) 4
IBTX Independent Bank Group Inc. 0.4% $71.80 $75.6 $75.6 $73.9 7.4  (2%) 2
HTLF Heartland Financial USA Inc. 0.4% $55.75 $55.8 $55.8 $54.6 6.8  (0%) 3
FCF First Commonwealth Financial Corporation 0.3% $15.97 $15.9 $15.9 $15.3 4.9  (17%) 4
RNST Renasant Corporation 0.3% $47.28 $48.1 $48.1 $46.6 7.3  (5%) 4
IBOC International Bancshares Corporation 0.3% $43.50 $43.6 $43.6 $41.7 2.7  (1%) 3
BPFH Boston Private Financial Holdings Inc. 0.3% $16.95 $17.1 $17.1 $16.5 6.1  (2%) 4
EFSC Enterprise Financial Services Corp 0.3% $55.05 $55.1 $55.1 $52.1 2.0  (-15%) 4
CUBI Customers Bancorp Inc. 0.3% $30.25 $30.5 $30.5 $29.8 5.8  (-4%) 3
SBCF Seacoast Banking Corporation of Florida 0.3% $32.54 $31.6 $31.6 $29.3 5.0  (4%) 4
SFBS ServisFirst Bancshares Inc 0.3% $43.08 $43.3 $43.3 $42.8 20.0  (-3%) 3
HFWA Heritage Financial Corporation 0.3% $33.15 $32.9 $32.9 $31.8 10.7  (-11%) 5
OPB Opus Bank 0.3% $29.30 $29.5 $29.5 $28.8 10.2  (-4%) 2
PFBC Preferred Bank 0.3% $65.46 $65.2 $65.2 $64.7 7.6  (18%) 3
INDB Independent Bank Corp. 0.2% $81.15 $79.1 $79.1 $75.7 14.1  (-4%) 5
NBHC National Bank Holdings Corporation Class A 0.2% $39.35 $39.3 $39.3 $36.6 5.4  (19%) 5
WABC Westamerica Bancorporation 0.2% $58.91 $58.3 $58.3 $57.6 40.6  (2%) 3
CPF Central Pacific Financial Corp. 0.2% $29.21 $29.8 $29.8 $29.7 4.3  (-8%) 1
BRKL Brookline Bancorp Inc. 0.2% $18.95 $18.4 $18.4 $17.3 6.5  (0%) 5
NBTB NBT Bancorp Inc. 0.2% $38.93 $38.7 $38.7 $37.5 19.5  (-3%) 5
SBSI Southside Bancshares Inc. 0.2% $34.45 $34.5 $34.5 $34.4 10.5  (-5%) 2
HAFC Hanmi Financial Corporation 0.2% $29.70 $30.1 $30.1 $29.6 5.4  (-7%) 1
TBK Triumph Bancorp Inc. 0.2% $41.30 $41.2 $41.2 $40.2 1.3  (-1%) 1
CHCO City Holding Company 0.2% $76.43 $75.7 $75.7 $73.5 17.7  (4%) 5
FBK FB Financial Corporation 0.2% $41.15 $41.7 $41.7 $41.3 6.0  (27%) 1
OFG OFG Bancorp 0.2% $14.20 $14.3 $14.3 $13.5 9.9  (5%) 4
UVSP Univest Corporation of Pennsylvania 0.2% $28.10 $29.0 $29.0 $28.8 6.5  (-0%) 1
GNBC Green Bancorp Inc. 0.2% $23.30 $23.2 $23.2 $23.0 3.6  (-22%) 2
TBBK Bancorp Inc. 0.2% $11.25 $11.4 $11.4 $11.0 1.2  (-6%) 3
STBZ State Bank Financial Corporation 0.2% $34.22 $34.1 $34.1 $32.7 1.7  (3%) 3
FSB Franklin Financial Network Inc. 0.1% $37.95 $36.7 $36.7 $34.8 15.2  (-3%) 5
CARO Carolina Financial Corp. 0.1% $41.88 $43.0 $43.0 $41.1 5.9  (-9%) 4
LOB Live Oak Bancshares Inc. 0.1% $29.70 $29.8 $29.8 $29.1 10.0  (-5%) 3
GBNK Guaranty Bancorp 0.1% $32.45 $33.2 $33.2 $30.7 6.7  (-3%) 5
CNOB ConnectOne Bancorp Inc. 0.1% $25.90 $26.7 $26.7 $27.3 7.9  (-7%) -1
PGC Peapack-Gladstone Financial Corporation 0.1% $34.23 $34.5 $34.5 $33.9 3.6  (60%) 2
TSC TriState Capital Holdings Inc. 0.1% $26.10 $26.1 $26.1 $25.2 16.0  (6%) 4
LBAI Lakeland Bancorp Inc. 0.1% $20.35 $20.4 $20.4 $20.1 6.6  (-2%) 1
LION Fidelity Southern Corporation 0.1% $25.46 $24.9 $24.9 $23.8 4.3  (29%) 4