SELECT id, prom.date('2024-11-28').avg().sigma() FROM /test/bucketpromdb /** output() match(id, "bucketpromdb:wecise11", "prom.0.2", 2.661111111111112, "prom.0.5", 0.16034299655179796) match(id, "bucketpromdb:wecise", "prom.0.2", 2.663157894736843, "prom.0.5", 0.15630781478860528~0.1563078147886053) **/ ;