Diel investments in metabolite production and consumption in a model microbial system