esper 附录A
A2 select irstream symbol, volume, price from MarketDate.win.time(5.5 sec) select irstream symbol, volume, price from MarketDate.win.time(5.5 sec) output every 1 seconds select irstream symbol, volume, price from MarketDate.win.time(5.5 sec) output last every 1 seconds select irstream symbol, volume, price from MarketDate.win.time(5.5 sec) output first every 1 seconds select irstream symbol, volume, price from MarketDate.win.time(5.5 sec) output snapshot every 1 seconds A3 select irstream sum(price) from MarketDate.win.time(5.5 sec) select irstream sum(price) from MarketDate.win.time(5.5 sec) output every 1 seconds select irstream sum(price) from MarketDate.win.time(5.5 sec) output last every 1 seconds select irstream sum(price) from MarketDate.win.time(5.5 sec) output first every 1 seconds select irstream sum(price) from MarketDate.win.time(5.5 sec) output snapshot every 1 seconds A4 select irstream symbol, sum(price) from MarketDate.win.time(5.5 sec) select irstream symbol, sum(price) from MarketDate.win.time(5.5 sec) output every 1 seconds select irstream symbol, sum(price) from MarketDate.win.time(5.5 sec) output last every 1 seconds select irstream symbol, sum(price) from MarketDate.win.time(5.5 sec) output first every 1 seconds select irstream symbol, sum(price) from MarketDate.win.time(5.5 sec) output snapshot every 1 seconds A5 select irstream symbol, sum(price) from MarketDate.win.time(5.5 sec) group by symbol order by symbol select irstream symbol, sum(price) from MarketDate.win.time(5.5 sec) group by symbol output every 1 seconds select irstream symbol, sum(price) from MarketDate.win.time(5.5 sec) group by symbol output all every 1 seconds order by symbol select irstream symbol, sum(price) from MarketDate.win.time(5.5 sec) group by symbol output last every 1 seconds order by symbol select irstream symbol, sum(price) from MarketDate.win.time(5.5 sec) group by symbol output first every 1 seconds select irstream symbol, sum(price) from MarketDate.win.time(5.5 sec) group by symbol output snapshot every 1 seconds order by symbol A6 select irstream symbol, volume, sum(price) from MarketDate.win.time(5.5 sec) group by symbol select irstream symbol, volume, sum(price) from MarketDate.win.time(5.5 sec) group by symbol output every 1 seconds select irstream symbol, volume, sum(price) from MarketDate.win.time(5.5 sec) group by symbol output all every 1 seconds order by symbol select irstream symbol, volume, sum(price) from MarketDate.win.time(5.5 sec) group by symbol output last every 1 seconds order by symbol select irstream symbol, volume, sum(price) from MarketDate.win.time(5.5 sec) group by symbol output first every 1 seconds select irstream symbol, volume, sum(price) from MarketDate.win.time(5.5 sec) group by symbol output snapshot every 1 seconds A7 select irstream symbol, volume, sum(price) from MarketDate.win.time(5.5 sec) group by rollup(symbol) select irstream symbol, volume, sum(price) from MarketDate.win.time(5.5 sec) group by rollup(symbol) output every 1 seconds select irstream symbol, volume, sum(price) from MarketDate.win.time(5.5 sec) group by rollup(symbol) output all every 1 seconds select irstream symbol, volume, sum(price) from MarketDate.win.time(5.5 sec) group by rollup(symbol) output last every 1 seconds select irstream symbol, volume, sum(price) from MarketDate.win.time(5.5 sec) group by rollup(symbol) output first every 1 seconds select irstream symbol, volume, sum(price) from MarketDate.win.time(5.5 sec) group by rollup(symbol) output snapshot every 1 seconds
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步