You can use the information_schema.storage_metering_history view to see daily information about aggregated storage consumption within an account.

SELECT
  *
FROM
  information_schema.storage_metering_history;

Columns in information_schema.storage_metering_history

Each row has the following columns.

Column NameData TypeDescription
usage_dateDATEDate for which the usage is reported
consumed_gib_per_monthNUMERICNumber of bytes consumed by the account for the given date