Query editor
-- VDD Multiple — Coin Days Destroyed / 90-gün ortalama CDD-- 365-gün aralık community plan'da timeout alır; 90-gün MA kullanılır.-- CDD = value_btc * age_days_of_utxo (harcandığında)WITHcdd_daily AS (SELECTDATE_TRUNC('day', i.block_time) AS date,SUM(CAST(o.value AS DOUBLE) / 1e8 *GREATEST(date_diff('day', o.block_time, i.block_time), 0)) AS cdd,SUM(CAST(o.value AS DOUBLE) / 1e8) AS btc_movedFROM bitcoin.inputs iJOIN bitcoin.outputs oON i.spent_tx_id = o.tx_idAND i.spent_output_number = o.indexWHERE i.block_date >= current_date - INTERVAL '90' dayAND o.value > 0GROUP BY 1),cdd_with_avg AS (SELECTc.date,c.cdd,c.btc_moved,AVG(c.cdd) OVER (ORDER BY c.dateROWS BETWEEN 89 PRECEDING AND CURRENT ROW) AS cdd_90maFROM cdd_daily c)SELECTdate,ROUND(cdd, 2) AS cdd,ROUND(cdd / NULLIF(cdd_90ma, 0), 4) AS vdd_multiple,ROUND(cdd_90ma, 2) AS cdd_365maFROM cdd_with_avgORDER BY date