Make sure the data is cut off at midnight

Also removes tables from the joins that no longer contain data
from the last 30 days

Change-Id: I8d51b6030b0a77eb9e38c10d0b20367cf90376f2
Mingle: https://wikimedia.mingle.thoughtworks.com/projects/multimedia/cards/565