Query editor
-- Pi Cycle Top — BTC 111MA vs 350MA×2-- Kaynak: prices.usd (Dune yerleşik fiyat tablosu)WITH daily_btc AS (SELECTDATE_TRUNC('day', minute) AS day,AVG(price) AS priceFROM prices.usdWHERE symbol = 'BTC'AND blockchain IS NULLAND minute >= NOW() - INTERVAL '500' dayGROUP BY 1)SELECTday AS date,price,AVG(price) OVER (ORDER BY day ROWS BETWEEN 110 PRECEDING AND CURRENT ROW) AS ma_111,AVG(price) OVER (ORDER BY day ROWS BETWEEN 349 PRECEDING AND CURRENT ROW) AS ma_350,AVG(price) OVER (ORDER BY day ROWS BETWEEN 349 PRECEDING AND CURRENT ROW) * 2 AS ma_350x2FROM daily_btcORDER BY day