You can use the information_schema.storage_billing view to see daily billing information for storage in all the accounts across all the regions in organization.

SELECT
  *
FROM
  information_schema.storage_billing;

Columns in information_schema.storage_billing

Each row has the following columns.

Column NameData TypeDescription
account_nameTEXTAccount for which the storage is billed
regionTEXTRegion where the data is stored
usage_dateDATEDate for which the usage is reported
consumed_gib_per_monthNUMERICAmount of data billed for the given date in GiB
billed_costNUMERICThe cost for the storage consumed for the given date
is_creditBOOLEANIndicates whether costs were used as credit