Complex marine microbial communities partition metabolism of scarce resources over the diel cycle