updated config, materialized queries

Going with materialized for now to convert the dates. Queries won't get
very big, even over time. TODO: either store in non-UTC or find
non-materialized way to convert utc time in DB to local time