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% $28.81 $28.8 $28.8 $27.4 1.6  (-16%) 2
MMP Magellan Midstream Partners LP 10.5% $70.30 $69.8 $69.8 $67.2 4.8  (1%) 3
ETP Energy Transfer Partners LP 9.9% $19.14 $19.1 $19.1 $18.3 2.1  (-23%) 3
MPLX MPLX LP 8.7% $35.36 $36.1 $36.1 $34.9 6.2  (20%) 3
PAA Plains All American Pipeline LP 8.5% $25.21 $24.3 $24.3 $24.2 4.1  (-27%) 4
WPZ Williams Partners LP 8.0% $40.87 $40.2 $40.2 $37.7 2.7  (3%) 3
BPL Buckeye Partners LP 5.2% $36.43 $36.9 $36.9 $38.7 3.0  (-7%) -2
WES Western Gas Partners LP 4.1% $51.11 $51.7 $51.7 $49.0 3.5  (-6%) 2
ANDX Andeavor Logistics LP 3.2% $44.07 $43.9 $43.9 $44.9 1.4  (-27%) -3
DCP DCP Midstream LP 2.9% $40.01 $40.8 $40.8 $38.3 3.8  (5%) 3
EQM EQT Midstream Partners LP 2.8% $57.13 $56.9 $56.9 $57.0 2.6  (-21%) 1
SEP Spectra Energy Partners LP 2.5% $31.81 $31.0 $31.0 $32.7 3.8  (-22%) -2
SHLX Shell Midstream Partners LP 2.3% $22.70 $23.2 $23.2 $22.3 3.3  (-29%) 1
PSXP Phillips 66 Partners LP 2.2% $52.75 $52.2 $52.2 $50.7 9.0  (-13%) 4
ENLK EnLink Midstream Partners LP 2.1% $16.61 $16.8 $16.8 $15.5 4.6  (-9%) 3
AM Antero Midstream Partners LP 2.0% $30.87 $30.1 $30.1 $27.8 10.1  (18%) 5
GEL Genesis Energy LP 2.0% $23.12 $22.6 $22.6 $21.7 9.6  (-8%) 5
EEP Enbridge Energy Partners LP 2.0% $10.25 $10.0 $10.0 $10.0 2.9  (6%) 1
TEP Tallgrass Energy Partners LP 1.6% $43.98 $44.0 $44.0 $42.7 19.7  (-9%) 4
TCP TC PipeLines LP 1.6% $24.82 $24.9 $24.9 $28.2 1.5  (-49%) -1
NS NuStar Energy LP 1.4% $24.11 $24.2 $24.2 $22.4 4.8  (-5%) 3
NGL NGL Energy Partners LP 1.2% $12.25 $11.4 $11.4 $11.5 4.2  (-24%) 2
BWP Boardwalk Pipeline Partners LP 1.2% $10.22 $10.6 $10.6 $10.5 0.9  (-8%) -1
RMP Rice Midstream Partners LP 1.2% $18.90 $18.8 $18.8 $18.3 2.9  (-25%) 2
HEP Holly Energy Partners LP 1.0% $29.37 $29.4 $29.4 $29.1 7.1  (-9%) 1
DM Dominion Energy Midstream Partners LP 0.6% $13.35 $13.5 $13.5 $14.4 1.9  (17%) -2