Token Prices Hourly

eth.token_prices_hourly

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

Columns

• token_address — FixedString(42)
• hour — DateTime
• sum_usd_direct — AggregateFunction(sum, Decimal(76, 18))
• sum_token_volume — AggregateFunction(sum, Decimal(76, 18))
• sum_weth_notional — AggregateFunction(sum, Decimal(76, 18))
• trade_count — AggregateFunction(count, UInt64)

Modeling notes

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