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.