Let $\mathsf{hCW}$ denote the homotopy category of CW-complexes and $\mathsf{hCWSpec}$ the homotopy category of CW-spectra (ie. families of CW-complexes $(X_i)_{i\in\mathbb{Z}}$ with connection maps $\Sigma X_i \rightarrow X_{i+1}$ given by subcomplex inclusions).
What is the essential image of the suspension spectrum functor $\Sigma^\infty: \mathsf{hCW} \rightarrow \mathsf{hCWSpec}$?
It is folklore (see this remark on the nlab) that any CW-spectrum can be built up from cofiber sequences of the form $$\begin{array}{ccc} \bigoplus_{I_k} \Sigma^{q_k}\mathbb{S} & \rightarrow & X_k\\ \downarrow&&\downarrow\\ * & \rightarrow & X_{k+1} \end{array}$$ Since a similar fact holds for CW-complexes, it seems reasonable to expect that a CW-spectrum in the essential image of $\Sigma^\infty$ requires all stable cells to have nonnegative dimension $q_k$. But I am unsure whether this is actually sufficient...
I was told to have a look at the Hurewicz-theorem for spectra, but I don't see how this can be applied here, since it requires connective spectra. Since for negative $k$ $$\pi_k(X)=\operatorname*{colim} \limits_{n\in\Bbb N} \pi_{n+k}(X_n) \overset{def}{=}\operatorname*{colim} \limits_{n \geq \vert k\vert}\pi_{n+k}(X_n)$$ I don't see what having no negative stable cells has to do with having vanishing negative stable homotopy groups. Even in the case of finite CW-spectra I don't see a connection there. It is however very likely that I misunderstood the hint given, so I appreciate any feedback.
As always thank you very much for your attention and support.