MySQL 8.0

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

CREATE TABLE t_1min (
    ID integer,
    dt datetime,
    YRWK integer,
    O decimal(10,2),
    C decimal(10,2) ,
    S integer
   )
INSERT INTO `t_1min` (`ID`, `DT`, `YRWK`, `O`, `C`, `S`) VALUES (124, '2005-09-06 18:16:00', 200536, 1138.50, 1138.50, 3);
INSERT INTO `t_1min` (`ID`, `DT`, `YRWK`, `O`, `C`, `S`) VALUES (216, '2005-09-06 21:25:00', 200536, 1137.75, 1138.00, 3);
INSERT INTO `t_1min` (`ID`, `DT`, `YRWK`, `O`, `C`, `S`) VALUES (230, '2005-09-06 21:53:00', 200536, 1137.50, 1137.50, 1);
INSERT INTO `t_1min` (`ID`, `DT`, `YRWK`, `O`, `C`, `S`) VALUES (290, '2005-09-07 00:20:00', 200536, 1138.25, 1138.50, 3);
INSERT INTO `t_1min` (`ID`, `DT`, `YRWK`, `O`, `C`, `S`) VALUES (299, '2005-09-07 00:32:00', 200536, 1138.25, 1138.25, 1);
INSERT INTO `t_1min` (`ID`, `DT`, `YRWK`, `O`, `C`, `S`) VALUES (315, '2005-09-07 01:02:00', 200536, 1138.50, 1138.50, 3);
INSERT INTO `t_1min` (`ID`, `DT`, `YRWK`, `O`, `C`, `S`) VALUES (318, '2005-09-07 01:05:00', 200536, 1138.50, 1138.25, 1);
INSERT INTO `t_1min` (`ID`, `DT`, `YRWK`, `O`, `C`, `S`) VALUES (320, '2005-09-07 01:07:00', 200536, 1138.00, 1137.75, 1);
INSERT INTO `t_1min` (`ID`, `DT`, `YRWK`, `O`, `C`, `S`) VALUES (322, '2005-09-07 01:09:00', 200536, 1138.00, 1137.75, 1);
INSERT INTO `t_1min` (`ID`, `DT`, `YRWK`, `O`, `C`, `S`) VALUES (325, '2005-09-07 01:12:00', 200536, 1138.25, 1138.25, 3);
with cte as (
    select
          (select id from t_1min AS cls where cls.dt > opn.dt and cls.s = 1 and opn.s = 3 order by cls.dt limit 1) c_id
         , opn.id as o_id
    from t_1min AS opn
)
select * from cte


c_id
o_id


230
124

230
216

null
230

299
290

null
299

318
315

null
318

null
320

null
322

null
325


with cte as (
    select
          (select id from t_1min AS cls where cls.dt > opn.dt and cls.s = 1 and opn.s = 3 order by cls.dt limit 1) c_id
         , opn.id as o_id
    from t_1min AS opn
)

select
       cte.c_id,cte.o_id, clv.c, opv.o
     , date_format(clv.dt,'%Y-%m-%d %H:%i:%s') c_dt
     , date_format(opv.dt,'%Y-%m-%d %H:%i:%s') o_dt
from cte
inner join t_1min AS clv on cte.c_id = clv.id
inner join t_1min AS opv on cte.o_id = opv.id



c_id
o_id
c
o
c_dt
o_dt


230
124
1137.50
1138.50
2005-09-06 21:53:00
2005-09-06 18:16:00

230
216
1137.50
1137.75
2005-09-06 21:53:00
2005-09-06 21:25:00

299
290
1138.25
1138.25
2005-09-07 00:32:00
2005-09-07 00:20:00

318
315
1138.25
1138.50
2005-09-07 01:05:00
2005-09-07 01:02:00


with cte as (
    select
          (select id from t_1min AS cls where cls.dt > opn.dt and cls.s = 1 and opn.s = 3 order by cls.dt limit 1) c_id
         , opn.id as o_id
    from t_1min AS opn
)

select avg(c-o) avg_co
from (
    select
        cte.c_id,cte.o_id, clv.c, opv.o, clv.dt c_dt, opv.dt o_dt
    from cte
    inner join t_1min AS clv on cte.c_id = clv.id
    inner join t_1min AS opv on cte.o_id = opv.id
    ) AS d


avg_co


-0.375000


select avg(c-o) avg_co
from (
    select
        cte.c_id,cte.o_id, clv.c, opv.o, clv.dt c_dt, opv.dt o_dt
    from (
          select
                (select id from t_1min AS cls where cls.dt > opn.dt and cls.s = 1 and opn.s = 3 order by cls.dt limit 1) c_id
               , opn.id as o_id
          from t_1min AS opn
          ) as cte
    inner join t_1min AS clv on cte.c_id = clv.id
    inner join t_1min AS opv on cte.o_id = opv.id
    ) AS d


avg_co


-0.375000

c_id	o_id
230	124
230	216
null	230
299	290
null	299
318	315
null	318
null	320
null	322
null	325

c_id	o_id	c	o	c_dt	o_dt
230	124	1137.50	1138.50	2005-09-06 21:53:00	2005-09-06 18:16:00
230	216	1137.50	1137.75	2005-09-06 21:53:00	2005-09-06 21:25:00
299	290	1138.25	1138.25	2005-09-07 00:32:00	2005-09-07 00:20:00
318	315	1138.25	1138.50	2005-09-07 01:05:00	2005-09-07 01:02:00