Query editor
WITH peg_stability AS (SELECTDATE_TRUNC('{{time}}', minute) AS day,symbol,AVG(price) AS price,STDDEV(price) AS volatility,AVG(ABS(1.00 - price)) AS depeg_magnitudeFROM prices.usdWHEREcontract_address IN (-- ethereum0xc5f0f7b66764F6ec8C8Dff7BA683102295E16409, -- FDUSD, also the same on bnb chain0xdac17f958d2ee523a2206206994597c13d831ec7, -- USDT0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48, -- USDC0x4c9edd5852cd905f086c759e8383e09bff1e68b3, -- USDe-- bnb chain0x55d398326f99059fF775485246999027B3197955, -- USDT0x8AC76a51cc950d9822D68b83fE1Ad97B32Cd580d -- USDC)AND blockchain IN ('ethereum', 'bnb')AND minute > TIMESTAMP '2023-04-28 11:15:10 UTC'GROUP BY 1, 2)SELECT * FROM peg_stability-- WHERE volatility < 0.1-- WHERE day > TIMESTAMP '2024-02-28 23:59:59 UTC'