[SQL] Convert 1minutes interval data to 5min,15min,30min,1hour interval in oracle sql

• 
  I have a table which contains data of 1minute time interval of a stock.
  
  
• 
  I need to convert the data into 5min,15min,30min,1hour time intervals and group the columns.
  

I have no idea how to convert time intervals. Can anyone help me pls.

date open close
27-09-2024 15:25:00 352.85 352.75
27-09-2024 15:26:00 353 351.95
27-09-2024 15:27:00 353.5 352
27-09-2024 15:28:00 354 353

Continue reading...