rollups.sql

SELECT
  count(*) tweets,
  cast(DATE_TRUNC('HOUR', PARSE_TIMESTAMP('%a %h %d %H:%M:%S %z %Y', i.created_at)) as string) as event_date_hour_str,
  DATE_TRUNC('HOUR', PARSE_TIMESTAMP('%a %h %d %H:%M:%S %z %Y', i.created_at)) as event_date_hour,
  cast(i.user.id as string) id,
  arbitrary(i.user.name) name
FROM
  _input i
where
  i.user.id is not null
  and i.user.id is not undefined
group by
  i.user.id,
  event_date_hour_str,
  event_date_hour