SpaceX's Nasdaq debut shattered expectations, soaring past $2 trillion and becoming the sixth-largest U.S. company. Investors, from institutions to retail fans, celebrated the record-breaking IPO, which raised $75 billion.