filter by ymd rather than timestamps; update schemas