subgraph_daily_summary.sh

# Consumes json summary file
# output call count per subgraph 

summaries=""
  day=2020115
  day_summary=$(jq -s 'group_by(.subgraph) |
    map({"subgraph":(.[0].subgraph), "calls":(reduce .[].calls as $calls (0; . + $calls)), "date":("'$day'") }) |
    map([.subgraph, .calls, .date] | join(", ")) | join(" \r\n ")' < $1)
  summaries+="${day_summary//\"} \r\n"
printf "${summaries//\"}" > subgraph_daily_summary.csv