MySQL 8.0

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

create table temp_data (rownum int auto_increment primary key,
last_price decimal (10,2))
insert into temp_data (last_price) values
(10.2),
(11.6),
(13.9),
(14.3),
(16.2),
(18.1),
(14.5),
(16.1)
SET @psmall = 2;
SET @pmedium = 5;
SET @sql = '
SELECT rownum,
       AVG(last_price) OVER (ORDER BY rownum ROWS BETWEEN ? PRECEDING AND CURRENT ROW) AS ma_small_price,
       AVG(last_price) OVER (ORDER BY rownum ROWS BETWEEN ? PRECEDING AND CURRENT ROW) AS ma_medium_price
FROM temp_data'
PREPARE stmt FROM @sql
EXECUTE stmt USING @psmall, @pmedium


rownum
ma_small_price
ma_medium_price


1
10.200000
10.200000

2
10.900000
10.900000

3
11.900000
11.900000

4
13.266667
12.500000

5
14.800000
13.240000

6
16.200000
14.050000

7
16.266667
14.766667

8
16.233333
15.516667

rownum	ma_small_price	ma_medium_price
1	10.200000	10.200000
2	10.900000	10.900000
3	11.900000	11.900000
4	13.266667	12.500000
5	14.800000	13.240000
6	16.200000	14.050000
7	16.266667	14.766667
8	16.233333	15.516667