WITH actions AS (
  SELECT
    submission_date_s3,

    split_part(locale, '-', 1) as locale,
    e.t.timestamp,
    e.t.category,
    e.t.method,
    e.t.object,
    e.t.value
  FROM
    telemetry_mobile_event_parquet
  CROSS JOIN
    UNNEST(events) AS e(t)
  WHERE
    submission_date_s3 >= '20180125' AND app_name = 'Fennec' AND os = 'iOS'
    AND e.t.category = 'action' AND e.t.method = 'scan'
)

SELECT
  submission_date_s3,
  object,
  COUNT(*) as count
FROM
  actions
GROUP BY
  submission_date_s3, object
ORDER BY
  submission_date_s3 ASC