Query editor
WITH price_avg AS (SELECTDATE_TRUNC('day', minute) AS day,AVG(price) AS priceFROM prices.usdWHERE1 = 1 AND symbol = 'EUL' AND minute >= CURRENT_TIMESTAMP - INTERVAL '1' yearGROUP BY1)SELECTprc.day,prc.price,AVG(prc.price) OVER (ORDER BY prc.day ROWS BETWEEN 29 PRECEDING AND CURRENT ROW) AS ma_30,AVG(prc.price) OVER (ORDER BY prc.day ROWS BETWEEN 59 PRECEDING AND CURRENT ROW) AS ma_60,AVG(prc.price) OVER (ORDER BY prc.day ROWS BETWEEN 89 PRECEDING AND CURRENT ROW) AS ma_90,(SELECTpriceFROM price_avgORDER BYday DESCLIMIT 1) AS last_priceFROM price_avg AS prcORDER BYprc.day DESC