Query: ebs_volume_top_10_write_ops_avg

with top_n as (
  select
    volume_id,
    avg(average)
  from
    aws_ebs_volume_metric_write_ops_daily
  where
    timestamp  >= CURRENT_DATE - INTERVAL '7 day'
  group by
    volume_id
  order by
    avg desc
  limit 10
)
select
  timestamp,
  volume_id,
  average
from
  aws_ebs_volume_metric_write_ops_hourly
where
  timestamp  >= CURRENT_DATE - INTERVAL '7 day'
  and volume_id in (select volume_id from top_n);