Cacher is the code snippet organizer for pro developers

SELECT
  *
FROM
  reports_account_snapshot
WHERE
  event_date IN (
    SELECT   MAX(event_date)
    FROM     reports_account_snapshot
    GROUP BY date_trunc('month',event_date), date_trunc('year',event_date)
  )
 AND closed_store = false