SELECT * FROM Interpolator (
ON ibm_stock1 AS input_table
PARTITION BY id
ORDER BY "period"
TimeColumn ('period')
TimeInterval (86400)
ValueColumns ('stockprice')
InterpolationType ('loess[(weights(constant),degree(2),span(4))]')
Values_BeforeFirst ('0')
Values_AfterLast ('0')
Accumulate ('id')
);