Parser Error: cannot copy window

Parser Error: cannot copy window "windowname" because it has a frame clause

While trying to create a moving average window over a number of days, I got the error "cannot copy window". e.g.

CREATE TABLE stocks AS SELECT * FROM read_parquet('https://www.timestored.com/data/sample/stocks/hive/pre=X/stocks_0.parquet');

SELECT date,close, 
        avg(close) OVER(threew) as three_day_average,
        list(close) OVER(threew) as three_day_list,
        list(close) OVER(ORDER BY date ASC ROWS BETWEEN 2 PRECEDING AND CURRENT ROW) as three_row_list,
        FROM (SELECT * FROM stocks WHERE SYM='XOM' AND date BETWEEN '2024-01-01' AND '2024-01-11')
        WINDOW threew AS (ORDER BY date ASC RANGE BETWEEN INTERVAL 2 DAYS  PRECEDING AND INTERVAL 0 DAYS FOLLOWING)
        ORDER BY date DESC;

Option 1 - Cast to ::STRING

To fix it change OVER(threew) to OVER threew.
i.e. The parenthesis should not be used.

SELECT date,close, 
        avg(close) OVER threew as three_day_average,
        list(close) OVER threew as three_day_list,
        list(close) OVER(ORDER BY date ASC ROWS BETWEEN 2 PRECEDING AND CURRENT ROW) as three_row_list,
        FROM stocks 
        WHERE SYM='XOM' AND date BETWEEN '2024-01-01' AND '2024-01-11'
        WINDOW threew AS (ORDER BY date ASC RANGE BETWEEN INTERVAL 2 DAYS  PRECEDING AND INTERVAL 0 DAYS FOLLOWING)
        ORDER BY date DESC;