Query editor
-- DuneSQL: Volatilidad Intradiaria y Riesgo de Flash CrashWITH hourly_prices AS (SELECTdate_trunc('hour', minute) AS hour,symbol,MAX(price) AS high_price,MIN(price) AS low_price,AVG(price) AS avg_priceFROM prices.usdWHEREsymbol IN ('wstETH', 'USDe', 'cbETH') -- Tokens de ejemplo en SymbioticAND minute >= current_date - interval '7' dayAND blockchain = 'ethereum'GROUP BY 1, 2)SELECThour,symbol,avg_price,((high_price - low_price) / low_price) * 100 AS intraday_volatility_pctFROM hourly_pricesWHERE ((high_price - low_price) / low_price) * 100 > 1.0 -- Filtramos horas con más de 1% de volatilidadORDER BY hour DESC