2a:null 2b:["$","title",null,{"children":"Financial Service Providers | João Ricardo Mendes | Observable"}] 30:T6b8,html`

The American Financial Markets

Trading Day

by Ajay Phogat

`31:T407,ChunkyWorker = async arr => { const copy = [...arr]; //the API allows us to ask for only 100 symbols in 1 query. //so we use chunks of 50 because we are nice and patient //especially, when using free APIs const chunks = _.chunk(copy, 50); return await Promise.all( chunks.map(async requests => { const url = `https://cloud.iexapis.com/stable/stock/market/batch?token=pk_930da6c1c50b4e33914febac3ab39fcb&symbols=${requests .map(x => x.Symbol) .join()}&types=quote&filter=symbol,companyName,marketCap,changePercent,sector,primaryExchange,latestVolume`; const res = await d3.json(url); const mergedData = Object.keys(res).map(each => { //console.log(requests,) //find the original list(group) and response list matches const match = _.find(requests, x => { //console.log(x,each) return x.Symbol === each; }); // console.log(match); return { ...match, ...res[each].quote }; }); return mergedData; }) ); }32:T6c9,Banner = html`

`33:T7db,dow30_wiki_csv = d3.tsvParse(`Company Exchange Symbol Industry Date Added Notes 3M NYSE MMM Conglomerate 1976-08-09 as Minnesota Mining and Manufacturing American Express NYSE AXP Financial services 1982-08-30 Apple NASDAQ AAPL Information technologies 2015-03-19 Boeing NYSE BA Aerospace and defense 1987-03-12 Caterpillar NYSE CAT Construction and mining equipment 1991-05-06 Chevron NYSE CVX Oil & gas 2008-02-19 also 1930-07-18 to 1999-11-01 Cisco Systems NASDAQ CSCO Information technologies 2009-06-08 Coca-Cola NYSE KO Food 1987-03-12 also 1932-05-26 to 1935-11-20 Dow Inc. NYSE DOW Chemical industry 2019-04-02 ExxonMobil NYSE XOM Oil & gas 1928-10-01 as Standard Oil of New Jersey Goldman Sachs NYSE GS Financial services 2013-09-20 The Home Depot NYSE HD Retail 1999-11-01 IBM NYSE IBM Information technologies 1979-06-29 also 1932-05-26 to 1939-03-04 Intel NASDAQ INTC Information technologies 1999-11-01 Johnson & Johnson NYSE JNJ Pharmaceuticals 1997-03-17 JPMorgan Chase NYSE JPM Financial services 1991-05-06 McDonald's NYSE MCD Food 1985-10-30 Merck & Company NYSE MRK Pharmaceuticals 1979-06-29 Microsoft NASDAQ MSFT Information technologies 1999-11-01 Nike NYSE NKE Apparel 2013-09-20 Pfizer NYSE PFE Pharmaceuticals 2004-04-08 Procter & Gamble NYSE PG Consumer goods 1932-05-26 Travelers NYSE TRV Insurance 2009-06-08 UnitedHealth Group NYSE UNH Managed health care 2012-09-24 United Technologies NYSE UTX Conglomerate 1939-03-14 as United Aircraft Verizon NYSE VZ Telecommunication 2004-04-08 Visa NYSE V Financial services 2013-09-20 Walmart NYSE WMT Retail 1997-03-17 Walgreens Boots Alliance NASDAQ WBA Retail 2018-06-26 Walt Disney NYSE DIS Broadcasting and entertainment 1991-05-06`, function(d){ let cleanD = {}; d3.keys(d).forEach(function(k) { cleanD[_.trim(k)] = _.trim(d[k]); }); return cleanD; })34:Te04f,sp500_wiki_csv=d3.csvParse(`Symbol,Security,SEC filings,GICS Sector,GICS Sub Industry,Headquarters Location,Date first added,CIK,Founded MMM,3M Company,reports,Industrials,Industrial Conglomerates,"St. Paul, Minnesota",,0000066740,1902 ABT,Abbott Laboratories,reports,Health Care,Health Care Equipment,"North Chicago, Illinois",1964-03-31,0000001800,1888 ABBV,AbbVie Inc.,reports,Health Care,Pharmaceuticals,"North Chicago, Illinois",2012-12-31,0001551152,2013 (1888) ABMD,ABIOMED Inc,reports,Health Care,Health Care Equipment,"Danvers, Massachusetts",2018-05-31,0000815094,1981 ACN,Accenture plc,reports,Information Technology,IT Consulting & Other Services,"Dublin, Ireland",2011-07-06,0001467373,1989 ATVI,Activision Blizzard,reports,Communication Services,Interactive Home Entertainment,"Santa Monica, California",2015-08-31,0000718877,2008 ADBE,Adobe Systems Inc,reports,Information Technology,Application Software,"San Jose, California",1997-05-05,0000796343,1982 AMD,Advanced Micro Devices Inc,reports,Information Technology,Semiconductors,"Sunnyvale, California",2017-03-20,0000002488,1969 AAP,Advance Auto Parts,reports,Consumer Discretionary,Automotive Retail,"Raleigh, North Carolina",2015-07-09,0001158449,1932 AES,AES Corp,reports,Utilities,Independent Power Producers & Energy Traders,"Arlington, Virginia",1998-10-02,0000874761,1981 AMG,Affiliated Managers Group Inc,reports,Financials,Asset Management & Custody Banks,"West Palm Beach, Florida",2014-07-01,0001004434,1993 AFL,AFLAC Inc,reports,Financials,Life & Health Insurance,"Columbus, Georgia",1999-05-28,0000004977,1955 A,Agilent Technologies Inc,reports,Health Care,Health Care Equipment,"Santa Clara, California",2000-06-05,0001090872,1999 APD,Air Products & Chemicals Inc,reports,Materials,Industrial Gases,"Allentown, Pennsylvania",1985-04-30,0000002969,1940 AKAM,Akamai Technologies Inc,reports,Information Technology,Internet Services & Infrastructure,"Cambridge, Massachusetts",2007-07-12,0001086222,1998 ALK,Alaska Air Group Inc,reports,Industrials,Airlines,"Seattle, Washington",2016-05-13,0000766421,1985 ALB,Albemarle Corp,reports,Materials,Specialty Chemicals,"Charlotte, North Carolina",2016-07-01,0000915913,1994 ARE,Alexandria Real Estate Equities,reports,Real Estate,Office REITs,"Pasadena, California",2017-03-20,0001035443,1994 ALXN,Alexion Pharmaceuticals,reports,Health Care,Biotechnology,"Boston, Massachusetts",2012-05-25,0000899866,1992 ALGN,Align Technology,reports,Health Care,Health Care Supplies,"San Jose, California",2017-06-19,0001097149,1997 ALLE,Allegion,reports,Industrials,Building Products,"Dublin, Ireland",2013-12-02,0001579241,1908 AGN,"Allergan, Plc",reports,Health Care,Pharmaceuticals,"Dublin, Ireland",1999-04-12,0001578845,1983 ADS,Alliance Data Systems,reports,Information Technology,Data Processing & Outsourced Services,"Plano, Texas",2013-12-23,0001101215,1996 LNT,Alliant Energy Corp,reports,Utilities,Electric Utilities,"Madison, Wisconsin",2016-07-01,0000352541,1917 ALL,Allstate Corp,reports,Financials,Property & Casualty Insurance,"Northfield Township, Illinois",1995-07-13,0000899051,1931 GOOGL,Alphabet Inc Class A,reports,Communication Services,Interactive Media & Services,"Mountain View, California",2014-04-03,0001652044,1998 GOOG,Alphabet Inc Class C,reports,Communication Services,Interactive Media & Services,"Mountain View, California",2006-04-03,0001652044,1998 MO,Altria Group Inc,reports,Consumer Staples,Tobacco,"Richmond, Virginia",,0000764180,1985 AMZN,Amazon.com Inc.,reports,Consumer Discretionary,Internet & Direct Marketing Retail,"Seattle, Washington",2005-11-18,0001018724,1994 AMCR,Amcor plc,reports,Materials,Paper Packaging,"Warmley, Bristol, United Kingdom",2019-06-07,0001748790, AEE,Ameren Corp,reports,Utilities,Multi-Utilities,"St. Louis, Missouri",1991-09-19,0001002910,1902 AAL,American Airlines Group,reports,Industrials,Airlines,"Fort Worth, Texas",2015-03-23,0000006201,1934 AEP,American Electric Power,reports,Utilities,Electric Utilities,"Columbus, Ohio",,0000004904,1906 AXP,American Express Co,reports,Financials,Consumer Finance,"New York, New York",1976-06-30,0000004962,1850 AIG,American International Group,reports,Financials,Property & Casualty Insurance,"New York, New York",1980-03-31,0000005272,1919 AMT,American Tower Corp.,reports,Real Estate,Specialized REITs,"Boston, Massachusetts",2007-11-19,0001053507,1995 AWK,American Water Works Company Inc,reports,Utilities,Water Utilities,"Voorhees, New Jersey",2016-03-04,0001410636,1886 AMP,Ameriprise Financial,reports,Financials,Asset Management & Custody Banks,"Minneapolis, Minnesota",2005-10-03,0000820027,1894 ABC,AmerisourceBergen Corp,reports,Health Care,Health Care Distributors,"Chesterbrook, Pennsylvania",2001-08-30,0001140859,1985 AME,AMETEK Inc.,reports,Industrials,Electrical Components & Equipment,"Berwyn, Pennsylvania",2013-09-23,0001037868,1930 AMGN,Amgen Inc.,reports,Health Care,Biotechnology,"Thousand Oaks, California",1992-01-02,0000318154,1980 APH,Amphenol Corp,reports,Information Technology,Electronic Components,"Wallingford, Connecticut",2008-09-30,0000820313,1932 APC,Anadarko Petroleum Corp,reports,Energy,Oil & Gas Exploration & Production,"The Woodlands, Texas",1997-07-28,0000773910,1959 ADI,"Analog Devices, Inc.",reports,Information Technology,Semiconductors,"Norwood, Massachusetts",1999-10-12,0000006281,1965 ANSS,ANSYS,reports,Information Technology,Application Software,"Canonsburg, Pennsylvania",2017-06-19,0001013462,1969 ANTM,Anthem Inc.,reports,Health Care,Managed Health Care,"Indianapolis, Indiana",2002-07-25,0001156039,2014 (1940s) AON,Aon plc,reports,Financials,Insurance Brokers,"London, United Kingdom",1996-04-23,0000315293,1982 (1919) AOS,A.O. Smith Corp,reports,Industrials,Building Products,"Milwaukee, Wisconsin",2017-07-26,0000091142,1916 APA,Apache Corporation,reports,Energy,Oil & Gas Exploration & Production,"Houston, Texas",1997-07-28,0000006769,1954 AIV,Apartment Investment & Management,reports,Real Estate,Residential REITs,"Denver, Colorado",2003-03-14,0000922864,1994 (1975) AAPL,Apple Inc.,reports,Information Technology,"Technology Hardware, Storage & Peripherals","Cupertino, California",1982-11-30,0000320193,1977 AMAT,Applied Materials Inc.,reports,Information Technology,Semiconductor Equipment,"Santa Clara, California",1995-03-16,0000006951,1967 APTV,Aptiv Plc,reports,Consumer Discretionary,Auto Parts & Equipment,"Gillingham, Kent, United Kingdom",2012-12-24,0001521332,1994 ADM,Archer-Daniels-Midland Co,reports,Consumer Staples,Agricultural Products,"Chicago, Illinois",1981-07-29,0000007084,1902 ARNC,Arconic Inc.,reports,Industrials,Aerospace & Defense,"New York, New York",1964-03-31,0000004281,2016 ANET,Arista Networks,reports,Information Technology,Communications Equipment,"Santa Clara, California",2018-08-28,0001596532,2004 AJG,Arthur J. Gallagher & Co.,reports,Financials,Insurance Brokers,"Itasca, Illinois",2016-05-31,0000354190, AIZ,Assurant,reports,Financials,Multi-line Insurance,"New York, New York",2007-04-10,0001267238, ATO,Atmos Energy Corp,reports,Utilities,Gas Utilities,"Dallas, Texas",2019-02-15,0000731802,1906 T,AT&T Inc.,reports,Communication Services,Integrated Telecommunication Services,"Dallas, Texas",1983-11-30,0000732717,1983 ADSK,Autodesk Inc.,reports,Information Technology,Application Software,"San Rafael, California",1989-12-01,0000769397, ADP,Automatic Data Processing,reports,Information Technology,Internet Services & Infrastructure,"Roseland, New Jersey",1981-03-31,0000008670, AZO,AutoZone Inc,reports,Consumer Discretionary,Specialty Stores,"Memphis, Tennessee",1997-01-02,0000866787, AVB,"AvalonBay Communities, Inc.",reports,Real Estate,Residential REITs,"Arlington, Virginia[3]",2007-01-10,0000915912, AVY,Avery Dennison Corp,reports,Materials,Paper Packaging,"Glendale, California",1987-12-31,0000008818, BHGE,"Baker Hughes, a GE Company",reports,Energy,Oil & Gas Equipment & Services,"Houston, Texas",,0001701605,2017 BLL,Ball Corp,reports,Materials,Metal & Glass Containers,"Broomfield, Colorado",1984-10-31,0000009389, BAC,Bank of America Corp,reports,Financials,Diversified Banks,"Charlotte, North Carolina",1976-06-30,0000070858, BK,The Bank of New York Mellon Corp.,reports,Financials,Asset Management & Custody Banks,"New York, New York",1995-03-31,0001390777, BAX,Baxter International Inc.,reports,Health Care,Health Care Equipment,"Deerfield, Illinois",1972-09-30,0000010456,1931 BBT,BB&T Corporation,reports,Financials,Regional Banks,"Winston-Salem, North Carolina",1997-12-04,0000092230, BDX,Becton Dickinson,reports,Health Care,Health Care Equipment,"Franklin Lakes, New Jersey",1972-09-30,0000010795,1897 BRK.B,Berkshire Hathaway,reports,Financials,Multi-Sector Holdings,"Omaha, Nebraska",2010-02-16,0001067983, BBY,Best Buy Co. Inc.,reports,Consumer Discretionary,Computer & Electronics Retail,"Richfield, Minnesota",1999-06-29,0000764478, BIIB,Biogen Inc.,reports,Health Care,Biotechnology,"Cambridge, Massachusetts",2003-11-13,0000875045, BLK,BlackRock,reports,Financials,Asset Management & Custody Banks,"New York, New York",2011-04-04,0001364742, HRB,Block H&R,reports,Consumer Discretionary,Specialized Consumer Services,"Kansas City, Missouri",1986-11-30,0000012659, BA,Boeing Company,reports,Industrials,Aerospace & Defense,"Chicago, Illinois",,0000012927,1916 BKNG,Booking Holdings Inc,reports,Consumer Discretionary,Internet & Direct Marketing Retail,"Norwalk, Connecticut",2009-11-06,0001075531, BWA,BorgWarner,reports,Consumer Discretionary,Auto Parts & Equipment,"Auburn Hills, Michigan",2011-12-19,0000908255, BXP,Boston Properties,reports,Real Estate,Office REITs,"Boston, Massachusetts",2006-04-03,0001037540, BSX,Boston Scientific,reports,Health Care,Health Care Equipment,"Marlborough, Massachusetts[4]",1995-02-24,0000885725, BMY,Bristol-Myers Squibb,reports,Health Care,Health Care Distributors,"New York, New York",,0000014272,1989 AVGO,Broadcom Inc.,reports,Information Technology,Semiconductors,"San Jose, California",2014-05-08,0001730168, BR,Broadridge Financial Solutions,reports,Information Technology,Data Processing & Outsourced Services,"Lake Success, New York",2018-06-18,0001383312,1962 BF.B,Brown-Forman Corp.,reports,Consumer Staples,Distillers & Vintners,"Louisville, Kentucky",1982-10-31,0000014693, CHRW,C. H. Robinson Worldwide,reports,Industrials,Air Freight & Logistics,"Eden Prairie, Minnesota",2007-03-02,0001043277, COG,Cabot Oil & Gas,reports,Energy,Oil & Gas Exploration & Production,"Houston, Texas",2008-06-23,0000858470, CDNS,Cadence Design Systems,reports,Information Technology,Application Software,"San Jose, California",2017-09-18,0000813672, CPB,Campbell Soup,reports,Consumer Staples,Packaged Foods & Meats,"Camden, New Jersey",,0000016732,1869 COF,Capital One Financial,reports,Financials,Consumer Finance,"Tysons Corner, Virginia",1998-07-01,0000927628,1935 CPRI,Capri Holdings,reports,Consumer Discretionary,"Apparel, Accessories & Luxury Goods","New York, New York",2013-11-13,0001530721, CAH,Cardinal Health Inc.,reports,Health Care,Health Care Distributors,"Dublin, Ohio",1997-05-27,0000721371, KMX,Carmax Inc,reports,Consumer Discretionary,Specialty Stores,"Richmond, Virginia",2010-06-28,0001170010, CCL,Carnival Corp.,reports,Consumer Discretionary,"Hotels, Resorts & Cruise Lines","Miami, Florida",1998-12-22,0000815097, CAT,Caterpillar Inc.,reports,Industrials,Construction Machinery & Heavy Trucks,"Deerfield, Illinois",,0000018230,1925 CBOE,Cboe Global Markets,reports,Financials,Financial Exchanges & Data,"Chicago, Illinois",2017-03-01,0001374310, CBRE,CBRE Group,reports,Real Estate,Real Estate Services,"Los Angeles, California",2006-11-10,0001138118, CBS,CBS Corp.,reports,Communication Services,Broadcasting,"New York, New York",1994-09-01,0000813828,2006 CE,Celanese,reports,Materials,Specialty Chemicals,"Irving, Texas",2018-12-24,0001306830, CELG,Celgene Corp.,reports,Health Care,Biotechnology,"Summit, New Jersey",2006-11-06,0000816284, CNC,Centene Corporation,reports,Health Care,Managed Health Care,"St Louis, Missouri",2016-03-30,0001071739, CNP,CenterPoint Energy,reports,Utilities,Multi-Utilities,"Houston, Texas",1985-07-31,0001130310, CTL,CenturyLink Inc,reports,Communication Services,Integrated Telecommunication Services,"Monroe, Louisiana",1999-03-25,0000018926, CERN,Cerner,reports,Health Care,Health Care Technology,"North Kansas City, Missouri",2010-04-30,0000804753, CF,CF Industries Holdings Inc,reports,Materials,Fertilizers & Agricultural Chemicals,"Deerfield, Illinois",2008-08-27,0001324404, SCHW,Charles Schwab Corporation,reports,Financials,Investment Banking & Brokerage,"San Francisco, California",1997-06-02,0000316709, CHTR,Charter Communications,reports,Communication Services,Cable & Satellite,"Stamford, Connecticut",2016-09-08,0001091667, CVX,Chevron Corp.,reports,Energy,Integrated Oil & Gas,"San Ramon, California",,0000093410,1879 CMG,Chipotle Mexican Grill,reports,Consumer Discretionary,Restaurants,"Newport Beach, California",2011-04-28,0001058090, CB,Chubb Limited,reports,Financials,Property & Casualty Insurance,"Zurich, Switzerland",2010-07-15,0000896159, CHD,Church & Dwight,reports,Consumer Staples,Household Products,"Ewing, New Jersey",2015-12-29,0000313927, CI,CIGNA Corp.,reports,Health Care,Managed Health Care,"Bloomfield, Connecticut",1976-06-30,0000701221, XEC,Cimarex Energy,reports,Energy,Oil & Gas Exploration & Production,"Denver, Colorado",2014-06-21,0001168054, CINF,Cincinnati Financial,reports,Financials,Property & Casualty Insurance,"Fairfield, Ohio",1997-12-18,0000020286, CTAS,Cintas Corporation,reports,Industrials,Diversified Support Services,"Mason, Ohio",2001-03-01,0000723254, CSCO,Cisco Systems,reports,Information Technology,Communications Equipment,"San Jose, California",1993-12-01,0000858877, C,Citigroup Inc.,reports,Financials,Diversified Banks,"New York, New York",1988-05-31,0000831001, CFG,Citizens Financial Group,reports,Financials,Regional Banks,"Providence, Rhode Island",2016-01-29,0000759944, CTXS,Citrix Systems,reports,Information Technology,Internet Software & Services,"Fort Lauderdale, Florida",1999-12-01,0000877890, CLX,The Clorox Company,reports,Consumer Staples,Household Products,"Oakland, California",1969-03-31,0000021076,1913 CME,CME Group Inc.,reports,Financials,Financial Exchanges & Data,"Chicago, Illinois",2006-08-11,0001156375, CMS,CMS Energy,reports,Utilities,Multi-Utilities,"Jackson, Michigan",1999-05-03,0000811156, KO,Coca-Cola Company,reports,Consumer Staples,Soft Drinks,"Atlanta, Georgia",,0000021344,1886 CTSH,Cognizant Technology Solutions,reports,Information Technology,IT Consulting & Other Services,"Teaneck, New Jersey",2006-11-17,0001058290, CL,Colgate-Palmolive,reports,Consumer Staples,Household Products,"New York, New York",,0000021665,1806 CMCSA,Comcast Corp.,reports,Communication Services,Cable & Satellite,"Philadelphia, Pennsylvania",2015-09-18,0001166691, CMA,Comerica Inc.,reports,Financials,Diversified Banks,"Dallas, Texas",1995-12-01,0000028412, CAG,Conagra Brands,reports,Consumer Staples,Packaged Foods & Meats,"Chicago, Illinois",1983-08-31,0000023217, CXO,Concho Resources,reports,Energy,Oil & Gas Exploration & Production,"Midland, Texas",2016-02-22,0001358071, COP,ConocoPhillips,reports,Energy,Oil & Gas Exploration & Production,"Houston, Texas",,0001163165,2002 ED,Consolidated Edison,reports,Utilities,Electric Utilities,"New York, New York",,0001047862,1823 STZ,Constellation Brands,reports,Consumer Staples,Distillers & Vintners,"Victor, New York",2005-07-01,0000016918, COO,The Cooper Companies,reports,Health Care,Health Care Supplies,"Pleasanton, California",2016-09-23,0000711404, CPRT,Copart Inc,reports,Industrials,Diversified Support Services,"Dallas, Texas",2018-07-02,0000900075, GLW,Corning Inc.,reports,Information Technology,Electronic Components,"Corning, New York",,0000024741,1851 CTVA,Corteva,reports,Materials,Fertilizers & Agricultural Chemicals,"Wilmington, Delaware",2019-06-03,0001755672,2019 COST,Costco Wholesale Corp.,reports,Consumer Staples,Hypermarkets & Super Centers,"Issaquah, Washington",1993-10-01,0000909832, COTY,"Coty, Inc",reports,Consumer Staples,Personal Products,"New York, New York",2016-10-03,0001024305, CCI,Crown Castle International Corp.,reports,Real Estate,Specialized REITs,"Houston, Texas",2012-03-14,0001051470, CSX,CSX Corp.,reports,Industrials,Railroads,"Jacksonville, Florida",1967-09-30,0000277948,1980 CMI,Cummins Inc.,reports,Industrials,Industrial Machinery,"Columbus, Indiana",1965-03-31,0000026172,1919 CVS,CVS Health,reports,Health Care,Health Care Services,"Woonsocket, Rhode Island",,0000064803,1996 DHI,D. R. Horton,reports,Consumer Discretionary,Homebuilding,"Fort Worth, Texas",,0000882184,1978 DHR,Danaher Corp.,reports,Health Care,Health Care Equipment,"Washington, D.C.",,0000313616,1969 DRI,Darden Restaurants,reports,Consumer Discretionary,Restaurants,"Orlando, Florida",,0000940944,1938 DVA,DaVita Inc.,reports,Health Care,Health Care Facilities,"Denver, Colorado",2008-07-31,0000927066, DE,Deere & Co.,reports,Industrials,Agricultural & Farm Machinery,"Moline, Illinois",,0000315189,1837 DAL,Delta Air Lines Inc.,reports,Industrials,Airlines,"Atlanta, Georgia",2013-09-11,0000027904, XRAY,Dentsply Sirona,reports,Health Care,Health Care Supplies,"York, Pennsylvania",2008-11-14,0000818479, DVN,Devon Energy,reports,Energy,Oil & Gas Exploration & Production,"Oklahoma City, Oklahoma",2000-08-30,0001090012, FANG,Diamondback Energy,reports,Energy,Oil & Gas Exploration & Production,"Midland, Texas",2018-12-03,0001539838,2007 DLR,Digital Realty Trust Inc,reports,Real Estate,Specialized REITs,"San Francisco, California",2016-05-18,0001297996, DFS,Discover Financial Services,reports,Financials,Consumer Finance,"Riverwoods, Illinois",2007-07-02,0001393612, DISCA,Discovery Inc. Class A,reports,Communication Services,Broadcasting,"Silver Spring, Maryland",2010-03-01,0001437107, DISCK,Discovery Inc. Class C,reports,Communication Services,Broadcasting,"Silver Spring, Maryland",2014-08-07,0001437107, DISH,Dish Network,reports,Communication Services,Cable & Satellite,"Meridian, Colorado",2017-03-13,0001001082, DG,Dollar General,reports,Consumer Discretionary,General Merchandise Stores,"Goodlettsville, Tennessee",2012-12-03,0000029534, DLTR,Dollar Tree,reports,Consumer Discretionary,General Merchandise Stores,"Chesapeake, Virginia",2011-12-19,0000935703, D,Dominion Energy,reports,Utilities,Electric Utilities,"Richmond, Virginia",,0000715957,1983 DOV,Dover Corp.,reports,Industrials,Industrial Machinery,"Downers Grove, Illinois",1985-10-31,0000029905, DOW,Dow Inc.,reports,Materials,Commodity Chemicals,"Midland, Michigan",2019-04-01,0001751788,2019 DD,DuPont de Nemours Inc,reports,Materials,Specialty Chemicals,"Midland, Michigan",,0001666700,2017 DTE,DTE Energy Co.,reports,Utilities,Multi-Utilities,"Detroit, Michigan",,0000936340,1995 DRE,Duke Realty Corp,reports,Real Estate,Industrial REITs,"Indianapolis, Indiana",2017-07-26,0000783280, DUK,Duke Energy,reports,Utilities,Electric Utilities,"Charlotte, North Carolina",1976-06-30,0001326160, DXC,DXC Technology,reports,Information Technology,IT Consulting & Other Services,"Tysons Corner, Virginia",2017-04-04,0001688568, ETFC,E*Trade,reports,Financials,Investment Banking & Brokerage,"New York, New York",2004-03-31,0001015780, EMN,Eastman Chemical,reports,Materials,Diversified Chemicals,"Kingsport, Tennessee",1994-01-01,0000915389, ETN,Eaton Corporation,reports,Industrials,Electrical Components & Equipment,"Dublin, Ireland",,0001551182,1911 EBAY,eBay Inc.,reports,Consumer Discretionary,Internet & Direct Marketing Retail,"San Jose, California",,0001065088,1995 ECL,Ecolab Inc.,reports,Materials,Specialty Chemicals,"St. Paul, Minnesota",1989-01-31,0000031462, EIX,Edison Int'l,reports,Utilities,Electric Utilities,"Rosemead, California",,0000827052,1886 EW,Edwards Lifesciences,reports,Health Care,Health Care Equipment,"Irvine, California",2011-04-01,0001099800, EA,Electronic Arts,reports,Communication Services,Interactive Home Entertainment,"Redwood City, California",2002-07-22,0000712515, EMR,Emerson Electric Company,reports,Industrials,Electrical Components & Equipment,"Ferguson, Missouri",1965-03-31,0000032604,1890 ETR,Entergy Corp.,reports,Utilities,Electric Utilities,"New Orleans, Louisiana",,0000065984,1913 EOG,EOG Resources,reports,Energy,Oil & Gas Exploration & Production,"Houston, Texas",2000-11-02,0000821189, EFX,Equifax Inc.,reports,Industrials,Research & Consulting Services,"Atlanta, Georgia",1997-06-19,0000033185, EQIX,Equinix,reports,Real Estate,Specialized REITs,"Redwood City, California",2015-03-20,0001101239, EQR,Equity Residential,reports,Real Estate,Residential REITs,"Chicago, Illinois",2001-12-03,0000906107, ESS,"Essex Property Trust, Inc.",reports,Real Estate,Residential REITs,"Palo Alto, California",2014-04-02,0000920522, EL,Estee Lauder Cos.,reports,Consumer Staples,Personal Products,"New York, New York",2006-01-05,0001001250, EVRG,Evergy,reports,Utilities,Electric Utilities,"Kansas City, Missouri",2018-06-05,0001711269,1909 ES,Eversource Energy,reports,Utilities,Multi-Utilities,"Springfield, Massachusetts",,0000072741,1966 RE,Everest Re Group Ltd.,reports,Financials,Reinsurance,"Hamilton, Bermuda",2017-06-19,0001095073, EXC,Exelon Corp.,reports,Utilities,Multi-Utilities,"Chicago, Illinois",,0001109357,2000 EXPE,Expedia Group,reports,Consumer Discretionary,Internet & Direct Marketing Retail,"Bellevue, Washington",2007-10-02,0001324424, EXPD,Expeditors,reports,Industrials,Air Freight & Logistics,"Seattle, Washington",2007-10-10,0000746515, EXR,Extra Space Storage,reports,Real Estate,Specialized REITs,"Salt Lake City, Utah",2016-01-19,0001289490, XOM,Exxon Mobil Corp.,reports,Energy,Integrated Oil & Gas,"Irving, Texas",,0000034088,1999 FFIV,F5 Networks,reports,Information Technology,Communications Equipment,"Seattle, Washington",2010-12-20,0001048695,1996 FB,"Facebook, Inc.",reports,Communication Services,Interactive Media & Services,"Menlo Park, California",2013-12-23,0001326801, FAST,Fastenal Co,reports,Industrials,Building Products,"Winona, Minnesota",2009-09-15,0000815556, FRT,Federal Realty Investment Trust,reports,Real Estate,Retail REITs,"Rockville, Maryland",2016-02-01,0000034903, FDX,FedEx Corporation,reports,Industrials,Air Freight & Logistics,"Memphis, Tennessee",1980-12-31,0001048911, FIS,Fidelity National Information Services,reports,Information Technology,Internet Software & Services,"Jacksonville, Florida",2006-11-10,0001136893, FITB,Fifth Third Bancorp,reports,Financials,Regional Banks,"Cincinnati, Ohio",,0000035527,1858 FE,FirstEnergy Corp,reports,Utilities,Electric Utilities,"Akron, Ohio",,0001031296,1997 FRC,First Republic Bank,reports,Financials,Regional Banks,"San Francisco, California",2019-01-02,0001132979,1985 FISV,Fiserv Inc,reports,Information Technology,Internet Software & Services,"Brookfield, Wisconsin",2001-04-02,0000798354, FLT,FleetCor Technologies Inc,reports,Information Technology,Data Processing & Outsources Services,"Norcross, Georgia",2018-06-20,0001175454,2000 FLIR,FLIR Systems,reports,Information Technology,Electronic Equipment & Instruments,"Wilsonville, Oregon",2009-01-02,0000354908, FLS,Flowserve Corporation,reports,Industrials,Industrial Machinery,"Irving, Texas",2008-10-02,0000030625, FMC,FMC Corporation,reports,Materials,Fertilizers & Agricultural Chemicals,"Philadelphia, Pennsylvania",2009-08-19,0000037785, FL,Foot Locker Inc,reports,Consumer Discretionary,Apparel Retail,"New York, New York",2016-04-04,0000850209, F,Ford Motor,reports,Consumer Discretionary,Automobile Manufacturers,"Dearborn, Michigan",,0000037996,1903 FTNT,Fortinet,reports,Information Technology,Systems Software,"Sunnyvale, California",2018-10-11,0001262039,2000 FTV,Fortive Corp,reports,Industrials,Industrial Machinery,"Everett, Washington",2016-07-01,0001659166, FBHS,Fortune Brands Home & Security,reports,Industrials,Building Products,"Deerfield, Illinois",2016-06-22,0001519751, FOXA,Fox Corporation Class A,reports,Communication Services,Movies & Entertainment,"New York, New York",2013-07-01,0001308161, FOX,Fox Corporation Class B,reports,Communication Services,Movies & Entertainment,"New York, New York",2015-09-18,0001308161, BEN,Franklin Resources,reports,Financials,Asset Management & Custody Banks,"San Mateo, California",,0000038777,1947 FCX,Freeport-McMoRan Inc.,reports,Materials,Copper,"Phoenix, Arizona",,0000831259,1912 GPS,Gap Inc.,reports,Consumer Discretionary,Apparel Retail,"San Francisco, California",1986-08-31,0000039911, GRMN,Garmin Ltd.,reports,Consumer Discretionary,Consumer Electronics,"Schaffhausen, Switzerland",2012-12-12,0001121788, IT,Gartner Inc,reports,Information Technology,IT Consulting & Other Services,"Stamford, Connecticut",2017-04-05,0000749251, GD,General Dynamics,reports,Industrials,Aerospace & Defense,"Falls Church, Virginia",,0000040533,1899 GE,General Electric,reports,Industrials,Industrial Conglomerates,"Boston, Massachusetts",,0000040545,1892 GIS,General Mills,reports,Consumer Staples,Packaged Foods & Meats,"Golden Valley, Minnesota",1969-03-31,0000040704,1856 GM,General Motors,reports,Consumer Discretionary,Automobile Manufacturers,"Detroit, Michigan",2013-06-06,0001467858, GPC,Genuine Parts,reports,Consumer Discretionary,Specialty Stores,"Atlanta, Georgia",1973-12-31,0000040987,1925 GILD,Gilead Sciences,reports,Health Care,Biotechnology,"Foster City, California",2004-07-01,0000882095, GPN,Global Payments Inc.,reports,Information Technology,Data Processing & Outsourced Services,"Atlanta, Georgia",2016-04-25,0001123360, GS,Goldman Sachs Group,reports,Financials,Investment Banking & Brokerage,"New York, New York",2002-07-22,0000886982, GWW,Grainger (W.W.) Inc.,reports,Industrials,Industrial Machinery,"Lake Forest, Illinois",1981-06-30,0000277135, HAL,Halliburton Co.,reports,Energy,Oil & Gas Equipment & Services,"Houston, Texas",,0000045012,1919 HBI,Hanesbrands Inc,reports,Consumer Discretionary,"Apparel, Accessories & Luxury Goods","Winston-Salem, North Carolina",2015-03-20,0001359841, HOG,Harley-Davidson,reports,Consumer Discretionary,Motorcycle Manufacturers,"Milwaukee, Wisconsin",,0000793952,1903 HRS,Harris Corporation,reports,Industrials,Aerospace & Defense,"Melbourne, Florida",2008-09-22,0000202058, HIG,Hartford Financial Svc.Gp.,reports,Financials,Property & Casualty Insurance,"Hartford, Connecticut",,0000874766, HAS,Hasbro Inc.,reports,Consumer Discretionary,Leisure Products,"Pawtucket, Rhode Island",1984-09-30,0000046080, HCA,HCA Healthcare,reports,Health Care,Health Care Facilities,"Nashville, Tennessee",2015-01-27,0000860730, HCP,HCP Inc.,reports,Real Estate,Health Care REITs,"Long Beach, California",2008-03-31,0000765880, HP,Helmerich & Payne,reports,Energy,Oil & Gas Drilling,"Tulsa, Oklahoma[5]",2010-03-01,0000046765, HSIC,Henry Schein,reports,Health Care,Health Care Distributors,"Melville, New York",2015-03-17,0001000228, HSY,The Hershey Company,reports,Consumer Staples,Packaged Foods & Meats,"Hershey, Pennsylvania",,0000047111,1894 HES,Hess Corporation,reports,Energy,Integrated Oil & Gas,"New York, New York",1984-05-31,0000004447, HPE,Hewlett Packard Enterprise,reports,Information Technology,"Technology Hardware, Storage & Peripherals","Palo Alto, California",2015-11-02,0001645590, HLT,Hilton Worldwide Holdings Inc,reports,Consumer Discretionary,"Hotels, Resorts & Cruise Lines","Tysons Corner, Virginia",2017-06-19,0001585689, HFC,HollyFrontier Corp,reports,Energy,Oil & Gas Refining & Marketing,"Dallas, Texas",2018-06-18,0000048039, HOLX,Hologic,reports,Health Care,Health Care Equipment,"Marlborough, Massachusetts",2016-03-30,0000859737, HD,Home Depot,reports,Consumer Discretionary,Home Improvement Retail,"Atlanta, Georgia",1988-03-31,0000354950, HON,Honeywell Int'l Inc.,reports,Industrials,Industrial Conglomerates,"Morristown, New Jersey",1964-03-31,0000773840,1906 HRL,Hormel Foods Corp.,reports,Consumer Staples,Packaged Foods & Meats,"Austin, Minnesota",2009-03-04,0000048465, HST,Host Hotels & Resorts,reports,Real Estate,Hotel & Resort REITs,"Bethesda, Maryland",2007-03-20,0001070750, HPQ,HP Inc.,reports,Information Technology,"Technology Hardware, Storage & Peripherals","Palo Alto, California",1974-12-31,0000047217,1939 (2015) HUM,Humana Inc.,reports,Health Care,Managed Health Care,"Louisville, Kentucky",,0000049071,1961 HBAN,Huntington Bancshares,reports,Financials,Regional Banks,"Columbus, Ohio",,0000049196,1866 HII,Huntington Ingalls Industries,reports,Industrials,Aerospace & Defense,"Newport News, Virginia",2018-01-03,0001501585, IDXX,IDEXX Laboratories,reports,Health Care,Health Care Equipment,"Westbrook, Maine",2017-01-05,0000874716, INFO,IHS Markit Ltd.,reports,Industrials,Research & Consulting Services,"London, United Kingdom",2017-06-02,0001598014, ITW,Illinois Tool Works,reports,Industrials,Industrial Machinery,"Glenview, Illinois",1986-02-28,0000049826, ILMN,Illumina Inc,reports,Health Care,Life Sciences Tools & Services,"San Diego, California",2015-11-19,0001110803, IR,Ingersoll-Rand PLC,reports,Industrials,Industrial Machinery,"Dublin, Ireland",2010-11-17,0001466258, INTC,Intel Corp.,reports,Information Technology,Semiconductors,"Santa Clara, California",1976-12-31,0000050863, ICE,Intercontinental Exchange,reports,Financials,Financial Exchanges & Data,"Atlanta, Georgia",2007-09-26,0001571949, IBM,International Business Machines,reports,Information Technology,IT Consulting & Other Services,"Armonk, New York",,0000051143,1911 INCY,Incyte,reports,Health Care,Biotechnology,"Wilmington, Delaware",2017-02-28,0000879169, IP,International Paper,reports,Materials,Paper Packaging,"Memphis, Tennessee",,0000051434,1898 IPG,Interpublic Group,reports,Communication Services,Advertising,"New York, New York",1992-10-01,0000051644, IFF,Intl Flavors & Fragrances,reports,Materials,Specialty Chemicals,"New York, New York",1976-03-31,0000051253, INTU,Intuit Inc.,reports,Information Technology,Internet Software & Services,"Mountain View, California",2000-12-05,0000896878, ISRG,Intuitive Surgical Inc.,reports,Health Care,Health Care Equipment,"Sunnyvale, California",2008-06-02,0001035267, IVZ,Invesco Ltd.,reports,Financials,Asset Management & Custody Banks,"Atlanta, Georgia",2008-08-21,0000914208, IPGP,IPG Photonics Corp.,reports,Information Technology,Electronic Manufacturing Services,"Oxford, Massachusetts",2018-03-07,0001111928, IQV,IQVIA Holdings Inc.,reports,Health Care,Life Sciences Tools & Services,"Durham, North Carolina",2017-08-29,0001478242, IRM,Iron Mountain Incorporated,reports,Real Estate,Specialized REITs,"Boston, Massachusetts",2009-01-06,0001020569, JKHY,Jack Henry & Associates,reports,Information Technology,Data Processing & Outsourced Services,"Monett, Missouri",2018-11-13,0000779152, JEC,Jacobs Engineering Group,reports,Industrials,Construction & Engineering,"Pasadena, California",2007-10-26,0000052988, JBHT,J. B. Hunt Transport Services,reports,Industrials,Trucking,"Lowell, Arkansas",2015-07-01,0000728535, JEF,Jefferies Financial Group,reports,Financials,Multi-Sector Holdings,"New York, New York",2007-08-27,0000096223, SJM,JM Smucker,reports,Consumer Staples,Packaged Foods & Meats,"Orrville, Ohio",2008-11-06,0000091419, JNJ,Johnson & Johnson,reports,Health Care,Pharmaceuticals,"New Brunswick, New Jersey",1973-06-30,0000200406,1886 JCI,Johnson Controls International,reports,Industrials,Building Products,"Cork, Ireland",2010-08-27,0000833444, JPM,JPMorgan Chase & Co.,reports,Financials,Diversified Banks,"New York, New York",1975-06-30,0000019617, JNPR,Juniper Networks,reports,Information Technology,Communications Equipment,"Sunnyvale, California",,0001043604,1996 KSU,Kansas City Southern,reports,Industrials,Railroads,"Kansas City, Missouri",2013-05-24,0000054480, K,Kellogg Co.,reports,Consumer Staples,Packaged Foods & Meats,"Battle Creek, Michigan",,0000055067,1906 KEY,KeyCorp,reports,Financials,Regional Banks,"Cleveland, Ohio",1994-03-01,0000091576, KEYS,Keysight Technologies,reports,Information Technology,Electronic Equipment & Instruments,"Santa Rosa, California",2018-11-06,0001601046,2014 KMB,Kimberly-Clark,reports,Consumer Staples,Household Products,"Irving, Texas",,0000055785,1872 KIM,Kimco Realty,reports,Real Estate,Retail REITs,"New Hyde Park, New York",2006-04-04,0000879101, KMI,Kinder Morgan,reports,Energy,Oil & Gas Storage & Transportation,"Houston, Texas",2012-05-25,0001506307, KLAC,KLA-Tencor Corp.,reports,Information Technology,Semiconductor Equipment,"Milpitas, California",,0000319201,1975/1977 (1997) KSS,Kohl's Corp.,reports,Consumer Discretionary,General Merchandise Stores,"Menomonee Falls, Wisconsin",,0000885639,1962 KHC,Kraft Heinz Co,reports,Consumer Staples,Packaged Foods & Meats,"Chicago, Illinois; Pittsburgh, Pennsylvania",2015-07-06,0001637459, KR,Kroger Co.,reports,Consumer Staples,Food Retail,"Cincinnati, Ohio",,0000056873,1883 LB,L Brands Inc.,reports,Consumer Discretionary,Apparel Retail,"Columbus, Ohio",1983-09-30,0000701985, LLL,L-3 Communications Holdings,reports,Industrials,Aerospace & Defense,"New York, New York",,0001039101,1997 LH,Laboratory Corp. of America Holding,reports,Health Care,Health Care Services,"Burlington, North Carolina",2004-11-01,0000920148, LRCX,Lam Research,reports,Information Technology,Semiconductor Equipment,"Fremont, California",2012-06-29,0000707549, LW,Lamb Weston Holdings Inc,reports,Consumer Staples,Packaged Foods & Meats,"Eagle, Idaho",2018-12-03,0001679273, LEG,Leggett & Platt,reports,Consumer Discretionary,Home Furnishings,"Carthage, Missouri",,0000058492,1883 LEN,Lennar Corp.,reports,Consumer Discretionary,Homebuilding,"Miami, Florida",2005-10-04,0000920760, LLY,Lilly (Eli) & Co.,reports,Health Care,Pharmaceuticals,"Indianapolis, Indiana",1970-12-31,0000059478,1876 LNC,Lincoln National,reports,Financials,Multi-line Insurance,"Radnor, Pennsylvania",1976-06-30,0000059558, LIN,Linde plc,reports,Materials,Industrial Gases,"Guildford, Surrey, United Kingdom",1992-07-01,0001707925, LKQ,LKQ Corporation,reports,Consumer Discretionary,Distributors,"Chicago, Illinois",2016-05-23,0001065696, LMT,Lockheed Martin Corp.,reports,Industrials,Aerospace & Defense,"Bethesda, Maryland",1984-07-31,0000936468, L,Loews Corp.,reports,Financials,Multi-line Insurance,"New York, New York",,0000060086, LOW,Lowe's Cos.,reports,Consumer Discretionary,Home Improvement Retail,"Mooresville, North Carolina",1984-02-29,0000060667,1904/1946/1959 LYB,LyondellBasell,reports,Materials,Specialty Chemicals,"Rotterdam, Netherlands",2012-09-05,0001489393, MTB,M&T Bank Corp.,reports,Financials,Regional Banks,"Buffalo, New York",,0000036270,1856 MAC,Macerich,reports,Real Estate,Retail REITs,"Santa Monica, California",2013-05-09,0000912242, M,Macy's Inc.,reports,Consumer Discretionary,Department Stores,"Cincinnati, Ohio",,0000794367,1929 MRO,Marathon Oil Corp.,reports,Energy,Oil & Gas Exploration & Production,"Houston, Texas",1991-05-01,0000101778, MPC,Marathon Petroleum,reports,Energy,Oil & Gas Refining & Marketing,"Findlay, Ohio",2011-07-01,0001510295, MAR,Marriott Int'l.,reports,Consumer Discretionary,"Hotels, Resorts & Cruise Lines","Bethesda, Maryland",,0001048286,1927 MMC,Marsh & McLennan,reports,Financials,Insurance Brokers,"New York, New York",1987-08-31,0000062709, MLM,Martin Marietta Materials,reports,Materials,Construction Materials,"Raleigh, North Carolina",2014-07-02,0000916076, MAS,Masco Corp.,reports,Industrials,Building Products,"Taylor, Michigan",1981-06-30,0000062996, MA,Mastercard Inc.,reports,Information Technology,IT Services,"Harrison, New York",2008-07-18,0001141391, MKC,McCormick & Co.,reports,Consumer Staples,Packaged Foods & Meats,"Sparks, Maryland",,0000063754,1889 MXIM,Maxim Integrated Products Inc,reports,Information Technology,Semiconductors,"San Jose, California",2018-12-03,0000743316,1983 MCD,McDonald's Corp.,reports,Consumer Discretionary,Restaurants,"Chicago, Illinois",1970-06-30,0000063908,1940 MCK,McKesson Corp.,reports,Health Care,Health Care Distributors,"San Francisco, California",,0000927653,1833 MDT,Medtronic plc,reports,Health Care,Health Care Equipment,"Dublin, Ireland",1986-10-31,0001613103, MRK,Merck & Co.,reports,Health Care,Pharmaceuticals,"Whitehouse Station, New Jersey",,0000310158,1891 MET,MetLife Inc.,reports,Financials,Life & Health Insurance,"New York, New York",,0001099219,1868 MTD,Mettler Toledo,reports,Health Care,Life Sciences Tools & Services,"Columbus, Ohio",2016-09-06,0001037646, MGM,MGM Resorts International,reports,Consumer Discretionary,Casinos & Gaming,"Paradise, Nevada",2017-07-26,0000789570, MCHP,Microchip Technology,reports,Information Technology,Semiconductors,"Chandler, Arizona",2007-09-07,0000827054, MU,Micron Technology,reports,Information Technology,Semiconductors,"Boise, Idaho",1994-09-27,0000723125, MSFT,Microsoft Corp.,reports,Information Technology,Systems Software,"Redmond, Washington",1994-06-01,0000789019,1975 MAA,Mid-America Apartments,reports,Real Estate,Residential REITs,"Memphis, Tennessee",2016-12-02,0000912595, MHK,Mohawk Industries,reports,Consumer Discretionary,Home Furnishings,"Amsterdam, New York",2013-12-23,0000851968, TAP,Molson Coors Brewing Company,reports,Consumer Staples,Brewers,"Denver, Colorado",1976-06-30,0000024545, MDLZ,Mondelez International,reports,Consumer Staples,Packaged Foods & Meats,"Deerfield, Illinois",2012-10-02,0001103982, MNST,Monster Beverage,reports,Consumer Staples,Soft Drinks,"Corona, California",2012-06-28,0000865752, MCO,Moody's Corp,reports,Financials,Financial Exchanges & Data,"New York, New York",,0001059556,1909 MS,Morgan Stanley,reports,Financials,Investment Banking & Brokerage,"New York, New York",,0000895421,1935 MOS,The Mosaic Company,reports,Materials,Fertilizers & Agricultural Chemicals,"Plymouth, Minnesota",2011-09-26,0001285785, MSI,Motorola Solutions Inc.,reports,Information Technology,Communications Equipment,"Schaumburg, Illinois",,0000068505,1928 (2011) MSCI,MSCI Inc,reports,Financials,Financial Exchanges & Data,"New York, New York",2018-04-04,0001408198, MYL,Mylan N.V.,reports,Health Care,Pharmaceuticals,"Amsterdam, Netherlands",2004-04-23,0001623613, NDAQ,"Nasdaq, Inc.",reports,Financials,Financial Exchanges & Data,"New York, New York",2008-10-22,0001120193, NOV,National Oilwell Varco Inc.,reports,Energy,Oil & Gas Equipment & Services,"Houston, Texas",2005-03-14,0001021860, NKTR,Nektar Therapeutics,reports,Health Care,Pharmaceuticals,"San Francisco, California",2018-03-19,0000906709, NTAP,NetApp,reports,Information Technology,Internet Software & Services,"Sunnyvale, California",1999-06-25,0001002047, NFLX,Netflix Inc.,reports,Communication Services,Movies & Entertainment,"Los Gatos, California",2010-12-20,0001065280,1997 NWL,Newell Brands,reports,Consumer Discretionary,Housewares & Specialties,"Hoboken, New Jersey",1989-04-30,0000814453, NEM,Newmont Goldcorp,reports,Materials,Gold,"Denver, Colorado",1969-06-30,0001164727,1921 NWSA,News Corp. Class A,reports,Communication Services,Publishing,"New York, New York",2013-08-01,0001564708, NWS,News Corp. Class B,reports,Communication Services,Publishing,"New York, New York",2015-09-18,0001564708, NEE,NextEra Energy,reports,Utilities,Multi-Utilities,"Juno Beach, Florida",1976-06-30,0000753308, NLSN,Nielsen Holdings,reports,Industrials,Research & Consulting Services,"New York, New York",2013-07-09,0001492633, NKE,Nike,reports,Consumer Discretionary,"Apparel, Accessories & Luxury Goods","Washington County, Oregon",1988-11-30,0000320187, NI,NiSource Inc.,reports,Utilities,Multi-Utilities,"Merrillville, Indiana",,0001111711,1912 NBL,Noble Energy Inc,reports,Energy,Oil & Gas Exploration & Production,"Houston, Texas",2007-10-08,0000072207, JWN,Nordstrom,reports,Consumer Discretionary,Department Stores,"Seattle, Washington",1986-08-31,0000072333, NSC,Norfolk Southern Corp.,reports,Industrials,Railroads,"Norfolk, Virginia",,0000702165,1881/1894 (1980) NTRS,Northern Trust Corp.,reports,Financials,Asset Management & Custody Banks,"Chicago, Illinois",,0000073124,1889 NOC,Northrop Grumman,reports,Industrials,Aerospace & Defense,"West Falls Church, Virginia",1985-06-30,0001133421, NCLH,Norwegian Cruise Line Holdings,reports,Consumer Discretionary,"Hotels, Resorts & Cruise Lines","Miami, Florida",2017-10-13,0001513761, NRG,NRG Energy,reports,Utilities,Independent Power Producers & Energy Traders,"Princeton, New Jersey",2010-01-29,0001013871, NUE,Nucor Corp.,reports,Materials,Steel,"Charlotte, North Carolina",1985-04-30,0000073309, NVDA,Nvidia Corporation,reports,Information Technology,Semiconductors,"Santa Clara, California",2001-11-30,0001045810, ORLY,O'Reilly Automotive,reports,Consumer Discretionary,Specialty Stores,"Springfield, Missouri",2009-03-27,0000898173, OXY,Occidental Petroleum,reports,Energy,Oil & Gas Exploration & Production,"Houston, Texas",1982-12-31,0000797468, OMC,Omnicom Group,reports,Communication Services,Advertising,"New York, New York",,0000029989,1986 OKE,ONEOK,reports,Energy,Oil & Gas Storage & Transportation,"Tulsa, Oklahoma",2010-03-15,0001039684, ORCL,Oracle Corp.,reports,Information Technology,Application Software,"Redwood Shores, California",1989-08-31,0001341439, PCAR,PACCAR Inc.,reports,Industrials,Construction Machinery & Heavy Trucks,"Bellevue, Washington",1980-12-31,0000075362, PKG,Packaging Corporation of America,reports,Materials,Paper Packaging,"Lake Forest, Illinois",2017-07-26,0000075677, PH,Parker-Hannifin,reports,Industrials,Industrial Machinery,"Cleveland, Ohio",1985-11-30,0000076334, PAYX,Paychex Inc.,reports,Information Technology,Internet Software & Services,"Penfield, New York",,0000723531,1971 PYPL,PayPal,reports,Information Technology,Data Processing & Outsourced Services,"San Jose, California",2015-07-20,0001633917, PNR,Pentair plc,reports,Industrials,Industrial Machinery,"Worsley, UK",2012-10-01,0000077360, PBCT,People's United Financial,reports,Financials,Thrifts & Mortgage Finance,"Bridgeport, Connecticut",2008-11-13,0001378946, PEP,PepsiCo Inc.,reports,Consumer Staples,Soft Drinks,"Purchase, New York",,0000077476,1898 PKI,PerkinElmer,reports,Health Care,Health Care Equipment,"Waltham, Massachusetts",1985-05-31,0000031791, PRGO,Perrigo,reports,Health Care,Pharmaceuticals,"Dublin, Ireland",2011-12-19,0001585364, PFE,Pfizer Inc.,reports,Health Care,Pharmaceuticals,"New York, New York",,0000078003,1849 PM,Philip Morris International,reports,Consumer Staples,Tobacco,"New York, New York",2008-03-31,0001413329, PSX,Phillips 66,reports,Energy,Oil & Gas Refining & Marketing,"Houston, Texas",2012-05-01,0001534701, PNW,Pinnacle West Capital,reports,Utilities,Multi-Utilities,"Phoenix, Arizona",,0000764622,1985 PXD,Pioneer Natural Resources,reports,Energy,Oil & Gas Exploration & Production,"Irving, Texas",2008-09-24,0001038357, PNC,PNC Financial Services,reports,Financials,Regional Banks,"Pittsburgh, Pennsylvania",1988-04-30,0000713676, PPG,PPG Industries,reports,Materials,Specialty Chemicals,"Pittsburgh, Pennsylvania",,0000079879,1883 PPL,PPL Corp.,reports,Utilities,Electric Utilities,"Allentown, Pennsylvania",,0000922224, PFG,Principal Financial Group,reports,Financials,Life & Health Insurance,"Des Moines, Iowa",2002-07-22,0001126328, PG,Procter & Gamble,reports,Consumer Staples,Personal Products,"Cincinnati, Ohio",,0000080424,1837 PGR,Progressive Corp.,reports,Financials,Property & Casualty Insurance,"Mayfield Village, Ohio",1997-08-04,0000080661, PLD,Prologis,reports,Real Estate,Industrial REITs,"San Francisco, California",2003-07-17,0001045609, PRU,Prudential Financial,reports,Financials,Life & Health Insurance,"Newark, New Jersey",2002-07-22,0001137774, PEG,Public Serv. Enterprise Inc.,reports,Utilities,Electric Utilities,"Newark, New Jersey",,0000788784, PSA,Public Storage,reports,Real Estate,Specialized REITs,"Glendale, California",2005-08-19,0001393311, PHM,Pulte Homes Inc.,reports,Consumer Discretionary,Homebuilding,"Atlanta, Georgia",1984-04-30,0000822416, PVH,PVH Corp.,reports,Consumer Discretionary,"Apparel, Accessories & Luxury Goods","New York, New York",2013-02-15,0000078239, QRVO,Qorvo,reports,Information Technology,Semiconductors,"Greensboro, North Carolina",2015-06-11,0001604778, PWR,Quanta Services Inc.,reports,Industrials,Construction & Engineering,"Houston, Texas",2009-07-01,0001050915, QCOM,QUALCOMM Inc.,reports,Information Technology,Semiconductors,"San Diego, California",,0000804328,1985 DGX,Quest Diagnostics,reports,Health Care,Health Care Services,"Madison, New Jersey",2002-12-12,0001022079, RL,Ralph Lauren Corporation,reports,Consumer Discretionary,"Apparel, Accessories & Luxury Goods","New York, New York",2007-02-02,0001037038, RJF,Raymond James Financial Inc.,reports,Financials,Investment Banking & Brokerage,"St. Petersburg, Florida",2017-03-20,0000720005, RTN,Raytheon Co.,reports,Industrials,Aerospace & Defense,"Waltham, Massachusetts",,0001047122,1922 O,Realty Income Corporation,reports,Real Estate,Retail REITs,"San Diego, California",2015-04-07,0000726728, RHT,Red Hat Inc.,reports,Information Technology,Systems Software,"Raleigh, North Carolina",2009-07-27,0001087423, REG,Regency Centers Corporation,reports,Real Estate,Retail REITs,"Jacksonville, Florida",2017-03-02,0000910606, REGN,Regeneron,reports,Health Care,Biotechnology,"Tarrytown, New York",2013-05-01,0000872589, RF,Regions Financial Corp.,reports,Financials,Regional Banks,"Birmingham, Alabama",1998-08-28,0001281761, RSG,Republic Services Inc,reports,Industrials,Environmental & Facilities Services,"Phoenix, Arizona",2008-12-05,0001060391, RMD,ResMed,reports,Health Care,Health Care Equipment,"San Diego, California",2017-07-26,0000943819, RHI,Robert Half International,reports,Industrials,Human Resource & Employment Services,"Menlo Park, California",2000-12-05,0000315213, ROK,Rockwell Automation Inc.,reports,Industrials,Electrical Components & Equipment,"Milwaukee, Wisconsin",,0001024478, ROL,Rollins Inc.,reports,Industrials,Environmental & Facilities Services,"Atlanta, Georgia",2018-10-01,0000084839, ROP,Roper Technologies,reports,Industrials,Industrial Conglomerates,"Sarasota, Florida",2009-12-23,0000882835, ROST,Ross Stores,reports,Consumer Discretionary,Apparel Retail,"Pleasanton, California",2009-12-21,0000745732, RCL,Royal Caribbean Cruises Ltd,reports,Consumer Discretionary,"Hotels, Resorts & Cruise Lines","Miami, Florida",2014-12-05,0000884887, CRM,Salesforce.com,reports,Information Technology,Internet Software & Services,"San Francisco, California",2008-09-15,0001108524, SBAC,SBA Communications,reports,Real Estate,Specialized REITs,"Boca Raton, Florida",2017-09-01,0001034054, SLB,Schlumberger Ltd.,reports,Energy,Oil & Gas Equipment & Services,"CuraÃ§ao, Kingdom of the Netherlands",1965-03-31,0000087347,1926 STX,Seagate Technology,reports,Information Technology,"Technology Hardware, Storage & Peripherals","Dublin, Ireland",2012-07-02,0001137789, SEE,Sealed Air,reports,Materials,Paper Packaging,"Elmwood Park, New Jersey",,0001012100, SRE,Sempra Energy,reports,Utilities,Multi-Utilities,"San Diego, California",,0001032208, SHW,Sherwin-Williams,reports,Materials,Specialty Chemicals,"Cleveland, Ohio",1964-06-30,0000089800,1866 SPG,Simon Property Group Inc,reports,Real Estate,Retail REITs,"Indianapolis, Indiana",2002-06-26,0001063761, SWKS,Skyworks Solutions,reports,Information Technology,Semiconductors,"Woburn, Massachusetts",2015-03-12,0000004127, SLG,SL Green Realty,reports,Real Estate,Office REITs,"New York, New York",2015-03-20,0001040971, SNA,Snap-on,reports,Industrials,Industrial Machinery,"Kenosha, Wisconsin",1982-09-30,0000091440, SO,Southern Co.,reports,Utilities,Electric Utilities,"Atlanta, Georgia",,0000092122, LUV,Southwest Airlines,reports,Industrials,Airlines,"Dallas, Texas",1994-07-01,0000092380, SPGI,"S&P Global, Inc.",reports,Financials,Financial Exchanges & Data,"New York, New York",,0000064040, SWK,Stanley Black & Decker,reports,Industrials,Industrial Machinery,"New Britain, Connecticut",1982-09-30,0000093556, SBUX,Starbucks Corp.,reports,Consumer Discretionary,Restaurants,"Seattle, Washington",,0000829224,1971 STT,State Street Corp.,reports,Financials,Asset Management & Custody Banks,"Boston, Massachusetts",,0000093751, SYK,Stryker Corp.,reports,Health Care,Health Care Equipment,"Kalamazoo, Michigan",2000-12-12,0000310764, STI,SunTrust Banks,reports,Financials,Regional Banks,"Atlanta, Georgia",1988-05-31,0000750556, SIVB,SVB Financial,reports,Financials,Regional Banks,"Santa Clara, California",2018-03-19,0000719739, SYMC,Symantec Corp.,reports,Information Technology,Application Software,"Mountain View, California",2003-03-25,0000849399, SYF,Synchrony Financial,reports,Financials,Consumer Finance,"Stamford, Connecticut",2015-11-18,0001601712, SNPS,Synopsys Inc.,reports,Information Technology,Application Software,"Mountain View, California",2017-03-16,0000883241, SYY,Sysco Corp.,reports,Consumer Staples,Food Distributors,"Houston, Texas",1986-12-31,0000096021, TROW,T. Rowe Price Group,reports,Financials,Asset Management & Custody Banks,"Baltimore, Maryland",,0001113169,1937 TTWO,Take-Two Interactive,reports,Communication Services,Interactive Home Entertainment,"New York, New York",2018-03-19,0000946581, TPR,"Tapestry, Inc.",reports,Consumer Discretionary,"Apparel, Accessories & Luxury Goods","New York, New York",,0001116132,2017 TGT,Target Corp.,reports,Consumer Discretionary,General Merchandise Stores,"Minneapolis, Minnesota",1976-12-31,0000027419, TEL,TE Connectivity Ltd.,reports,Information Technology,Electronic Manufacturing Services,"Schaffhausen, Switzerland",2011-10-17,0001385157, FTI,TechnipFMC,reports,Energy,Oil & Gas Equipment & Services,"London, United Kingdom",2009-06-05,0001681459, TFX,Teleflex,reports,Health Care,Health Care Equipment,"Wayne, Pennsylvania",2019-01-18,0000096943,1943 TXN,Texas Instruments,reports,Information Technology,Semiconductors,"Dallas, Texas",,0000097476,1930 TXT,Textron Inc.,reports,Industrials,Aerospace & Defense,"Providence, Rhode Island",1978-12-31,0000217346, TMO,Thermo Fisher Scientific,reports,Health Care,Health Care Equipment,"Waltham, Massachusetts",,0000097745,2006 TIF,Tiffany & Co.,reports,Consumer Discretionary,"Apparel, Accessories & Luxury Goods","New York, New York",2000-06-21,0000098246, TWTR,"Twitter, Inc.",reports,Communication Services,Interactive Media & Services,"San Francisco, California",2018-06-07,0001418091, TJX,TJX Companies Inc.,reports,Consumer Discretionary,Apparel Retail,"Framingham, Massachusetts",1985-09-30,0000109198, TMK,Torchmark Corp.,reports,Financials,Life & Health Insurance,"McKinney, Texas",1989-04-30,0000320335, TSS,Total System Services,reports,Information Technology,Internet Software & Services,"Columbus, Georgia",2008-01-02,0000721683, TSCO,Tractor Supply Company,reports,Consumer Discretionary,Specialty Stores,"Brentwood, Tennessee",2014-01-24,0000916365, TDG,TransDigm Group,reports,Industrials,Aerospace & Defense,"Cleveland, Ohio",2016-06-03,0001260221, TRV,The Travelers Companies Inc.,reports,Financials,Property & Casualty Insurance,"New York, New York",2002-08-21,0000086312, TRIP,TripAdvisor,reports,Communication Services,Interactive Media & Services,"Newton, Massachusetts",2011-12-21,0001526520, TSN,Tyson Foods,reports,Consumer Staples,Packaged Foods & Meats,"Springdale, Arkansas",,0000100493, UDR,UDR Inc,reports,Real Estate,Residential REITs,"Highlands Ranch, Colorado",2016-03-07,0000074208, ULTA,Ulta Beauty,reports,Consumer Discretionary,Specialty Stores,"Bolingbrook, Illinois",2016-04-18,0001403568, USB,U.S. Bancorp,reports,Financials,Diversified Banks,"Minneapolis, Minnesota",,0000036104,1968 UAA,Under Armour Class A,reports,Consumer Discretionary,"Apparel, Accessories & Luxury Goods","Baltimore, Maryland",2016-03-25,0001336917, UA,Under Armour Class C,reports,Consumer Discretionary,"Apparel, Accessories & Luxury Goods","Baltimore, Maryland",2014-05-01,0001336917, UNP,Union Pacific,reports,Industrials,Railroads,"Omaha, Nebraska",,0000100885, UAL,United Continental Holdings,reports,Industrials,Airlines,"Chicago, Illinois",2015-09-03,0000100517, UNH,United Health Group Inc.,reports,Health Care,Managed Health Care,"Minnetonka, Minnesota",1994-07-01,0000731766, UPS,United Parcel Service,reports,Industrials,Air Freight & Logistics,"Atlanta, Georgia",2002-07-22,0001090727, URI,"United Rentals, Inc.",reports,Industrials,Trading Companies & Distributors,"Stamford, Connecticut",2014-09-20,0001067701, UTX,United Technologies,reports,Industrials,Aerospace & Defense,"Hartford, Connecticut",,0000101829, UHS,"Universal Health Services, Inc.",reports,Health Care,Health Care Facilities,"King of Prussia, Pennsylvania",2014-09-20,0000352915, UNM,Unum Group,reports,Financials,Life & Health Insurance,"Chattanooga, Tennessee",1994-03-01,0000005513, VFC,V.F. Corp.,reports,Consumer Discretionary,"Apparel, Accessories & Luxury Goods","Greensboro, North Carolina",1979-06-30,0000103379, VLO,Valero Energy,reports,Energy,Oil & Gas Refining & Marketing,"San Antonio, Texas",,0001035002,1980 VAR,Varian Medical Systems,reports,Health Care,Health Care Equipment,"Palo Alto, California",2007-02-12,0000203527, VTR,Ventas Inc,reports,Real Estate,Health Care REITs,"Chicago, Illinois",2009-03-04,0000740260, VRSN,Verisign Inc.,reports,Information Technology,Internet Services & Infrastructure,"Dulles, Virginia",2006-02-01,0001014473, VRSK,Verisk Analytics,reports,Industrials,Research & Consulting Services,"Jersey City, New Jersey",2015-10-08,0001442145, VZ,Verizon Communications,reports,Communication Services,Integrated Telecommunication Services,"New York, New York",1983-11-30,0000732712, VRTX,Vertex Pharmaceuticals Inc,reports,Health Care,Biotechnology,"Cambridge, Massachusetts",2013-09-23,0000875320, VIAB,Viacom Inc.,reports,Communication Services,Movies & Entertainment,"New York, New York",,0001339947, V,Visa Inc.,reports,Information Technology,IT Services,"San Francisco, California",2009-12-21,0001403161, VNO,Vornado Realty Trust,reports,Real Estate,Office REITs,"New York, New York",,0000899689, VMC,Vulcan Materials,reports,Materials,Construction Materials,"Birmingham, Alabama",1999-06-30,0001396009, WAB,Wabtec Corporation,reports,Industrials,Construction Machinery & Heavy Trucks,"Wilmerding, Pennsylvania",2019-02-27,0000943452, WMT,Walmart,reports,Consumer Staples,Hypermarkets & Super Centers,"Bentonville, Arkansas",1982-08-31,0000104169, WBA,Walgreens Boots Alliance,reports,Consumer Staples,Drug Retail,"Deerfield, Illinois",1979-12-31,0001618921, DIS,The Walt Disney Company,reports,Communication Services,Movies & Entertainment,"Burbank, California",1976-06-30,0001001039, WM,Waste Management Inc.,reports,Industrials,Environmental & Facilities Services,"Houston, Texas",,0000823768,1968 WAT,Waters Corporation,reports,Health Care,Health Care Distributors,"Milford, Massachusetts",,0001000697,1958 WEC,Wec Energy Group Inc,reports,Utilities,Electric Utilities,"Milwaukee, Wisconsin",2008-10-31,0000783325, WCG,WellCare,reports,Health Care,Managed Health Care,"Tampa, Florida",1985,0001279363, WFC,Wells Fargo,reports,Financials,Diversified Banks,"San Francisco, California",1976-06-30,0000072971, WELL,Welltower Inc.,reports,Real Estate,Health Care REITs,"Toledo, Ohio",2009-01-30,0000766704, WDC,Western Digital,reports,Information Technology,"Technology Hardware, Storage & Peripherals","Irvine, California",2009-07-01,0000106040, WU,Western Union Co,reports,Information Technology,Internet Software & Services,"Englewood, Colorado",,0001365135,1851 WRK,WestRock,reports,Materials,Paper Packaging,"Richmond, Virginia",,0001636023, WY,Weyerhaeuser,reports,Real Estate,Specialized REITS,"Federal Way, Washington",,0000106535, WHR,Whirlpool Corp.,reports,Consumer Discretionary,Household Appliances,"Benton Harbor, Michigan",,0000106640,1911 WMB,Williams Cos.,reports,Energy,Oil & Gas Storage & Transportation,"Tulsa, Oklahoma",1975-03-31,0000107263, WLTW,Willis Towers Watson,reports,Financials,Insurance Brokers,"London, United Kingdom",2016-01-05,0001140536, WYNN,Wynn Resorts Ltd,reports,Consumer Discretionary,Casinos & Gaming,"Paradise, Nevada",2008-11-14,0001174922, XEL,Xcel Energy Inc,reports,Utilities,Multi-Utilities,"Minneapolis, Minnesota",,0000072903,1909 XRX,Xerox,reports,Information Technology,"Technology Hardware, Storage & Peripherals","Norwalk, Connecticut",,0000108772,1906 XLNX,Xilinx,reports,Information Technology,Semiconductors,"San Jose, California",1999-11-08,0000743988, XYL,Xylem Inc.,reports,Industrials,Industrial Machinery,"White Plains, New York",2011-11-01,0001524472, YUM,Yum! Brands Inc,reports,Consumer Discretionary,Restaurants,"Louisville, Kentucky",1997-10-06,0001041061, ZBH,Zimmer Biomet Holdings,reports,Health Care,Health Care Equipment,"Warsaw, Indiana",2001-08-07,0001136869, ZION,Zions Bancorp,reports,Financials,Regional Banks,"Salt Lake City, Utah",2001-06-22,0000109380, ZTS,Zoetis,reports,Health Care,Pharmaceuticals,"Florham Park, New Jersey",2013-06-21,0001555280,`).map(row=>{ let company={} company.Symbol=row['Symbol'] company.Name=row["Security"]; company.Sector=row['GICS Sector']; company.SubIndustry=row['GICS Sub Industry']; company.HQ=row["Headquarters Location"]; company.CIK=row['CIK']; company.SecReports=row["SEC filings"]; company.Name=row["Security"]; company.SP500_Since=row['Date first added']; company.Founded=row["Founded"]; return {...company}; })35:T4e80,NASDAQ100_mock = JSON.parse( `[{"symbol":"ATVI","companyName":"Activision Blizzard, Inc. Common Stock","marketCap":"47,271,042,107","lastSalePrice":"$61.53","netChange":"+1.27","percentageChange":"2.11%","deltaIndicator":"up"},{"symbol":"ADBE","companyName":"Adobe Inc. Common Stock","marketCap":"178,551,580,222","lastSalePrice":"$366.09","netChange":"-1.37","percentageChange":"0.37%","deltaIndicator":"down"},{"symbol":"AMD","companyName":"Advanced Micro Devices, Inc. Common Stock","marketCap":"58,167,268,185","lastSalePrice":"$49.73","netChange":"+0.41","percentageChange":"0.83%","deltaIndicator":"up"},{"symbol":"ALXN","companyName":"Alexion Pharmaceuticals, Inc. Common Stock","marketCap":"22,264,071,688","lastSalePrice":"$100.56","netChange":"-3.48","percentageChange":"3.34%","deltaIndicator":"down"},{"symbol":"ALGN","companyName":"Align Technology, Inc. Common Stock","marketCap":"20,386,547,846","lastSalePrice":"$258.67","netChange":"-8.09","percentageChange":"3.03%","deltaIndicator":"down"},{"symbol":"GOOG","companyName":"Alphabet Inc. Class C Capital Stock","marketCap":"1,016,654,202,911","lastSalePrice":"$1479.23","netChange":"+3.00","percentageChange":"0.2%","deltaIndicator":"up"},{"symbol":"GOOGL","companyName":"Alphabet Inc. Class A Common Stock","marketCap":"1,016,571,728,580","lastSalePrice":"$1479.11","netChange":"+3.14","percentageChange":"0.21%","deltaIndicator":"up"},{"symbol":"AMZN","companyName":"Amazon.com, Inc. Common Stock","marketCap":"1,035,087,300,000","lastSalePrice":"$2079.28","netChange":"+29.05","percentageChange":"1.42%","deltaIndicator":"up"},{"symbol":"AAL","companyName":"American Airlines Group Inc. Common Stock","marketCap":"12,152,316,000","lastSalePrice":"$28.38","netChange":"+0.08","percentageChange":"0.28%","deltaIndicator":"up"},{"symbol":"AMGN","companyName":"Amgen Inc. Common Stock","marketCap":"135,534,030,000","lastSalePrice":"$229.33","netChange":"-2.12","percentageChange":"0.92%","deltaIndicator":"down"},{"symbol":"ADI","companyName":"Analog Devices, Inc. Common Stock","marketCap":"41,422,510,937","lastSalePrice":"$112.27","netChange":"-3.52","percentageChange":"3.04%","deltaIndicator":"down"},{"symbol":"ANSS","companyName":"ANSYS, Inc. Common Stock","marketCap":"24,350,780,069","lastSalePrice":"$284.83","netChange":"-1.05","percentageChange":"0.37%","deltaIndicator":"down"},{"symbol":"AAPL","companyName":"Apple Inc. Common Stock","marketCap":"1,400,284,864,400","lastSalePrice":"$320.03","netChange":"-4.41","percentageChange":"1.36%","deltaIndicator":"down"},{"symbol":"AMAT","companyName":"Applied Materials, Inc. Common Stock","marketCap":"56,687,213,101","lastSalePrice":"$61.71","netChange":"-1.48","percentageChange":"2.34%","deltaIndicator":"down"},{"symbol":"ASML","companyName":"ASML Holding N.V. New York Registry Shares","marketCap":"129,813,439,929","lastSalePrice":"$304.97","netChange":"-4.58","percentageChange":"1.48%","deltaIndicator":"down"},{"symbol":"ADSK","companyName":"Autodesk, Inc. Common Stock","marketCap":"45,549,031,744","lastSalePrice":"$207.01","netChange":"+1.01","percentageChange":"0.49%","deltaIndicator":"up"},{"symbol":"ADP","companyName":"Automatic Data Processing, Inc. Common Stock","marketCap":"77,327,186,533","lastSalePrice":"$179.10","netChange":"-1.16","percentageChange":"0.64%","deltaIndicator":"down"},{"symbol":"BIDU","companyName":"Baidu, Inc. ADS","marketCap":"45,360,148,744","lastSalePrice":"$130.91","netChange":"-2.25","percentageChange":"1.69%","deltaIndicator":"down"},{"symbol":"BIIB","companyName":"Biogen Inc. Common Stock","marketCap":"61,115,664,079","lastSalePrice":"$338.70","netChange":"+1.46","percentageChange":"0.43%","deltaIndicator":"up"},{"symbol":"BMRN","companyName":"BioMarin Pharmaceutical Inc. Common Stock","marketCap":"15,550,162,481","lastSalePrice":"$86.57","netChange":"-2.30","percentageChange":"2.59%","deltaIndicator":"down"},{"symbol":"BKNG","companyName":"Booking Holdings Inc. Common Stock","marketCap":"79,927,226,163","lastSalePrice":"$1909.59","netChange":"-51.31","percentageChange":"2.62%","deltaIndicator":"down"},{"symbol":"AVGO","companyName":"Broadcom Inc. Common Stock","marketCap":"125,396,063,261","lastSalePrice":"$315.23","netChange":"-4.46","percentageChange":"1.4%","deltaIndicator":"down"},{"symbol":"CDNS","companyName":"Cadence Design Systems, Inc. Common Stock","marketCap":"20,637,615,150","lastSalePrice":"$73.55","netChange":"-0.99","percentageChange":"1.33%","deltaIndicator":"down"},{"symbol":"CDW","companyName":"CDW Corporation Common Stock","marketCap":"19,060,675,427","lastSalePrice":"$132.66","netChange":"-1.98","percentageChange":"1.47%","deltaIndicator":"down"},{"symbol":"CERN","companyName":"Cerner Corporation Common Stock","marketCap":"24,791,708,571","lastSalePrice":"$78.93","netChange":"-0.02","percentageChange":"0.03%","deltaIndicator":"down"},{"symbol":"CHTR","companyName":"Charter Communications, Inc. Class A Common Stock New","marketCap":"110,281,476,052","lastSalePrice":"$525.21","netChange":"-1.35","percentageChange":"0.26%","deltaIndicator":"down"},{"symbol":"CHKP","companyName":"Check Point Software Technologies Ltd. Ordinary Shares","marketCap":"17,851,604,708","lastSalePrice":"$117.26","netChange":"-0.27","percentageChange":"0.23%","deltaIndicator":"down"},{"symbol":"CTAS","companyName":"Cintas Corporation Common Stock","marketCap":"30,251,657,681","lastSalePrice":"$291.58","netChange":"-2.07","percentageChange":"0.7%","deltaIndicator":"down"},{"symbol":"CSCO","companyName":"Cisco Systems, Inc. Common Stock","marketCap":"203,501,335,483","lastSalePrice":"$47.97","netChange":"-0.72","percentageChange":"1.48%","deltaIndicator":"down"},{"symbol":"CTXS","companyName":"Citrix Systems, Inc. Common Stock","marketCap":"15,767,018,469","lastSalePrice":"$121.08","netChange":"-1.15","percentageChange":"0.94%","deltaIndicator":"down"},{"symbol":"CTSH","companyName":"Cognizant Technology Solutions Corporation Class A Common Stock","marketCap":"38,105,105,553","lastSalePrice":"$69.59","netChange":"-1.83","percentageChange":"2.56%","deltaIndicator":"down"},{"symbol":"CMCSA","companyName":"Comcast Corporation Class A Common Stock","marketCap":"203,702,770,017","lastSalePrice":"$44.74","netChange":"+0.14","percentageChange":"0.31%","deltaIndicator":"up"},{"symbol":"CPRT","companyName":"Copart, Inc. (DE) Common Stock","marketCap":"23,845,152,451","lastSalePrice":"$102.58","netChange":"-0.37","percentageChange":"0.36%","deltaIndicator":"down"},{"symbol":"CSGP","companyName":"CoStar Group, Inc. Common Stock","marketCap":"24,416,845,154","lastSalePrice":"$666.49","netChange":"-0.03","percentageChange":"0%","deltaIndicator":"down"},{"symbol":"COST","companyName":"Costco Wholesale Corporation Common Stock","marketCap":"138,548,444,556","lastSalePrice":"$313.63","netChange":"+3.02","percentageChange":"0.97%","deltaIndicator":"up"},{"symbol":"CSX","companyName":"CSX Corporation Common Stock","marketCap":"60,555,154,788","lastSalePrice":"$77.87","netChange":"-0.45","percentageChange":"0.57%","deltaIndicator":"down"},{"symbol":"DLTR","companyName":"Dollar Tree Inc. Common Stock","marketCap":"20,622,753,345","lastSalePrice":"$87.14","netChange":"-0.80","percentageChange":"0.91%","deltaIndicator":"down"},{"symbol":"EBAY","companyName":"eBay Inc. Common Stock","marketCap":"28,818,125,901","lastSalePrice":"$36.20","netChange":"-1.80","percentageChange":"4.74%","deltaIndicator":"down"},{"symbol":"EA","companyName":"Electronic Arts Inc. Common Stock","marketCap":"31,600,569,496","lastSalePrice":"$109.09","netChange":"-0.91","percentageChange":"0.83%","deltaIndicator":"down"},{"symbol":"EXC","companyName":"Exelon Corporation Common Stock","marketCap":"46,845,926,204","lastSalePrice":"$48.19","netChange":"-0.07","percentageChange":"0.15%","deltaIndicator":"down"},{"symbol":"EXPE","companyName":"Expedia Group, Inc. Common Stock","marketCap":"15,950,529,684","lastSalePrice":"$110.09","netChange":"-1.66","percentageChange":"1.49%","deltaIndicator":"down"},{"symbol":"FB","companyName":"Facebook, Inc. Class A Common Stock","marketCap":"605,236,188,425","lastSalePrice":"$212.33","netChange":"+1.48","percentageChange":"0.7%","deltaIndicator":"up"},{"symbol":"FAST","companyName":"Fastenal Company Common Stock","marketCap":"21,443,714,826","lastSalePrice":"$37.35","netChange":"-0.55","percentageChange":"1.45%","deltaIndicator":"down"},{"symbol":"FISV","companyName":"Fiserv, Inc. Common Stock","marketCap":"82,852,004,822","lastSalePrice":"$121.86","netChange":"+0.19","percentageChange":"0.16%","deltaIndicator":"up"},{"symbol":"FOX","companyName":"Fox Corporation Class B Common Stock","marketCap":"22,574,302,503","lastSalePrice":"$36.37","netChange":"-0.13","percentageChange":"0.36%","deltaIndicator":"down"},{"symbol":"FOXA","companyName":"Fox Corporation Class A Common Stock","marketCap":"22,965,333,863","lastSalePrice":"$37.00","netChange":"-0.11","percentageChange":"0.3%","deltaIndicator":"down"},{"symbol":"GILD","companyName":"Gilead Sciences, Inc. Common Stock","marketCap":"87,130,578,298","lastSalePrice":"$68.87","netChange":"+0.66","percentageChange":"0.97%","deltaIndicator":"up"},{"symbol":"IDXX","companyName":"IDEXX Laboratories, Inc. Common Stock","marketCap":"23,881,868,045","lastSalePrice":"$278.40","netChange":"-2.27","percentageChange":"0.81%","deltaIndicator":"down"},{"symbol":"ILMN","companyName":"Illumina, Inc. Common Stock","marketCap":"43,262,100,000","lastSalePrice":"$294.30","netChange":"-6.93","percentageChange":"2.3%","deltaIndicator":"down"},{"symbol":"INCY","companyName":"Incyte Corp. Common Stock","marketCap":"15,969,555,081","lastSalePrice":"$74.14","netChange":"-1.67","percentageChange":"2.2%","deltaIndicator":"down"},{"symbol":"INTC","companyName":"Intel Corporation Common Stock","marketCap":"282,367,540,000","lastSalePrice":"$66.02","netChange":"-1.07","percentageChange":"1.59%","deltaIndicator":"down"},{"symbol":"INTU","companyName":"Intuit Inc. Common Stock","marketCap":"76,714,967,222","lastSalePrice":"$294.71","netChange":"+0.50","percentageChange":"0.17%","deltaIndicator":"up"},{"symbol":"ISRG","companyName":"Intuitive Surgical, Inc. Common Stock","marketCap":"66,966,756,002","lastSalePrice":"$579.43","netChange":"-2.12","percentageChange":"0.36%","deltaIndicator":"down"},{"symbol":"JD","companyName":"JD.com, Inc. American Depositary Shares","marketCap":"58,391,837,190","lastSalePrice":"$39.99","netChange":"-0.39","percentageChange":"0.97%","deltaIndicator":"down"},{"symbol":"KLAC","companyName":"KLA Corporation Common Stock","marketCap":"26,051,871,125","lastSalePrice":"$165.10","netChange":"-6.64","percentageChange":"3.87%","deltaIndicator":"down"},{"symbol":"LRCX","companyName":"Lam Research Corporation Common Stock","marketCap":"45,905,987,438","lastSalePrice":"$315.40","netChange":"-8.12","percentageChange":"2.51%","deltaIndicator":"down"},{"symbol":"LBTYA","companyName":"Liberty Global plc Class A Ordinary Shares","marketCap":"12,895,750,232","lastSalePrice":"$20.39","netChange":"-0.66","percentageChange":"3.14%","deltaIndicator":"down"},{"symbol":"LBTYK","companyName":"Liberty Global plc Class C Ordinary Shares","marketCap":"12,307,567,411","lastSalePrice":"$19.46","netChange":"-0.50","percentageChange":"2.51%","deltaIndicator":"down"},{"symbol":"LULU","companyName":"lululemon athletica inc. Common Stock","marketCap":"31,728,112,804","lastSalePrice":"$243.51","netChange":"-0.27","percentageChange":"0.11%","deltaIndicator":"down"},{"symbol":"MAR","companyName":"Marriott International Class A Common Stock","marketCap":"47,101,845,141","lastSalePrice":"$144.07","netChange":"-2.15","percentageChange":"1.47%","deltaIndicator":"down"},{"symbol":"MXIM","companyName":"Maxim Integrated Products, Inc. Common Stock","marketCap":"16,845,218,326","lastSalePrice":"$62.53","netChange":"-1.55","percentageChange":"2.42%","deltaIndicator":"down"},{"symbol":"MELI","companyName":"MercadoLibre, Inc. Common Stock","marketCap":"32,113,625,129","lastSalePrice":"$646.02","netChange":"-24.98","percentageChange":"3.72%","deltaIndicator":"down"},{"symbol":"MCHP","companyName":"Microchip Technology Incorporated Common Stock","marketCap":"25,441,339,052","lastSalePrice":"$106.21","netChange":"-2.27","percentageChange":"2.09%","deltaIndicator":"down"},{"symbol":"MU","companyName":"Micron Technology, Inc. Common Stock","marketCap":"63,186,487,752","lastSalePrice":"$56.88","netChange":"-1.80","percentageChange":"3.07%","deltaIndicator":"down"},{"symbol":"MSFT","companyName":"Microsoft Corporation Common Stock","marketCap":"1,398,675,984,669","lastSalePrice":"$183.89","netChange":"+0.26","percentageChange":"0.14%","deltaIndicator":"up"},{"symbol":"MDLZ","companyName":"Mondelez International, Inc. Class A Common Stock","marketCap":"84,460,097,603","lastSalePrice":"$58.66","netChange":"+0.24","percentageChange":"0.41%","deltaIndicator":"up"},{"symbol":"MNST","companyName":"Monster Beverage Corporation","marketCap":"37,048,956,436","lastSalePrice":"$68.905","netChange":"-0.545","percentageChange":"0.78%","deltaIndicator":"down"},{"symbol":"NTAP","companyName":"NetApp, Inc. Common Stock","marketCap":"13,086,490,652","lastSalePrice":"$57.34","netChange":"-0.81","percentageChange":"1.39%","deltaIndicator":"down"},{"symbol":"NTES","companyName":"NetEase, Inc. American Depositary Shares","marketCap":"43,474,660,056","lastSalePrice":"$339.75","netChange":"-7.13","percentageChange":"2.06%","deltaIndicator":"down"},{"symbol":"NFLX","companyName":"Netflix, Inc. Common Stock","marketCap":"160,941,114,654","lastSalePrice":"$366.77","netChange":"-0.18","percentageChange":"0.05%","deltaIndicator":"down"},{"symbol":"NVDA","companyName":"NVIDIA Corporation Common Stock","marketCap":"161,518,563,995","lastSalePrice":"$251.59","netChange":"-2.655","percentageChange":"1.04%","deltaIndicator":"down"},{"symbol":"NXPI","companyName":"NXP Semiconductors N.V. Common Stock","marketCap":"36,970,250,940","lastSalePrice":"$132.26","netChange":"-3.08","percentageChange":"2.28%","deltaIndicator":"down"},{"symbol":"ORLY","companyName":"O'Reilly Automotive, Inc. Common Stock","marketCap":"29,332,197,778","lastSalePrice":"$387.69","netChange":"-10.44","percentageChange":"2.62%","deltaIndicator":"down"},{"symbol":"PCAR","companyName":"PACCAR Inc. Common Stock","marketCap":"26,114,483,000","lastSalePrice":"$75.41","netChange":"-2.18","percentageChange":"2.81%","deltaIndicator":"down"},{"symbol":"PAYX","companyName":"Paychex, Inc. Common Stock","marketCap":"31,530,842,510","lastSalePrice":"$87.98","netChange":"-0.47","percentageChange":"0.53%","deltaIndicator":"down"},{"symbol":"PYPL","companyName":"PayPal Holdings, Inc. Common Stock","marketCap":"139,587,998,337","lastSalePrice":"$118.88","netChange":"-1.01","percentageChange":"0.84%","deltaIndicator":"down"},{"symbol":"PEP","companyName":"PepsiCo, Inc. Common Stock","marketCap":"202,709,065,085","lastSalePrice":"$145.37","netChange":"+1.04","percentageChange":"0.72%","deltaIndicator":"up"},{"symbol":"QCOM","companyName":"QUALCOMM Incorporated Common Stock","marketCap":"99,862,146,875","lastSalePrice":"$87.42","netChange":"-3.19","percentageChange":"3.52%","deltaIndicator":"down"},{"symbol":"REGN","companyName":"Regeneron Pharmaceuticals, Inc. Common Stock","marketCap":"41,927,708,399","lastSalePrice":"$381.87","netChange":"-7.98","percentageChange":"2.05%","deltaIndicator":"down"},{"symbol":"ROST","companyName":"Ross Stores, Inc. Common Stock","marketCap":"42,143,553,421","lastSalePrice":"$117.43","netChange":"-0.76","percentageChange":"0.64%","deltaIndicator":"down"},{"symbol":"SGEN","companyName":"Seattle Genetics, Inc. Common Stock","marketCap":"20,122,389,871","lastSalePrice":"$117.41","netChange":"-1.23","percentageChange":"1.04%","deltaIndicator":"down"},{"symbol":"SIRI","companyName":"Sirius XM Holdings Inc. Common Stock","marketCap":"31,383,145,217","lastSalePrice":"$7.11","netChange":"-0.08","percentageChange":"1.11%","deltaIndicator":"down"},{"symbol":"SWKS","companyName":"Skyworks Solutions, Inc. Common Stock","marketCap":"19,387,481,323","lastSalePrice":"$113.94","netChange":"-3.74","percentageChange":"3.18%","deltaIndicator":"down"},{"symbol":"SPLK","companyName":"Splunk Inc. Common Stock","marketCap":"25,352,828,896","lastSalePrice":"$162.55","netChange":"-0.12","percentageChange":"0.07%","deltaIndicator":"down"},{"symbol":"SBUX","companyName":"Starbucks Corporation Common Stock","marketCap":"101,431,154,000","lastSalePrice":"$86.42","netChange":"+0.27","percentageChange":"0.31%","deltaIndicator":"up"},{"symbol":"SNPS","companyName":"Synopsys, Inc. Common Stock","marketCap":"23,224,520,824","lastSalePrice":"$154.28","netChange":"-0.49","percentageChange":"0.32%","deltaIndicator":"down"},{"symbol":"TMUS","companyName":"T-Mobile US, Inc. Common Stock","marketCap":"73,100,310,741","lastSalePrice":"$85.44","netChange":"+2.67","percentageChange":"3.23%","deltaIndicator":"up"},{"symbol":"TTWO","companyName":"Take-Two Interactive Software, Inc. Common Stock","marketCap":"12,762,865,669","lastSalePrice":"$112.60","netChange":"-15.14","percentageChange":"11.85%","deltaIndicator":"down"},{"symbol":"TSLA","companyName":"Tesla, Inc. Common Stock","marketCap":"134,835,770,924","lastSalePrice":"$748.07","netChange":"-0.89","percentageChange":"0.12%","deltaIndicator":"down"},{"symbol":"TXN","companyName":"Texas Instruments Incorporated Common Stock","marketCap":"119,952,461,515","lastSalePrice":"$128.70","netChange":"-3.82","percentageChange":"2.88%","deltaIndicator":"down"},{"symbol":"KHC","companyName":"The Kraft Heinz Company Common Stock","marketCap":"36,073,085,483","lastSalePrice":"$29.54","netChange":"+0.48","percentageChange":"1.65%","deltaIndicator":"up"},{"symbol":"TCOM","companyName":"Trip.com Group Limited American Depositary Shares","marketCap":"19,929,700,048","lastSalePrice":"$33.87","netChange":"-0.20","percentageChange":"0.59%","deltaIndicator":"down"},{"symbol":"ULTA","companyName":"Ulta Beauty, Inc. Common Stock","marketCap":"16,917,470,778","lastSalePrice":"$295.96","netChange":"+2.91","percentageChange":"0.99%","deltaIndicator":"up"},{"symbol":"UAL","companyName":"United Airlines Holdings, Inc. Common Stock","marketCap":"20,111,909,302","lastSalePrice":"$79.48","netChange":"-1.02","percentageChange":"1.27%","deltaIndicator":"down"},{"symbol":"VRSN","companyName":"VeriSign, Inc. Common Stock","marketCap":"24,077,065,681","lastSalePrice":"$205.07","netChange":"-11.87","percentageChange":"5.47%","deltaIndicator":"down"},{"symbol":"VRSK","companyName":"Verisk Analytics, Inc. Common Stock","marketCap":"27,713,665,819","lastSalePrice":"$169.12","netChange":"+0.17","percentageChange":"0.1%","deltaIndicator":"up"},{"symbol":"VRTX","companyName":"Vertex Pharmaceuticals Incorporated Common Stock","marketCap":"61,731,330,095","lastSalePrice":"$240.06","netChange":"+0.94","percentageChange":"0.39%","deltaIndicator":"up"},{"symbol":"WBA","companyName":"Walgreens Boots Alliance, Inc. Common Stock","marketCap":"47,163,272,862","lastSalePrice":"$53.24","netChange":"-0.25","percentageChange":"0.47%","deltaIndicator":"down"},{"symbol":"WDC","companyName":"Western Digital Corporation Common Stock","marketCap":"19,935,025,981","lastSalePrice":"$67.03","netChange":"-1.67","percentageChange":"2.43%","deltaIndicator":"down"},{"symbol":"WLTW","companyName":"Willis Towers Watson Public Limited Company Ordinary Shares","marketCap":"27,032,411,437","lastSalePrice":"$210.25","netChange":"+1.35","percentageChange":"0.65%","deltaIndicator":"up"},{"symbol":"WDAY","companyName":"Workday, Inc. Class A Common Stock","marketCap":"44,178,400,000","lastSalePrice":"$192.08","netChange":"+4.58","percentageChange":"2.44%","deltaIndicator":"up"},{"symbol":"XEL","companyName":"Xcel Energy Inc. Common Stock","marketCap":"36,030,706,076","lastSalePrice":"$68.71","netChange":"-0.59","percentageChange":"0.85%","deltaIndicator":"down"},{"symbol":"XLNX","companyName":"Xilinx, Inc. Common Stock","marketCap":"21,305,386,353","lastSalePrice":"$85.62","netChange":"-2.10","percentageChange":"2.39%","deltaIndicator":"down"}]` )36:T2464,world_exchanges = { var psv = d3.dsvFormat("|"); return psv.parse(`CODE|EXCHANGE ABUDHABISECURITIESEXCHANGE|Domestic Market Capitalization at Exchange: Abu Dhabi Securities Exchange ABUDHABISECURITIESEXCHANGEADI|Stock Market Index at Exchange: Abu Dhabi Securities Exchange ADI AMMANSE|Value of Share Trading at Exchange: Amman Stock Exchange AMMANSEASEINDEX|Stock Market Index at Exchange: Amman Stock Exchange ASE Index ATHENSSE|Value of Share Trading at Exchange: Athens Stock Exchange ATHENSSEGENERALPRICE|Stock Market Index at Exchange: Athens Stock Exchange General Price AUSTRALIANSECURITIESEXCHANGE|Domestic Market Capitalization at Exchange: Australian Securities Exchange AUSTRALIANSECURITIESEXCHANGEALLORDINARYPRICE|Stock Market Index at Exchange: Australian Securities Exchange All Ordinary Price BAHRAINBOURSE|Domestic Market Capitalization at Exchange: Bahrain Bourse BATSCHIXEUROPE|Value of Share Trading at Exchange: BATS Chi-x Europe BATSGLOBALMARKETSUS|Value of Share Trading at Exchange: BATS Global Markets, US BERMUDASE|Value of Share Trading at Exchange: Bermuda Stock Exchange BERMUDASEBSXINDEX|Stock Market Index at Exchange: Bermuda Stock Exchange BSX Index BMESPANISHEXCHANGES|Domestic Market Capitalization at Exchange: BME Spanish Exchanges BMESPANISHEXCHANGESBARCELONABCNGLOBAL|Stock Market Index at Exchange: BME Spanish Exchanges Barcelona BCN Global, 100 Index BMESPANISHEXCHANGESBILBAOINDICEBOLSABILBAO|Stock Market Index at Exchange: BME Spanish Exchanges Bilbao Indice Bolsa Bilbao 2000 BMESPANISHEXCHANGESMADRID|Stock Market Index at Exchange: BME Spanish Exchanges Madrid BMESPANISHEXCHANGESVALENCIAIGBVINDEX|Stock Market Index at Exchange: BME Spanish Exchanges Valencia IGBV Index BMFBOVESPA|Value of Share Trading at Exchange: BM&FBOVESPA BOURSEDECASABLANCA|Value of Share Trading at Exchange: Bourse de Casablanca BOURSEDECASABLANCAMASIFLOAT|Stock Market Index at Exchange: Bourse de Casablanca MASI Float BSEINDIALIMITED|Value of Bond Trading at Exchange: BSE India Limited BSEINDIALIMITEDSPBSE|Stock Market Index at Exchange: BSE India Limited S&P BSE 500 BUDAPESTSE|Value of Bond Trading at Exchange: Budapest Stock Exchange BUENOSAIRESSE|Value of Share Trading at Exchange: Bolsa de Comercio de Buenos Aires BUENOSAIRESSECOMPOSITE|Stock Market Index at Exchange: Bolsa de Comercio de Buenos Aires Composite BURSAMALAYSIA|Domestic Market Capitalization at Exchange: Bursa Malaysia BURSAMALAYSIAFBMEMASINDEX|Stock Market Index at Exchange: Bursa Malaysia FBM Emas Index COLOMBIASE|Value of Share Trading at Exchange: Bolsa de Valores de Colombia COLOMBIASECOLEQTY|Stock Market Index at Exchange: Bolsa de Valores de Colombia COLEQTY COLOMBOSE|Value of Bond Trading at Exchange: Colombo Stock Exchange COLOMBOSECSEALLSHARE|Stock Market Index at Exchange: Colombo Stock Exchange CSE All Share CYPRUSSE|Domestic Market Capitalization at Exchange: Cyprus Stock Exchange CYPRUSSECSEGENERALINDEX|Stock Market Index at Exchange: Cyprus Stock Exchange CSE General Index DEUTSCHEBOERSE|Value of Share Trading at Exchange: Deutsche Boerse DEUTSCHEBOERSECDAXPRICE|Stock Market Index at Exchange: Deutsche Boerse CDAX Price DUBAIFINANCIALMARKET|Value of Share Trading at Exchange: Dubai Financial Market DUBAIFINANCIALMARKETDFMGI|Stock Market Index at Exchange: Dubai Financial Market DFMGI EGYPTIANEXCHANGE|Value of Share Trading at Exchange: Egyptian Exchange EGYPTIANEXCHANGEEGXINDEX|Stock Market Index at Exchange: Egyptian Exchange EGX 30 Index EURONEXT|Value of Bond Trading at Exchange: Euronext EURONEXTAMSTERDAMAAX|Stock Market Index at Exchange: Euronext Amsterdam AAX EURONEXTBRUSSELSGENERALPRICE|Stock Market Index at Exchange: Euronext Brussels General Price EURONEXTLISBONBVLGENERAL|Stock Market Index at Exchange: Euronext Lisbon BVL General EURONEXTPARISSBF|Stock Market Index at Exchange: Euronext Paris SBF 250 HOCHIMINHSE|Value of Share Trading at Exchange: Hochiminh Stock Exchange HOCHIMINHSEVNINDEX|Stock Market Index at Exchange: Hochiminh Stock Exchange VN Index HONGKONGEXCHANGES|Value of Share Trading at Exchange: Hong Kong Exchanges and Clearing HONGKONGEXCHANGESSPHKEXLARGECAPINDEX|Stock Market Index at Exchange: Hong Kong Exchanges and Clearing S&P/HKEX LargeCap Index INDONESIASE|Value of Share Trading at Exchange: Indonesia Stock Exchange IRISHSE|Domestic Market Capitalization at Exchange: Irish Stock Exchange IRISHSEISEQOVERALL|Stock Market Index at Exchange: Irish Stock Exchange ISEQ Overall ISTANBULSE|Domestic Market Capitalization at Exchange: Borsa Istanbul ISTANBULSEBIST|Stock Market Index at Exchange: Borsa Istanbul BIST 100 JAPANEXCHANGEGROUP|Value of Share Trading at Exchange: Japan Exchange Group JAPANEXCHANGEGROUPTOPIX|Stock Market Index at Exchange: Japan Exchange Group Topix JOHANNESBURGSE|Domestic Market Capitalization at Exchange: Johannesburg Stock Exchange JOHANNESBURGSEFTSEJSEALLSHARE|Stock Market Index at Exchange: Johannesburg Stock Exchange FTSE/JSE All Share KAZAKHSTANSE|Value of Bond Trading at Exchange: Kazakhstan Stock Exchange KOREAEXCHANGE|Domestic Market Capitalization at Exchange: Korea Exchange KOREAEXCHANGEKOSPI|Stock Market Index at Exchange: Korea Exchange KOSPI LIMASE|Domestic Market Capitalization at Exchange: Bolsa de Valores de Lima LJUBLJANASE|Value of Bond Trading at Exchange: Ljubljana Stock Exchange LUXEMBOURGSE|Value of Bond Trading at Exchange: Luxembourg Stock Exchange LUXEMBOURGSELUXGENERALPRICE|Stock Market Index at Exchange: Luxembourg Stock Exchange Lux General Price MALTASE|Stock Market Index at Exchange: Malta Stock Exchange MEXICANASE|Domestic Market Capitalization at Exchange: Bolsa Mexicana de Valores MOSCOWEXCHANGE|Value of Share Trading at Exchange: Moscow Exchange MUSCATSECURITIESMARKET|Domestic Market Capitalization at Exchange: Muscat Securities Market MUSCATSECURITIESMARKETMSM|Stock Market Index at Exchange: Muscat Securities Market msm30 NASDAQOMXNORDICCOPENHAGENOMXC|Stock Market Index at Exchange: NASDAQ OMX Nordic Copenhagen OMXC NASDAQOMXNORDICEXCHANGE|Domestic Market Capitalization at Exchange: NASDAQ OMX Nordic Exchange NASDAQOMXNORDICEXCHANGEOMXNORDICEURPI|Stock Market Index at Exchange: NASDAQ OMX Nordic Exchange OMX Nordic Eur PI (All-Share) NASDAQOMXNORDICHELSINKIOMXH|Stock Market Index at Exchange: NASDAQ OMX Nordic Helsinki OMXH NASDAQOMXNORDICICELANDOMXIPI|Stock Market Index at Exchange: NASDAQ OMX Nordic Iceland OMXIPI NASDAQOMXNORDICSTOCKHOLMOMXS|Stock Market Index at Exchange: NASDAQ OMX Nordic Stockholm OMXS NASDAQUS|Value of Share Trading at Exchange: Nasdaq, US NASDAQUSCOMPOSITE|Stock Market Index at Exchange: Nasdaq, US Composite NATIONALSEOFINDIA|Value of Share Trading at Exchange: National Stock Exchange of India NATIONALSEOFINDIASPCNX|Stock Market Index at Exchange: National Stock Exchange of India S&P CNX 500 NIGERIANSE|Domestic Market Capitalization at Exchange: Nigerian Stock Exchange NYSE|Domestic Market Capitalization at Exchange: NYSE NYSECOMPOSITE|Stock Market Index at Exchange: NYSE Composite NZXLIMITED|Value of Bond Trading at Exchange: NZX Limited NZXLIMITEDGROSSINDEX|Stock Market Index at Exchange: NZX Limited Gross Index OSLOBORS|Domestic Market Capitalization at Exchange: Oslo Bors OSLOBORSOSEBXPR|Stock Market Index at Exchange: Oslo Bors OSEBXPR PHILIPPINESE|Value of Share Trading at Exchange: Philippine Stock Exchange QATARSE|Value of Bond Trading at Exchange: Qatar Stock Exchange QATARSEQEALLSHAREINDEX|Stock Market Index at Exchange: Qatar Stock Exchange QE All Share Index SANTIAGOSE|Value of Share Trading at Exchange: Bolsa de Comercio de Santiago SANTIAGOSEIGPA|Stock Market Index at Exchange: Bolsa de Comercio de Santiago IGPA SAUDISE|Domestic Market Capitalization at Exchange: Saudi Stock Exchange (Tadawul) SAUDISETASI|Stock Market Index at Exchange: Saudi Stock Exchange (Tadawul) TASI SEOFMAURITIUS|Domestic Market Capitalization at Exchange: Stock Exchange of Mauritius SEOFMAURITIUSSEMDEX|Stock Market Index at Exchange: Stock Exchange of Mauritius SEMDEX SEOFTHAILAND|Value of Bond Trading at Exchange: Stock Exchange of Thailand SEOFTHAILANDSETINDEX|Stock Market Index at Exchange: Stock Exchange of Thailand SET Index SHANGHAISE|Value of Share Trading at Exchange: Shanghai Stock Exchange SHENZHENSE|Value of Bond Trading at Exchange: Shenzhen Stock Exchange SHENZHENSESZSECOMPOSITEINDEX|Stock Market Index at Exchange: Shenzhen Stock Exchange SZSE Composite Index SINGAPOREEXCHANGE|Domestic Market Capitalization at Exchange: Singapore Exchange SIXSWISSEXCHANGE|Value of Bond Trading at Exchange: SIX Swiss Exchange SIXSWISSEXCHANGESMI|Stock Market Index at Exchange: SIX Swiss Exchange SMI TAIPEIEXCHANGE|Value of Share Trading at Exchange: Taipei Exchange TAIPEIEXCHANGETPEXINDEX|Stock Market Index at Exchange: Taipei Exchange TPEx index TAIWANSECORP.|Value of Share Trading at Exchange: Taiwan Stock Exchange Corp. TAIWANSECORP.TAIEX|Stock Market Index at Exchange: Taiwan Stock Exchange Corp. TAIEX TELAVIVSE|Domestic Market Capitalization at Exchange: Tel-Aviv Stock Exchange TELAVIVSEGENERAL|Stock Market Index at Exchange: Tel-Aviv Stock Exchange General TMXGROUP|Stock Market Index at Exchange: TMX Group WIENERBORSE|Value of Bond Trading at Exchange: Wiener Borse WIENERBORSESEPRICEINDEX|Stock Market Index at Exchange: Wiener Borse SE Price Index`) } 37:T4e5,//A useful function from //https://stackoverflow.com/a/8497474 function CSVtoArray(text) { var re_valid = /^\s*(?:'[^'\\]*(?:\\[\S\s][^'\\]*)*'|"[^"\\]*(?:\\[\S\s][^"\\]*)*"|[^,'"\s\\]*(?:\s+[^,'"\s\\]+)*)\s*(?:,\s*(?:'[^'\\]*(?:\\[\S\s][^'\\]*)*'|"[^"\\]*(?:\\[\S\s][^"\\]*)*"|[^,'"\s\\]*(?:\s+[^,'"\s\\]+)*)\s*)*$/; var re_value = /(?!\s*$)\s*(?:'([^'\\]*(?:\\[\S\s][^'\\]*)*)'|"([^"\\]*(?:\\[\S\s][^"\\]*)*)"|([^,'"\s\\]*(?:\s+[^,'"\s\\]+)*))\s*(?:,|$)/g; // Return NULL if input string is not well formed CSV string. if (!re_valid.test(text)) return null; var a = []; // Initialize array to receive values. text.replace(re_value, // "Walk" the string using replace with callback. function(m0, m1, m2, m3) { // Remove backslash from \' in single quoted values. if (m1 !== undefined) a.push(m1.replace(/\\'/g, "'")); // Remove backslash from \" in double quoted values. else if (m2 !== undefined) a.push(m2.replace(/\\"/g, '"')); else if (m3 !== undefined) a.push(m3); return ''; // Return empty string. }); // Handle special case of empty last value. if (/,\s*$/.test(text)) a.push(''); return a; };38:[] 2e:{"id":"44f5ce935ce4b6c1","slug":"financial-service-providers","title":"Financial Service Providers","thumbnail":"69fd3dc00f178e5982baeb54f00b46349e81cc9c9465d349999eca389dececc7","access_level":"public","create_time":"$D2022-01-05T18:19:35.030Z","update_time":"$D2022-01-05T18:19:35.030Z","view_time":null,"first_public_time":"$D2022-01-06T02:09:38.457Z","has_unpublished_edits":null,"fork":{"id":"9a8bd0d4d9d19d35","slug":"tradingday","title":"Financial Service Providers","owner":{"id":"c4502285a4e37a76","login":"stroked","name":"Ajay"}},"stars":0,"starred":false,"owner":{"type":"team","id":"7632798b0a0057f3","login":"joaormendes","name":"João Ricardo Mendes","avatar_url":"https://avatars-next.observableusercontent.com/5a37070bf9e58604859ec9aa7033b0dcb40e61c4ff0aeaba33424ba04567b1fd","tier":"pro_2024"},"version":4581,"publish_version":4581,"role":null,"authored":false,"authors":[{"type":"individual","id":"fb55e01b401bd78d","login":"joaohurb","name":"João Ricardo Hurb Com","avatar_url":"https://avatars-next.observableusercontent.com/5a37070bf9e58604859ec9aa7033b0dcb40e61c4ff0aeaba33424ba04567b1fd","tier":null}],"members":[{"type":"individual","id":"fb55e01b401bd78d","login":"joaohurb","name":"João Ricardo Hurb Com","avatar_url":"https://avatars-next.observableusercontent.com/5a37070bf9e58604859ec9aa7033b0dcb40e61c4ff0aeaba33424ba04567b1fd","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Financial Service Providers","cells":[{"id":0,"value":"md`\n# Financial Service Providers`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2553,"value":"$30","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2518,"value":"md`\n_There are no visuals here. this notebook is full of import-stuff for other stock market related notebooks_\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2337,"value":"//the fn uses my pk for iex api; ","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1947,"value":"$31","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2469,"value":"AllListingsQuote = async () => d3.merge(await YahooChunkyWorker(all_listings))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2369,"value":"YahooChunkyWorker=async (arr)=>{\n const chunks = _.chunk(arr.map(x=>x.Symbol),200);\n return await Promise.all(chunks.map(async(group)=>{\n const quoteUrl =`https://query1.finance.yahoo.com/v7/finance/quote?symbols=${group.join()}`;\n //const profileUrl = `https://query2.finance.yahoo.com/v10/finance/quoteSummary?symbols=${group.join()}?modules=assetProfile`;\n \n //latestVolume,\n const quote = await soFetch(quoteUrl)\n // const profile=await soFetch(profileUrl)\n const quoteText = await quote.text();\n // const profileText = await profile.text();\n const yahooProps = JSON.parse(quoteText).quoteResponse.result;\n //return yahooProps;\n return yahooProps.map(x=>{\n let origProp = _.find(arr,y=>y.Symbol===x.symbol)\n // origProp;\n return {...origProp,...x};\n })\n //,profile:JSON.parse(profileText).quoteSummary\n \n // return Object.values(res).map(each=>({...}) )\n } ))\n}\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2406,"value":"SP500_fMP_Match={\n\n return SP500.filter(x=>!fMP_symbol_directory.includes(x.Symbol)) \n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":189,"value":"md`### Market`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3176,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":339,"value":"md`#### *Listings*`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4553,"value":"API_KEY = '?apikey=a7b7f9214b578f4967814045dbea2e06'","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":378,"value":"all_listings = d3.merge([\n await nyseListings(),\n await nasdaqListings(),\n await amexListings()\n])\n// =async()=>await\n//,nasdaqListings,amexListings","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":964,"value":"symbol_directory=({nasdaqListings,nyseListings, amexListings, ETFs})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2353,"value":"fMP_all_symbols = async () =>\n await d3.json(\n 'https://financialmodelingprep.com/api/v3/company/stock/list' + API_KEY\n )","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2403,"value":"fMP_symbol_directory = (await d3.json(\n 'https://financialmodelingprep.com/api/v3/company/stock/list' + API_KEY\n)).symbolsList","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2219,"value":"md`### Live Market`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2343,"value":"MarketHours = async () =>\n await d3.json(\n `https://financialmodelingprep.com/api/v3/is-the-market-open${API_KEY}`\n )","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":822,"value":"markitQuote=async(ticker)=>{\n \n const res =await soFetch(`http://dev.markitondemand.com/MODApis/Api/v2/Quote/json?symbol=${ticker}`)\n const data= await res.text();\n return JSON.parse(data);\n \n }","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2356,"value":"CompanyQuote = async ticker =>\n await d3.json(\n `https://financialmodelingprep.com/api/v3/company/profile/${ticker}${API_KEY}`\n )\n/*\n{\n \"symbol\": \"AAPL\",\n \"profile\": {\n \"price\": 179.66,\n \"beta\": \"1.139593\",\n \"volAvg\": \"36724977\",\n \"mktCap\": \"898319582940.00\",\n \"lastDiv\": \"2.92\",\n \"range\": \"142-233.47\",\n \"changes\": 0.01,\n \"changesPercentage\": \"(+0.01%)\",\n \"companyName\": \"Apple Inc.\",\n \"exchange\": \"Nasdaq Global Select\",\n \"industry\": \"Computer Hardware\",\n \"website\": \"http://www.apple.com\",\n \"description\": \"Apple Inc is designs, manufactures and markets mobile communication and media devices and personal computers, and sells a variety of related software, services, accessories, networking solutions and third-party digital content and applications.\",\n \"ceo\": \"Timothy D. Cook\",\n \"sector\": \"Technology\",\n \"image\": \"https://financialmodelingprep.com/images-New-jpg/AAPL.jpg\"\n }\n}\n*/","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2118,"value":"MajorIndexesQuote = async()=>await d3.json(`https://financialmodelingprep.com/api/v3/majors-indexes${API_KEY}`)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2121,"value":"SectorsQuote =async ()=> await d3.json(`https://financialmodelingprep.com/api/v3/stock/sectors-performance${API_KEY}`)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2123,"value":"ActivesQuote = async () =>\n await d3.json(\n `https://financialmodelingprep.com/api/v3/stock/actives${API_KEY}`\n )","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2126,"value":"WorstQuote = async () =>\n await d3.json(`https://financialmodelingprep.com/api/v3/losers${API_KEY}`)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2128,"value":"BestQuote = async () =>\n await d3.json(`https://financialmodelingprep.com/api/v3/gainers${API_KEY}`)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2361,"value":"financialModelling = async symbol =>\n Promise.all([\n await d3.json(\n `https://financialmodelingprep.com/api/v3/financials/income-statement/${symbol}${API_KEY}`\n ),\n await d3.json(\n `https://financialmodelingprep.com/api/v3/financial-ratios/${symbol}${API_KEY}`\n ),\n await d3.json(\n `https://financialmodelingprep.com/api/v3/enterprise-value/${symbol}${API_KEY}`\n ),\n await d3.json(\n `https://financialmodelingprep.com/api/v3/company-key-metrics/${symbol}${API_KEY}`\n ),\n await d3.json(\n `https://financialmodelingprep.com/api/v3/company/rating/${symbol}${API_KEY}`\n ),\n await d3.json(\n `https://financialmodelingprep.com/api/v3/company/discounted-cash-flow/${symbol}${API_KEY}`\n ),\n await d3.json(\n `https://financialmodelingprep.com/api/v3/company/historical-discounted-cash-flow/${symbol}${API_KEY}`\n ),\n await d3.json(\n `https://financialmodelingprep.com/api/v3/financial-statement-growth/${symbol}${API_KEY}`\n )\n ])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2345,"value":"md`## Currencies`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2346,"value":"QuoteForexMarket=async(cross)=>{await d3.json('https://financialmodelingprep.com/api/forex/v3/${cross}')}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2349,"value":"QuoteCryptoMarket=async()=>{await d3.json('https://financialmodelingprep.com/api/v3/cryptocurrency/BTC')}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2351,"value":"Cryptos=async()=>{await d3.json('https://financialmodelingprep.com/api/v3/cryptocurrencies')}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2359,"value":"CurrencyCrosses=async()=>await d3.json('https://financialmodelingprep.com/api/v3/forex')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2189,"value":"md`---`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":336,"value":"md`### *MAJOR MARKET INDEXES*`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2476,"value":"MajorIndexCodes = [\n \"^GSPC\",\n \"^DJI\",\n \"^IXIC\",\n \"^RUT\",\n \"CL=F\",\n \"SI=F\",\n \"GC=F\",\n \"^TNX\",\n \"^VIX\",\n];","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2475,"value":"YahooIndexSpark={\n\n const data = await soFetch(\n `https://query1.finance.yahoo.com/v7/finance/spark?symbols=${MajorIndexCodes.join(',')}&range=1d&interval=5m&indicators=close`\n )\n \n return JSON.parse(await data.text());\n // (_.toString(symbols)),\n //await fetchMarketNews(),\n //await fetchInFocus()\n // ]);\n\n // return { quotes: data[0], news: data[1], infocus: data[2] };\n// };\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2137,"value":"major_indexes = ({ SP500, NASDAQ100_mock, DOW30 })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1678,"value":"md`### DOW 30`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1538,"value":"DOW30 =d3.merge((await YahooChunkyWorker(dow30_wiki_csv)))\n \n //.map((x)=>{ \n // x.Symbol=x.Exchange==='NYSE' \n // ? (await wiki.fetch(x.WikiPage,'en')).templates(0).list[0].split('|')[1].replace(/}/g,'')\n // : dow30_wiki_csv.find(entry=> entry.Name===x.Name).Symbol\n// x.Symbol=_.find(dow30_wiki_csv,entry=> entry.Company===x.Name).Symbol\n// return x;\n \n \n \n\n// })\n //yield companyPage.doc;\n //.infoboxes(0).json()\n // return companyPage.infoboxes(0)\n ","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":939,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1510,"value":"dow30_wiki_table= (await wiki.fetch('Dow_Jones_Industrial_Average','en')).tables(0).json().map(row=>{\n\n const company={};\n company.Name=row[\"Company\"].text;\n company.Exchange=row[\"Exchange\"].text;\n company.Industry=row['Industry'].text;\n company.WikiPage=row[\"Company\"].links[0].page.replace(/ /g,'_').replace(/\\'/g,'%27');\n company.DOW30_Since=row['Date Added']?.text;\nreturn company;\n // urlParser.href = company.SecReports;\n // company.Symbol=urlParser.searchObject\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1689,"value":"md`### S&P 500`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1855,"value":"SP500= d3.merge(await YahooChunkyWorker(sp500_wiki_csv))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1727,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1715,"value":"sp500_quoteList = sp500_wiki_csv\n// sp500_wiki_table.map((x)=>{\n// // x.Symbol=x.Exchange==='NYSE'\n// // ? (await wiki.fetch(x.WikiPage,'en')).templates(0).list[0].split('|')[1].replace(/}/g,'')\n// // : dow30_wiki_csv.find(entry=> entry.Name===x.Name).Symbol\n// let Symbol=_.find(,entry=> entry.Name===x.Name).Symbol;\n\n// //.Symbol\n// return {...x,Symbol};\n\n// })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1506,"value":"sp500_wiki_table = (await wiki.fetch('List of_S&P_500_companies','en')).tables(0).json().map(row=>{\n const company={};\n company.Symbol=row[\"SEC filings\"].links[0].site.split(\"=\")[1].split('&')[0]\n company.Name=row[\"Security\"].text;\n company.Sector=row['GICS Sector'].text;\n company.SubIndustry=row['GICS Sub Industry']?.text;\n company.HQ=row[\"Headquarters Location\"].text;\n company.CIK=row['CIK'].text;\n company.SecReports=row[\"SEC filings\"].links[0].site;\n company.Name=row[\"Security\"].text;\n company.WikiPage=row[\"Security\"].links[0].page;\n\n company.SP500_Since=row['Date first added'].text;\n company.Founded=row[\"Founded\"].text;\nreturn {...company};\n //urlParser.href = company.SecReports;\n //company.Symbol=urlParser.searchObject\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1699,"value":"md`### NASDAQ 100`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1975,"value":"// NASDAQ100 = d3.merge(\n// await YahooChunkyWorker(\n// NQ100.map(each => {\n// return { Symbol: each.symbol, Name: each.companyName };\n// })\n// )\n// )","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3986,"value":"// NQ100 = getNasdaq100List()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4567,"value":"(await await fetch(\n 'https://cors-anywhere.herokuapp.com/old.nasdaq.com/quotes/nasdaq-100-stocks.aspx?render=download'\n)).text()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3965,"value":"// getNasdaq100List = async () =>\n// JSON.parse(\n// await await soFetch('https://api.nasdaq.com/api/quote/list-type/nasdaq100') //.text()\n// ) //.data.data.rows","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4550,"value":"NQ100 = NASDAQ100_mock","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3976,"value":"$35","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4538,"value":"// fetch('https://old.nasdaq.com/quotes/nasdaq-100-stocks.aspx')","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":216,"value":"Download_Parse_Csv = {\n //parshing this file was annoying bc csvParse left many keys and values with leading/trailing white-space.\n const file = await soFetch(\n 'https://old.nasdaq.com/quotes/nasdaq-100-stocks.aspx?render=download'\n );\n const text = await file.text();\n return d3.csvParse(text, row => {\n delete row[\"\"];\n Object.keys(row).map(k => {\n //trim all values\n const value = row[k].trim();\n let key = k;\n //check if key needs to be trimmed\n if (k.endsWith(' ') || k.startsWith(' ')) {\n key = k.trim();\n delete row[k];\n }\n //update the key-value pair\n row[key] = value;\n });\n //\n return row;\n });\n //https://raw.githubusercontent.com/Stroked/react-d3-workspace/master/public/nasdaq100.csv\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":341,"value":"md`## FSP`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4504,"value":"//financial service providers","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":950,"value":"md`\n\n### Data Transfer Object(DTO)\nthe structure of the data should be on your fingertips`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2186,"value":"md`#### Intraday`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2548,"value":"fMP_full_eod(['AIG','AAPL'])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2239,"value":"fMP_full_eod = async (symbols) =>await d3.json(`https://financialmodelingprep.com/api/v3/historical-price-full/${symbols.join(',')}`)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3369,"value":"HistoricalEndOfDayQuote = symbol=>fMP_full_eod([symbol])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2528,"value":"ALPHAVANTAGE_INTRADAY('SPY')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2831,"value":"ALPHAVANTAGE_INTRADAY","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3359,"value":"ALPHAVANTAGE_INTRADAY('AIG')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2073,"value":"ALPHAVANTAGE_INTRADAY = async (\n symbol,\n alphaVantageApiKey = 'TRDGNTGBQG2BI9J0'\n) => {\n const period = \"1min\";\n const res = await d3.json(\n `https://www.alphavantage.co/query?function=TIME_SERIES_INTRADAY&symbol=${symbol}&interval=1min&outputsize=full&apikey=${alphaVantageApiKey}`,\n d3.autoType\n );\n\n return [\n ...Object.entries(res[\"Time Series (1min)\"]).map(([date, cols]) => {\n return {\n date: new Date(date),\n open: +cols[\"1. open\"],\n high: +cols[\"2. high\"],\n low: +cols[\"3. low\"],\n close: +cols[\"4. close\"],\n volume: +cols[\"5. volume\"]\n };\n })\n ];\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2070,"value":"IEX_DYNAMIC=async (symbol)=>{\n const data =await d3.json(`https://api.iextrading.com/1.0/stock/${symbol}/chart/dynamic?chartReset=true`);\n data.data.forEach(d=>{\n let year = d.date.slice(0,4)\n let month = d.date.slice(4,6)\n let day= d.date.slice(6,8);\n const stringDate = `${year}-${month}-${day}T${d.minute}`\n d._stringDate = stringDate\n d.date=new Date(stringDate)\n })\n return data.data.reverse()\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":929,"value":"md`### NasdaqWeb`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3420,"value":"// fetchETF()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3415,"value":"// fetchETF = async () => {\n// const etfs = await soFetch(\n// `https://www.bloomberg.com/graphics/world-economic-indicators-dashboard/`\n// );\n// return await etfs.text();\n// // return d3.csvParse(text).sort((a, b) => a.Symbol - b.Symbol);\n// }","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":355,"value":"NASDAQ = {\n const ETFs = async () => {\n const etfs = await soFetch(\n `https://old.nasdaq.com/investing/etfs/etf-finder-results.aspx?download=yes`\n );\n const text = await etfs.text();\n return d3.csvParse(text).sort((a, b) => a.Symbol - b.Symbol);\n };\n const listingFetcher = async group => {\n const listings = await soFetch(\n `https://old.nasdaq.com/screening/companies-by-industry.aspx?${group}&render=download`\n )\n .then(res => res.text())\n .then(file => d3.csvParse(file));\n return listings.map(l => {\n //last column in file is empty\n delete l[''];\n //parse numbers\n l.LastSale = +l.LastSale;\n l.MarketCap = +l.MarketCap;\n l[\"ADR TSO\"] = +l[\"ADR TSO\"];\n //assign exchange property\n if (group) {\n l[\"Exchange\"] = group.split('=').pop();\n }\n\n //IPO\n const ipoYear = +l.IPOyear;\n if (ipoYear) {\n l.IPOyear = ipoYear;\n }\n return l;\n });\n };\n return { ETFs, listingFetcher };\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":683,"value":"ETFs = ()=> NASDAQ.ETFs();\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":443,"value":"nasdaqListings = ()=> NASDAQ.listingFetcher(\"exchange=NASDAQ\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":360,"value":"nyseListings =async()=>await NASDAQ.listingFetcher(\"exchange=NYSE\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":364,"value":" amexListings =async()=>await NASDAQ.listingFetcher(\"exchange=AMEX\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":358,"value":"adr_listings =async()=>await NASDAQ.listingFetcher('market=ADR')\n ","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":409,"value":"repeated_listings = d3.nest().key(d=>d.Symbol).entries(all_listings).filter(d=>d.values.length>1)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":412,"value":"ipo_years=all_listings.filter(x=>x.IPOyear!=='n/a').sort((a,b)=>a.IPOyear - b.IPOyear)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1101,"value":"md`### Finviz`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":935,"value":"ListingInfo =async (ticker)=>{\n const url=`https://finviz.com/quote.ashx?t=${ticker}`;\n const res = await soFetch(url)\n const source = await res.text();\n const dom = html`${source}`;\n const captions =[...dom.querySelectorAll('.snapshot-td2-cp')].map(x=>{ return x.innerText}); \n\n const values= [...dom.querySelectorAll('.snapshot-td2')].map(x=>{ return x.innerText});\n\n let dto=_.zip(captions,values)\n\n return dto;\n \n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1079,"value":"info = await ListingInfo(\"AAPL\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3169,"value":"md`#### Financial Modelling Prep`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3150,"value":"md`#### Quandl`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1481,"value":"$36","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":177,"value":"md`### UTILS`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2598,"value":"fonts = new Promise(active =>\n WebFont.load({\n google: {\n families: [\"Cousine\"]\n },\n active\n })\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":180,"value":"nthIndex=(str, pat, n)=>{\n var L= str.length, i= -1;\n while(n-- && i++ [i, p.then(res => [i, res])]));\n while (map.size) {\n const [key, result] = await Promise.race(map.values());\n yield result;\n map.delete(key);\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1369,"value":"_=require ('lodash') ","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":114,"value":"d3 = require(\"d3@5\", 'd3-array@2.2')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2602,"value":"WebFont = require(\"https://ajax.googleapis.com/ajax/libs/webfont/1.6.26/webfont.js\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3261,"value":"import {slider} from '@jashkenas/inputs'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2077,"value":"md `__NOTE: the infograph shown below is from 2016. the information is dated. the goal is the recreate it with dynamiclly updating data in an interactive visualization___`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2075,"value":"html`

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":764,"value":"md`----\n\n\n\n\n---\n\n---\n\n\n---\n\n\n---\n### DEPRECATIONS`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3145,"value":"//broken","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2394,"value":"FinModelChunkyWorker = async (arr)=>{\n const chunks = _.chunk(arr.map(x=>x.Symbol),20);\n return await Promise.all(chunks.map(async(group)=>{\n const quoteUrl =`https://financialmodelingprep.com/api/v3/company/profile/${group.join()}`;\n //const profileUrl = `https://query2.finance.yahoo.com/v10/finance/quoteSummary?symbols=${group.join()}?modules=assetProfile`;\n \n //latestVolume,\n const quote = await soFetch(quoteUrl)\n // const profile=await soFetch(profileUrl)\n const quoteText = await quote.text();\n // const profileText = await profile.text();\n return JSON.parse(quoteText)\n //,profile:JSON.parse(profileText).quoteSummary\n \n // return Object.values(res).map(each=>({...}) )\n } ))\n}\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3147,"value":"//broken","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2371,"value":"fMP_profiles = (await FinModelChunkyWorker((SP500.filter(x=>fMP_symbol_directory.includes(x.Symbol))))) ","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1185,"value":"md`### DataHub`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":207,"value":"sp500_old={\n \n// return d3.json('https://www.datahub.io/core/s-and-p-500-companies-financials/r/constituents-financials.json')\n\n//using SO-FETCH\n const file = await soFetch('https://www.datahub.io/core/s-and-p-500-companies-financials/r/constituents-financials.json')\n let text = await file.text()\n return JSON.parse(text);\n \n// using MOCK-DATA\n //https://raw.githubusercontent.com/Stroked/react-d3-workspace/master/src/mock-data/sp500-constituents-financials.json\n }","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":220,"value":"nasdaqListed_old=async()=>await d3.json('https://cors-anywhere.herokuapp.com/datahub.io/core/nasdaq-listings/r/nasdaq-listed.json')\n\n//'https://raw.githubusercontent.com/Stroked/react-d3-workspace/master/src/mock-data/nasdaq-listed.json'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":43,"value":"md`### Journal`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":895,"value":"buyingOnWeakness = wsj_money_flows(\"http://online.wsj.com/mdc/public/npage/2_3045-mfgppl-mfxml2csv.html\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2505,"value":"sellingOnStrength.columns","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":901,"value":"sellingOnStrength = wsj_money_flows(\"http://online.wsj.com/mdc/public/npage/2_3045-mflppg-mfxml2csv.html\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2815,"value":"// soFetch(\"http://online.wsj.com/mdc/public/npage/2_3045-mflppg-mfxml2csv.html\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":88,"value":"WSJ_MoneyFlows =({buyingOnWeakness, sellingOnStrength})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":222,"value":"wsj_money_flows =async (url)=> {\n let moneyFlowQuery = await soFetch(url)\n let res = await moneyFlowQuery.text();\n let file = res.trim(); \n file= file.substring(file.indexOf(\"C\"));\n return d3.tsvParse(file);\n\n\n\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":18,"value":"md`### Barrons`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":545,"value":"{\n \n return false;\n \n const res = await soFetch(\"http://www.barrons.com/mdc/public/page/9_3024-USETFs.html\")\nconst source = await res.text();\n const dom = html`${source}`;\n return [...dom.querySelectorAll('table')].map(x=>x.innerText)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":701,"value":"retired_barrons_dsr={\n const _retired_barrons_eod=({\n \"etfs\" : \"http://www.barrons.com/public/resources/documents/USETFs.csv\",\n \"nyse\":\"http://www.barrons.com/public/resources/documents/NYSE.csv\",\n \"amex\":\"http://www.barrons.com/public/resources/documents/AMEX.csv\",\n \"nasdaq\":\"http://www.barrons.com/public/resources/documents/Nasdaq.csv\",\n \"nasdaqCapitalMarkets\":\"http://www.barrons.com/public/resources/documents/SCAP.csv\",\n \"preferreds\":\"http://www.barrons.com/public/resources/documents/Preferreds.csv\",\n })\n return Promise.all(Object.keys(_retired_barrons_eod).map(async (key)=>{ \n const data = await soFetch(_retired_barrons_eod[key]);\n const text=await data.text();\n await d3.csvParse(text.substring(nthIndex(data,'\\n',3)+1))})\n )\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":37,"value":"listingGroups=[\"USETFs\",\"NYSE\",\"AMEX\", \"Nasdaq\",\"SCAP\",\"Preferreds\"]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W38","stdlib":"1"}} 2f:"$2e:body"