MySQL 8.0

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

CREATE TABLE `heikin_ashi_temp` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `timestamp` datetime DEFAULT NULL,
  `open` float DEFAULT NULL,
  `high` float DEFAULT NULL,
  `low` float DEFAULT NULL,
  `close` float DEFAULT NULL,
  `ha_open` float DEFAULT NULL,
  `ha_high` float DEFAULT NULL,
  `ha_low` float DEFAULT NULL,
  `ha_close` float DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=104 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

INSERT INTO `heikin_ashi_temp`
(`id`,
`timestamp`,
`open`,
`high`,
`low`,
`close`,
`ha_open`,
`ha_high`,
`ha_low`,
`ha_close`)
VALUES
(1,'2020-01-14 13:24:59',12361.2,12363,12358.5,12360.2,NULL,NULL,NULL,NULL),
(2,'2020-01-14 13:29:59',12360.2,12362,12355,12355.1,NULL,NULL,NULL,NULL),
(3,'2020-01-14 13:34:59',12355.1,12358.5,12351,12357,NULL,NULL,NULL,NULL),
(4,'2020-01-14 13:39:59',12357,12360,12354.1,12359.3,NULL,NULL,NULL,NULL),
(5,'2020-01-14 13:44:59',12359.3,12364.2,12356.9,12358.2,NULL,NULL,NULL,NULL),
(6,'2020-01-14 13:49:59',12358.2,12360,12354,12358.7,NULL,NULL,NULL,NULL),
(7,'2020-01-14 13:54:59',12358.7,12359,12354.2,12357.1,NULL,NULL,NULL,NULL),
(8,'2020-01-14 13:59:59',12357.1,12357.5,12349.5,12350.6,NULL,NULL,NULL,NULL),
(9,'2020-01-14 14:04:59',12350.4,12356,12349,12352,NULL,NULL,NULL,NULL),
(10,'2020-01-14 14:09:59',12352,12355.5,12351.1,12353.2,NULL,NULL,NULL,NULL);

SELECT * FROM heikin_ashi_temp;

id	timestamp	open	high	low	close	ha_open	ha_high	ha_low	ha_close
1	2020-01-14 13:24:59	12361.2	12363	12358.5	12360.2	null	null	null	null
2	2020-01-14 13:29:59	12360.2	12362	12355	12355.1	null	null	null	null
3	2020-01-14 13:34:59	12355.1	12358.5	12351	12357	null	null	null	null
4	2020-01-14 13:39:59	12357	12360	12354.1	12359.3	null	null	null	null
5	2020-01-14 13:44:59	12359.3	12364.2	12356.9	12358.2	null	null	null	null
6	2020-01-14 13:49:59	12358.2	12360	12354	12358.7	null	null	null	null
7	2020-01-14 13:54:59	12358.7	12359	12354.2	12357.1	null	null	null	null
8	2020-01-14 13:59:59	12357.1	12357.5	12349.5	12350.6	null	null	null	null
9	2020-01-14 14:04:59	12350.4	12356	12349	12352	null	null	null	null
10	2020-01-14 14:09:59	12352	12355.5	12351.1	12353.2	null	null	null	null

id	timestamp	open	high	low	close	ha_open	ha_high	ha_low	ha_close
1	2020-01-14 13:24:59	12361.2	12363	12358.5	12360.2	12357.3	12363	12357.3	12360.7
2	2020-01-14 13:29:59	12360.2	12362	12355	12355.1	12356.6	12362	12356.6	12358.1
3	2020-01-14 13:34:59	12355.1	12358.5	12351	12357	12357.8	12358.5	12355.4	12355.4
4	2020-01-14 13:39:59	12357	12360	12354.1	12359.3	12358	12360	12357.6	12357.6
5	2020-01-14 13:44:59	12359.3	12364.2	12356.9	12358.2	12356.4	12364.2	12356.4	12359.7
6	2020-01-14 13:49:59	12358.2	12360	12354	12358.7	12355.1	12360	12355.1	12357.7
7	2020-01-14 13:54:59	12358.7	12359	12354.2	12357.1	12352.9	12359	12352.9	12357.2
8	2020-01-14 13:59:59	12357.1	12357.5	12349.5	12350.6	12352.2	12357.5	12352.2	12353.7
9	2020-01-14 14:04:59	12350.4	12356	12349	12352	12352.5	12356	12351.8	12351.8
10	2020-01-14 14:09:59	12352	12355.5	12351.1	12353.2	12352	12355.5	12352	12353