Spreadsheet: 737487d1624441841-calculating-4threads-my-excel-sheet-is-not-calculating-correctly-working-excel-example
Sheet: Eikon Merged

 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28
CIK | CIK | Package Identifier | Dates: Issue Date | Issuer/Borrower Name Full | Issuer/Borrower Nation | Offer Price | Proceeds Amount Incl Overallotment Sold All Markets (USD, Millions) | Issuer/Borrower Stock Exchange Name ('|') | Security Type | Offering Technique ('|') | Fees: Gross Spread as Pct of Principal Amount This Market | Domicile Nation Sub Region | Domicile Nation Region | Issuer/Borrower TRBC Business Sector | Issuer/Borrower TRBC Economic Sector | High Yield Issues:  Lead Left Bookrunner ('|') | Book Or Co-Managers ('|') | Target Market ('|') | Financials: Total Assets Before Offering (USD, Millions) | Financials: Net Income After Taxes Before Offering (USD, Millions) | [NAME] (text) | PE Flag (text) | SEC File Form | Transaction Status (True) | Current Filing Date (True) | Date Company Founded ('|') | Venture Capital Backed IPO Issue Flag | Private Equity Backed IPO Issue Flag(Y/N) | SIC ('|')
 | [PHONE] | 3913734 | 2019-12-11 00:00:00 | Bill.com Holdings Inc | United States | 22 | 248.535276 | New York Stock Exchange | Common Stock | Firm Commitment | 7 | North America | Americas | Software & IT Services | Technology |  | KeyBanc Capital Markets Inc|Canaccord Genuity Corp|Jefferies LLC|BofA Securities Inc|Goldman Sachs & Co|Needham & Co LLC|William Blair & Co | United States Of America (North America) | 1662.2 | -12.1 |  |  | S1 | Live | 2019-12-10 00:00:00 |  | TRUE | FALSE | Prepackaged Software
 | [PHONE] | 3901947 | 2019-11-20 00:00:00 | SiTime Corp | United States | 13 | 55.9 | Nasdaq | Common Stock | Negotiated Sale | 7 | North America | Americas | Technology Equipment | Technology |  | Raymond James & Associates Inc|Roth Capital Partners Inc|Barclays Capital Inc|Needham & Co LLC|Stifel Nicolaus & Co Inc | United States Of America (North America) | 71.2 | 0 |  |  | S1 | Live | 2019-11-07 00:00:00 | 12/3/2003 12:00:00 AM | True | False | Electronic parts and equipment, nec|Semiconductors and related devices
 | [PHONE] | 3903008 | 2019-11-07 00:00:00 | CNS Pharmaceuticals Inc | United States | 4 | 8.5 | Nasdaq | Common Stock | Negotiated Sale|Firm Commitment | 7 | North America | Americas | Pharmaceuticals & Medical Research | Healthcare |  | [NAME], [NAME] | United States Of America (North America) | 1.4 | -8 |  |  | S1 | Live | 2019-11-07 00:00:00 | 7/27/2017 12:00:00 AM | False | False | Noncommercial research organizations|Commercial physical and biological research
 | [PHONE] | 3847868 | 2019-10-30 00:00:00 | RAPT Therapeutics Inc | United States | 12 | 36 | Nasdaq | Common Stock | Firm Commitment|Negotiated Sale | 7 | North America | Americas | Pharmaceuticals & Medical Research | Healthcare |  | Wells Fargo Securities LLC|BMO Capital Markets|UBS Securities Inc | United States Of America (North America) | 58.4 | -39.2 |  |  | S1 | Live | 2019-10-28 00:00:00 | 3/4/2015 12:00:00 AM | True | False | Pharmaceutical preparations|In vitro and in vivo diagnostic substances
 | [PHONE] | 3874215 | 2019-10-10 00:00:00 | Vir Biotechnology Inc | United States | 20 | 142.85716 | Nasdaq | Common Stock | Negotiated Sale|Firm Commitment | 7 | North America | Americas | Pharmaceuticals & Medical Research | Healthcare |  | Cowen & Co|JP Morgan Securities LLC|Barclays Capital Inc|Goldman Sachs & Co | United States Of America (North America) | 422.6 | -137.3 |  |  | S1 | Live | 2019-10-10 00:00:00 | 4/7/2016 12:00:00 AM | True | False | Pharmaceutical preparations
 | [PHONE] | 3880807 | 2019-10-10 00:00:00 | HBT Financial Inc | United States | 16 | 150.876704 | Nasdaq | Common Stock | Firm Commitment|Negotiated Sale | 7 | North America | Americas | Banking & Investment Services | Financials |  | Raymond James & Associates Inc|JP Morgan Securities LLC|DA Davidson & Co Inc|Keefe Bruyette & Woods Inc|Sandler O'Neill Partners  L.P. | United States Of America (North America) | 3166.6 | 62.7 |  |  | S1 | Live | 2019-10-10 00:00:00 | 1/1/1982 12:00:00 AM | False | False | Offices of bank holding companies|National commercial banks
 | [PHONE] | 3872249 | 2019-10-02 00:00:00 | [NAME] | United States | 19 | 172.615 | Nasdaq | Common Stock | Firm Commitment|Negotiated Sale | 7 | North America | Americas | Pharmaceuticals & Medical Research | Healthcare |  | Guggenheim Securities LLC|Cowen & Co|Goldman Sachs & Co|Morgan Stanley & Co | United States Of America (North America) | 233.8 | -89.9 |  |  | S1 | Live | 2019-09-23 00:00:00 | 12/11/2017 12:00:00 AM | True | False | Commercial physical and biological research|In vitro and in vivo diagnostic substances|Pharmaceutical preparations|Noncommercial research organizations
 | [PHONE] | 3876273 | 2019-10-02 00:00:00 | Frequency Therapeutics Inc | United States | 14 | 84 | Nasdaq | Common Stock | Negotiated Sale|Firm Commitment | 7 | North America | Americas | Pharmaceuticals & Medical Research | Healthcare |  | JP Morgan Securities LLC|Cowen & Co|Goldman Sachs & Co | United States Of America (North America) | 170.8 | -18.7 |  |  | S1 | Live | 2019-10-02 00:00:00 | 11/13/2014 12:00:00 AM | True | False | Biological products, except diagnostic substances
 | [PHONE] | 3876383 | 2019-10-02 00:00:00 | Aprea Therapeutics Inc | United States | 15 | 97.750005 | Nasdaq | Common Stock | Negotiated Sale|Firm Commitment | 7 | North America | Americas | Pharmaceuticals & Medical Research | Healthcare |  | RBC Capital Markets LLC|JP Morgan Securities LLC|Morgan Stanley & Co | United States Of America (North America) |  |  |  |  | S1 | Live | 2019-10-02 00:00:00 | 5/1/2019 12:00:00 AM | True | False | Pharmaceutical preparations|In vitro and in vivo diagnostic substances
 | [PHONE] | 3890288 | 2019-09-30 00:00:00 | 4D Molecular Therapeutics Inc | United States |  |  | Nasdaq | Common Stock | Firm Commitment|Negotiated Sale | -999 | North America | Americas | Pharmaceuticals & Medical Research | Healthcare |  | Evercore Group|Chardan Capital Markets LLC|Goldman Sachs & Co|William Blair & Co | United States Of America (North America) | 80.5 | -20.9 |  |  | S1 | Cancelled |  | 4/12/2012 12:00:00 AM |  | False | Noncommercial research organizations|Biological products, except diagnostic substances|Commercial physical and biological research
 | [PHONE] | 3889889 | 2019-09-27 00:00:00 | Fortis Minerals LLC | United States |  |  |  | Class A Common Shares | Firm Commitment|Negotiated Sale | -999 | North America | Americas | Energy - Fossil Fuels | Energy |  | Raymond James & Associates Inc|UBS Securities Ltd|Citigroup Global Markets Inc|Piper Jaffray Cos|Wells Fargo Securities LLC|Scotia Capital (USA) Inc.|Credit Suisse Securities (USA) LLC|RBC Capital Markets LLC|JP Morgan Securities LLC|Tudor Pickering Holt & Co LLC|Barclays Capital Inc|Goldman Sachs & Co | United States Of America (North America) |  |  |  |  | S1 | Cancelled |  | 2/1/2019 12:00:00 AM |  | True | Crude petroleum and natural gas|Natural gas liquids|Industrial inorganic chemicals, nec
 | [PHONE] | 3775778 | 2019-09-25 00:00:00 | Peloton Interactive Inc | United States | 29 | 1160 | Nasdaq | Class A Common Shares | Negotiated Sale|Firm Commitment | 5 | North America | Americas | Cyclical Consumer Products | Consumer Cyclicals |  | Williams Capital Group LP|Raymond James & Associates Inc|Evercore Group|R Seelaus & Company Inc|SunTrust Robinson Humphrey|JMP Securities LLC|Oppenheimer & Co Inc|Cowen & Co|KeyBanc Capital Markets Inc|Canaccord Genuity|Academy Securities Inc|Telsey Advisory Group LLC|JP Morgan Securities LLC|Siebert Cisneros Shank & Co|BofA Securities Inc|Barclays Capital Inc|Goldman Sachs & Co|Needham & Co LLC|Stifel Nicolaus & Co Inc|UBS Securities Inc|William Blair & Co | United States Of America (North America) | 864.5 | -245.7 |  |  | S1 | Live | 2019-09-25 00:00:00 | 1/1/2012 12:00:00 AM | True | False | Sporting and recreational goods and supplies|Sporting and athletic goods, nec
 | [PHONE] | 3853020 | 2019-09-25 00:00:00 | Oportun Financial Corp | United States | 15 | 107.8125 | Nasdaq | Common Stock | Firm Commitment|Negotiated Sale | 7 | North America | Americas | Banking & Investment Services | Financials |  | JMP Securities LLC|BTIG LLC|Jefferies LLC|JP Morgan Securities LLC|Barclays Capital Inc|Keefe Bruyette & Woods Inc | United States Of America (North America) | 1864.8 | 10 |  |  | S1 | Live | 2019-09-16 00:00:00 | 1/1/2005 12:00:00 AM | True | False | Misc business credit|Short-term business credit institutions|Personal credit institutions
 | [PHONE] | 3857005 | 2019-09-18 00:00:00 | Datadog Inc | United States | 27 | 745.2 | Nasdaq | Common Stock | Firm Commitment|Negotiated Sale | 5 | North America | Americas | Software & IT Services | Technology |  | Raymond James & Associates Inc|Barclays Capital Group|RBC Capital Markets|JMP Securities LLC|Credit Suisse Securities (USA) LLC|Jefferies LLC|JP Morgan Securities LLC|Goldman Sachs & Co|Morgan Stanley & Co|Needham & Co LLC|Stifel Nicolaus & Co Inc|William Blair & Co | United States Of America (North America) | 261.8 | -24.7 |  |  | S1 | Live | 2019-09-17 00:00:00 | 1/1/2010 12:00:00 AM | True | False | Prepackaged Software|Business services, nec
 | [PHONE] | 3869923 | 2019-09-18 00:00:00 | [NAME] | United States | 14 | 57.96 | Nasdaq | Common Stock | Negotiated Sale|Firm Commitment | 7 | North America | Americas | Healthcare Services & Equipment | Healthcare |  | Cantor Fitzgerald & Co|Cowen & Co|William Blair & Co | United States Of America (North America) | 33.1 | -8.6 |  |  | S1 | Live | 2019-09-09 00:00:00 | 1/1/2002 12:00:00 AM | True | False | Medical laboratories
 | [PHONE] | 3854790 | 2019-09-17 00:00:00 | Envista Holdings Corp | United States | 22 | 677.2304 | New York Stock Exchange | Common Stock | Firm Commitment|Negotiated Sale | 5 | North America | Americas | Healthcare Services & Equipment | Healthcare |  | Evercore Group|Credit Suisse Securities (USA) LLC|Jefferies [NAME] Securities LLC|BofA Securities Inc|Goldman Sachs & Co|Morgan Stanley & Co|Stifel Nicolaus & Co Inc|William Blair & Co | United States Of America (North America) | 5841.6 | 230.7 |  |  | S1 | Live | 2019-09-04 00:00:00 | 8/29/2018 12:00:00 AM | True | False | Medical, dental, and hospital equipment & supplies|Dental equipment and supplies
 | [PHONE] | 3882520 | 2019-09-17 00:00:00 | Karat Packaging Inc | United States |  | 40 | Nasdaq | Common Stock | Firm Commitment | -999 | North America | Americas | Chemicals | Basic Materials |  | Loop Capital Markets|National Securities Corp (US) | United States Of America (North America) | 133.3 | 1.7 |  |  | S1 | Cancelled | 2019-09-30 00:00:00 |  |  | False | Plastics products, nec|Manufacturing industries, nec
 | [PHONE] | 3814419 | 2019-09-12 00:00:00 | Cloudflare Inc | United States | 15 | 603.75 | New York Stock Exchange | Class A Common Shares | Negotiated Sale|Firm Commitment | 5.5 | North America | Americas | Telecommunications Services | Technology |  | Evercore Group|SunTrust Robinson Humphrey|RBC Capital Markets|JMP Securities LLC|Oppenheimer & Co Inc|Wells Fargo Securities LLC|BTIG LLC|Jefferies LLC|JP Morgan Securities LLC|Goldman Sachs & Co|Morgan Stanley & Co|Needham & Co LLC | United States Of America (North America) | 286.9 | -91.5 |  |  | S1 | Live | 2019-09-12 00:00:00 | 7/1/2009 12:00:00 AM | True | False | Computer related services, nec|Information retrieval services|Computer programming services
 | [PHONE] | 3867153 | 2019-09-12 00:00:00 | SpringWorks Therapeutics Inc | United States | 18 | 186.3 | Nasdaq | Common Stock | Firm Commitment|Negotiated Sale | 7 | North America | Americas | Pharmaceuticals & Medical Research | Healthcare |  | JP Morgan Securities LLC|Cowen & Co|Goldman Sachs & Co|Wedbush Securities, Inc. | United States Of America (North America) | 194.6 | -28.8 |  |  | S1 | Live | 2019-09-12 00:00:00 |  | True | False | Noncommercial research organizations|Commercial physical and biological research|Biological products, except diagnostic substances
 | [PHONE] | 3867282 | 2019-09-11 00:00:00 | SmileDirectClub Inc | United States | 23 | 1346.351 | Nasdaq | Class A Common Shares | Negotiated Sale|Firm Commitment | 5 | North America | Americas | Healthcare Services & Equipment | Healthcare |  | Loop Capital Markets|Citigroup Global Markets Inc|Guggenheim Securities LLC|Credit Suisse Securities (USA) LLC|Jefferies LLC|JP Morgan Securities LLC|BofA Securities Inc|Stifel Nicolaus & Co Inc|UBS Securities Inc|William Blair & Co | United States Of America (North America) | 542.5 | -93.9 |  |  | S1 | Live | 2019-09-11 00:00:00 | 1/1/2014 12:00:00 AM | True | False | Dental equipment and supplies
 |  | 8053317 | 2019-08-14 00:00:00 | WeWork Cos Inc | United States |  |  |  | Class A Common Shares | Firm Commitment|Negotiated Sale | -999 | North America | Americas | Real Estate | Real Estate |  | Citigroup Global Markets Inc|Wells Fargo Securities LLC|Credit Suisse Securities (USA) LLC|Barclays Capital Securities Ltd|HSBC Securities (USA) Inc|JP Morgan Securities LLC|BofA Securities Inc|Goldman Sachs & Co|UBS Securities Inc | United States Of America (North America) |  |  |  |  | S1 | Cancelled | 2019-09-03 00:00:00 | 1/1/2010 12:00:00 AM |  | False | Lessors of real property, nec|Real estate agents and managers
 | [PHONE] | 3853612 | 2019-08-14 00:00:00 | Crossfirst Bankshares Inc | United States | 14.5 | 113.9112895 | Nasdaq | Common Stock | Negotiated Sale|Firm Commitment | 6.5 | North America | Americas | Banking & Investment Services | Financials |  | Raymond James & Associates Inc|Keefe Bruyette & Woods Inc|Stephens Inc|Sandler O'Neill Partners  L.P. | United States Of America (North America) | 4464.3 | 35.5 |  |  | S1 | Live | 2019-08-05 00:00:00 | 9/1/2008 12:00:00 AM | False | False | Offices of bank holding companies
 | [PHONE] | 3847423 | 2019-07-31 00:00:00 | Dynatrace Inc | United States | 16 | 655.216848 | New York Stock Exchange | Common Stock | Firm Commitment | 5.36 | North America | Americas | Software & IT Services | Technology |  | Barclays|RBC Capital Markets|JMP Securities LLC|Citigroup Global Markets Inc|KeyBanc Capital Markets Inc|Canaccord Genuity|Macquarie Capital (USA) Inc|Jefferies LLC|JP Morgan Securities LLC|Goldman Sachs & Co|UBS Securities Inc|William Blair & Co | United States Of America (North America) | 1764.8 | -141.8 |  |  | S1 | Live | 2019-07-30 00:00:00 |  | False | True | Prepackaged Software
 | [PHONE] | 3814482 | 2019-07-24 00:00:00 | Health Catalyst Inc | United States | 26 | 209.3 | Nasdaq | Common Stock | Firm Commitment|Negotiated Sale | 7 | North America | Americas | Software & IT Services | Technology |  | Evercore Group|SunTrust [NAME] Humphrey|Piper Jaffray Cos|JP Morgan Securities LLC|SVB Leerink LLC|Goldman Sachs & Co|William Blair & Co | United States Of America (North America) | 139.7 | -280 |  |  | S1 | Live | 2019-07-24 00:00:00 |  | True | False | Computer integrated systems design
 | [PHONE] | 3844775 | 2019-07-24 00:00:00 | ProSight Global Inc | United States | 14 | 126.500066 | New York Stock Exchange | Common Stock | Negotiated Sale|Firm Commitment | 6.5 | North America | Americas | Insurance | Financials |  | Dowling & Partners Securities LLC|Barclays Capital Group|SunTrust Robinson Humphrey|Citizens Capital Markets Inc|Keefe Bruyette & Woods Inc|Merrill Lynch Pierce Fenner & Smith | United States Of America (North America) | 2785.7 | 51.4 |  |  | S1 | Live | 2019-07-16 00:00:00 | 2/4/2010 12:00:00 AM | False | True | [NAME], marine, and casualty insurance
 | [PHONE] | 3844831 | 2019-07-24 00:00:00 | Livongo Health Inc | United States | 28 | 408.5214 | Nasdaq | Common Stock | Firm Commitment|Negotiated Sale | 7 | North America | Americas | Software & IT Services | Technology |  | [NAME] Cos|KeyBanc Capital Markets Inc|Canaccord Genuity|JP Morgan Securities LLC|SVB Leerink LLC|Goldman Sachs & Co|Morgan Stanley & Co|Needham & Co LLC | United States Of America (North America) | 177.2 | -52.2 |  |  | S1 | Live | 2019-07-22 00:00:00 |  | False | False | Prepackaged Software|Medical, dental, and hospital equipment & supplies
 |  | 3844775 | 2019-07-24 00:00:00 | ProSight Global Inc | United States | 14 | 126.500066 | New York Stock Exchange | Common Stock | Negotiated Sale|Firm Commitment | 6.5 | North America | Americas | Insurance | Financials |  | Goldman Sachs & Co | United States Of America (North America) | 2785.7 | 51.4 |  |  | S1 | Live | 2019-07-16 00:00:00 | 2/4/2010 12:00:00 AM | False | True | [NAME], marine, and casualty insurance
 | [PHONE] | 3855454 | 2019-07-22 00:00:00 | [NAME] | United States |  | 9.3 |  | Common Stock | Firm Commitment|Negotiated Sale | -999 | North America | Americas | Healthcare Services & Equipment | Healthcare |  | Aegis Capital Corp. | United States Of America (North America) |  |  |  |  | S1 | Cancelled | 2019-10-03 00:00:00 | 3/18/2019 12:00:00 AM |  | False | Prepackaged Software|Specialty outpatient facilities, nec
 | [PHONE] | 3840400 | 2019-07-17 00:00:00 | Phreesia Inc | United States | 18 | 192.265614 | New York Stock Exchange | Common Stock | Negotiated Sale | 7 | North America | Americas | Software & IT Services | Technology |  | [NAME] Fargo Securities LLC|Allen & Co Inc|JP Morgan Securities LLC|William Blair & Co | United States Of America (North America) | 68.1 | -18.5 |  |  | S1 | Live | 2019-07-08 00:00:00 | 1/1/2005 12:00:00 AM | True | False | Prepackaged Software
 | [PHONE] | 3840529 | 2019-07-17 00:00:00 | Fulcrum Therapeutics Inc | United States | 16 | 72 | Nasdaq | Common Stock | Firm Commitment|Negotiated Sale | 7 | North America | Americas | Pharmaceuticals & Medical Research | Healthcare |  | SVB Leerink LLC|Merrill Lynch Pierce Fenner & Smith|Morgan Stanley & Co | United States Of America (North America) | 65.2 | -67.8 |  |  | S1 | Live | 2019-07-17 00:00:00 | 8/18/2015 12:00:00 AM | True | False | In vitro and in vivo diagnostic substances|Pharmaceutical preparations
 | [PHONE] | 3840574 | 2019-07-17 00:00:00 | Mirum Pharmaceuticals Inc | United States | 15 | 75 | Nasdaq | Common Stock | Firm Commitment|Negotiated Sale | 7 | North America | Americas | Pharmaceuticals & Medical Research | Healthcare |  | Raymond James & Associates Inc|Evercore Group|Roth Capital Partners Inc|Citigroup Global Markets Inc|Guggenheim Securities LLC | United States Of America (North America) | 104.3 | 0 |  |  | S1 | Live | 2019-07-08 00:00:00 | 5/2/2018 12:00:00 AM | True | False | Pharmaceutical preparations|In vitro and in vivo diagnostic substances|Commercial physical and biological research|Noncommercial research organizations
 | [PHONE] | 3841504 | 2019-07-17 00:00:00 | AssetMark Financial Holdings Inc | United States | 22 | 316.25 | New York Stock Exchange | Common Stock | Firm Commitment|Negotiated Sale | 6.5 | North America | Americas | Banking & Investment Services | Financials |  | Raymond James & Associates Inc|Huatai Securities Co Ltd|BMO Capital Markets|Credit Suisse Securities (USA) LLC|JP Morgan Securities LLC|Goldman Sachs & Co|William Blair & Co | United States Of America (North America) | 1151.4 | 24.4 |  |  | S1 | Live | 2019-07-08 00:00:00 | 1/31/1996 12:00:00 AM | False | False | Investment advice|Management consulting services|Business consulting services, nec
 | [PHONE] | 3827899 | 2019-06-27 00:00:00 | Karuna Therapeutics Inc | United States | 16 | 102.637472 | Nasdaq | Common Stock | Negotiated Sale|Firm Commitment | 7 | North America | Americas | Pharmaceuticals & Medical Research | Healthcare |  | Citigroup Global Markets Inc|Wells Fargo Securities LLC|Goldman Sachs & Co|Wedbush Securities, Inc. | United States Of America (North America) | 85.4 | -27.1 |  |  | S1 | Live | 2019-06-17 00:00:00 | 7/24/2009 12:00:00 AM | False | False | In vitro and in vivo diagnostic substances|Commercial physical and biological research|Noncommercial research organizations|Pharmaceutical preparations
 | [PHONE] | 3824543 | 2019-06-26 00:00:00 | [NAME] | United States | 17 | 400.775 | Nasdaq | Common Stock | Negotiated Sale|Firm Commitment | 7 | North America | Americas | Pharmaceuticals & Medical Research | Healthcare |  | Raymond James & Associates Inc|Piper Jaffray Cos|BMO Capital Markets|KKR Capital Markets LLC|Jefferies LLC|JP Morgan Securities LLC|Mizuho Securities USA LLC|SVB Leerink LLC|Goldman Sachs & Co | United States Of America (North America) | 401.4 | -167.9 |  |  | S1 | Live | 2019-06-25 00:00:00 | 1/1/2015 12:00:00 AM | True | False | Biological products, except diagnostic substances|Medical laboratories|Commercial physical and biological research|Noncommercial research organizations
 | [PHONE] | 3827258 | 2019-06-26 00:00:00 | Adaptive Biotechnologies Corp | United States | 20 | 345 | Nasdaq | Common Stock | Firm Commitment|Negotiated Sale | 7 | North America | Americas | Pharmaceuticals & Medical Research | Healthcare |  | Guggenheim Securities LLC|Cowen & Co|BTIG LLC|JP Morgan Securities LLC|Goldman Sachs & Co|Merrill Lynch Pierce Fenner & Smith|William Blair & Co | United States Of America (North America) | 614.6 | -52.3 |  |  | S1 | Live | 2019-06-26 00:00:00 |  | True | False | Biological products, except diagnostic substances|Commercial physical and biological research|Noncommercial research organizations|Medical laboratories
 | [PHONE] | 3827283 | 2019-06-26 00:00:00 | [NAME] | United States | 15 | 103.5 | Nasdaq | Common Stock | Negotiated Sale | 7 | North America | Americas | Pharmaceuticals & Medical Research | Healthcare |  | Wells Fargo Securities LLC|BMO Capital Markets|Cowen & Co|Jefferies LLC | United States Of America (North America) | 190.3 | -23.9 |  |  | S1 | Live | 2019-06-14 00:00:00 | 8/1/2014 12:00:00 AM | True | False | Medicinal chemicals and botanical products
 | [PHONE] | 3819556 | 2019-06-25 00:00:00 | Blackrock Science & Technology Trust Ii | United States | 20 | 1500 | New York Stock Exchange | Common Stock | Negotiated Sale|Firm Commitment | -999 | North America | Americas | Collective Investments | Financials |  | Raymond James & Associates Inc|Arcadia Securities|B Riley & Company|BB&T Capital Markets|Joseph Gunnar & Co., LLC|Newbridge Securities|InCapital LLC|Maxim Group LLC|UBS Investment Bank|Oppenheimer & Co Inc|Janney Montgomery Scott LLC|Wells Fargo Securities LLC|Pershing LLC|Ameriprise Financial Inc|Click Securities Inc|RBC Capital Markets LLC|JonesTrading Institutional Services LLC|DA Davidson & Co Inc|Ladenburg Thalmann & Co|Merrill Lynch Pierce Fenner & Smith|Morgan Stanley & Co|Stifel Nicolaus & Co Inc | United States Of America (North America) |  |  |  |  | S1 | Live | 2019-06-25 00:00:00 | 1/1/1970 12:00:00 AM | False | False | Investment offices, nec
 | [PHONE] | 3826809 | 2019-06-25 00:00:00 | Cambium Networks Corp | United States | 12 | 69.6 | Nasdaq | Ordinary Shares | Negotiated Sale | 7 | North America | Americas | Technology Equipment | Technology |  | Raymond James & Associates Inc|Deutsche Bank Securities Inc|JMP Securities LLC|Oppenheimer & Co Inc|JP Morgan Securities LLC|Goldman Sachs & Co | United States Of America (North America) | 146.7 | 0.4 |  |  | S1 | Live | 2019-06-13 00:00:00 |  | False | True | Electronic components, nec|Radio & TV broadcasting & communications equipment
 | [PHONE] | 3824564 | 2019-06-19 00:00:00 | AKERO THERAPEUTICS, INC. | United States | 16 | 105.8 | Nasdaq | Common Stock | Firm Commitment | 7 | North America | Americas | Pharmaceuticals & Medical Research | Healthcare |  | Evercore Group|Roth Capital Partners Inc|Jefferies LLC|JP Morgan Securities LLC | United States Of America (North America) | 72.1 | -86.7 |  |  | S1 | Live | 2019-06-10 00:00:00 | 1/24/2017 12:00:00 AM | True | False | Medical laboratories|Commercial physical and biological research|Noncommercial research organizations|Biological products, except diagnostic substances
 | [PHONE] | 3823705 | 2019-06-18 00:00:00 | Stoke Therapeutics Inc | United States | 18 | 163.345968 | Nasdaq | Common Stock | Firm Commitment|Negotiated Sale | 7 | North America | Americas | Pharmaceuticals & Medical Research | Healthcare |  | Cowen & Co|Credit Suisse Securities (USA) LLC|Canaccord Genuity|JP Morgan Securities LLC | United States Of America (North America) | 102.9 | -16.4 |  |  | S1 | Live | 2019-06-07 00:00:00 |  | True | False | Commercial physical and biological research|Noncommercial research organizations|Biological products, except diagnostic substances
 | [PHONE] | 3716929 | 2019-06-06 00:00:00 | Revolve Group LLC | United States | 18 | 243.529398 | New York Stock Exchange | Class A Common Shares | Firm Commitment|Negotiated Sale | 6.25 | North America | Americas | Retailers | Consumer Cyclicals |  | Barclays|Guggenheim Securities LLC|Cowen & Co|Raymond James|Jefferies LLC|Credit Suisse|Merrill Lynch Pierce Fenner & Smith|Morgan Stanley & Co|William Blair & Co | United States Of America (North America) | 177.2 | 30.3 |  |  | S1 | Live | 2019-06-06 00:00:00 |  | False | True | Men's  and boys' clothing and accessory stores|Women's and children's clothing and accessories|Catalog and mail-order houses|Women's clothing stores|Women's accessory and specialty stores|Miscellaneous apparel and accessory stores
 | [PHONE] | 3823393 | 2019-05-23 00:00:00 | Endeavor Group Holdings Inc | United States |  | 600.000009 | New York Stock Exchange | Class A Common Shares | Firm Commitment | -999 | North America | Americas | Cyclical Consumer Services | Consumer Cyclicals |  | [NAME] Capital Group LP|Evercore Group|Barclays Capital Group|Deutsche Bank Securities Inc|RBC Capital Markets|Citigroup Global Markets Inc|Credit Suisse Securities (USA) LLC|Moelis & Co|Code Advisors|KKR Capital Markets LLC|BTIG LLC|Academy Securities Inc|LionTree Advisors LLC|HSBC Securities (USA) Inc|Jefferies LLC|Dean Bradley Osborne Partners LLC|JP Morgan Securities LLC|Siebert Cisneros Shank & Co|Goldman Sachs & Co|Morgan Stanley & Co|UBS Securities Inc|Sandler O'Neill Partners  L.P. | United States Of America (North America) | 9885.3 | 292.4 |  |  | S1 | Cancelled | 2019-09-16 00:00:00 |  |  | True | Coin-operated amusement devices|Dance studios, schools, and halls|Amusement and recreation svcs|Membership sports and clubs
 | [PHONE] | 3810573 | 2019-05-16 00:00:00 | Fastly Inc | United States | 16 | 182.435344 | New York Stock Exchange | Class A Common Shares | Firm Commitment|Negotiated Sale | 7 | North America | Americas | Software & IT Services | Technology |  | Raymond James & Associates Inc|Citigroup Global Markets Inc|Oppenheimer & Co Inc|Credit Suisse Securities (USA) LLC|Robert W Baird & Co Inc|Craig-Hallum, Inc.|DA Davidson & Co Inc|Merrill Lynch Pierce Fenner & Smith|Stifel Nicolaus & Co Inc|William Blair & Co | United States Of America (North America) | 163.7 | -31.4 |  |  | S1 | Live | 2019-05-06 00:00:00 | 3/2/2011 12:00:00 AM | True | False | Data processing services|Computer related services, nec
 | [PHONE] | 3802418 | 2019-05-14 00:00:00 | Postal Realty Trust Inc | United States | 17 | 76.5 | New York Stock Exchange | Class A Common Shares | Firm Commitment|Negotiated Sale | 7 | North America | Americas | Real Estate | Real Estate |  | [NAME] Markets|Height Securities LLC|B Riley Financial Inc|DA Davidson & Co Inc|Stifel Nicolaus & Co Inc | United States Of America (North America) | 36 | 1.3 |  |  | S1 | Live | 2019-05-14 00:00:00 | 1/1/1970 12:00:00 AM | False | False | Real estate investment trusts
 | [PHONE] | 3808332 | 2019-05-10 00:00:00 | Sonim Technologies Inc | United States | 11 | 45.178573 | Nasdaq | Common Stock | Negotiated Sale|Firm Commitment | 7 | North America | Americas | Technology Equipment | Technology |  | Oppenheimer & Co Inc|Lake Street Capital Markets LLC|National Securities Corp (US) | United States Of America (North America) | 61.9 | 0.1 |  |  | S1 | Live | 2019-05-10 00:00:00 | 1/1/1999 12:00:00 AM | False | True | Communications services, nec|Radiotelephone communications|Radio & TV broadcasting & communications equipment|Computer integrated systems design|Prepackaged Software
 | [PHONE] | 3551675 | 2019-05-09 00:00:00 | Uber Technologies Inc | United States | 45 | 8100 | New York Stock Exchange | Common Stock | Firm Commitment|Negotiated Sale | 1.311 | North America | Americas | Software & IT Services | Technology |  | Williams Capital Group LP|Raymond James & Associates Inc|Evercore Group|Barclays|Loop Capital Markets|Deutsche Bank Securities Inc|SunTrust Robinson Humphrey|RBC Capital Markets|JMP Securities LLC|Citigroup Global Markets Inc|Oppenheimer & Co Inc|CastleOak Securities LP|Canaccord Genuity|BTIG LLC|Mischler Financial Group Inc|Academy Securities Inc|Macquarie Capital (USA) Inc|HSBC Securities (USA) Inc|TPG Capital BD LLC|SMBC Nikko Securities America Inc|Allen & Co Inc|Siebert Cisneros Shank & Co|Mizuho Securities USA LLC|Cowen & Co|Goldman Sachs & Co|Merrill Lynch Pierce Fenner & Smith|Morgan Stanley & Co|Needham & Co LLC|William Blair & Co | United States Of America (North America) | 24390 | -1960 |  |  | S1 | Live | 2019-04-26 00:00:00 | 1/1/2009 12:00:00 AM | True | False | Information retrieval services|Prepackaged Software|Taxicabs|Communications services, nec
 | [PHONE] | 3807078 | 2019-05-08 00:00:00 | Axcella Health Inc | United States | 20 | 71.42856 | Nasdaq | Common Stock | Firm Commitment|Negotiated Sale | 7 | North America | Americas | Pharmaceuticals & Medical Research | Healthcare |  | JP Morgan Securities LLC|SVB Leerink LLC|Goldman Sachs & Co | United States Of America (North America) | 70.9 | -39.5 |  |  | S1 | Live | 2019-05-08 00:00:00 | 8/27/2008 12:00:00 AM | True | False | Medical laboratories|Commercial physical and biological research|Biological products, except diagnostic substances|Noncommercial research organizations
 | [PHONE] | 3807328 | 2019-05-08 00:00:00 | Cortexyme Inc | United States | 17 | 86.2546 | Nasdaq | Common Stock | Firm Commitment|Negotiated Sale | 7 | North America | Americas | Pharmaceuticals & Medical Research | Healthcare |  | JMP Securities LLC|Credit Suisse Securities (USA) LLC|Canaccord Genuity|Merrill Lynch Pierce Fenner & Smith | United States Of America (North America) | 70.6 | -14.8 |  |  | S1 | Live | 2019-04-29 00:00:00 | 6/20/2012 12:00:00 AM | True | False | In vitro and in vivo diagnostic substances|Pharmaceutical preparations|Biological products, except diagnostic substances|Medical laboratories|Commercial physical and biological research|Noncommercial research organizations
 | [PHONE] | 3807700 | 2019-05-08 00:00:00 | Milestone Pharmaceuticals Inc | Canada | 15 | 94.875 | Nasdaq | Common Stock | Negotiated Sale|Firm Commitment | 7 | North America | Americas | Pharmaceuticals & Medical Research | Healthcare |  | Oppenheimer & Co Inc|Piper Jaffray Cos|Jefferies LLC|Cowen & Co | United States Of America (North America) | 77.6 | -29.5 |  |  | S1 | Live | 2019-04-29 00:00:00 | 7/16/2003 12:00:00 AM | True | False | In vitro and in vivo diagnostic substances|Pharmaceutical preparations|Commercial physical and biological research
 | [PHONE] | 3807706 | 2019-05-08 00:00:00 | NextCure Inc | United States | 15 | 86.25 | Nasdaq | Common Stock | Firm Commitment|Negotiated Sale | 7 | North America | Americas | Pharmaceuticals & Medical Research | Healthcare |  | [NAME] Lynch Pierce Fenner & Smith|Morgan Stanley & Co | United States Of America (North America) | 145.4 | -24 |  |  | S1 | Live | 2019-04-29 00:00:00 |  | True | False | Noncommercial research organizations|Commercial physical and biological research
 | [PHONE] | 3804104 | 2019-05-06 00:00:00 | Trevi Therapeutics Inc | United States | 10 | 55 | Nasdaq | Common Stock | Firm Commitment | 7 | North America | Americas | Pharmaceuticals & Medical Research | Healthcare |  | BMO Capital Markets|SVB Leerink LLC|Needham & Co LLC|Stifel Nicolaus & Co Inc | United States Of America (North America) | 17.2 | -20.9 |  |  | S1 | Live | 2019-05-06 00:00:00 | 3/17/2011 12:00:00 AM | True | False | Medicinal chemicals and botanical products|Pharmaceutical preparations|Biological products, except diagnostic substances
 | [PHONE] | 3804047 | 2019-05-01 00:00:00 | Transmedics Group Inc | United States | 16 | 104.696 | Nasdaq | Common Stock | Firm Commitment|Negotiated Sale | 7 | North America | Americas | Healthcare Services & Equipment | Healthcare |  | [NAME] Securities LLC|Cowen & Co|Morgan Stanley & Co | United States Of America (North America) | 38.8 | -25.7 |  |  | S1 | Live | 2019-04-30 00:00:00 | 1/1/1970 12:00:00 AM | True | False | Medical, dental, and hospital equipment & supplies
 | [PHONE] | 3749455 | 2019-04-30 00:00:00 | Atif Holdings Ltd | China (PRC) | 5 | 10.37336 | Nasdaq | Ordinary Shares | Best Efforts | 6.4 | North Asia | Asia Pacific Excluding Central Asia | Industrial & Commercial Services | Industrials |  | Boustead Securities LLC | United States Of America (North America) | 3.7 | 1.9 |  |  | S1 | Live | 2019-04-30 00:00:00 |  | False | False | Services, nec|News syndicates|Newspapers: publishing, or publishing & printing
 | [PHONE] | 3814195 | 2019-04-29 00:00:00 | [NAME] | United States |  |  | Nasdaq | Common Stock | Firm Commitment | -999 | North America | Americas | Pharmaceuticals & Medical Research | Healthcare |  | Evercore Group|Jefferies LLC|Wedbush Securities, Inc.|William Blair & Co | United States Of America (North America) | 144 | -48.3 |  |  | S1 | Cancelled |  | 1/1/2015 12:00:00 AM |  | False | Noncommercial research organizations|Biological products, except diagnostic substances|Commercial physical and biological research
 | [PHONE] | 3813676 | 2019-04-26 00:00:00 | Peloton Therapeutics Inc | United States |  | 150 |  | Common Stock | Firm Commitment|Negotiated Sale | -999 | North America | Americas | Pharmaceuticals & Medical Research | Healthcare |  | Citigroup Global Markets Inc|Jefferies LLC|JP Morgan Securities LLC | United States Of America (North America) | 175.6 | -38 |  |  | S1 | Cancelled | 2019-05-13 00:00:00 | 8/1/2010 12:00:00 AM |  | False | Pharmaceutical preparations|In vitro and in vivo diagnostic substances|Biological products, except diagnostic substances
 | [PHONE] | 3811285 | 2019-04-22 00:00:00 | Seqll Inc | United States |  |  | Nasdaq | Common Stock | Firm Commitment|Negotiated Sale | -999 | North America | Americas | Healthcare Services & Equipment | Healthcare |  | WallachBeth Capital LLC | United States Of America (North America) | 1.1 | -3.4 |  |  | S1 | Cancelled |  | 4/3/2014 12:00:00 AM |  | False | Laboratory analytical instruments
 | [PHONE] | 3781499 | 2019-04-17 00:00:00 | Zoom Video Communications Inc | United States | 36 | 864 | Nasdaq | Class A Common Shares | Firm Commitment | 5 | North America | Americas | Software & IT Services | Technology |  | RBC Capital Markets|JMP Securities LLC|Piper Jaffray Cos|Wells Fargo Securities LLC|Credit Suisse Securities (USA) LLC|KeyBanc Capital Markets Inc|JP Morgan Securities LLC|Goldman Sachs & Co|Merrill Lynch Pierce Fenner & Smith|Morgan Stanley & Co|Stifel Nicolaus & Co Inc|William Blair & Co | United States Of America (North America) | 354.6 | 0 |  |  | S1 | Live | 2019-04-16 00:00:00 |  | True | False | Prepackaged Software|Information retrieval services|Telephone communications, except radiotelephone
 | [PHONE] | 3792326 | 2019-04-17 00:00:00 | Brigham Minerals Inc | United States | 18 | 300.15 | New York Stock Exchange | Class A Common Shares | Firm Commitment|Negotiated Sale | 6 | North America | Americas | Energy - Fossil Fuels | Energy |  | Raymond James & Associates Inc|Barclays|RBC Capital Markets|Piper Jaffray Cos|Wells Fargo Securities LLC|Credit Suisse Securities (USA) LLC|Sea Port Group Securities LLC|Tudor Pickering Holt & Co LLC|Goldman Sachs & Co|UBS Securities Inc | United States Of America (North America) | 567.2 | 29.4 |  |  | S1 | Live | 2019-04-09 00:00:00 | 1/1/1970 12:00:00 AM | False | True | Crude petroleum and natural gas
 | [PHONE] | 3795120 | 2019-04-17 00:00:00 | HOOKIPA Pharma Inc | United States | 14 | 84 | Nasdaq | Common Stock | Firm Commitment | 7 | North America | Americas | Pharmaceuticals & Medical Research | Healthcare |  | Kempen and Co NV|RBC Capital Markets|Leerink Partners LLC|Merrill Lynch Pierce Fenner & Smith | United States Of America (North America) | 102 | -21 |  |  | S1 | Live | 2019-04-08 00:00:00 |  | True | False | Commercial physical and biological research|Biological products, except diagnostic substances|Noncommercial research organizations
 | [PHONE] | 3809545 | 2019-04-17 00:00:00 | Kci Holdings Inc | United States |  |  |  | Common Stock | Negotiated Sale|Firm Commitment | -999 | North America | Americas | Healthcare Services & Equipment | Healthcare |  | JP Morgan Securities LLC|Goldman Sachs & Co|Merrill Lynch Pierce Fenner & Smith | United States Of America (North America) |  |  |  |  | S1 | Cancelled |  |  |  | False | Surgical and medical instruments and apparatus|Measuring & controlling devices
 | [PHONE] | 3807708 | 2019-04-15 00:00:00 | Conversionpoint Holdings Inc | United States |  |  |  | Common Stock | Firm Commitment|Negotiated Sale | -999 | North America | Americas | Software & IT Services | Technology |  | Oppenheimer & Co Inc|GMP Securities Ltd | United States Of America (North America) |  |  |  |  | S1 | Cancelled |  | 1/1/1970 12:00:00 AM |  | False | Computer programming services
 | [PHONE] | 3716887 | 2019-04-03 00:00:00 | NGM Biopharmaceuticals Inc | United States | 16 | 120.342304 | Nasdaq | Common Stock | Firm Commitment|Negotiated Sale | 7 | North America | Americas | Pharmaceuticals & Medical Research | Healthcare |  | Citigroup Global Markets Inc|Cowen & Co|Goldman Sachs & Co | United States Of America (North America) | 231.6 | -4.8 |  |  | S1 | Live | 2019-04-03 00:00:00 | 1/1/2008 12:00:00 AM | True | False | Noncommercial research organizations|Commercial physical and biological research|Pharmaceutical preparations|Biological products, except diagnostic substances|Medical laboratories
 | [PHONE] | 3784103 | 2019-04-03 00:00:00 | Silk Road Medical Inc | United States | 20 | 138 | Nasdaq | Common Stock | Firm Commitment | 7 | North America | Americas | Pharmaceuticals & Medical Research | Healthcare |  | BMO Capital Markets|JP Morgan Securities LLC|Merrill Lynch Pierce Fenner & Smith|Stifel Nicolaus & Co Inc | United States Of America (North America) | 38.7 | -56.4 |  |  | S1 | Live | 2019-04-03 00:00:00 |  | False | True | Pharmaceutical preparations
 | [PHONE] | 3783847 | 2019-03-27 00:00:00 | Precision Biosciences Inc | United States | 16 | 145.36 | Nasdaq | Common Stock | Firm Commitment|Negotiated Sale | 7 | North America | Americas | Pharmaceuticals & Medical Research | Healthcare |  | Barclays|Jefferies LLC|JP Morgan Securities LLC|Goldman Sachs & Co | United States Of America (North America) | 138.6 | -46 |  |  | S1 | Live | 2019-03-18 00:00:00 | 1/1/2005 12:00:00 AM | True | False | Biological products, except diagnostic substances|Medical laboratories|Commercial physical and biological research|Noncommercial research organizations
 | [PHONE] | 3763752 | 2019-02-27 00:00:00 | Kaleido Biosciences Inc | United States | 15 | 75 | Nasdaq | Common Stock | Firm Commitment|Negotiated Sale | 7 | North America | Americas | Pharmaceuticals & Medical Research | Healthcare |  | [NAME] Securities LLC|Goldman Sachs & Co|Morgan Stanley & Co | United States Of America (North America) | 85.3 | -61.7 |  |  | S1 | Live | 2019-02-27 00:00:00 | 1/27/2015 12:00:00 AM | True | False | Noncommercial research organizations|Commercial physical and biological research
 | [PHONE] | 3760520 | 2019-02-26 00:00:00 | Super League Gaming Inc | United States | 11 | 24.999997 | Nasdaq | Common Stock | Firm Commitment | 7 | North America | Americas | Software & IT Services | Technology |  | Northland Securities Inc|Lake Street Capital Markets LLC|National Securities Corp (US) | United States Of America (North America) | 5 | -20.6 |  |  | S1 | Live | 2019-02-26 00:00:00 | 1/1/2014 12:00:00 AM | True | False | Prepackaged Software|Professional sports clubs and promoters
 | [PHONE] | 3828490 | 2019-02-22 00:00:00 | Inhibrx Inc | United States |  |  | Nasdaq | Common Stock | Negotiated Sale | -999 | North America | Americas | Pharmaceuticals & Medical Research | Healthcare |  | Raymond James & Associates Inc|Evercore Group|Barclays Capital Group|Nomura Securities International Inc | United States Of America (North America) | 10 | -31.2 |  |  | S1 | Cancelled | 2019-08-20 00:00:00 |  |  | False | In vitro and in vivo diagnostic substances|Pharmaceutical preparations
 | [PHONE] | 3721462 | 2019-02-15 00:00:00 | Hoth Therapeutics Inc | United States | 5.6 | 7 | Nasdaq | Common Stock | Firm Commitment|Negotiated Sale | 7 | North America | Americas | Pharmaceuticals & Medical Research | Healthcare |  | Laidlaw & Co (UK) Ltd | United States Of America (North America) | 0.5 | -2.5 |  |  | S1 | Live | 2019-02-15 00:00:00 | 1/1/2017 12:00:00 AM | False | False | Noncommercial research organizations|Commercial physical and biological research|Biological products, except diagnostic substances|Medical laboratories
 | [PHONE] | 3759281 | 2019-02-13 00:00:00 | TCR2 Therapeutics Inc | United States | 15 | 86.25 | Nasdaq | Common Stock | Firm Commitment | 7 | North America | Americas | Pharmaceuticals & Medical Research | Healthcare |  | BMO Capital Markets|Jefferies LLC|China Renaissance Securities(Hong Kong)Ltd|Leerink Partners LLC|Wedbush Securities, Inc. | United States Of America (North America) | 129.4 | -24.3 |  |  | S1 | Live | 2019-02-13 00:00:00 | 1/1/2015 12:00:00 AM | True | False | Commercial physical and biological research|Biological products, except diagnostic substances|Noncommercial research organizations
 | [PHONE] | 3766477 | 2019-02-13 00:00:00 | Avedro Inc | United States | 14 | 70 | Nasdaq | Common Stock | Firm Commitment|Negotiated Sale | 7 | North America | Americas | Healthcare Services & Equipment | Healthcare |  | Guggenheim Securities LLC|SVB Financial Group|JP Morgan Securities LLC|Cowen & Co|Merrill Lynch Pierce Fenner & Smith | United States Of America (North America) | 25.9 | -25.1 |  |  | S1 | Live | 2019-02-13 00:00:00 | 1/1/2007 12:00:00 AM | True | False | Optical instruments and lenses|Surgical and medical instruments and apparatus|X-Ray apparatus & tubes & other irradiation equip.
 | [PHONE] | 3709833 | 2019-02-12 00:00:00 | IMAC Holdings Inc | United States | 5.5 | 4.675 | Nasdaq | Common Stock | Negotiated Sale|Firm Commitment | 5.818 | North America | Americas | Healthcare Services & Equipment | Healthcare |  | Axiom Capital Management Inc|Dawson James Securities|Benchmark Co LLC | United States Of America (North America) | 11.1 | -3.1 |  |  | S1 | Live | 2019-02-12 00:00:00 |  | True | False | Specialty outpatient facilities, nec
 | [PHONE] | 3732588 | 2019-02-12 00:00:00 | Unex Holdings Inc | United States | 0.03 | 0.1581 | OTC | Common Stock | Best Efforts | -999 | North America | Americas | Banking & Investment Services | Financials |  | Not Applicable | United States Of America (North America) | 0 | 0 |  |  | S1 | Live | 2019-02-12 00:00:00 |  | False | False | Offices of bank holding companies
 | [PHONE] | 3735109 | 2019-01-30 00:00:00 | New Fortress Energy LLC | United States | 14 | 322 | Nasdaq | Class A Common Shares | Negotiated Sale|Firm Commitment | 6.161 | North America | Americas | Utilities | Utilities |  | Evercore Group|Barclays|JMP Securities LLC|Citigroup Global Markets Inc|Credit Suisse Securities (USA) LLC|Allen & Co Inc|Morgan Stanley & Co|Stifel Nicolaus & Co Inc | United States Of America (North America) | 699.2 | -78.1 |  |  | S1 | Live | 2019-01-30 00:00:00 |  | False | False | Heavy construction, nec|Natural gas transmission|Natural gas transmission and distribution|Natural gas distribution|Water, sewer, pipeline & utility line construction|Gas production and/or distribution|Electric and other services combined|Management services|Combination utilities, nec|Gas and other services combined
 | [PHONE] | 3763764 | 2019-01-11 00:00:00 | Cirius Therapeutics Inc | United States |  |  |  | Common Stock | Firm Commitment|Negotiated Sale | -999 | North America | Americas | Pharmaceuticals & Medical Research | Healthcare |  | Citigroup Global Markets Inc|Credit Suisse Securities (USA) LLC|Needham & Co LLC|Wedbush Securities | United States Of America (North America) | 23.8 | -22.4 |  |  | S1 | Cancelled |  |  |  | False | In vitro and in vivo diagnostic substances|Pharmaceutical preparations
 | [PHONE] | 3764437 | 2019-01-10 00:00:00 | Bitwise Bitcoin ETF Trust | United States |  |  |  | Common Stock | Negotiated Sale | -999 | North America | Americas | Collective Investments | Financials |  | Not Applicable | United States Of America (North America) |  |  |  |  | S1 | Cancelled | 2019-09-10 00:00:00 |  |  | False | Trusts, [NAME]. educational, religious, & charitable|Educational, religious, and charitable trusts|Investment offices, nec|Pension, health, and welfare funds|Real estate investment trusts
 | [PHONE] | 3697481 | 2019-01-08 00:00:00 | Exeter Finance Corp | United States |  |  |  | Common Stock | Firm Commitment|Negotiated Sale | -999 | North America | Americas | Banking & Investment Services | Financials |  | Citigroup Global Markets Inc|Wells Fargo Securities LLC | United States Of America (North America) |  |  |  |  | S1 | Cancelled |  | 1/1/2006 12:00:00 AM |  | False | Misc business credit
 | [PHONE] | 3727002 | 2019-01-08 00:00:00 | Mmtec Inc | China (PRC) | 4 | 7.2 | Nasdaq | Common Stock | Firm Commitment|Negotiated Sale | 8 | North Asia | Asia Pacific Excluding Central Asia | Software & IT Services | Technology |  | [NAME] James Securities|WestPark Capital Inc|WallachBeth Capital LLC | United States Of America (North America) | 0.4 | -2.3 |  |  | S1 | Live | 2019-01-08 00:00:00 |  | False | False | Prepackaged Software
 | [PHONE] | 3760500 | 2019-01-04 00:00:00 | Poseida Therapeutics Inc | United States |  |  | Nasdaq | Common Stock | Negotiated Sale|Firm Commitment | -999 | North America | Americas | Pharmaceuticals & Medical Research | Healthcare |  | Citigroup Global Markets Inc|Wells Fargo Securities LLC|Credit Suisse Securities (USA) LLC | United States Of America (North America) | 45.1 | -44.4 |  |  | S1 | Cancelled | 2019-03-04 00:00:00 | 12/1/2014 12:00:00 AM |  | False | Commercial physical and biological research|Medical laboratories|Biological products, except diagnostic substances|Noncommercial research organizations
 | [PHONE] | 3758509 | 2018-12-26 00:00:00 | Cyty Capital Solutions Inc | United States |  | 1.25 |  | Common Stock | Best Efforts | -999 | North America | Americas | Industrial & Commercial Services | Industrials |  | Not Applicable | United States Of America (North America) |  |  |  |  | S1 | Cancelled | 2019-05-14 00:00:00 |  |  | False | Business consulting services, nec
 | [PHONE] | 3821029 | 2018-12-21 00:00:00 | Safe Auto Insurance Group Inc | United States |  |  |  | Common Stock | Firm Commitment|Negotiated Sale | -999 | North America | Americas | Insurance | Financials |  | Dowling & Partners Securities LLC|Deutsche Bank Securities Inc|Keefe Bruyette & Woods Inc|Merrill Lynch Pierce Fenner & Smith|Sandler O'Neill Partners  L.P. | United States Of America (North America) |  |  |  |  | S1 | Cancelled | 2019-05-17 00:00:00 | 1/1/1993 12:00:00 AM |  | False | Fire, marine, and casualty insurance
 | [PHONE] | 3756540 | 2018-12-20 00:00:00 | Hoverink Biotechnologies Inc | United States |  |  | OTC | Common Stock | Best Efforts | -999 | North America | Americas | Pharmaceuticals & Medical Research | Healthcare |  | Not Applicable | United States Of America (North America) |  |  |  |  | S1 | Cancelled |  | 7/13/2013 12:00:00 AM |  | False | Medicinal chemicals and botanical products|Drugs, drug proprietaries, and druggists' sundries|Commercial physical and biological research|Noncommercial research organizations
 | [PHONE] | 3824496 | 2018-12-20 00:00:00 | Dermavant Sciences Inc | United States |  | 100.1 |  | Common Stock | Firm Commitment|Negotiated Sale | -999 | North America | Americas | Pharmaceuticals & Medical Research | Healthcare |  | Guggenheim Securities LLC|Jefferies LLC|SVB Leerink LLC | United States Of America (North America) |  |  |  |  | S1 | Cancelled | 2019-06-10 00:00:00 | 3/10/2016 12:00:00 AM |  | False | Biological products, except diagnostic substances|Pharmaceutical preparations|Medicinal chemicals and botanical products
 | [PHONE] | 3720785 | 2018-12-18 00:00:00 | Mercantil Bank Holding Corp | United States | 13 | 84.877247 | Nasdaq | Class A Common Shares | Firm Commitment|Negotiated Sale | 7 | North America | Americas | Banking & Investment Services | Financials |  | Raymond James & Associates Inc|SunTrust Robinson Humphrey|Fig Partners LLC|Keefe Bruyette & Woods Inc|Stephens Inc | United States Of America (North America) | 8413 | 49.8 |  |  | S1 | Live | 2018-12-18 00:00:00 |  | False | False | Offices of bank holding companies|National commercial banks
 | [PHONE] | 3734998 | 2018-12-13 00:00:00 | Legacy Housing Corp | United States | 12 | 55.2 | Nasdaq | Common Stock | Firm Commitment|Negotiated Sale | 7 | North America | Americas | Cyclical Consumer Products | Consumer Cyclicals |  | B Riley & Company|Oak Ridge Financial|National Securities Corp (US) | United States Of America (North America) | 233.7 | 28.3 |  |  | S1 | Live | 2018-11-30 00:00:00 |  | False | False | Mobile homes
 | [PHONE] | 3745694 | 2018-12-04 00:00:00 | Ardent Health Partners LLC | United States |  |  |  | Common Stock | Firm Commitment|Negotiated Sale | -999 | North America | Americas | Healthcare Services & Equipment | Healthcare |  | Barclays|Loop Capital Markets|RBC Capital Markets|Citigroup Global Markets Inc|Credit Suisse Securities (USA) LLC|JP Morgan Securities LLC|Goldman Sachs & Co|Merrill Lynch Pierce Fenner & Smith|Stephens Inc | United States Of America (North America) |  |  |  |  | S1 | Cancelled |  |  |  | False | General medical and surgical hospitals|Specialty hospitals, except psychiatric
 | [PHONE] | 3616125 | 2018-11-28 00:00:00 | Tiburon International Trading Corp | China (PRC) | 0.03 | 0.183 | OTC | Common Stock | Best Efforts | -999 | North Asia | Asia Pacific Excluding Central Asia | Industrial Goods | Industrials |  | Not Applicable | United States Of America (North America) | 0 | 0 |  |  | S1 | Live | 2018-11-28 00:00:00 |  | False | False | Industrial supplies
 | [PHONE] | 3738230 | 2018-11-16 00:00:00 | Cibus Ltd | Bermuda |  | 100.000005 |  | Class A Common Shares | Firm Commitment|Negotiated Sale | -999 | Caribbean | Americas | Pharmaceuticals & Medical Research | Healthcare |  | [NAME] Cos|BMO Capital Markets|Merrill Lynch Pierce Fenner & Smith|Morgan Stanley & Co | United States Of America (North America) |  |  |  |  | S1 | Cancelled | 2019-02-11 00:00:00 |  |  | False | Noncommercial research organizations|Commercial physical and biological research|Forest nurseries and gathering of forest products|General farms, primarily crop|Horticultural specialties|Field crops, except cash grains, nec
 | [PHONE] | 3738241 | 2018-11-16 00:00:00 | [NAME] LLC | United States |  | 510.012 |  | Common Stock | Firm Commitment|Negotiated Sale | -999 | North America | Americas | Transportation | Industrials |  | Raymond James & Associates Inc|Barclays|JMP Securities LLC|Allen & Co Inc|JP Morgan Securities LLC|Merrill Lynch Pierce Fenner & Smith|Morgan Stanley & Co|Stephens Inc | United States Of America (North America) | 1836.9 | -95.8 |  |  | S1 | Cancelled | 2019-01-30 00:00:00 |  |  | False | Railroads, line-haul operating
 | [PHONE] | 3716818 | 2018-10-24 00:00:00 | Yeti Holdings Inc | United States | 18 | 304.53894 | New York Stock Exchange | Common Stock | Firm Commitment | 5.75 | North America | Americas | Cyclical Consumer Products | Consumer Cyclicals |  | Raymond James & Associates Inc|Citigroup Global Markets Inc|Piper Jaffray Cos|KeyBanc Capital Markets Inc|Academy Securities Inc|Jefferies LLC|Robert W Baird & Co Inc|Goldman Sachs & Co|Merrill Lynch Pierce Fenner & Smith|Morgan Stanley & Co|Stifel Nicolaus & Co Inc|William Blair & Co | United States Of America (North America) | 493.5 | 42.3 |  |  | S1 | Live | 2018-10-24 00:00:00 | 5/15/2012 12:00:00 AM | False | True | Sporting and athletic goods, nec
 | [PHONE] | 3726111 | 2018-10-19 00:00:00 | Centrexion Therapeutics Corp | United States |  |  |  | Common Stock | Negotiated Sale|Firm Commitment | -999 | North America | Americas | Pharmaceuticals & Medical Research | Healthcare |  | SVB Leerink LLC|BofA Securities Inc | United States Of America (North America) | 52.8 | -30.5 |  |  | S1 | Cancelled | 2019-12-23 00:00:00 | 1/1/2013 12:00:00 AM |  | False | Pharmaceutical preparations
 | [PHONE] | 3726180 | 2018-10-19 00:00:00 | Caliburn International Corp | United States |  |  | New York Stock Exchange | Class A Common Shares | Firm Commitment|Negotiated Sale | -999 | North America | Americas | Industrial & Commercial Services | Industrials |  | Raymond James & Associates Inc|SunTrust Robinson Humphrey|Jefferies LLC|Cowen & Co|Merrill Lynch Pierce Fenner & Smith | United States Of America (North America) |  |  |  |  | S1 | Cancelled |  |  |  | False | Business consulting services, nec|Engineering services
 | [PHONE] | 3726265 | 2018-10-19 00:00:00 | Qualtrics International Inc | United States |  | 400.0000095 | Munich | Class B Common Shares | Firm Commitment|Negotiated Sale | -999 | North America | Americas | Software & IT Services | Technology |  | Raymond James & Associates Inc|Barclays|Deutsche Bank Securities Inc|RBC Capital Markets|BMO Capital Markets|KeyBanc Capital Markets Inc|BTIG LLC|Canaccord Genuity Corp|Jefferies [NAME] Baird & Co Inc|Goldman Sachs & Co|Morgan Stanley & Co | United States Of America (North America) | 334.3 | 3.1 |  |  | S1 | Cancelled | 2018-11-05 00:00:00 | 1/1/2014 12:00:00 AM |  | False | Prepackaged Software
 | [PHONE] | 3659324 | 2018-10-18 00:00:00 | Solarwinds Corp | United States | 15 | 375 | New York Stock Exchange | Common Stock | Firm Commitment|Negotiated Sale | 4.75 | North America | Americas | Software & IT Services | Technology |  | [NAME] Co.|Evercore Group|Barclays|SunTrust Robinson Humphrey|JMP Securities LLC|Citigroup Global Markets Inc|Credit Suisse Securities (USA) LLC|KeyBanc Capital Markets Inc|Macquarie Capital Group Ltd|Nomura Securities International Inc|Mischler Financial Group Inc|RBC Capital Markets LLC|Jefferies [NAME] Securities LLC|Goldman Sachs & Co|Merrill Lynch Pierce Fenner & Smith|Morgan Stanley & Co | United States Of America (North America) | 5163.6 | -127.1 |  |  | S1 | Live | 2018-10-18 00:00:00 |  | False | True | Prepackaged Software
 | [PHONE] | 3714935 | 2018-10-18 00:00:00 | Logicbio Therapeutics Inc | United States | 10 | 80.5 | Nasdaq | Common Stock | Negotiated Sale|Firm Commitment | 7 | North America | Americas | Pharmaceuticals & Medical Research | Healthcare |  | Barclays|Chardan Capital Markets LLC|Jefferies LLC|William Blair & Co | United States Of America (North America) | 17 | -13.6 |  |  | S1 | Live |  | 8/4/2014 12:00:00 AM | True | False | Biological products, except diagnostic substances|Medical laboratories|Commercial physical and biological research|Noncommercial research organizations
 | [PHONE] | 3709024 | 2018-10-17 00:00:00 | Osmotica Pharmaceuticals PLC | United States | 7 | 46.55 | Nasdaq | Ordinary Shares | Firm Commitment | 7 | North America | Americas | Pharmaceuticals & Medical Research | Healthcare |  | Barclays|RBC Capital Markets|Wells Fargo Securities LLC|Jefferies LLC | United States Of America (North America) | 855.5 | -6.4 |  |  | S1 | Live | 2018-10-17 00:00:00 |  | False | True | In vitro and in vivo diagnostic substances|Pharmaceutical preparations
 | [PHONE] | 3713163 | 2018-10-17 00:00:00 | PhaseBio Pharmaceuticals Inc | United States | 5 | 46 | Nasdaq | Common Stock | Firm Commitment | 7 | North America | Americas | Pharmaceuticals & Medical Research | Healthcare |  | Citigroup Global Markets Inc|Cowen & Co|Needham & Co LLC|Stifel Nicolaus & Co Inc | United States Of America (North America) | 27.5 | -21.5 |  |  | S1 | Live | 2018-10-17 00:00:00 |  | True | False | In vitro and in vivo diagnostic substances|Pharmaceutical preparations|Noncommercial research organizations|Commercial physical and biological research
 | [PHONE] | 3712481 | 2018-10-16 00:00:00 | SI-Bone Inc | United States | 15 | 124.2 | Nasdaq | Common Stock | Negotiated Sale|Firm Commitment | 7 | North America | Americas | Healthcare Services & Equipment | Healthcare |  | JMP Securities LLC|Canaccord Genuity|Merrill Lynch Pierce Fenner & Smith|Morgan Stanley & Co | United States Of America (North America) | 28.4 | -17 |  |  | S1 | Live | 2018-10-05 00:00:00 | 3/18/2008 12:00:00 AM | True | False | Surgical and medical instruments and apparatus|Measuring & controlling devices|Electromedical and electrotherapeutic apparatus
 | [PHONE] | 3499652 | 2018-10-11 00:00:00 | Anaplan Inc | United States | 17 | 303.025 | New York Stock Exchange | Common Stock | Negotiated Sale | 7 | North America | Americas | Software & IT Services | Technology |  | Evercore Group|Barclays|SunTrust Robinson Humphrey|JMP Securities LLC|Piper Jaffray Cos|KeyBanc Capital Markets Inc|Canaccord Genuity Corp|Goldman Sachs & Co|Morgan Stanley & Co|Needham & Co LLC | United States Of America (North America) | 234.2 | -78.8 |  |  | S1 | Live | 2018-10-10 00:00:00 |  | True | False | Computer related services, nec|Computer facilities management services|Data processing services|Prepackaged Software
 | [PHONE] | 3709866 | 2018-10-11 00:00:00 | Equillium Inc | United States | 14 | 71.611358 | Nasdaq | Common Stock | Firm Commitment | 7 | North America | Americas | Pharmaceuticals & Medical Research | Healthcare |  | Jefferies LLC|Leerink Partners LLC|Stifel Nicolaus & Co Inc | United States Of America (North America) | 6.4 | -9.4 |  |  | S1 | Live | 2018-10-02 00:00:00 |  | False | False | Noncommercial research organizations|In vitro and in vivo diagnostic substances|Commercial physical and biological research|Pharmaceutical preparations
 | [PHONE] | 3699028 | 2018-10-10 00:00:00 | Livent Corp | United States | 17 | 391 | New York Stock Exchange | Common Stock | Negotiated Sale|Firm Commitment | 5.5 | North America | Americas | Chemicals | Basic Materials |  | Loop Capital Markets|Citigroup Global Markets Inc|Credit Suisse Securities (USA) LLC|Nomura Securities International Inc|Goldman Sachs & Co|Merrill Lynch Pierce Fenner & Smith | United States Of America (North America) | 564.9 | 100.7 |  |  | S1 | Live | 2018-10-01 00:00:00 |  | False | False | Industrial organic chemicals, nec|Industrial inorganic chemicals, nec|Chemicals and allied products, nec
 | [PHONE] | 3708992 | 2018-10-10 00:00:00 | [NAME] | United States | 18 | 372.6 | Nasdaq | Common Stock | Negotiated Sale|Firm Commitment | 7 | North America | Americas | Pharmaceuticals & Medical Research | Healthcare |  | Jefferies LLC|JP Morgan Securities LLC|Cowen & Co|Goldman Sachs & Co | United States Of America (North America) | 435.2 | 0 |  |  | S1 | Live | 2018-10-10 00:00:00 | 11/30/2017 12:00:00 AM | True | False | Commercial physical and biological research|Biological products, except diagnostic substances|Noncommercial research organizations
 | [PHONE] | 3720827 | 2018-10-05 00:00:00 | The Parking REIT Inc | United States |  |  |  | Common Stock | Negotiated Sale | -999 | North America | Americas | Real Estate | Real Estate |  | Not Applicable|Chardan Capital Markets LLC | United States Of America (North America) |  |  |  |  | S1 | Cancelled |  | 5/4/2015 12:00:00 AM |  | False | Real estate investment trusts