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