How can I group a timetable in hours 0-24h

Hi,

I have a timetable with tick data of FX rates on a minutely basis.

The timetable is 527040 x 4

Starting from the 01.01.2018 until 01.01.2019

I want to investegate the behaviour of every hour.

So i want the mean of all prices from 00-01 and so on until 23-24.

any ideas?

Answer 1

[Steven Lord]

See the "Aggregate Timetable Data and Calculate Mean Values" example on the retime documentation page. While that uses a duration array as the RowTimes for the timetable you can do the same using a timetable with datetime RowTimes as well.

[Antonio Melieni]

what I needed was hour = hour(timetable.Time);

[Peter Perkins]

Antonio, I think what you needed was

TThourly = retime(TTminutely,'hourly','mean')

but perhaps that's what you meant.