Cube.js 时间范围最佳实践

我有一个表格，其中包含日期范围内的商品价格。在cube.js 中对此进行建模以允许时间维度查询（例如随时间变化的价格或商品的平均价格）的最佳方法是什么？

Thanks!

该表看起来像：

CREATE pricing test_timestamp (
    id INT AUTO_INCREMENT PRIMARY KEY,
    itemId VARCHAR(255) NOT NULL,
    price INT,
    from TIMESTAMP,
    to TIMESTAMP
);

考虑周期不重叠：

cube(`Pricing`, {
  sql: `select itemId, price, from as timestamp from pricing_test_timestamp
  UNION ALL
  select itemId, -1 * price as price, to as timestamp from pricing_test_timestamp
  `,

  measures: {
    price: {
      sql: `price`,
      type: `sum`,
      rollingWindow: {
        trailing: `unbounded`
      }
    }
  },

  dimensions: {
    timestamp: {
      sql: `timestamp`,
      type: `number`
    }
  }
})