WITH moving_avg AS (

SELECT

date_trunc('day', hour) as date,

AVG(price) as AVGPrice,

AVG(AVGPrice) OVER (ORDER BY date ROWS BETWEEN 19 PRECEDING AND CURRENT ROW) AS MA_20

FROM

aptos.price.ez_prices_hourly

WHERE TOKEN_ADDRESS ilike '{{Token_Address}}'

group by 1

),

std_dev AS (

SELECT

date,

AVGPrice,

MA_20,

STDDEV(AVGPrice) OVER (ORDER BY date ROWS BETWEEN 19 PRECEDING AND CURRENT ROW) AS stddev_20

FROM

moving_avg

SELECT

date,

AVGPrice,

MA_20,

MA_20 + (2 * stddev_20) AS upper_band,

MA_20 - (2 * stddev_20) AS lower_band

FROM

std_dev;