Query editor
SELECTsymbol,COUNT_IF(price < 1) AS negative_deviations,COUNT_IF(price > 1) AS positive_deviations,AVG(1.00 - price) AS avg_deviation,MAX(CASE WHEN price > 1 THEN price - 1.00 ELSE 0 END) AS max_positive_deviation,MAX(CASE WHEN price < 1 THEN 1.00 - price ELSE 0 END) AS max_negative_deviationFROM "query_4284978(time='hour')" AS peg_statsGROUP BY 1