changed -08 to PST for timestamping
working on storing nulls whenever a value doesn't exist