Query editor
-- Realized Cap & MVRV (tx-weighted approximation, 90-gün pencere)-- bitcoin.transactions penceresini 90 güne kısıtlayarak timeout önlenir.-- Realized Price ≈ son 90 günlük tx hacmi ağırlıklı ortalama BTC fiyatı.WITHprice_daily AS (SELECT DATE_TRUNC('day', minute) AS day, AVG(price) AS priceFROM prices.usdWHERE symbol = 'BTC' AND blockchain IS NULLAND minute >= NOW() - INTERVAL '500' dayGROUP BY 1),cur AS (SELECT AVG(price) AS price FROM prices.usdWHERE symbol = 'BTC' AND blockchain IS NULLAND minute >= NOW() - INTERVAL '1' hour),-- 90 günlük coinbase-dışı işlem hacmi (kısa pencere = hız)tx_vol AS (SELECTDATE_TRUNC('day', block_time) AS day,SUM(CAST(output_value AS DOUBLE)) / 1e8 AS btc_volFROM bitcoin.transactionsWHERE is_coinbase = FALSEAND block_time >= NOW() - INTERVAL '90' dayGROUP BY 1),joined AS (SELECT p.day, p.price, COALESCE(v.btc_vol, 0) AS btc_volFROM price_daily pJOIN tx_vol v ON v.day = p.day),realized AS (SELECTSUM(btc_vol * price) / NULLIF(SUM(btc_vol), 0) AS realized_price,SUM(btc_vol) AS total_volFROM joinedWHERE btc_vol > 0)SELECTCURRENT_DATE AS date,(SELECT price FROM cur) AS current_price,ROUND((SELECT price FROM cur) * 19870000.0, 0) AS market_cap_usd,ROUND(r.realized_price * 19870000.0, 0) AS realized_cap_usd,ROUND(r.realized_price, 2) AS realized_price,ROUND((SELECT price FROM cur) * 19870000.0/ NULLIF(r.realized_price * 19870000.0, 0), 4) AS mvrv_ratio,ROUND(((SELECT price FROM cur) - r.realized_price)/ NULLIF(r.realized_price, 0) * 10, 4) AS mvrv_z_approx,ROUND(((SELECT price FROM cur) * 19870000.0 - r.realized_price * 19870000.0)/ NULLIF((SELECT price FROM cur) * 19870000.0, 0), 4) AS nuplFROM realized r