use bigint for seconds since unix epoch
get hit aggregation correct