creating a 24 hours data table - Suggestions/improvements
Your entities are based on hours, not days, so you should go with one row per hour, just like you did, not a full day in a row.

I did not understand if when you say data between two timestamps, if timestamp refers to the "inserted" column, or if it refers to the date and times on the data file. If it is the latter one, then having a datetime column for your date and hour, instead of two separate columns, would help you doing your comparisons. You would place an index on this datetime column and when you'd want to get data between two datetimes, or even one specific datetime, it would give you the results ultra-fast.