MySQL 5.7

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table ticks (timeInMilliseconds int, price decimal(10,2))
insert into ticks values
(60005, 10.2),
(60025, 10.4),
(60035, 10.6),
(60045, 10.5),
(120105, 10.3),
(120119, 10.4),
(120120, 10.5),
(180125, 10.1),
(180127, 10.3),
(180129, 9.9),
(180153, 10.0)

Records: 11  Duplicates: 0  Warnings: 0


SELECT MIN(timeInMilliseconds) AS min_time,
             MAX(timeInMilliseconds) AS max_time,
             MIN(price) as low,
             MAX(price) as high,
             FLOOR(timeInMilliseconds/(1000*60)) as open_time
      FROM ticks
      GROUP BY open_time


min_time
max_time
low
high
open_time


60005
60045
10.20
10.60
1

120105
120120
10.30
10.50
2

180125
180153
9.90
10.30
3


SELECT t1.price AS open,
       m.high,
       m.low,
       t2.price as close,
       open_time
FROM (SELECT MIN(timeInMilliseconds) AS min_time,
             MAX(timeInMilliseconds) AS max_time,
             MIN(price) as low,
             MAX(price) as high,
             FLOOR(timeInMilliseconds/(1000*60)) as open_time
      FROM ticks
      GROUP BY open_time) m
JOIN ticks t1 ON t1.timeInMilliseconds = min_time
JOIN ticks t2 ON t2.timeInMilliseconds = max_time


open
high
low
close
open_time


10.20
10.60
10.20
10.50
1

10.30
10.50
10.30
10.50
2

10.10
10.30
9.90
10.00
3

min_time	max_time	low	high	open_time
60005	60045	10.20	10.60	1
120105	120120	10.30	10.50	2
180125	180153	9.90	10.30	3