window functions over unbounded RANGE fails on not numeric type

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)