daily_big3 = {
aq.addFunction(
'parse_ts',
ts => {
const date = new Date(ts);
const year = date.getUTCFullYear();
const month = date.getUTCMonth();
const day = date.getUTCDate();
const hour = date.getUTCHours();
return op.datetime(year, month, day, hour);
},
{
override: true
}
);
var raw = await aq.loadArrow(
await FileAttachment('daily_big3_20210514.arrow').url(),
{ autoType: true }
);
raw = raw.derive({ date: d => op.parse_ts(d.date) }, { before: 'trips' });
return raw;
}