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

AMLP Conmponent Weighting

Ticker
Symbol
Company Name ETF Weight Close Price 10-Day 20-Day 50-Day Short Int Ratio Technical Score
EPD Enterprise Products Partners LP 10.5% $29.51 $29.0 $29.0 $28.6 1.7  (-9%) 3
MMP Magellan Midstream Partners LP 10.5% $71.70 $70.0 $70.0 $69.6 4.7  (4%) 3
ETP Energy Transfer Partners LP 9.9% $23.28 $21.2 $21.2 $19.9 1.7  (18%) 4
MPLX MPLX LP 8.7% $38.71 $35.8 $35.8 $35.4 3.3  (-4%) 4
PAA Plains All American Pipeline LP 8.5% $26.84 $24.6 $24.6 $24.3 4.1  (7%) 4
WPZ Williams Partners LP 8.0% $47.55 $44.2 $44.2 $42.0 1.6  (31%) 4
BPL Buckeye Partners LP 5.2% $40.09 $35.4 $35.4 $35.7 1.8  (5%) 1
WES Western Gas Partners LP 4.1% $52.43 $50.8 $50.8 $50.2 3.8  (15%) 2
ANDX Andeavor Logistics LP 3.2% $49.40 $44.7 $44.7 $43.8 2.4  (-4%) 3
DCP DCP Midstream LP 2.9% $45.57 $43.6 $43.6 $41.5 2.9  (14%) 4
EQM EQT Midstream Partners LP 2.8% $55.59 $53.4 $53.4 $54.3 2.6  (21%) 1
SEP Spectra Energy Partners LP 2.5% $38.10 $36.4 $36.4 $33.9 2.0  (6%) 4
SHLX Shell Midstream Partners LP 2.3% $22.18 $22.8 $22.8 $22.7 2.7  (23%) 0
PSXP Phillips 66 Partners LP 2.2% $54.25 $52.8 $52.8 $52.2 6.2  (8%) 4
ENLK EnLink Midstream Partners LP 2.1% $18.01 $16.3 $16.3 $16.3 2.2  (38%) 4
AM Antero Midstream Partners LP 2.0% $32.42 $31.6 $31.6 $30.9 6.4  (6%) 5
GEL Genesis Energy LP 2.0% $23.11 $23.1 $23.1 $22.8 7.2  (-7%) 3
EEP Enbridge Energy Partners LP 2.0% $11.58 $11.1 $11.1 $10.6 2.4  (-8%) 4
TCP TC PipeLines LP 1.6% $33.07 $30.4 $30.4 $27.5 3.2  (61%) 3
NS NuStar Energy LP 1.4% $28.05 $25.5 $25.5 $24.8 3.6  (-24%) 4
NGL NGL Energy Partners LP 1.2% $12.75 $12.5 $12.5 $12.3 2.3  (15%) 4
HEP Holly Energy Partners LP 1.0% $32.64 $30.4 $30.4 $29.6 2.6  (-4%) 4
DM Dominion Energy Midstream Partners LP 0.6% $16.00 $15.4 $15.4 $14.2 1.1  (81%) 3