CREATE CONTINUOUS QUERY "1h_avg_rate"  ON backend BEGIN SELECT mean(value) INTO backend."1h_avg".:MEASUREMENT FROM /Rate$/ GROUP BY time(1h) FILL(0) END
CREATE CONTINUOUS QUERY "1h_avg_time"  ON backend BEGIN SELECT mean(value) INTO backend."1h_avg".:MEASUREMENT FROM /Time$/ GROUP BY time(1h) FILL(null) END
CREATE CONTINUOUS QUERY "1h_avg_gauge" ON backend BEGIN SELECT mean(value) INTO backend."1h_avg".:MEASUREMENT FROM /Gauge$/ GROUP BY time(1h) FILL(previous) END

CREATE CONTINUOUS QUERY "1h_min_rate" ON backend BEGIN SELECT mean(value) INTO backend."1h_min".:MEASUREMENT FROM /Rate$/ GROUP BY time(1h) FILL(0) END
CREATE CONTINUOUS QUERY "1h_min_time" ON backend BEGIN SELECT mean(value) INTO backend."1h_min".:MEASUREMENT FROM /Time$/ GROUP BY time(1h) FILL(null) END
CREATE CONTINUOUS QUERY "1h_min_gauge" ON backend BEGIN SELECT mean(value) INTO backend."1h_min".:MEASUREMENT FROM /Gauge$/ GROUP BY time(1h) FILL(previous) END

CREATE CONTINUOUS QUERY "1h_max_rate" ON backend BEGIN SELECT mean(value) INTO backend."1h_max".:MEASUREMENT FROM /Rate$/ GROUP BY time(1h) FILL(0) END
CREATE CONTINUOUS QUERY "1h_max_time" ON backend BEGIN SELECT mean(value) INTO backend."1h_max".:MEASUREMENT FROM /Time$/ GROUP BY time(1h) FILL(null) END
CREATE CONTINUOUS QUERY "1h_max_gauge" ON backend BEGIN SELECT mean(value) INTO backend."1h_max".:MEASUREMENT FROM /Gauge$/ GROUP BY time(1h) FILL(previous) END

CREATE CONTINUOUS QUERY "1d_avg_rate" ON backend BEGIN SELECT mean(value) INTO backend."1d_avg".:MEASUREMENT FROM /Rate$/ GROUP BY time(1d) FILL(0) END
CREATE CONTINUOUS QUERY "1d_avg_time" ON backend BEGIN SELECT mean(value) INTO backend."1d_avg".:MEASUREMENT FROM /Time$/ GROUP BY time(1d) FILL(null) END
CREATE CONTINUOUS QUERY "1d_avg_gauge" ON backend BEGIN SELECT mean(value) INTO backend."1d_avg".:MEASUREMENT FROM /Gauge$/ GROUP BY time(1d) FILL(previous) END

CREATE CONTINUOUS QUERY "1d_min_rate" ON backend BEGIN SELECT mean(value) INTO backend."1d_min".:MEASUREMENT FROM /Rate$/ GROUP BY time(1d) FILL(0) END
CREATE CONTINUOUS QUERY "1d_min_time" ON backend BEGIN SELECT mean(value) INTO backend."1d_min".:MEASUREMENT FROM /Time$/ GROUP BY time(1d) FILL(null) END
CREATE CONTINUOUS QUERY "1d_min_gauge" ON backend BEGIN SELECT mean(value) INTO backend."1d_min".:MEASUREMENT FROM /Gauge$/ GROUP BY time(1d) FILL(previous) END

CREATE CONTINUOUS QUERY "1d_max_rate" ON backend BEGIN SELECT mean(value) INTO backend."1d_max".:MEASUREMENT FROM /Rate$/ GROUP BY time(1d) FILL(0) END
CREATE CONTINUOUS QUERY "1d_max_time" ON backend BEGIN SELECT mean(value) INTO backend."1d_max".:MEASUREMENT FROM /Time$/ GROUP BY time(1d) FILL(null) END
CREATE CONTINUOUS QUERY "1d_max_gauge" ON backend BEGIN SELECT mean(value) INTO backend."1d_max".:MEASUREMENT FROM /Gauge$/ GROUP BY time(1d) FILL(previous) END