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

KBE 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.0% $319.00 $312.1 $312.1 $310.4 1.4  (-4%) 1
CFR Cullen/Frost Bankers Inc. 1.9% $111.38 $112.9 $112.9 $113.0 5.0  (8%) 1
TCBI Texas Capital Bancshares Inc. 1.9% $92.15 $92.5 $92.5 $94.6 3.0  (-6%) -1
BPOP Popular Inc. 1.8% $50.51 $49.0 $49.0 $47.4 2.3  (-4%) 3
SNV Synovus Financial Corp. 1.8% $49.61 $51.5 $51.5 $53.5 1.3  (-6%) 0
EWBC East West Bancorp Inc. 1.8% $64.77 $65.4 $65.4 $67.6 2.0  (-10%) -0
VOYA Voya Financial Inc. 1.7% $50.40 $49.6 $49.6 $50.0 9.1  (-3%) 2
UMPQ Umpqua Holdings Corporation 1.7% $21.37 $22.1 $22.1 $23.0 1.8  (-22%) 0
ZION Zions Bancorporation 1.7% $53.15 $52.8 $52.8 $54.1 8.2  (-6%) 0
STL Sterling Bancorp 1.7% $22.15 $22.7 $22.7 $23.7 12.4  (3%) 1
PACW PacWest Bancorp 1.7% $51.01 $50.4 $50.4 $51.8 3.3  (-15%) 0
FITB Fifth Third Bancorp 1.7% $29.52 $29.5 $29.5 $29.9 2.2  (14%) -1
WAL Western Alliance Bancorporation 1.7% $56.55 $57.5 $57.5 $59.1 3.0  (-1%) -2
FRC First Republic Bank 1.7% $101.08 $99.6 $99.6 $99.8 14.4  (4%) 3
CIT CIT Group Inc. 1.7% $53.94 $52.9 $52.9 $51.8 5.5  (-11%) 3
NTRS Northern Trust Corporation 1.7% $110.73 $109.2 $109.2 $106.9 1.6  (3%) 4
BBT BB&T Corporation 1.7% $51.20 $51.3 $51.3 $51.9 2.4  (17%) -1
BK Bank of New York Mellon Corporation 1.7% $52.29 $53.3 $53.3 $54.7 2.2  (31%) 0
BKU BankUnited Inc. 1.7% $40.92 $40.0 $40.0 $41.7 3.2  (24%) -1
CMA Comerica Incorporated 1.6% $97.91 $95.3 $95.3 $94.5 1.9  (6%) 2
RF Regions Financial Corporation 1.6% $19.28 $18.4 $18.4 $18.4 1.5  (2%) 1
WBS Webster Financial Corporation 1.6% $67.29 $66.4 $66.4 $65.9 7.1  (-22%) 5
STI SunTrust Banks Inc. 1.6% $72.77 $71.3 $71.3 $69.5 2.9  (3%) 4
JPM JPMorgan Chase & Co. 1.6% $116.88 $113.8 $113.8 $109.8 1.5  (17%) 2
MTB M&T Bank Corporation 1.6% $175.94 $173.1 $173.1 $173.1 2.1  (-3%) 2
PBCT People's United Financial Inc. 1.6% $18.50 $18.4 $18.4 $18.5 7.8  (14%) 1
BAC Bank of America Corporation 1.6% $31.60 $30.7 $30.7 $29.7 2.0  (24%) 2
FHN First Horizon National Corporation 1.6% $18.33 $17.8 $17.8 $18.3 2.5  (55%) 2
USB U.S. Bancorp 1.6% $53.48 $52.1 $52.1 $51.4 1.6  (-1%) 4
WFC Wells Fargo & Company 1.6% $58.44 $57.7 $57.7 $56.1 1.6  (-7%) 4
C Citigroup Inc. 1.6% $71.98 $70.8 $70.8 $68.6 1.2  (5%) 2
KEY KeyCorp 1.6% $21.57 $20.8 $20.8 $20.4 1.2  (3%) 4
HBAN Huntington Bancshares Incorporated 1.6% $15.93 $15.4 $15.4 $15.3 3.6  (212%) 4
CFG Citizens Financial Group Inc. 1.6% $40.59 $40.2 $40.2 $40.6 2.6  (-4%) -1
PNC PNC Financial Services Group Inc. 1.6% $145.22 $143.2 $143.2 $142.1 1.7  (-4%) 2
FNB F.N.B. Corporation 1.5% $13.13 $13.2 $13.2 $13.5 5.7  (5%) 1
NYCB New York Community Bancorp Inc. 1.5% $10.72 $11.0 $11.0 $11.3 9.0  (3%) 0
TCF TCF Financial Corporation 1.5% $25.46 $25.4 $25.4 $25.7 2.4  (-13%) 0
SBNY Signature Bank 1.5% $111.78 $115.9 $115.9 $123.7 1.2  (-28%) -2
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
TREE LendingTree Inc. 1.3% $248.15 $243.3 $243.3 $245.1 8.9  (10%) 2
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
MTG MGIC Investment Corporation 1.3% $12.61 $12.2 $12.2 $11.5 1.8  (43%) 4
ESNT Essent Group Ltd. 1.1% $40.46 $38.5 $38.5 $37.4 1.1  (-27%) 4
BXS BancorpSouth Bank 1.1% $34.00 $33.6 $33.6 $33.9 5.9  (-25%) 2
UBSI United Bankshares Inc. 1.1% $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
BOFI BofI Holding Inc 1.0% $37.11 $40.2 $40.2 $41.5 18.1  (3%) 0
RDN Radian Group Inc. 1.0% $19.73 $18.2 $18.2 $17.2 0.8  (-10%) 4
BOH Bank of Hawaii Corporation 1.0% $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
UCBI United Community Banks Inc. 0.6% $30.77 $30.7 $30.7 $31.7 1.9  (-11%) -2
WAFD Washington Federal Inc. 0.6% $33.70 $33.6 $33.6 $33.4 8.9  (7%) 3
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
GBCI Glacier Bancorp Inc. 0.6% $43.65 $42.6 $42.6 $41.1 16.6  (1%) 5
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
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
GWB Great Western Bancorp Inc. 0.5% $42.14 $41.9 $41.9 $42.9 7.4  (-1%) 1
TRMK Trustmark Corporation 0.4% $35.10 $34.7 $34.7 $33.7 10.5  (20%) 5
HOPE Hope Bancorp Inc. 0.4% $17.32 $17.3 $17.3 $17.9 8.0  (18%) -1
CVBF CVB Financial Corp. 0.4% $24.11 $23.4 $23.4 $23.3 11.4  (-9%) 5