Use consistent "local_date" column name for aggregate tables, which will simplify SQL design. For hourly aggregates the column is actually a TIMESTAMP, others will have DATE.