Query editor
WITH iv_1w_history (AggregatedDate, IV_1w) AS (VALUES/* NOV 2025 */(DATE '2025-11-13', 53.2), (DATE '2025-11-14', 52.8), (DATE '2025-11-15', 51.0), (DATE '2025-11-16', 50.5), (DATE '2025-11-17', 49.2), (DATE '2025-11-18', 48.5), (DATE '2025-11-19', 49.8), (DATE '2025-11-20', 51.2), (DATE '2025-11-21', 54.0), (DATE '2025-11-22', 55.0), (DATE '2025-11-23', 57.2), (DATE '2025-11-24', 60.5), (DATE '2025-11-25', 60.2), (DATE '2025-11-26', 61.8), (DATE '2025-11-27', 63.2), (DATE '2025-11-28', 58.4), (DATE '2025-11-29', 57.5), (DATE '2025-11-30', 58.1),/* DEC 2025 */(DATE '2025-12-01', 55.2), (DATE '2025-12-02', 52.4), (DATE '2025-12-03', 53.1), (DATE '2025-12-04', 54.8), (DATE '2025-12-05', 55.1), (DATE '2025-12-06', 53.2), (DATE '2025-12-07', 51.0), (DATE '2025-12-08', 49.3), (DATE '2025-12-09', 48.5), (DATE '2025-12-10', 48.2), (DATE '2025-12-11', 44.2), (DATE '2025-12-12', 43.8), (DATE '2025-12-13', 44.5), (DATE '2025-12-14', 45.8), (DATE '2025-12-15', 45.3), (DATE '2025-12-16', 49.1), (DATE '2025-12-17', 53.2), (DATE '2025-12-18', 55.4), (DATE '2025-12-19', 57.8), (DATE '2025-12-20', 58.7), (DATE '2025-12-21', 56.5), (DATE '2025-12-22', 55.2), (DATE '2025-12-23', 54.1), (DATE '2025-12-24', 53.0), (DATE '2025-12-25', 52.1), (DATE '2025-12-26', 50.2), (DATE '2025-12-27', 49.5), (DATE '2025-12-28', 48.8), (DATE '2025-12-29', 47.5), (DATE '2025-12-30', 48.6), (DATE '2025-12-31', 48.6),/* JAN 2026 */(DATE '2026-01-01', 45.2), (DATE '2026-01-02', 43.1), (DATE '2026-01-03', 42.3), (DATE '2026-01-04', 41.8), (DATE '2026-01-05', 40.5), (DATE '2026-01-06', 39.2), (DATE '2026-01-07', 38.5), (DATE '2026-01-08', 38.2), (DATE '2026-01-09', 38.0), (DATE '2026-01-10', 38.5), (DATE '2026-01-11', 39.4), (DATE '2026-01-12', 40.1), (DATE '2026-01-13', 42.5), (DATE '2026-01-14', 44.8), (DATE '2026-01-15', 44.9), (DATE '2026-01-16', 44.9), (DATE '2026-01-17', 45.2), (DATE '2026-01-18', 44.8), (DATE '2026-01-19', 43.5), (DATE '2026-01-20', 42.1), (DATE '2026-01-21', 41.2), (DATE '2026-01-22', 40.5), (DATE '2026-01-23', 39.7), (DATE '2026-01-24', 39.1), (DATE '2026-01-25', 38.9), (DATE '2026-01-26', 38.5), (DATE '2026-01-27', 39.8), (DATE '2026-01-28', 41.2), (DATE '2026-01-29', 42.5), (DATE '2026-01-30', 44.5), (DATE '2026-01-31', 48.9),/* FEB 2026 - THE PANIC SPIKE */(DATE '2026-02-01', 53.2), (DATE '2026-02-02', 58.4), (DATE '2026-02-03', 65.4), (DATE '2026-02-04', 79.8), (DATE '2026-02-05', 92.1), (DATE '2026-02-06', 84.5), (DATE '2026-02-07', 72.3), (DATE '2026-02-08', 68.2), (DATE '2026-02-09', 64.2), (DATE '2026-02-10', 60.1), (DATE '2026-02-11', 60.8), (DATE '2026-02-12', 61.2), (DATE '2026-02-13', 60.5), (DATE '2026-02-14', 58.2), (DATE '2026-02-15', 57.2), (DATE '2026-02-16', 57.0), (DATE '2026-02-17', 56.8), (DATE '2026-02-18', 56.2), (DATE '2026-02-19', 55.4), (DATE '2026-02-20', 54.1), (DATE '2026-02-21', 53.5), (DATE '2026-02-22', 52.8), (DATE '2026-02-23', 51.5), (DATE '2026-02-24', 50.2), (DATE '2026-02-25', 49.1), (DATE '2026-02-26', 48.9), (DATE '2026-02-27', 49.5), (DATE '2026-02-28', 50.3),/* MAR 2026 */(DATE '2026-03-01', 52.1), (DATE '2026-03-02', 54.5), (DATE '2026-03-03', 56.4), (DATE '2026-03-04', 59.2), (DATE '2026-03-05', 62.1), (DATE '2026-03-06', 64.2), (DATE '2026-03-07', 66.5), (DATE '2026-03-08', 65.3), (DATE '2026-03-09', 67.8), (DATE '2026-03-10', 65.2), (DATE '2026-03-11', 60.4), (DATE '2026-03-12', 58.4), (DATE '2026-03-13', 61.2), (DATE '2026-03-14', 58.1), (DATE '2026-03-15', 61.2), (DATE '2026-03-16', 64.2), (DATE '2026-03-17', 62.8), (DATE '2026-03-18', 65.4), (DATE '2026-03-19', 68.4), (DATE '2026-03-20', 65.1), (DATE '2026-03-21', 62.4), (DATE '2026-03-22', 60.1), (DATE '2026-03-23', 58.9), (DATE '2026-03-24', 59.2), (DATE '2026-03-25', 57.5), (DATE '2026-03-26', 55.2), (DATE '2026-03-27', 54.2), (DATE '2026-03-28', 53.8), (DATE '2026-03-29', 55.2), (DATE '2026-03-30', 52.8), (DATE '2026-03-31', 51.4),/* APR 2026 */(DATE '2026-04-01', 49.8), (DATE '2026-04-02', 48.1), (DATE '2026-04-03', 48.3), (DATE '2026-04-04', 49.5), (DATE '2026-04-05', 51.0), (DATE '2026-04-06', 51.2), (DATE '2026-04-07', 52.1), (DATE '2026-04-08', 54.5), (DATE '2026-04-09', 53.2), (DATE '2026-04-10', 51.5), (DATE '2026-04-11', 49.2), (DATE '2026-04-12', 47.8), (DATE '2026-04-13', 46.5), (DATE '2026-04-14', 45.1), (DATE '2026-04-15', 44.2), (DATE '2026-04-16', 43.8), (DATE '2026-04-17', 51.4), (DATE '2026-04-18', 52.5), (DATE '2026-04-19', 51.5), (DATE '2026-04-20', 48.6), (DATE '2026-04-21', 47.9), (DATE '2026-04-22', 49.2), (DATE '2026-04-23', 53.2), (DATE '2026-04-24', 46.8), (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),/* MAY 2026 */(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.2), (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 >= DATE '2025-11-13'GROUP BY 1)SELECTiv.AggregatedDate,iv.IV_1w as iv_percent,p.btc_price as btc_price_usdFROM iv_1w_history ivJOIN btc_prices p ON iv.AggregatedDate = p.dayORDER BY iv.AggregatedDate ASC