Skip to content

Weth Price Hourly

eth.weth_price_hourly

Purpose: TODO (describe what this table powers and its grain).

Columns

  • hour — DateTime
  • sum_usd — AggregateFunction(sum, Decimal(76, 18))
  • sum_weth — AggregateFunction(sum, Decimal(76, 18))

Modeling notes

  • Engine: AggregatingMergeTree
  • Partition key: toYYYYMM(hour)
  • Sorting (ORDER BY): hour