Yes.
If there is almost any conceivable hook by which the U.S. government can assert its subpoena authority as a practical matter, the CLOUD Act of 2018 gives a federal court subpoena the authority to demand that the data be turned over. Foreign firms were U.S. servers were mostly already covered by the Stored Communications Act.
The CLOUD Act primarily amends the Stored Communications Act (SCA) of
1986 to allow federal law enforcement to compel U.S.-based technology
companies via warrant or subpoena to provide requested data stored on
servers regardless of whether the data are stored in the U.S. or on
foreign soil.
If you have a foreign server, in a foreign country, with no employees or assets or agents in the U.S., obtaining documents from them through U.S. legal process may, as a practical matter, be impossible. In those cases, foreign subpoenas and foreign legal action is often available in most parts of the developed and developing world.
Intermediate between a foreign lawsuit and a U.S. lawsuit, is for a U.S. court to request that a foreign court issue "letters rogatory" which essentially allow discovery in another country's court case to be conducted through the courts of the country to which the letters rogatory are directed (if the discovery isn't contrary to the public policies of the country where the discovery conducting court is located).
For example, Alice in the United States, could not summon Jean from
France to the US courthouse. Instead, the US court would issue a
letter rogatory to a French court, which would then examine Jean in
France, and send a deposition back to the requesting court.
But the Cloud Act closed all of the easy and trivial loopholes in prior law (especially the SCA).
Since Nintendo is headquartered in Japan, could they be obliged to
reveal global numbers or are they free to restricting data that
pertains to the US only, through their subsidiary Nintendo of America?
The scope of the request is determined by the discovery issuing court in accordance with its rules of civil procedure.
A common standard in U.S. civil procedure is that the target of a subpoena must turn over all records, which in its "possession, custody, or control" (see Federal Rule of Civil Procedure 34), that are relevant to the disputed issues of fact in the case or reasonably calculated to potentially lead to relevant evidence regarding the disputed facts, and are not privileged (see Federal Rule of Civil Procedure 26(b) and Federal Rule of Evidence 501). This is a very broad standard, although the court has discretion to narrow the scope of discovery for good cause.
If the target is a parent company, it could easily have global scope and apply to all of the firm's subsidiaries and affiliates.