Ask HN: What's the best way to store time series data in a relational database?

We are currently having a write heavy load with about a half a million records being added every day. This could grow in future , so having one record for every minute with an index would slow down the writes.

Is it ok to have one record per hour with sixty columns for each minute ?

Or is it better to use a non relational database ?