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% $319.00 $312.1 $312.1 $310.4 1.4  (-4%) 1
TCBI Texas Capital Bancshares Inc. 2.1% $92.15 $92.5 $92.5 $94.6 3.0  (-6%) -1
CFR Cullen/Frost Bankers Inc. 2.0% $111.38 $112.9 $112.9 $113.0 5.0  (8%) 1
EWBC East West Bancorp Inc. 2.0% $64.77 $65.4 $65.4 $67.6 2.0  (-10%) -0
ZION Zions Bancorporation 1.9% $53.15 $52.8 $52.8 $54.1 8.2  (-6%) 0
STL Sterling Bancorp 1.9% $22.15 $22.7 $22.7 $23.7 12.4  (3%) 1
PACW PacWest Bancorp 1.9% $51.01 $50.4 $50.4 $51.8 3.3  (-15%) 0
FITB Fifth Third Bancorp 1.9% $29.52 $29.5 $29.5 $29.9 2.2  (14%) -1
FRC First Republic Bank 1.9% $101.08 $99.6 $99.6 $99.8 14.4  (4%) 3
CIT CIT Group Inc. 1.9% $53.94 $52.9 $52.9 $51.8 5.5  (-11%) 3
BBT BB&T Corporation 1.9% $51.20 $51.3 $51.3 $51.9 2.4  (17%) -1
SNV Synovus Financial Corp. 1.9% $49.61 $51.5 $51.5 $53.5 1.3  (-6%) 0
CMA Comerica Incorporated 1.8% $97.91 $95.3 $95.3 $94.5 1.9  (6%) 2
RF Regions Financial Corporation 1.8% $19.28 $18.4 $18.4 $18.4 1.5  (2%) 1
STI SunTrust Banks Inc. 1.8% $72.77 $71.3 $71.3 $69.5 2.9  (3%) 4
MTB M&T Bank Corporation 1.8% $175.94 $173.1 $173.1 $173.1 2.1  (-3%) 2
PBCT People's United Financial Inc. 1.8% $18.50 $18.4 $18.4 $18.5 7.8  (14%) 1
FHN First Horizon National Corporation 1.8% $18.33 $17.8 $17.8 $18.3 2.5  (55%) 2
KEY KeyCorp 1.8% $21.57 $20.8 $20.8 $20.4 1.2  (3%) 4
HBAN Huntington Bancshares Incorporated 1.8% $15.93 $15.4 $15.4 $15.3 3.6  (212%) 4
CFG Citizens Financial Group Inc. 1.8% $40.59 $40.2 $40.2 $40.6 2.6  (-4%) -1
PNC PNC Financial Services Group Inc. 1.8% $145.22 $143.2 $143.2 $142.1 1.7  (-4%) 2
BPOP Popular Inc. 1.7% $50.51 $49.0 $49.0 $47.4 2.3  (-4%) 3
WAL Western Alliance Bancorporation 1.7% $56.55 $57.5 $57.5 $59.1 3.0  (-1%) -2
UMPQ Umpqua Holdings Corporation 1.7% $21.37 $22.1 $22.1 $23.0 1.8  (-22%) 0
BKU BankUnited Inc. 1.7% $40.92 $40.0 $40.0 $41.7 3.2  (24%) -1
SBNY Signature Bank 1.6% $111.78 $115.9 $115.9 $123.7 1.2  (-28%) -2
WBS Webster Financial Corporation 1.6% $67.29 $66.4 $66.4 $65.9 7.1  (-22%) 5
FNB F.N.B. Corporation 1.4% $13.13 $13.2 $13.2 $13.5 5.7  (5%) 1
TCF TCF Financial Corporation 1.4% $25.46 $25.4 $25.4 $25.7 2.4  (-13%) 0
PB Prosperity Bancshares Inc.(R) 1.4% $72.96 $70.0 $70.0 $70.8 6.5  (-1%) 3
IBKC IBERIABANK Corporation 1.4% $84.95 $81.6 $81.6 $80.5 3.2  (-6%) 4
ISBC Investors Bancorp Inc 1.4% $12.66 $12.7 $12.7 $13.0 2.3  (-18%) -1
WTFC Wintrust Financial Corporation 1.4% $89.25 $89.2 $89.2 $90.9 1.9  (-22%) 1
CBSH Commerce Bancshares Inc. 1.4% $69.41 $68.5 $68.5 $66.9 8.2  (-8%) 5
ASB Associated Banc-Corp 1.3% $27.10 $27.7 $27.7 $27.9 2.4  (-16%) -1
PNFP Pinnacle Financial Partners Inc. 1.3% $63.55 $62.6 $62.6 $63.7 6.0  (13%) 0
VLY Valley National Bancorp 1.3% $11.76 $12.3 $12.3 $12.5 6.3  (-7%) 0
BXS BancorpSouth Bank 1.1% $34.00 $33.6 $33.6 $33.9 5.9  (-25%) 2
UBSI United Bankshares Inc. 1.0% $38.25 $37.0 $37.0 $37.1 13.4  (3%) 4
HOMB Home BancShares Inc. 1.0% $23.50 $23.2 $23.2 $23.2 7.3  (8%) 1
BOH Bank of Hawaii Corporation 0.9% $82.96 $83.1 $83.1 $84.5 6.2  (-7%) 1
CHFC Chemical Financial Corporation 0.8% $57.29 $56.7 $56.7 $57.2 7.1  (-3%) 1
UMBF UMB Financial Corporation 0.8% $74.70 $75.5 $75.5 $77.0 3.9  (-4%) 0
MBFI MB Financial Inc. 0.8% $48.31 $48.1 $48.1 $48.6 1.3  (-3%) 0
FULT Fulton Financial Corporation 0.7% $17.65 $17.3 $17.3 $17.2 4.1  (2%) 2
FMBI First Midwest Bancorp Inc. 0.7% $26.90 $26.5 $26.5 $26.4 3.7  (-21%) 3
SFNC Simmons First National Corporation Class A 0.7% $30.25 $30.4 $30.4 $31.0 6.6  (9%) 1
SSB South State Corporation 0.6% $83.15 $86.4 $86.4 $88.3 6.2  (-5%) 1
FBP First Bancorp 0.6% $8.44 $8.2 $8.2 $8.0 2.2  (-16%) 4
UCBI United Community Banks Inc. 0.6% $30.77 $30.7 $30.7 $31.7 1.9  (-11%) -2
ONB Old National Bancorp 0.6% $19.40 $19.3 $19.3 $19.0 5.3  (1%) 4
CATY Cathay General Bancorp 0.6% $42.29 $41.8 $41.8 $42.0 3.5  (8%) 2
CSFL CenterState Bank Corporation 0.6% $29.78 $29.5 $29.5 $30.3 6.6  (-11%) 1
GBCI Glacier Bancorp Inc. 0.6% $43.65 $42.6 $42.6 $41.1 16.6  (1%) 5
UBSH Union Bankshares Corporation 0.6% $40.80 $40.7 $40.7 $40.7 5.1  (-1%) 3
PPBI Pacific Premier Bancorp Inc. 0.6% $37.05 $37.2 $37.2 $39.2 13.7  (-39%) -1
BOKF BOK Financial Corporation 0.6% $98.96 $98.0 $98.0 $98.6 5.3  (19%) 2
CBU Community Bank System Inc. 0.6% $63.71 $63.2 $63.2 $61.8 13.2  (0%) 5
BANC Banc of California Incorporated 0.6% $20.20 $19.6 $19.6 $19.7 13.9  (-3%) 3
FFIN First Financial Bankshares Inc. 0.6% $58.10 $56.1 $56.1 $54.5 27.4  (-1%) 5
FCB FCB Financial Holdings Inc. Class A 0.5% $51.30 $54.4 $54.4 $58.2 1.1  (-28%) -1
COLB Columbia Banking System Inc. 0.5% $41.88 $41.6 $41.6 $42.3 6.3  (-18%) 0
CADE Cadence Bancorporation Class A 0.5% $28.23 $28.4 $28.4 $29.1 4.1  (36%) -1
ABCB Ameris Bancorp 0.5% $48.88 $50.2 $50.2 $53.5 2.7  (-9%) -1
FFBC First Financial Bancorp. 0.5% $31.05 $31.1 $31.1 $31.7 4.2  (11%) 0
FHB First Hawaiian Inc. 0.5% $28.81 $28.6 $28.6 $29.4 1.4  (-18%) -2
GWB Great Western Bancorp Inc. 0.5% $42.14 $41.9 $41.9 $42.9 7.4  (-1%) 1
EGBN Eagle Bancorp Inc. 0.4% $54.50 $56.4 $56.4 $59.9 3.6  (54%) -1
HTH Hilltop Holdings Inc. 0.4% $20.90 $21.5 $21.5 $22.5 3.5  (9%) -2
LTXB LegacyTexas Financial Group Inc. 0.4% $43.43 $42.9 $42.9 $42.0 4.1  (-2%) 2
BANR Banner Corporation 0.4% $65.03 $62.8 $62.8 $61.8 3.9  (2%) 4
TRMK Trustmark Corporation 0.4% $35.10 $34.7 $34.7 $33.7 10.5  (20%) 5
FRME First Merchants Corporation 0.4% $47.54 $47.4 $47.4 $47.3 2.9  (17%) 2
HOPE Hope Bancorp Inc. 0.4% $17.32 $17.3 $17.3 $17.9 8.0  (18%) -1
BHLB Berkshire Hills Bancorp Inc. 0.4% $41.25 $41.0 $41.0 $41.3 9.3  (-1%) 1
CVBF CVB Financial Corp. 0.4% $24.11 $23.4 $23.4 $23.3 11.4  (-9%) 5
FIBK First Interstate BancSystem Inc. Class A 0.4% $43.50 $43.2 $43.2 $43.3 11.3  (1%) 2
SASR Sandy Spring Bancorp Inc. 0.4% $39.18 $40.3 $40.3 $41.5 2.9  (27%) 0
IBTX Independent Bank Group Inc. 0.4% $69.15 $68.4 $68.4 $70.3 6.7  (-2%) 0
HTLF Heartland Financial USA Inc. 0.4% $59.70 $58.6 $58.6 $57.1 4.3  (8%) 4
FCF First Commonwealth Financial Corporation 0.3% $16.76 $16.6 $16.6 $16.2 8.6  (6%) 5
RNST Renasant Corporation 0.3% $45.50 $45.2 $45.2 $46.5 5.0  (-27%) -1
IBOC International Bancshares Corporation 0.3% $45.60 $44.7 $44.7 $44.2 2.9  (-20%) 4
BPFH Boston Private Financial Holdings Inc. 0.3% $14.10 $14.9 $14.9 $16.1 3.7  (21%) 0
EFSC Enterprise Financial Services Corp 0.3% $56.45 $56.1 $56.1 $55.6 2.2  (-12%) 3
CUBI Customers Bancorp Inc. 0.3% $25.20 $27.2 $27.2 $29.1 3.1  (-18%) -2
SBCF Seacoast Banking Corporation of Florida 0.3% $29.93 $31.2 $31.2 $31.8 7.0  (0%) 1
SFBS ServisFirst Bancshares Inc 0.3% $42.42 $42.4 $42.4 $43.0 23.4  (14%) 1
HFWA Heritage Financial Corporation 0.3% $35.35 $35.7 $35.7 $34.6 7.7  (-9%) 4
OPB Opus Bank 0.3% $28.50 $28.6 $28.6 $29.2 5.2  (-15%) 0
PFBC Preferred Bank 0.3% $62.53 $63.9 $63.9 $64.9 7.0  (-23%) 0
INDB Independent Bank Corp. 0.2% $88.00 $86.2 $86.2 $82.9 10.3  (-5%) 5
NBHC National Bank Holdings Corporation Class A 0.2% $40.32 $39.4 $39.4 $39.4 10.5  (-1%) 5
WABC Westamerica Bancorporation 0.2% $63.28 $60.3 $60.3 $59.4 42.9  (0%) 5
CPF Central Pacific Financial Corp. 0.2% $27.87 $28.5 $28.5 $29.1 7.3  (46%) 0
BRKL Brookline Bancorp Inc. 0.2% $17.95 $18.4 $18.4 $18.7 8.2  (-2%) 1
NBTB NBT Bancorp Inc. 0.2% $39.61 $39.9 $39.9 $39.4 22.6  (4%) 3
SBSI Southside Bancshares Inc. 0.2% $35.25 $34.8 $34.8 $34.7 15.0  (-5%) 4
HAFC Hanmi Financial Corporation 0.2% $25.45 $26.3 $26.3 $28.4 3.4  (-17%) -2
TBK Triumph Bancorp Inc. 0.2% $42.20 $40.6 $40.6 $41.3 2.8  (-9%) 1
CHCO City Holding Company 0.2% $80.37 $79.4 $79.4 $78.0 16.4  (1%) 4
FBK FB Financial Corporation 0.2% $43.54 $42.2 $42.2 $41.8 5.9  (-20%) 4
OFG OFG Bancorp 0.2% $16.75 $16.0 $16.0 $15.0 8.3  (28%) 5
UVSP Univest Corporation of Pennsylvania 0.2% $27.65 $27.6 $27.6 $28.1 3.5  (4%) -2
GNBC Green Bancorp Inc. 0.2% $24.45 $23.5 $23.5 $23.0 0.9  (5%) 4
TBBK Bancorp Inc. 0.2% $10.03 $10.4 $10.4 $10.8 1.7  (26%) -1
STBZ State Bank Financial Corporation 0.2% $32.52 $32.7 $32.7 $33.5 2.1  (-18%) -1
FSB Franklin Financial Network Inc. 0.1% $38.30 $37.6 $37.6 $37.8 11.5  (21%) 3
CARO Carolina Financial Corp. 0.1% $41.89 $42.0 $42.0 $43.0 6.3  (-6%) 0
LOB Live Oak Bancshares Inc. 0.1% $29.85 $30.6 $30.6 $30.6 7.4  (9%) -1
GBNK Guaranty Bancorp 0.1% $31.10 $30.6 $30.6 $31.5 4.3  (-2%) 0
CNOB ConnectOne Bancorp Inc. 0.1% $25.30 $25.1 $25.1 $25.7 6.7  (-17%) -1
PGC Peapack-Gladstone Financial Corporation 0.1% $33.05 $33.9 $33.9 $34.6 4.4  (7%) -1
TSC TriState Capital Holdings Inc. 0.1% $29.35 $28.4 $28.4 $27.1 6.0  (28%) 5
LBAI Lakeland Bancorp Inc. 0.1% $19.45 $20.0 $20.0 $20.3 9.4  (0%) 0
LION Fidelity Southern Corporation 0.1% $23.84 $24.7 $24.7 $25.3 4.9  (11%) 0