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% $253.80 $255.5 $255.5 $251.3 1.4  (-8%) 2
MSFT MICROSOFT CORP 8.7% $109.67 $107.2 $107.2 $103.2 1.4  (-2%) 4
CRM SALESFORCE.COM INC 8.5% $145.82 $145.1 $145.1 $139.9 2.4  (-25%) 2
ORCL ORACLE CORP 7.7% $48.54 $48.5 $48.5 $47.0 2.5  (10%) 2
ATVI ACTIVISION BLIZZARD INC 6.5% $70.50 $76.4 $76.4 $75.9 1.7  (-10%) -2
INTU INTUIT INC 5.0% $211.19 $212.2 $212.2 $208.7 2.4  (-7%) 3
EA ELECTRONIC ARTS INC 4.3% $127.82 $138.8 $138.8 $139.9 1.1  (10%) -1
RHT RED HAT INC 3.6% $144.72 $145.5 $145.5 $152.0 4.1  (3%) -2
NOW SERVICENOW INC 3.6% $188.34 $187.0 $187.0 $182.9 4.8  (-3%) 2
ADSK AUTODESK INC 3.5% $135.11 $134.0 $134.0 $134.4 4.4  (3%) 1
WDAY WORKDAY INC CLASS A 2.2% $136.53 $132.3 $132.3 $128.7 9.6  (-0%) 2
SYMC SYMANTEC CORP 2.2% $19.23 $20.6 $20.6 $20.9 2.0  (-6%) -1
SPLK SPLUNK INC 1.9% $105.36 $103.7 $103.7 $107.0 2.1  (-12%) 1
DVMT DELL TECHNOLOGIES CLASS V INC 1.8% $94.73 $94.0 $94.0 $90.6 4.2  (-4%) 2
CTXS CITRIX SYSTEMS INC 1.7% $111.18 $110.2 $110.2 $108.0 5.8  (-7%) 5
ANSS ANSYS INC 1.7% $172.01 $176.0 $176.0 $175.0 2.8  (-14%) 1
SNPS SYNOPSYS INC 1.6% $93.42 $91.8 $91.8 $89.9 2.2  (17%) 3
TTWO TAKE TWO INTERACTIVE SOFTWARE INC 1.5% $125.20 $123.5 $123.5 $119.7 1.3  (-25%) 2
CDNS CADENCE DESIGN SYSTEMS INC 1.4% $45.33 $45.2 $45.2 $44.5 3.1  (-6%) 2
CA CA INC 1.4% $43.36 $44.0 $44.0 $39.4 1.9  (5%) 4
PTC PTC INC 1.2% $93.70 $95.8 $95.8 $94.2 9.8  (297%) 1
OTEX OPEN TEXT CORP 1.2% $39.32 $38.1 $38.1 $36.6 11.2  (3%) 5
SSNC SS AND C TECHNOLOGIES HOLDINGS INC 1.2% $55.53 $54.9 $54.9 $53.6 3.6  (-5%) 4
VMW VMWARE INC CLASS A 1.1% $153.76 $151.4 $151.4 $150.4 8.2  (-18%) 4
CDK CDK GLOBAL INC 1.0% $64.11 $64.7 $64.7 $65.1 4.4  (-13%) -1
FTNT FORTINET INC 1.0% $74.55 $68.8 $68.8 $65.7 4.6  (-11%) 4
TYL TYLER TECHNOLOGIES INC 1.0% $233.49 $234.2 $234.2 $232.2 6.9  (1%) 2
ULTI ULTIMATE SOFTWARE GROUP INC 0.9% $282.73 $285.5 $285.5 $274.7 5.7  (-19%) 4
GWRE GUIDEWIRE SOFTWARE INC 0.9% $94.40 $92.2 $92.2 $91.8 7.1  (-12%) 2
AZPN ASPEN TECHNOLOGY INC 0.8% $105.70 $99.5 $99.5 $97.0 2.6  (6%) 4
PFPT PROOFPOINT INC 0.8% $118.01 $121.4 $121.4 $120.9 2.7  (35%) -1
DATA TABLEAU SOFTWARE INC CLASS A 0.7% $103.67 $107.6 $107.6 $103.2 5.5  (-6%) 3
BB BLACKBERRY LTD 0.7% $10.46 $10.1 $10.1 $10.8 8.1  (4%) 1
ZEN ZENDESK INC 0.7% $62.96 $60.6 $60.6 $58.3 3.9  (10%) 4
FICO FAIR ISAAC CORP 0.7% $213.21 $206.5 $206.5 $199.5 2.4  (-8%) 4
PAYC PAYCOM SOFTWARE INC 0.6% $133.85 $118.3 $118.3 $111.1 10.6  (-1%) 5
BLKB BLACKBAUD INC 0.6% $96.47 $109.4 $109.4 $106.8 10.4  (3%) 0
RNG RINGCENTRAL INC CLASS A 0.6% $87.05 $81.1 $81.1 $77.2 4.2  (21%) 3
NUAN NUANCE COMMUNICATIONS INC 0.5% $16.82 $15.4 $15.4 $14.6 6.4  (9%) 4
HUBS HUBSPOT INC 0.5% $129.25 $130.1 $130.1 $130.2 7.5  (-11%) 1
ELLI ELLIE MAE INC 0.4% $105.87 $105.4 $105.4 $107.0 9.6  (8%) 1
FEYE FIREEYE INC 0.4% $15.23 $16.2 $16.2 $16.4 7.3  (5%) 0
RP REALPAGE INC 0.4% $59.15 $58.0 $58.0 $57.7 4.1  (9%) 3
MANH MANHATTAN ASSOCIATES INC 0.4% $50.97 $49.7 $49.7 $48.2 15.4  (3%) 4
ZNGA ZYNGA INC CLASS A 0.4% $3.86 $4.1 $4.1 $4.2 3.7  (4%) 0
CVLT COMMVAULT SYSTEMS INC 0.4% $67.20 $67.0 $67.0 $68.3 1.5  (-8%) -1
ACIW ACI WORLDWIDE INC 0.3% $27.36 $26.6 $26.6 $25.9 18.4  (-2%) 5
VRNT VERINT SYSTEMS INC 0.3% $46.70 $47.1 $47.1 $45.8 3.5  (-16%) 2
SNAP SNAP INC CLASS A 0.3% $12.31 $13.0 $13.0 $13.0 7.0  (3%) 0
QLYS QUALYS INC 0.3% $88.45 $91.7 $91.7 $88.9 7.6  (-3%) 3
PEGA PEGASYSTEMS INC 0.3% $59.20 $58.0 $58.0 $58.9 3.0  (11%) 0
EBIX EBIX INC 0.2% $79.30 $81.6 $81.6 $79.1 36.0  (3%) 2
PRGS PROGRESS SOFTWARE CORP 0.2% $38.31 $38.8 $38.8 $38.5 2.7  (-0%) 0
TIVO TIVO CORP 0.2% $12.35 $12.3 $12.3 $13.3 10.5  (2%) 0
BL BLACKLINE INC 0.2% $47.75 $46.9 $46.9 $45.9 7.8  (-2%) 5
PCTY PAYLOCITY HOLDING CORP 0.2% $64.05 $63.6 $63.6 $62.1 8.1  (-4%) 4
IMPV IMPERVA INC 0.2% $45.90 $51.6 $51.6 $50.5 3.0  (-11%) -1
VRNS VARONIS SYSTEMS INC 0.2% $68.30 $73.5 $73.5 $76.2 0.7  (-27%) -1
MSTR MICROSTRATEGY INC CLASS A 0.2% $139.75 $135.2 $135.2 $133.2 2.8  (21%) 4