Currently, the where clause includes this expression

snapshot_date > now() - interval '2 day';  

However, depending on timing, this sometimes gathers 1 days data, sometimes 2 days worth.

Instead, change the clause to

snapshot_date=date_trunc('day', now() - interval '2 day') 

which will force the query to pull only data from tallies for 2 days ago.