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_monthNUMERICAverage amount of data stored over given date
For detailed information about consumed_gib_per_month usage and calculations, see Understanding Storage Billing.