拼接一个常量列后,利用 pivot by 即可实现,如:
syms=`600300`600400`600500$SYMBOL
sym=syms[0 1 2]
time=09:40:00+1 30 65
price=172.12 170.32 172.25
volume=100 * 10 3 7 8 25 6 10 4 5 1 2 8 6 10 2 2 5 5 4 4 3
t1=table(sym, price );
t1;
addColumn(t1, 'sample', 1)
select price from t1 pivot by sample,sym
output:
sample 600300 600400 600500
------ ------------------- ------------------- ------
172.120000000000004 170.319999999999993 172.25