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% $108.03 $110.0 $110.0 $110.5 2.1  (2%) -3
BAC Bank of America Corporation 8.6% $29.50 $29.9 $29.9 $30.1 1.8  (-6%) -3
WFC Wells Fargo & Company 7.0% $54.74 $54.8 $54.8 $53.5 2.1  (14%) 1
C Citigroup Inc. 5.3% $66.16 $68.3 $68.3 $69.3 1.7  (29%) -2
GS Goldman Sachs Group Inc. 2.5% $233.65 $233.1 $233.1 $240.6 2.0  (-6%) -2
USB U.S. Bancorp 2.4% $50.93 $50.9 $50.9 $50.8 2.1  (-6%) 1
MS Morgan Stanley 2.2% $51.31 $52.3 $52.3 $52.9 1.8  (32%) -2
AXP American Express Company 2.1% $99.76 $100.5 $100.5 $98.6 2.4  (-16%) 3
PNC PNC Financial Services Group Inc. 2.1% $141.84 $146.9 $146.9 $147.2 2.8  (-2%) -1
SCHW Charles Schwab Corporation 2.0% $56.61 $57.5 $57.5 $55.9 4.8  (24%) 2
BLK BlackRock Inc. 1.9% $523.36 $539.8 $539.8 $531.3 2.7  (3%) -1
CB Chubb Limited 1.9% $130.10 $132.5 $132.5 $134.1 2.7  (9%) -2
BK Bank of New York Mellon Corporation 1.7% $56.80 $56.7 $56.7 $55.2 3.8  (-6%) 2
CME CME Group Inc. Class A 1.6% $168.86 $165.7 $165.7 $162.7 3.8  (-4%) 4
AIG American International Group Inc. 1.5% $54.80 $54.1 $54.1 $54.1 2.2  (24%) -1
SPGI S&P Global Inc. 1.5% $207.29 $202.2 $202.2 $196.3 2.8  (-9%) 4
MET MetLife Inc. 1.4% $46.77 $47.2 $47.2 $47.0 1.9  (-5%) -1
COF Capital One Financial Corporation 1.3% $96.28 $95.5 $95.5 $94.6 1.3  (-8%) 1
PRU Prudential Financial Inc. 1.3% $98.75 $99.7 $99.7 $102.0 1.5  (-15%) -2
ICE Intercontinental Exchange Inc. 1.3% $74.52 $73.0 $73.0 $72.5 1.7  (-7%) 1
BBT BB&T Corporation 1.3% $52.44 $54.1 $54.1 $53.5 3.0  (-15%) -1
MMC Marsh & McLennan Companies Inc. 1.2% $81.94 $81.4 $81.4 $81.6 4.3  (25%) -1
STT State Street Corporation 1.1% $98.26 $99.1 $99.1 $99.8 3.5  (1%) -2
AFL Aflac Incorporated 1.1% $45.68 $45.5 $45.5 $45.1 4.0  (-3%) 1
TRV Travelers Companies Inc. 1.1% $128.86 $130.0 $130.0 $132.1 2.4  (-9%) -1
AON Aon plc 1.0% $140.21 $141.4 $141.4 $141.6 2.9  (-9%) 0
PGR Progressive Corporation 1.0% $61.89 $62.2 $62.2 $61.4 3.1  (23%) 2
ALL Allstate Corporation 1.0% $92.80 $94.2 $94.2 $95.6 3.8  (46%) -1
STI SunTrust Banks Inc. 1.0% $68.89 $69.1 $69.1 $68.2 4.7  (-1%) 1
TROW T. Rowe Price Group 0.8% $123.66 $123.0 $123.0 $115.9 6.3  (0%) 5
MCO Moody's Corporation 0.8% $175.93 $174.9 $174.9 $169.1 4.7  (-4%) 3
MTB M&T Bank Corporation 0.8% $174.71 $177.4 $177.4 $180.6 2.9  (25%) -1
DFS Discover Financial Services 0.8% $75.20 $75.6 $75.6 $73.7 2.3  (23%) 1
SYF Synchrony Financial 0.7% $35.26 $35.3 $35.3 $34.5 1.7  (3%) 1
FITB Fifth Third Bancorp 0.7% $30.84 $31.4 $31.4 $32.2 2.6  (1%) -1
NTRS Northern Trust Corporation 0.7% $106.95 $106.4 $106.4 $106.0 1.6  (-8%) 2
KEY KeyCorp 0.6% $20.53 $20.2 $20.2 $20.0 1.5  (-20%) 1
RF Regions Financial Corporation 0.6% $18.62 $18.9 $18.9 $18.8 1.8  (-1%) -1
CFG Citizens Financial Group Inc. 0.6% $41.40 $41.6 $41.6 $41.8 2.2  (3%) -3
AMP Ameriprise Financial Inc. 0.6% $147.65 $142.3 $142.3 $141.1 1.7  (25%) 1
WLTW Willis Towers Watson Public Limited Company 0.6% $156.04 $154.9 $154.9 $152.2 1.9  (10%) 1
HIG Hartford Financial Services Group Inc. 0.6% $53.08 $52.9 $52.9 $52.6 2.1  (20%) 1
CMA Comerica Incorporated 0.5% $95.18 $96.8 $96.8 $96.3 3.6  (4%) -1
ETFC E*TRADE Financial Corporation 0.5% $64.84 $64.6 $64.6 $61.9 2.6  (-0%) 2
SIVB SVB Financial Group 0.5% $316.49 $319.8 $319.8 $294.3 1.9  (-4%) 2
HBAN Huntington Bancshares Incorporated 0.5% $15.42 $15.3 $15.3 $15.0 1.4  (-12%) 2
PFG Principal Financial Group Inc. 0.5% $56.26 $57.4 $57.4 $58.7 2.6  (-9%) -1
LNC Lincoln National Corporation 0.5% $68.05 $68.5 $68.5 $69.1 2.0  (48%) -1
XL XL Group Ltd 0.4% $56.20 $55.9 $55.9 $55.6 2.4  (12%) 2
L Loews Corporation 0.4% $49.61 $50.0 $50.0 $50.6 3.9  (-6%) -1
MSCI MSCI Inc. Class A 0.4% $172.35 $162.8 $162.8 $156.0 1.9  (28%) 4
AJG Arthur J. Gallagher & Co. 0.4% $65.98 $67.0 $67.0 $68.1 1.7  (-4%) -2
CBOE Cboe Global Markets Inc 0.4% $103.81 $102.8 $102.8 $105.6 2.9  (6%) -1
RJF Raymond James Financial Inc. 0.3% $98.45 $99.2 $99.2 $93.1 3.2  (7%) 3
IVZ Invesco Ltd. 0.3% $27.21 $27.9 $27.9 $29.0 1.4  (-10%) -2
ZION Zions Bancorporation 0.3% $55.45 $56.7 $56.7 $55.5 11.9  (3%) 2
BEN Franklin Resources Inc. 0.3% $33.15 $33.9 $33.9 $33.6 4.8  (5%) 0
CINF Cincinnati Financial Corporation 0.3% $68.92 $70.3 $70.3 $71.6 5.0  (-3%) -1
NDAQ Nasdaq Inc. 0.3% $94.77 $93.1 $93.1 $89.8 3.2  (29%) 4
RE Everest Re Group Ltd. 0.3% $226.00 $227.3 $227.3 $234.8 2.9  (18%) -1
TMK Torchmark Corporation 0.3% $84.20 $85.4 $85.4 $85.3 5.9  (-18%) 1
UNM Unum Group 0.3% $38.83 $38.8 $38.8 $42.2 1.7  (26%) -1
AMG Affiliated Managers Group Inc. 0.3% $155.51 $163.1 $163.1 $166.7 2.2  (2%) -2
PBCT People's United Financial Inc. 0.2% $18.79 $18.8 $18.8 $18.6 6.6  (-11%) 2
AIZ Assurant Inc. 0.1% $95.76 $95.8 $95.8 $92.7 2.1  (-5%) 3
BHF Brighthouse Financial Inc. 0.1% $45.26 $47.1 $47.1 $49.0 6.0  (16%) -1
NAVI Navient Corp 0.1% $13.49 $14.3 $14.3 $13.8 3.4  (-9%) 1