github.com/rohankumardubey/aresdb@v0.0.2-0.20190517170215-e54e3ca06b9c/examples/1k_trips/queries/total_trips.sql

{
  "queries": ["SELECT count(*) AS value FROM trips WHERE status='completed' AND aql_time_filter(request_at, \"24 hours ago\", \"this quarter-hour\", America/New_York) GROUP BY aql_time_bucket_hour(request_at, \"\", America/New_York)"]
}