MariaDB 10.3

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version();


version()


10.3.27-MariaDB


create table ticks 
(SYMBOL varchar(50), `DATE` Date, PRICE int);
insert into ticks values
("AAPL","2021-02-21",10),
("TSLA","2021-02-21",800),
("AMZN","2021-02-21",90),
("AAPL","2021-02-20",17),
("TSLA","2021-02-20",900),
("AMZN","2021-02-20",105),
("AAPL","2021-02-19",5),
("TSLA","2021-02-19",960),
("AMZN","2021-02-19",80);
select distinct symbol, first_value(price) over w as first, last_value(price) over w as last
from ticks
window w as (partition by symbol order by date range between UNBOUNDED PRECEDING and UNBOUNDED FOLLOWING)
Numeric datatype is required for RANGE-type frame

select symbol, last - first as price_change
from (select distinct symbol, first_value(price) over w as first, last_value(price) over w as last
from ticks
window w as (partition by symbol order by date range between UNBOUNDED PRECEDING and UNBOUNDED FOLLOWING) ) as p
Numeric datatype is required for RANGE-type frame