user2989408 questions

user2989408 answers

• Update using a subquery with aggregates and groupby in Postgres
• sum column to show total in every row
• Postgres group by timestamp into 6 hourly buckets