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

IGV Conmponent Weighting

Ticker
Symbol
Company Name ETF Weight Close Price 10-Day 20-Day 50-Day Short Int Ratio Technical Score
ADBE ADOBE SYSTEM INC 9.0% $258.10 $247.6 $247.6 $235.6 2.8  (22%) 4
MSFT MICROSOFT CORP 8.7% $101.42 $99.7 $99.7 $96.6 2.0  (-3%) 4
CRM SALESFORCE.COM INC 8.5% $138.41 $131.0 $131.0 $126.2 4.4  (-7%) 3
ORCL ORACLE CORP 7.7% $45.90 $47.2 $47.2 $46.5 2.9  (-8%) -1
ATVI ACTIVISION BLIZZARD INC 6.5% $77.71 $73.0 $73.0 $69.9 1.1  (-13%) 2
INTU INTUIT INC 5.0% $209.08 $201.3 $201.3 $189.7 2.6  (-7%) 4
EA ELECTRONIC ARTS INC 4.3% $144.39 $135.2 $135.2 $127.8 1.6  (34%) 3
RHT RED HAT INC 3.6% $175.90 $167.4 $167.4 $163.9 3.4  (-7%) 3
NOW SERVICENOW INC 3.6% $185.34 $178.4 $178.4 $172.9 4.8  (2%) 3
ADSK AUTODESK INC 3.5% $138.41 $135.5 $135.5 $132.3 4.3  (13%) 2
WDAY WORKDAY INC CLASS A 2.2% $128.20 $128.8 $128.8 $129.0 9.9  (-3%) -1
SYMC SYMANTEC CORP 2.2% $21.36 $21.3 $21.3 $24.6 1.2  (-13%) -1
SPLK SPLUNK INC 1.9% $119.50 $115.1 $115.1 $109.5 3.9  (5%) 3
DVMT DELL TECHNOLOGIES CLASS V INC 1.8% $87.91 $83.7 $83.7 $77.2 3.6  (-6%) 4
CTXS CITRIX SYSTEMS INC 1.7% $106.82 $106.7 $106.7 $102.8 2.7  (-14%) 3
ANSS ANSYS INC 1.7% $176.92 $167.7 $167.7 $164.6 3.5  (-0%) 4
SNPS SYNOPSYS INC 1.6% $90.87 $89.6 $89.6 $87.3 2.1  (1%) 2
TTWO TAKE TWO INTERACTIVE SOFTWARE INC 1.5% $121.84 $113.9 $113.9 $107.6 1.6  (45%) 2
CDNS CADENCE DESIGN SYSTEMS INC 1.4% $44.94 $43.1 $43.1 $40.7 2.3  (-4%) 4
CA CA INC 1.4% $37.06 $35.9 $35.9 $35.1 4.4  (6%) 4
PTC PTC INC 1.2% $95.33 $87.7 $87.7 $84.9 3.8  (-8%) 3
OTEX OPEN TEXT CORP 1.2% $35.97 $35.1 $35.1 $35.1 8.0  (-1%) 3
SSNC SS AND C TECHNOLOGIES HOLDINGS INC 1.2% $53.02 $51.0 $51.0 $50.0 1.4  (-13%) 2
VMW VMWARE INC CLASS A 1.1% $150.25 $142.9 $142.9 $136.3 10.8  (-6%) 5
CDK CDK GLOBAL INC 1.0% $65.86 $64.5 $64.5 $64.6 5.5  (-4%) 2
FTNT FORTINET INC 1.0% $65.74 $61.5 $61.5 $58.5 3.1  (20%) 4
TYL TYLER TECHNOLOGIES INC 1.0% $237.00 $230.8 $230.8 $224.6 5.8  (-13%) 4
ULTI ULTIMATE SOFTWARE GROUP INC 0.9% $275.61 $265.8 $265.8 $255.5 5.2  (-6%) 5
GWRE GUIDEWIRE SOFTWARE INC 0.9% $92.29 $92.3 $92.3 $88.4 10.9  (10%) 3
AZPN ASPEN TECHNOLOGY INC 0.8% $99.79 $95.3 $95.3 $90.5 3.2  (-1%) 4
PFPT PROOFPOINT INC 0.8% $126.52 $121.9 $121.9 $122.0 6.9  (2%) 3
DATA TABLEAU SOFTWARE INC CLASS A 0.7% $102.04 $98.2 $98.2 $90.7 2.5  (8%) 4
BB BLACKBERRY LTD 0.7% $12.22 $11.9 $11.9 $11.2 12.7  (3%) 2
ZEN ZENDESK INC 0.7% $59.43 $56.6 $56.6 $52.9 2.3  (12%) 3
FICO FAIR ISAAC CORP 0.7% $200.72 $188.0 $188.0 $178.7 3.0  (-10%) 4
PAYC PAYCOM SOFTWARE INC 0.6% $113.67 $105.8 $105.8 $108.2 6.7  (0%) 2
BLKB BLACKBAUD INC 0.6% $107.72 $100.9 $100.9 $102.6 13.5  (-4%) 2
RNG RINGCENTRAL INC CLASS A 0.6% $77.90 $75.7 $75.7 $71.5 3.9  (8%) 3
NUAN NUANCE COMMUNICATIONS INC 0.5% $14.49 $13.8 $13.8 $14.3 1.3  (13%) 1
HUBS HUBSPOT INC 0.5% $134.65 $123.3 $123.3 $115.8 5.8  (-4%) 5
ELLI ELLIE MAE INC 0.4% $113.40 $107.1 $107.1 $100.4 10.0  (3%) 5
FEYE FIREEYE INC 0.4% $17.30 $17.1 $17.1 $17.6 2.9  (-2%) 0
RP REALPAGE INC 0.4% $59.90 $58.9 $58.9 $56.7 3.2  (-10%) 2
MANH MANHATTAN ASSOCIATES INC 0.4% $47.71 $44.4 $44.4 $43.6 21.3  (3%) 4
ZNGA ZYNGA INC CLASS A 0.4% $4.37 $4.3 $4.3 $3.9 2.2  (52%) 4
CVLT COMMVAULT SYSTEMS INC 0.4% $71.45 $69.4 $69.4 $68.9 2.1  (-15%) 4
ACIW ACI WORLDWIDE INC 0.3% $25.79 $24.6 $24.6 $24.1 8.5  (16%) 5
VRNT VERINT SYSTEMS INC 0.3% $45.80 $43.4 $43.4 $42.3 3.0  (-4%) 4
SNAP SNAP INC CLASS A 0.3% $13.87 $11.9 $11.9 $12.7 2.5  (18%) 1
QLYS QUALYS INC 0.3% $94.80 $79.9 $79.9 $78.4 6.5  (-3%) 5
PEGA PEGASYSTEMS INC 0.3% $62.20 $62.2 $62.2 $62.2 1.2  (10%) -1
EBIX EBIX INC 0.2% $79.00 $75.5 $75.5 $76.6 22.2  (-1%) 0
PRGS PROGRESS SOFTWARE CORP 0.2% $39.24 $38.2 $38.2 $38.0 5.9  (-14%) 2
TIVO TIVO CORP 0.2% $14.45 $14.2 $14.2 $14.2 4.6  (-1%) 2
BL BLACKLINE INC 0.2% $48.86 $42.9 $42.9 $41.5 5.2  (18%) 5
PCTY PAYLOCITY HOLDING CORP 0.2% $61.59 $59.8 $59.8 $56.8 4.2  (16%) 4
IMPV IMPERVA INC 0.2% $52.45 $49.0 $49.0 $47.5 4.7  (6%) 3
VRNS VARONIS SYSTEMS INC 0.2% $80.95 $77.4 $77.4 $71.2 1.3  (24%) 4
MSTR MICROSTRATEGY INC CLASS A 0.2% $133.16 $130.9 $130.9 $130.2 2.5  (0%) 1