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

IYG 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 12.1% $108.03 $110.0 $110.0 $110.5 2.1  (2%) -3
BAC BANK OF AMERICA CORP 9.2% $29.50 $29.9 $29.9 $30.1 1.8  (-6%) -3
WFC WELLS FARGO 7.5% $54.74 $54.8 $54.8 $53.5 2.1  (14%) 1
V VISA INC CLASS A 7.4% $135.00 $132.4 $132.4 $128.1 4.9  (2%) 4
C CITIGROUP INC 5.7% $66.16 $68.3 $68.3 $69.3 1.7  (29%) -2
MA MASTERCARD INC CLASS A 5.6% $199.31 $195.2 $195.2 $186.6 2.0  (22%) 4
GS GOLDMAN SACHS GROUP INC 2.7% $233.65 $233.1 $233.1 $240.6 2.0  (-6%) -2
USB US BANCORP 2.5% $50.93 $50.9 $50.9 $50.8 2.1  (-6%) 1
MS MORGAN STANLEY 2.3% $51.31 $52.3 $52.3 $52.9 1.8  (32%) -2
AXP AMERICAN EXPRESS 2.3% $99.76 $100.5 $100.5 $98.6 2.4  (-16%) 3
PNC PNC FINANCIAL SERVICES GROUP INC 2.2% $141.84 $146.9 $146.9 $147.2 2.8  (-2%) -1
SCHW CHARLES SCHWAB CORP 2.2% $56.61 $57.5 $57.5 $55.9 4.8  (24%) 2
BLK BLACKROCK INC 2.1% $523.36 $539.8 $539.8 $531.3 2.7  (3%) -1
BK BANK OF NEW YORK MELLON CORP 1.8% $56.80 $56.7 $56.7 $55.2 3.8  (-6%) 2
CME CME GROUP INC CLASS A 1.7% $168.86 $165.7 $165.7 $162.7 3.8  (-4%) 4
SPGI S&P GLOBAL INC 1.6% $207.29 $202.2 $202.2 $196.3 2.8  (-9%) 4
COF CAPITAL ONE FINANCIAL CORP 1.4% $96.28 $95.5 $95.5 $94.6 1.3  (-8%) 1
ICE INTERCONTINENTAL EXCHANGE INC 1.4% $74.52 $73.0 $73.0 $72.5 1.7  (-7%) 1
BBT BB AND T CORP 1.3% $52.44 $54.1 $54.1 $53.5 3.0  (-15%) -1
STT STATE STREET CORP 1.2% $98.26 $99.1 $99.1 $99.8 3.5  (1%) -2
STI SUNTRUST BANKS INC 1.0% $68.89 $69.1 $69.1 $68.2 4.7  (-1%) 1
TROW T ROWE PRICE GROUP INC 0.9% $123.66 $123.0 $123.0 $115.9 6.3  (0%) 5
MCO MOODYS CORP 0.9% $175.93 $174.9 $174.9 $169.1 4.7  (-4%) 3
MTB M&T BANK CORP 0.9% $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.8% $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 CORP TRUST 0.7% $106.95 $106.4 $106.4 $106.0 1.6  (-8%) 2
KEY KEYCORP 0.7% $20.53 $20.2 $20.2 $20.0 1.5  (-20%) 1
RF REGIONS FINANCIAL CORP 0.7% $18.62 $18.9 $18.9 $18.8 1.8  (-1%) -1
CFG CITIZENS FINANCIAL GROUP INC 0.7% $41.40 $41.6 $41.6 $41.8 2.2  (3%) -3
AMP AMERIPRISE FINANCE INC 0.6% $147.65 $142.3 $142.3 $141.1 1.7  (25%) 1
CMA COMERICA INC 0.5% $95.18 $96.8 $96.8 $96.3 3.6  (4%) -1
ETFC E TRADE FINANCIAL CORP 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 INC 0.5% $15.42 $15.3 $15.3 $15.0 1.4  (-12%) 2
AMTD TD AMERITRADE HOLDING CORP 0.5% $59.99 $60.7 $60.7 $60.0 4.4  (14%) 0
FRC FIRST REPUBLIC BANK 0.5% $100.06 $100.5 $100.5 $96.3 13.0  (2%) 4
MSCI MSCI INC 0.4% $172.35 $162.8 $162.8 $156.0 1.9  (28%) 4
CBOE CBOE GLOBAL MARKETS INC 0.4% $103.81 $102.8 $102.8 $105.6 2.9  (6%) -1
ALLY ALLY FINANCIAL INC 0.4% $26.34 $26.6 $26.6 $26.8 5.9  (-2%) -1
RJF RAYMOND JAMES INC 0.4% $98.45 $99.2 $99.2 $93.1 3.2  (7%) 3
IVZ INVESCO LTD 0.4% $27.21 $27.9 $27.9 $29.0 1.4  (-10%) -2
ZION ZIONS BANCORPORATION 0.4% $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
NDAQ NASDAQ INC 0.3% $94.77 $93.1 $93.1 $89.8 3.2  (29%) 4
FNF FIDELITY NATIONAL FINANCIAL INC 0.3% $38.21 $37.9 $37.9 $38.0 6.1  (6%) 1
EWBC EAST WEST BANCORP INC 0.3% $70.18 $71.1 $71.1 $67.8 3.2  (11%) 3
AMG AFFILIATED MANAGERS GROUP INC 0.3% $155.51 $163.1 $163.1 $166.7 2.2  (2%) -2
SEIC SEI INVESTMENTS 0.3% $65.71 $65.5 $65.5 $66.6 3.4  (30%) -2
MKTX MARKETAXESS HOLDINGS INC 0.2% $217.31 $212.6 $212.6 $207.0 13.8  (8%) 4
FDS FACTSET RESEARCH SYSTEMS INC 0.2% $213.38 $204.4 $204.4 $198.3 7.9  (-0%) 3
SBNY SIGNATURE BANK 0.2% $126.06 $129.2 $129.2 $131.2 3.7  (4%) -2
LAZ LAZARD LTD CLASS A 0.2% $53.69 $53.3 $53.3 $53.4 2.4  (21%) -1
CIT CIT GROUP INC 0.2% $51.34 $52.3 $52.3 $52.6 3.8  (-5%) -2
CFR CULLEN FROST BANKERS INC 0.2% $113.58 $116.7 $116.7 $113.6 3.9  (-30%) 3
PACW PACWEST BANCORP 0.2% $54.25 $54.4 $54.4 $52.5 5.6  (-5%) 4
EV EATON VANCE COM NON VOTING CORP 0.2% $54.89 $55.6 $55.6 $55.5 5.5  (-12%) 1
PBCT PEOPLES UNITED FINANCIAL INC 0.2% $18.79 $18.8 $18.8 $18.6 6.6  (-11%) 2
SNV SYNOVUS FINANCIAL CORP 0.2% $55.73 $55.2 $55.2 $53.1 3.8  (-7%) 4
FHN FIRST HORIZON NATIONAL CORP 0.2% $19.10 $19.0 $19.0 $18.9 2.9  (-25%) 1
CBSH COMMERCE BANCSHARES INC 0.2% $65.51 $65.5 $65.5 $64.1 11.4  (-4%) 4
NYCB NEW YORK COMMUNITY BANCORP INC 0.2% $11.54 $11.8 $11.8 $12.1 10.4  (-2%) 0
WAL WESTERN ALLIANCE 0.2% $61.88 $61.8 $61.8 $60.1 3.6  (7%) 2
OZRK BANK OF OZARKS 0.2% $48.72 $48.6 $48.6 $47.9 16.6  (-5%) 2
JHG JANUS HENDERSON GROUP PLC 0.2% $31.57 $31.9 $31.9 $32.1 6.3  (55%) -1
WBS WEBSTER FINANCIAL CORP 0.2% $66.04 $65.6 $65.6 $61.9 14.5  (3%) 5
STL STERLING BAN 0.2% $24.60 $24.8 $24.8 $23.9 10.2  (17%) 2
LPLA LPL FINANCIAL HOLDINGS INC 0.2% $70.04 $70.5 $70.5 $65.6 1.7  (3%) 3
UMPQ UMPQUA HOLDINGS CORP 0.2% $23.95 $24.0 $24.0 $23.4 2.7  (-25%) 3
WTFC WINTRUST FINANCIAL CORP 0.2% $94.34 $94.8 $94.8 $92.2 2.8  (-15%) 3
PB PROSPERITY BANCSHARES INC 0.2% $72.02 $74.1 $74.1 $73.6 8.9  (-9%) 1
SLM SLM CORP 0.2% $11.61 $11.7 $11.7 $11.6 7.6  (-9%) 3
TCBI TEXAS CAPITAL BANCSHARES INC 0.2% $100.05 $99.5 $99.5 $97.7 7.3  (-1%) 4
BPOP POPULAR INC 0.2% $46.51 $46.7 $46.7 $45.8 4.4  (-16%) 2
PNFP PINNACLE FINANCIAL PARTNERS INC 0.2% $65.50 $66.5 $66.5 $65.3 8.7  (-7%) 3
ASB ASSOCIATED BANCORP 0.2% $28.10 $27.9 $27.9 $26.6 4.9  (26%) 4
BKU BANKUNITED INC 0.1% $43.77 $43.0 $43.0 $41.3 3.2  (3%) 4
TCF TCF FINANCIAL CORP 0.1% $26.36 $26.5 $26.5 $25.1 3.0  (-22%) 3
EVR EVERCORE INC CLASS A 0.1% $110.95 $108.7 $108.7 $102.6 3.8  (2%) 3
CACC CREDIT ACCEPTANCE CORP 0.1% $362.00 $359.7 $359.7 $340.4 18.7  (-6%) 5
FNB FNB CORP 0.1% $13.79 $13.7 $13.7 $13.4 6.5  (-5%) 2
SF STIFEL FINANCIAL CORP 0.1% $59.45 $60.2 $60.2 $59.2 8.1  (32%) 2
IBKC IBERIABANK CORP 0.1% $80.55 $81.1 $81.1 $78.8 2.4  (43%) 1
CHFC CHEMICAL FINANCIAL CORP 0.1% $58.64 $57.6 $57.6 $56.3 8.2  (-6%) 4
MTG MGIC INVESTMENT CORP 0.1% $10.97 $10.8 $10.8 $10.8 1.4  (-4%) 1
FCNCA FIRST CITIZENS BANCSHARES INC CLAS 0.1% $435.13 $443.2 $443.2 $434.6 2.2  (-14%) 1
HOMB HOME BANCSHARES INC 0.1% $22.71 $23.3 $23.3 $23.2 12.0  (-0%) 0
MBFI MB FINANCIAL INC 0.1% $49.71 $49.6 $49.6 $45.4 8.8  (6%) 5
UBSI UNITED BANKSHARES INC 0.1% $36.75 $36.8 $36.8 $35.5 20.1  (-4%) 4
BOH BANK OF HAWAII CORP. 0.1% $85.47 $86.2 $86.2 $84.9 8.2  (1%) 3
NAVI NAVIENT CORP 0.1% $13.49 $14.3 $14.3 $13.8 3.4  (-9%) 1
ISBC INVESTORS BANCORP INC 0.1% $13.38 $13.5 $13.5 $13.5 4.7  (0%) -1
FFIN FIRST FINANCIAL BANKSHARES INC 0.1% $53.40 $53.6 $53.6 $51.2 36.9  (0%) 4
BGCP BGC PARTNERS INC CLASS A 0.1% $11.88 $11.7 $11.7 $12.5 0.8  (-21%) -2
UMBF UMB FINANCIAL CORP 0.1% $78.02 $78.5 $78.5 $76.9 6.3  (5%) 4
VLY VALLEY NATIONAL 0.1% $12.65 $12.9 $12.9 $12.6 6.2  (-5%) 2
RDN RADIAN GROUP INC 0.1% $16.70 $16.4 $16.4 $16.2 0.9  (18%) 2
LM LEGG MASON INC 0.1% $35.86 $37.8 $37.8 $38.4 7.4  (4%) -1
CATY CATHAY GENERAL BANCORP 0.1% $42.48 $42.8 $42.8 $41.4 3.0  (-9%) 2
FULT FULTON FINANCIAL CORP 0.1% $17.05 $17.5 $17.5 $17.4 4.9  (15%) -0
GBCI GLACIER BANCORP INC 0.1% $39.79 $40.0 $40.0 $38.9 23.4  (2%) 2
ESNT ESSENT GROUP LTD 0.1% $37.11 $35.8 $35.8 $35.9 1.7  (51%) 1
FNGN FINANCIAL ENGINES INC 0.1% $44.90 $44.8 $44.8 $41.0 0.6  (-70%) 3
BXS BANCORPSOUTH 0.1% $34.00 $34.4 $34.4 $33.4 10.3  (33%) 4
WAFD WASHINGTON FEDERAL INC 0.1% $32.90 $33.0 $33.0 $32.7 5.1  (-8%) 2
BOKF BOK FINANCIAL CORP 0.1% $102.09 $103.3 $103.3 $102.5 5.6  (-2%) 2
FII FEDERATED INVESTORS INC CLASS B 0.1% $23.68 $24.5 $24.5 $27.1 6.7  (-16%) 0
IBOC INTERNATIONAL BANCSHARES CORP 0.1% $43.50 $43.6 $43.6 $41.7 2.7  (1%) 3
TRMK TRUSTMARK CORP 0.1% $32.63 $32.8 $32.8 $32.0 13.5  (8%) 4
CFFN CAPITOL FEDERAL FINANCIAL INC 0.1% $13.17 $13.2 $13.2 $12.9 10.8  (3%) 4
PRAA PRA GROUP INC 0.1% $41.05 $40.0 $40.0 $38.4 26.1  (-0%) 5
WDR WADDELL AND REED FINANCIAL INC CLA 0.1% $19.38 $19.7 $19.7 $19.6 9.6  (-1%) 0
LC LENDINGCLUB CORP 0.0% $3.82 $3.5 $3.5 $3.3 4.2  (1%) 1