WITH
  calendar AS (
  SELECT
    day
  FROM
    UNNEST(GENERATE_DATE_ARRAY( (
        SELECT
          MIN(PARSE_DATE('%Y%m%d',
              event_date))
        FROM
          `***`.`***`.`***`), (
        SELECT
          MAX(PARSE_DATE('%Y%m%d',
              event_date))
        FROM
          `***`.`***`.`***`), INTERVAL 1 DAY) ) AS day )
SELECT
  c.day AS date,
  COUNT(DISTINCT m.user_pseudo_id ) AS MAU
  --  UNNEST(event_params) AS event_params1
FROM
  calendar AS c
JOIN
  `***`.`***`.`***` AS m
ON
  parse_DATE('%Y%m%d',
    m.event_date) BETWEEN DATE_SUB(c.day, INTERVAL 30 DAY)
  AND c.day
WHERE
  event_name = 'eventCreation'
  AND event_params.key = 'isCommented'
  AND event_params.value.string_value = 'true'
GROUP BY
  date
ORDER BY
  date