Query editor
sELECTday,price,AVG(price) OVER (ORDER BY day ROWS BETWEEN 29 PRECEDING AND CURRENT ROW) AS ma_30,AVG(price) OVER (ORDER BY day ROWS BETWEEN 89 PRECEDING AND CURRENT ROW) AS ma_90,AVG(price) OVER (ORDER BY day ROWS BETWEEN 199 PRECEDING AND CURRENT ROW) AS ma_200FROM(selectdate_trunc('day', minute) AS day,AVG(price) AS priceFROM prices.usdWHERE contract_address is null and symbol = 'SOL'and minute>=now() - interval '5' yearGROUP BY 1) a