SELECT
  COALESCE(STRING(SAFE.PARSE_DATE("%Y%m%d", partition_id)), partition_id) AS date,
  total_rows,
  ROUND(total_logical_bytes/POW(2,30), 2) AS size_GB
FROM `{{project}}.{{dataset}}.INFORMATION_SCHEMA.PARTITIONS`
WHERE table_name = '{{table}}'
ORDER BY partition_id desc