date_trunc('day', hour) as date,

symbol,

AVG(price) as "AVG $ZBU Price",

AVG(AVG(price)) OVER (ORDER BY date_trunc('day', hour) ROWS BETWEEN 6 PRECEDING AND CURRENT ROW) AS "$ZBU 7-days MA",

AVG(AVG(price)) OVER (ORDER BY date_trunc('day', hour) ROWS BETWEEN 19 PRECEDING AND CURRENT ROW) AS "$ZBU 20-days MA",

AVG(AVG(price)) OVER (ORDER BY date_trunc('day', hour) ROWS BETWEEN 49 PRECEDING AND CURRENT ROW) AS "$ZBU 50-days MA"

FROM bsc.price.ez_prices_hourly

WHERE token_address = '0x4d3dc895a9edb234dfa3e303a196c009dc918f84'

GROUP BY 1, 2