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% $116.88 $113.8 $113.8 $109.8 1.5  (17%) 2
BAC BANK OF AMERICA CORP 9.2% $31.60 $30.7 $30.7 $29.7 2.0  (24%) 2
WFC WELLS FARGO 7.5% $58.44 $57.7 $57.7 $56.1 1.6  (-7%) 4
V VISA INC CLASS A 7.4% $140.01 $140.0 $140.0 $136.3 3.9  (10%) 3
C CITIGROUP INC 5.7% $71.98 $70.8 $70.8 $68.6 1.2  (5%) 2
MA MASTERCARD INC CLASS A 5.6% $203.60 $205.0 $205.0 $201.1 1.8  (2%) 3
GS GOLDMAN SACHS GROUP INC 2.7% $233.78 $233.8 $233.8 $230.0 1.3  (15%) 1
USB US BANCORP 2.5% $53.48 $52.1 $52.1 $51.4 1.6  (-1%) 4
MS MORGAN STANLEY 2.3% $49.44 $50.0 $50.0 $49.8 1.4  (26%) 1
AXP AMERICAN EXPRESS 2.3% $102.99 $101.4 $101.4 $99.9 1.4  (-3%) 1
PNC PNC FINANCIAL SERVICES GROUP INC 2.2% $145.22 $143.2 $143.2 $142.1 1.7  (-4%) 2
SCHW CHARLES SCHWAB CORP 2.2% $50.73 $51.7 $51.7 $53.3 3.1  (-7%) -1
BLK BLACKROCK INC 2.1% $484.10 $497.9 $497.9 $512.3 1.8  (-7%) -2
BK BANK OF NEW YORK MELLON CORP 1.8% $52.29 $53.3 $53.3 $54.7 2.2  (31%) 0
CME CME GROUP INC CLASS A 1.7% $162.97 $165.8 $165.8 $166.4 5.8  (3%) 1
SPGI S&P GLOBAL INC 1.6% $200.95 $206.8 $206.8 $205.9 2.9  (-22%) 0
COF CAPITAL ONE FINANCIAL CORP 1.4% $97.62 $96.5 $96.5 $95.6 1.1  (-18%) 1
ICE INTERCONTINENTAL EXCHANGE INC 1.4% $73.23 $74.9 $74.9 $74.4 2.4  (5%) -0
BBT BB AND T CORP 1.3% $51.20 $51.3 $51.3 $51.9 2.4  (17%) -1
STT STATE STREET CORP 1.2% $85.80 $88.8 $88.8 $93.5 0.9  (19%) -1
STI SUNTRUST BANKS INC 1.0% $72.77 $71.3 $71.3 $69.5 2.9  (3%) 4
TROW T ROWE PRICE GROUP INC 0.9% $118.89 $119.8 $119.8 $120.7 5.1  (-8%) 2
MCO MOODYS CORP 0.9% $172.04 $178.9 $178.9 $175.9 2.7  (-1%) 1
MTB M&T BANK CORP 0.9% $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.8% $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 CORP TRUST 0.7% $110.73 $109.2 $109.2 $106.9 1.6  (3%) 4
KEY KEYCORP 0.7% $21.57 $20.8 $20.8 $20.4 1.2  (3%) 4
RF REGIONS FINANCIAL CORP 0.7% $19.28 $18.4 $18.4 $18.4 1.5  (2%) 1
CFG CITIZENS FINANCIAL GROUP INC 0.7% $40.59 $40.2 $40.2 $40.6 2.6  (-4%) -1
AMP AMERIPRISE FINANCE INC 0.6% $139.66 $142.8 $142.8 $143.1 1.8  (-9%) -1
CMA COMERICA INC 0.5% $97.91 $95.3 $95.3 $94.5 1.9  (6%) 2
ETFC E TRADE FINANCIAL CORP 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 INC 0.5% $15.93 $15.4 $15.4 $15.3 3.6  (212%) 4
AMTD TD AMERITRADE HOLDING CORP 0.5% $58.77 $57.8 $57.8 $58.1 3.9  (14%) 1
FRC FIRST REPUBLIC BANK 0.5% $101.08 $99.6 $99.6 $99.8 14.4  (4%) 3
MSCI MSCI INC 0.4% $173.17 $170.9 $170.9 $168.8 2.5  (-2%) 3
CBOE CBOE GLOBAL MARKETS INC 0.4% $92.10 $100.2 $100.2 $101.8 4.0  (-1%) -1
ALLY ALLY FINANCIAL INC 0.4% $27.71 $27.4 $27.4 $26.8 4.8  (3%) -1
RJF RAYMOND JAMES INC 0.4% $90.80 $93.4 $93.4 $94.6 2.4  (5%) 1
IVZ INVESCO LTD 0.4% $25.49 $25.8 $25.8 $26.6 1.7  (20%) -2
ZION ZIONS BANCORPORATION 0.4% $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
NDAQ NASDAQ INC 0.3% $92.82 $93.7 $93.7 $93.2 3.7  (-8%) 1
FNF FIDELITY NATIONAL FINANCIAL INC 0.3% $39.87 $39.6 $39.6 $38.4 4.9  (-3%) 3
EWBC EAST WEST BANCORP INC 0.3% $64.77 $65.4 $65.4 $67.6 2.0  (-10%) -0
AMG AFFILIATED MANAGERS GROUP INC 0.3% $151.19 $151.7 $151.7 $154.0 1.8  (-25%) -2
SEIC SEI INVESTMENTS 0.3% $59.61 $61.5 $61.5 $63.5 3.5  (9%) -2
MKTX MARKETAXESS HOLDINGS INC 0.2% $185.98 $199.7 $199.7 $205.5 8.4  (-12%) 0
FDS FACTSET RESEARCH SYSTEMS INC 0.2% $214.01 $205.9 $205.9 $206.0 9.9  (-6%) 4
SBNY SIGNATURE BANK 0.2% $111.78 $115.9 $115.9 $123.7 1.2  (-28%) -2
LAZ LAZARD LTD CLASS A 0.2% $52.26 $52.0 $52.0 $51.6 3.7  (59%) 2
CIT CIT GROUP INC 0.2% $53.94 $52.9 $52.9 $51.8 5.5  (-11%) 3
CFR CULLEN FROST BANKERS INC 0.2% $111.38 $112.9 $112.9 $113.0 5.0  (8%) 1
PACW PACWEST BANCORP 0.2% $51.01 $50.4 $50.4 $51.8 3.3  (-15%) 0
EV EATON VANCE COM NON VOTING CORP 0.2% $52.91 $53.2 $53.2 $53.7 5.5  (-8%) 0
PBCT PEOPLES UNITED FINANCIAL INC 0.2% $18.50 $18.4 $18.4 $18.5 7.8  (14%) 1
SNV SYNOVUS FINANCIAL CORP 0.2% $49.61 $51.5 $51.5 $53.5 1.3  (-6%) 0
FHN FIRST HORIZON NATIONAL CORP 0.2% $18.33 $17.8 $17.8 $18.3 2.5  (55%) 2
CBSH COMMERCE BANCSHARES INC 0.2% $69.41 $68.5 $68.5 $66.9 8.2  (-8%) 5
NYCB NEW YORK COMMUNITY BANCORP INC 0.2% $10.72 $11.0 $11.0 $11.3 9.0  (3%) 0
WAL WESTERN ALLIANCE 0.2% $56.55 $57.5 $57.5 $59.1 3.0  (-1%) -2
JHG JANUS HENDERSON GROUP PLC 0.2% $28.81 $30.6 $30.6 $31.1 10.6  (-7%) -1
WBS WEBSTER FINANCIAL CORP 0.2% $67.29 $66.4 $66.4 $65.9 7.1  (-22%) 5
STL STERLING BAN 0.2% $22.15 $22.7 $22.7 $23.7 12.4  (3%) 1
LPLA LPL FINANCIAL HOLDINGS INC 0.2% $66.37 $67.7 $67.7 $68.1 1.6  (-25%) 1
UMPQ UMPQUA HOLDINGS CORP 0.2% $21.37 $22.1 $22.1 $23.0 1.8  (-22%) 0
WTFC WINTRUST FINANCIAL CORP 0.2% $89.25 $89.2 $89.2 $90.9 1.9  (-22%) 1
PB PROSPERITY BANCSHARES INC 0.2% $72.96 $70.0 $70.0 $70.8 6.5  (-1%) 3
SLM SLM CORP 0.2% $11.48 $11.5 $11.5 $11.6 8.9  (-1%) 1
TCBI TEXAS CAPITAL BANCSHARES INC 0.2% $92.15 $92.5 $92.5 $94.6 3.0  (-6%) -1
BPOP POPULAR INC 0.2% $50.51 $49.0 $49.0 $47.4 2.3  (-4%) 3
PNFP PINNACLE FINANCIAL PARTNERS INC 0.2% $63.55 $62.6 $62.6 $63.7 6.0  (13%) 0
ASB ASSOCIATED BANCORP 0.2% $27.10 $27.7 $27.7 $27.9 2.4  (-16%) -1
BKU BANKUNITED INC 0.1% $40.92 $40.0 $40.0 $41.7 3.2  (24%) -1
TCF TCF FINANCIAL CORP 0.1% $25.46 $25.4 $25.4 $25.7 2.4  (-13%) 0
EVR EVERCORE INC CLASS A 0.1% $111.85 $111.7 $111.7 $109.7 3.7  (-3%) 3
CACC CREDIT ACCEPTANCE CORP 0.1% $442.48 $395.6 $395.6 $374.8 23.4  (-1%) 5
FNB FNB CORP 0.1% $13.13 $13.2 $13.2 $13.5 5.7  (5%) 1
SF STIFEL FINANCIAL CORP 0.1% $54.53 $53.9 $53.9 $55.7 7.7  (-2%) 1
IBKC IBERIABANK CORP 0.1% $84.95 $81.6 $81.6 $80.5 3.2  (-6%) 4
CHFC CHEMICAL FINANCIAL CORP 0.1% $57.29 $56.7 $56.7 $57.2 7.1  (-3%) 1
MTG MGIC INVESTMENT CORP 0.1% $12.61 $12.2 $12.2 $11.5 1.8  (43%) 4
FCNCA FIRST CITIZENS BANCSHARES INC CLAS 0.1% $439.75 $414.4 $414.4 $420.3 1.4  (-6%) 1
HOMB HOME BANCSHARES INC 0.1% $23.50 $23.2 $23.2 $23.2 7.3  (8%) 1
MBFI MB FINANCIAL INC 0.1% $48.31 $48.1 $48.1 $48.6 1.3  (-3%) 0
UBSI UNITED BANKSHARES INC 0.1% $38.25 $37.0 $37.0 $37.1 13.4  (3%) 4
BOH BANK OF HAWAII CORP. 0.1% $82.96 $83.1 $83.1 $84.5 6.2  (-7%) 1
NAVI NAVIENT CORP 0.1% $13.33 $13.5 $13.5 $13.6 4.7  (-1%) -0
ISBC INVESTORS BANCORP INC 0.1% $12.66 $12.7 $12.7 $13.0 2.3  (-18%) -1
FFIN FIRST FINANCIAL BANKSHARES INC 0.1% $58.10 $56.1 $56.1 $54.5 27.4  (-1%) 5
BGCP BGC PARTNERS INC CLASS A 0.1% $11.10 $11.0 $11.0 $11.4 1.7  (-7%) -2
UMBF UMB FINANCIAL CORP 0.1% $74.70 $75.5 $75.5 $77.0 3.9  (-4%) 0
VLY VALLEY NATIONAL 0.1% $11.76 $12.3 $12.3 $12.5 6.3  (-7%) 0
RDN RADIAN GROUP INC 0.1% $19.73 $18.2 $18.2 $17.2 0.8  (-10%) 4
LM LEGG MASON INC 0.1% $32.74 $33.2 $33.2 $34.8 3.3  (-2%) -2
CATY CATHAY GENERAL BANCORP 0.1% $42.29 $41.8 $41.8 $42.0 3.5  (8%) 2
FULT FULTON FINANCIAL CORP 0.1% $17.65 $17.3 $17.3 $17.2 4.1  (2%) 2
GBCI GLACIER BANCORP INC 0.1% $43.65 $42.6 $42.6 $41.1 16.6  (1%) 5
ESNT ESSENT GROUP LTD 0.1% $40.46 $38.5 $38.5 $37.4 1.1  (-27%) 4
BXS BANCORPSOUTH 0.1% $34.00 $33.6 $33.6 $33.9 5.9  (-25%) 2
WAFD WASHINGTON FEDERAL INC 0.1% $33.70 $33.6 $33.6 $33.4 8.9  (7%) 3
BOKF BOK FINANCIAL CORP 0.1% $98.96 $98.0 $98.0 $98.6 5.3  (19%) 2
FII FEDERATED INVESTORS INC CLASS B 0.1% $22.91 $23.4 $23.4 $23.7 9.9  (13%) 0
IBOC INTERNATIONAL BANCSHARES CORP 0.1% $45.60 $44.7 $44.7 $44.2 2.9  (-20%) 4
TRMK TRUSTMARK CORP 0.1% $35.10 $34.7 $34.7 $33.7 10.5  (20%) 5
CFFN CAPITOL FEDERAL FINANCIAL INC 0.1% $13.15 $13.1 $13.1 $13.3 15.0  (10%) 0
PRAA PRA GROUP INC 0.1% $37.00 $40.9 $40.9 $40.6 37.8  (4%) 1
WDR WADDELL AND REED FINANCIAL INC CLA 0.1% $20.56 $19.5 $19.5 $19.4 15.7  (-1%) 4
LC LENDINGCLUB CORP 0.0% $3.68 $4.2 $4.2 $4.0 6.2  (4%) 2