Aqua over at Install Base leaked NPD numbers for PS5 and Xbox Series X/S up to Nov 2022. (Not sure if I am allowed to link to the thread itself of that forum but there's lots of good info there so it's worth a look anyways)
PS5 US NPD HW:
XBX US NPD HW:
In the end, I was right to lower expectations for XBS for November. But I still underestimated PS5, Switch I think I got close.