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% $316.49 $319.8 $319.8 $294.3 1.9  (-4%) 2
CFR Cullen/Frost Bankers Inc. 1.9% $113.58 $116.7 $116.7 $113.6 3.9  (-30%) 3
TCBI Texas Capital Bancshares Inc. 1.9% $100.05 $99.5 $99.5 $97.7 7.3  (-1%) 4
BPOP Popular Inc. 1.8% $46.51 $46.7 $46.7 $45.8 4.4  (-16%) 2
SNV Synovus Financial Corp. 1.8% $55.73 $55.2 $55.2 $53.1 3.8  (-7%) 4
EWBC East West Bancorp Inc. 1.8% $70.18 $71.1 $71.1 $67.8 3.2  (11%) 3
VOYA Voya Financial Inc. 1.7% $51.70 $53.0 $53.0 $52.4 7.2  (-8%) 1
UMPQ Umpqua Holdings Corporation 1.7% $23.95 $24.0 $24.0 $23.4 2.7  (-25%) 3
ZION Zions Bancorporation 1.7% $55.45 $56.7 $56.7 $55.5 11.9  (3%) 2
STL Sterling Bancorp 1.7% $24.60 $24.8 $24.8 $23.9 10.2  (17%) 2
PACW PacWest Bancorp 1.7% $54.25 $54.4 $54.4 $52.5 5.6  (-5%) 4
FITB Fifth Third Bancorp 1.7% $30.84 $31.4 $31.4 $32.2 2.6  (1%) -1
WAL Western Alliance Bancorporation 1.7% $61.88 $61.8 $61.8 $60.1 3.6  (7%) 2
FRC First Republic Bank 1.7% $100.06 $100.5 $100.5 $96.3 13.0  (2%) 4
CIT CIT Group Inc. 1.7% $51.34 $52.3 $52.3 $52.6 3.8  (-5%) -2
NTRS Northern Trust Corporation 1.7% $106.95 $106.4 $106.4 $106.0 1.6  (-8%) 2
BBT BB&T Corporation 1.7% $52.44 $54.1 $54.1 $53.5 3.0  (-15%) -1
BK Bank of New York Mellon Corporation 1.7% $56.80 $56.7 $56.7 $55.2 3.8  (-6%) 2
BKU BankUnited Inc. 1.7% $43.77 $43.0 $43.0 $41.3 3.2  (3%) 4
CMA Comerica Incorporated 1.6% $95.18 $96.8 $96.8 $96.3 3.6  (4%) -1
RF Regions Financial Corporation 1.6% $18.62 $18.9 $18.9 $18.8 1.8  (-1%) -1
WBS Webster Financial Corporation 1.6% $66.04 $65.6 $65.6 $61.9 14.5  (3%) 5
STI SunTrust Banks Inc. 1.6% $68.89 $69.1 $69.1 $68.2 4.7  (-1%) 1
JPM JPMorgan Chase & Co. 1.6% $108.03 $110.0 $110.0 $110.5 2.1  (2%) -3
MTB M&T Bank Corporation 1.6% $174.71 $177.4 $177.4 $180.6 2.9  (25%) -1
PBCT People's United Financial Inc. 1.6% $18.79 $18.8 $18.8 $18.6 6.6  (-11%) 2
BAC Bank of America Corporation 1.6% $29.50 $29.9 $29.9 $30.1 1.8  (-6%) -3
FHN First Horizon National Corporation 1.6% $19.10 $19.0 $19.0 $18.9 2.9  (-25%) 1
USB U.S. Bancorp 1.6% $50.93 $50.9 $50.9 $50.8 2.1  (-6%) 1
WFC Wells Fargo & Company 1.6% $54.74 $54.8 $54.8 $53.5 2.1  (14%) 1
C Citigroup Inc. 1.6% $66.16 $68.3 $68.3 $69.3 1.7  (29%) -2
KEY KeyCorp 1.6% $20.53 $20.2 $20.2 $20.0 1.5  (-20%) 1
OZRK Bank of The Ozarks 1.6% $48.72 $48.6 $48.6 $47.9 16.6  (-5%) 2
HBAN Huntington Bancshares Incorporated 1.6% $15.42 $15.3 $15.3 $15.0 1.4  (-12%) 2
CFG Citizens Financial Group Inc. 1.6% $41.40 $41.6 $41.6 $41.8 2.2  (3%) -3
PNC PNC Financial Services Group Inc. 1.6% $141.84 $146.9 $146.9 $147.2 2.8  (-2%) -1
FNB F.N.B. Corporation 1.5% $13.79 $13.7 $13.7 $13.4 6.5  (-5%) 2
NYCB New York Community Bancorp Inc. 1.5% $11.54 $11.8 $11.8 $12.1 10.4  (-2%) 0
TCF TCF Financial Corporation 1.5% $26.36 $26.5 $26.5 $25.1 3.0  (-22%) 3
SBNY Signature Bank 1.5% $126.06 $129.2 $129.2 $131.2 3.7  (4%) -2
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
TREE LendingTree Inc. 1.3% $248.25 $265.9 $265.9 $282.4 7.9  (-2%) -1
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
MTG MGIC Investment Corporation 1.3% $10.97 $10.8 $10.8 $10.8 1.4  (-4%) 1
ESNT Essent Group Ltd. 1.1% $37.11 $35.8 $35.8 $35.9 1.7  (51%) 1
BXS BancorpSouth Bank 1.1% $34.00 $34.4 $34.4 $33.4 10.3  (33%) 4
UBSI United Bankshares Inc. 1.1% $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
BOFI BofI Holding Inc 1.0% $42.35 $42.4 $42.4 $41.6 19.8  (-4%) 2
RDN Radian Group Inc. 1.0% $16.70 $16.4 $16.4 $16.2 0.9  (18%) 2
BOH Bank of Hawaii Corporation 1.0% $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
UCBI United Community Banks Inc. 0.6% $33.13 $33.2 $33.2 $32.7 3.5  (10%) 1
WAFD Washington Federal Inc. 0.6% $32.90 $33.0 $33.0 $32.7 5.1  (-8%) 2
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
GBCI Glacier Bancorp Inc. 0.6% $39.79 $40.0 $40.0 $38.9 23.4  (2%) 2
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
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
GWB Great Western Bancorp Inc. 0.5% $44.16 $44.1 $44.1 $42.2 8.4  (12%) 4
TRMK Trustmark Corporation 0.4% $32.63 $32.8 $32.8 $32.0 13.5  (8%) 4
HOPE Hope Bancorp Inc. 0.4% $18.20 $18.4 $18.4 $18.1 3.4  (16%) 1
CVBF CVB Financial Corp. 0.4% $23.46 $23.5 $23.5 $23.0 20.7  (3%) 2