Query editor
WITH iv_60d_history (AggregatedDate, IV_1w) AS (VALUES-- Sampled data points for the last 60 days to provide context for the scaling math(DATE '2026-03-12', 58.1), (DATE '2026-03-19', 68.4), (DATE '2026-03-26', 55.2), (DATE '2026-04-02', 48.1),(DATE '2026-04-09', 53.2), (DATE '2026-04-16', 43.8), (DATE '2026-04-23', 53.2),-- DAILY DATA (Focus on the most recent 20 days for the 15-day "Zoom")(DATE '2026-04-25', 45.5), (DATE '2026-04-26', 47.5), (DATE '2026-04-27', 46.2), (DATE '2026-04-28', 45.1),(DATE '2026-04-29', 44.1), (DATE '2026-04-30', 43.1), (DATE '2026-05-01', 41.5), (DATE '2026-05-02', 40.8),(DATE '2026-05-03', 39.5), (DATE '2026-05-04', 38.8), (DATE '2026-05-05', 38.2), (DATE '2026-05-06', 37.9),(DATE '2026-05-07', 39.8), (DATE '2026-05-08', 38.28), (DATE '2026-05-09', 39.5), (DATE '2026-05-10', 40.1),(DATE '2026-05-11', 41.53)),btc_prices AS (SELECTDATE_TRUNC('day', minute) as day,AVG(price) as btc_priceFROM prices.usdWHERE symbol = 'BTC'AND blockchain IS NULLAND minute >= CURRENT_DATE - INTERVAL '15' DAYGROUP BY 1),stats AS (-- This calculates min/max ONLY for the 15-day window so lines use the full chart heightSELECTMIN(iv.IV_1w) as min_iv, MAX(iv.IV_1w) as max_iv,MIN(p.btc_price) as min_price, MAX(p.btc_price) as max_priceFROM iv_60d_history ivJOIN btc_prices p ON iv.AggregatedDate = p.dayWHERE iv.AggregatedDate >= CURRENT_DATE - INTERVAL '15' DAY)SELECTiv.AggregatedDate,-- Visual Columns (Scaled 0-100 for the lines)(iv.IV_1w - s.min_iv) / NULLIF(s.max_iv - s.min_iv, 0) * 100 as scaled_iv_line,(p.btc_price - s.min_price) / NULLIF(s.max_price - s.min_price, 0) * 100 as scaled_price_line,-- Exact values for Hover Tooltipsiv.IV_1w as raw_iv_percent,p.btc_price as raw_price_usdFROM iv_60d_history ivJOIN btc_prices p ON iv.AggregatedDate = p.dayCROSS JOIN stats sWHERE iv.AggregatedDate >= CURRENT_DATE - INTERVAL '15' DAYORDER BY iv.AggregatedDate ASC