Query: compute_disk_write_throughput

select
  timestamp,
  (sum / 300) as write_throughput_ops
from
  gcp_compute_disk_metric_write_ops
where
  timestamp >= current_date - interval '7 day'
  and name in (
    select
      name
    from
      gcp_compute_disk
    where
      id = $1
  )
order by
  timestamp;