I am trying to create a line graph from data pulled using an API. The data returned from the api is of two columns; a date time in millis utc and a price. Currently the date time column is prices every 5 minutes but I want to aggregate the five minute prices into an average price over the hour.
When I try to group by and aggregate I get 3 options to aggregate on (exact, day, month). Is there a way to aggregate by the hour? I could try creating a new column from the api which pulls the hour from the date then aggregate by that column but I’m not sure if that’s possible or how I would do that.
Any help would be appreciated!