5 This object contains daily query counts per subgraph.

forty_eight_hour_volume = query_volume %>% # filter to the past 2 days (48 hours) filter(date >= Sys.Date() - days(2)) %>% # group by subgraph id (using the correct column name) group_by(subgraph_deployment_ipfs_hash) %>% # sum the query count over the past 2 days summarize(forty_eight_hour_volume = sum(query_count, na.rm = TRUE), .groups = ‘drop’)