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

XLF Conmponent Weighting

Ticker
Symbol
Company Name ETF Weight Close Price 10-Day 20-Day 50-Day Short Int Ratio Technical Score
JPM JPMorgan Chase & Co. 11.3% $116.88 $113.8 $113.8 $109.8 1.5  (17%) 2
BAC Bank of America Corporation 8.6% $31.60 $30.7 $30.7 $29.7 2.0  (24%) 2
WFC Wells Fargo & Company 7.0% $58.44 $57.7 $57.7 $56.1 1.6  (-7%) 4
C Citigroup Inc. 5.3% $71.98 $70.8 $70.8 $68.6 1.2  (5%) 2
GS Goldman Sachs Group Inc. 2.5% $233.78 $233.8 $233.8 $230.0 1.3  (15%) 1
USB U.S. Bancorp 2.4% $53.48 $52.1 $52.1 $51.4 1.6  (-1%) 4
MS Morgan Stanley 2.2% $49.44 $50.0 $50.0 $49.8 1.4  (26%) 1
AXP American Express Company 2.1% $102.99 $101.4 $101.4 $99.9 1.4  (-3%) 1
PNC PNC Financial Services Group Inc. 2.1% $145.22 $143.2 $143.2 $142.1 1.7  (-4%) 2
SCHW Charles Schwab Corporation 2.0% $50.73 $51.7 $51.7 $53.3 3.1  (-7%) -1
BLK BlackRock Inc. 1.9% $484.10 $497.9 $497.9 $512.3 1.8  (-7%) -2
CB Chubb Limited 1.9% $137.08 $135.9 $135.9 $132.1 3.3  (30%) 2
BK Bank of New York Mellon Corporation 1.7% $52.29 $53.3 $53.3 $54.7 2.2  (31%) 0
CME CME Group Inc. Class A 1.6% $162.97 $165.8 $165.8 $166.4 5.8  (3%) 1
AIG American International Group Inc. 1.5% $52.00 $54.0 $54.0 $54.1 4.2  (-12%) -1
SPGI S&P Global Inc. 1.5% $200.95 $206.8 $206.8 $205.9 2.9  (-22%) 0
MET MetLife Inc. 1.4% $46.12 $45.1 $45.1 $45.4 2.8  (-11%) 1
COF Capital One Financial Corporation 1.3% $97.62 $96.5 $96.5 $95.6 1.1  (-18%) 1
PRU Prudential Financial Inc. 1.3% $99.94 $98.1 $98.1 $97.5 1.8  (-12%) 1
ICE Intercontinental Exchange Inc. 1.3% $73.23 $74.9 $74.9 $74.4 2.4  (5%) -0
BBT BB&T Corporation 1.3% $51.20 $51.3 $51.3 $51.9 2.4  (17%) -1
MMC Marsh & McLennan Companies Inc. 1.2% $84.02 $85.4 $85.4 $83.5 3.4  (-6%) 2
STT State Street Corporation 1.1% $85.80 $88.8 $88.8 $93.5 0.9  (19%) -1
AFL Aflac Incorporated 1.1% $46.76 $44.7 $44.7 $44.6 3.7  (-8%) 2
TRV Travelers Companies Inc. 1.1% $129.56 $128.1 $128.1 $127.1 2.1  (28%) 2
AON Aon plc 1.0% $142.98 $144.9 $144.9 $141.7 2.4  (8%) 2
PGR Progressive Corporation 1.0% $62.54 $60.2 $60.2 $60.7 2.0  (2%) 2
ALL Allstate Corporation 1.0% $99.48 $95.3 $95.3 $93.8 2.7  (-1%) 2
STI SunTrust Banks Inc. 1.0% $72.77 $71.3 $71.3 $69.5 2.9  (3%) 4
TROW T. Rowe Price Group 0.8% $118.89 $119.8 $119.8 $120.7 5.1  (-8%) 2
MCO Moody's Corporation 0.8% $172.04 $178.9 $178.9 $175.9 2.7  (-1%) 1
MTB M&T Bank Corporation 0.8% $175.94 $173.1 $173.1 $173.1 2.1  (-3%) 2
DFS Discover Financial Services 0.8% $75.67 $72.5 $72.5 $72.9 1.7  (3%) 1
SYF Synchrony Financial 0.7% $29.98 $31.4 $31.4 $33.3 1.1  (4%) -2
FITB Fifth Third Bancorp 0.7% $29.52 $29.5 $29.5 $29.9 2.2  (14%) -1
NTRS Northern Trust Corporation 0.7% $110.73 $109.2 $109.2 $106.9 1.6  (3%) 4
KEY KeyCorp 0.6% $21.57 $20.8 $20.8 $20.4 1.2  (3%) 4
RF Regions Financial Corporation 0.6% $19.28 $18.4 $18.4 $18.4 1.5  (2%) 1
CFG Citizens Financial Group Inc. 0.6% $40.59 $40.2 $40.2 $40.6 2.6  (-4%) -1
AMP Ameriprise Financial Inc. 0.6% $139.66 $142.8 $142.8 $143.1 1.8  (-9%) -1
WLTW Willis Towers Watson Public Limited Company 0.6% $151.61 $156.6 $156.6 $155.2 3.0  (-13%) -1
HIG Hartford Financial Services Group Inc. 0.6% $52.20 $52.7 $52.7 $52.5 1.3  (-25%) 0
CMA Comerica Incorporated 0.5% $97.91 $95.3 $95.3 $94.5 1.9  (6%) 2
ETFC E*TRADE Financial Corporation 0.5% $61.46 $60.7 $60.7 $62.3 1.3  (1%) -1
SIVB SVB Financial Group 0.5% $319.00 $312.1 $312.1 $310.4 1.4  (-4%) 1
HBAN Huntington Bancshares Incorporated 0.5% $15.93 $15.4 $15.4 $15.3 3.6  (212%) 4
PFG Principal Financial Group Inc. 0.5% $55.64 $55.4 $55.4 $55.3 2.0  (-21%) 2
LNC Lincoln National Corporation 0.5% $66.69 $66.0 $66.0 $65.9 2.5  (-2%) 2
XL XL Group Ltd 0.4% $56.42 $56.3 $56.3 $56.2 5.0  (-2%) 1
L Loews Corporation 0.4% $50.33 $50.2 $50.2 $49.6 5.2  (-2%) 1
MSCI MSCI Inc. Class A 0.4% $173.17 $170.9 $170.9 $168.8 2.5  (-2%) 3
AJG Arthur J. Gallagher & Co. 0.4% $71.36 $70.7 $70.7 $68.1 2.0  (5%) 2
CBOE Cboe Global Markets Inc 0.4% $92.10 $100.2 $100.2 $101.8 4.0  (-1%) -1
RJF Raymond James Financial Inc. 0.3% $90.80 $93.4 $93.4 $94.6 2.4  (5%) 1
IVZ Invesco Ltd. 0.3% $25.49 $25.8 $25.8 $26.6 1.7  (20%) -2
ZION Zions Bancorporation 0.3% $53.15 $52.8 $52.8 $54.1 8.2  (-6%) 0
BEN Franklin Resources Inc. 0.3% $32.89 $32.6 $32.6 $32.9 4.9  (-9%) 1
CINF Cincinnati Financial Corporation 0.3% $75.00 $72.7 $72.7 $70.5 4.0  (15%) 3
NDAQ Nasdaq Inc. 0.3% $92.82 $93.7 $93.7 $93.2 3.7  (-8%) 1
RE Everest Re Group Ltd. 0.3% $215.21 $225.5 $225.5 $227.6 2.7  (8%) -1
TMK Torchmark Corporation 0.3% $87.53 $85.7 $85.7 $84.7 4.6  (-2%) 2
UNM Unum Group 0.3% $36.02 $37.6 $37.6 $38.1 3.3  (18%) -1
AMG Affiliated Managers Group Inc. 0.3% $151.19 $151.7 $151.7 $154.0 1.8  (-25%) -2
PBCT People's United Financial Inc. 0.2% $18.50 $18.4 $18.4 $18.5 7.8  (14%) 1
AIZ Assurant Inc. 0.1% $105.95 $108.0 $108.0 $103.2 3.7  (-1%) 3
BHF Brighthouse Financial Inc. 0.1% $42.64 $42.3 $42.3 $43.5 6.3  (-11%) 1
NAVI Navient Corp 0.1% $13.33 $13.5 $13.5 $13.6 4.7  (-1%) -0