您可以使用 interval 函数代替 bar 来做时间间隔的聚合。interval() 的函数说明链接: interval — DolphinDB 2.0 documentation
我写了一个简单的例子,可以运行一下看看 bar 和 interval 效果的区别。
col1 = 2021.01.01T01:00:01.001 2021.01.01T01:00:01.002 2021.01.01T01:00:03.001 2021.01.01T01:00:03.002 2021.01.01T01:00:04.001 2021.01.01T01:00:04.002 2021.01.01T01:00:05.001 2021.01.01T01:00:05.002 2021.01.01T01:00:06.001 2021.01.01T01:00:06.002
col2 = rand(1.0, 10)
tb = table(col1 as time, col2 as price)
tb2 = select avg(price) from tb group by bar(time, 1s, "right") as minu
tb3 = select avg(price) from tb group by interval(time, 1s, "prev") as minu