代码可以参考如下,可以使用interval函数
timer t1 = select last(prc_last) as prc_last from loadTable(dbName, tbName)
where datehour(trd_ts) <= datehour(d), datehour(trd_ts) > temporalAdd(datehour(d),-7*7, 'h') group by bbg_tkr, interval(trd_dt64, 1H,'prev') order by bbg_tkr
//Time elapsed: 224.23 ms