update cloudfront_log
   set landing_page_id = landing_page.id
  from landing_page
 where cloudfront_log.log->>'landing-page' = landing_page.landing_page
   and cloudfront_log.date_time >= '2017-01-05' -- %(date_time)s
   and cloudfront_log.date_time < cast('2017-01-05' as timestamp with time zone) + interval '1 days' -- cast(%(date_time)s as timestamp with time zone) + interval '1 weeks'