timeseries.sql

declare timeseries by30min(){
    from Temp 
        between '2020-01-01' and '2020-04-01'
    group by 30m 
    select avg()
}
declare function fill_missing_range(d){
    
    for(var i = 0; i< d.Results.length-1;i++ ){
        if( new Date(d.Results[i].To).toISOString() >= 
            new Date(d.Results[i+1].From).toISOString())
            continue;
        var cur = new Date(d.Results[i].From);
        d.Results.splice(i+1, 0, {
            From: new Date(cur.getTime() + 30*60000).toISOString(),
            To: new Date(cur.getTime() + 60*60000).toISOString(),
            Count: d.Results[i].Count,
            Average: d.Results[i].Average
        });
    }
    
    return d;
}
from Containers where id() = 'containers/123918-A'
select fill_missing_range(by30min())