Query editor
WITHBTC AS (SELECTDATE_TRUNC('day', "minute") AS day,AVG("price") AS BTC_PriceFROMprices.usdWHEREcontract_address is null and symbol='BTC'AND DATE_TRUNC('day', "minute") >= CURRENT_TIMESTAMP - INTERVAL '750' dayGROUP BY1),Delta AS (SELECTday,BTC_Price,lag(BTC_price,1) over (order by day) as lag_priceFROM BTCGROUP BY 1,2ORDER BY 1),R_stat as (select day,BTC_Price,lag_price,power(ln(BTC_Price)-ln(lag_price),2) as R_pricefrom Deltaorder by day),RV as (select day,BTC_Price,R_price,sum(R_price) over (order by day rows between 29 preceding and current row) as Varfrom R_statorder by day)select day,BTC_Price,sqrt((365/30)*Var) as Realized_Volfrom RVwhere day >= CURRENT_TIMESTAMP - INTERVAL '720' dayorder by day