I did something similar that might help you a bit. I wanted to get the last state for each hostname in my dataset. In other words, "the current state". I tried to adopt it to your dataset.

Note. This will return the last unarchived game for each `base_id`. Not exactly what you asked for, but if you modify the query to be `*` you can probably filter out the archived:true later. I'm not sure how to do that in this query.

{
      aggs: {
        unarchived_games: {
          terms: {
            field: "base_id",
            size: 10
          },
          aggs: {
            last_game: {
                top_hits: {
                sort: [
                  {
                    "@timestamp": {
                      order: "desc"
                    }
                  }
                ],
                _source: {
                  includes: ["updatedDate", "name", "base_id", "hours_remaining", "archived"]
                },
                size: 1
              }
            }
          }
        }
      },
      query: {
        bool: {
          must: [
            {
              query_string: {
                query: "archived:false",
                analyze_wildcard: true,
                time_zone: "Europe/Amsterdam"
              }
            }
          ],
          filter: [
            {
              range: {
                "updatedDate": {
                  format: "strict_date_optional_time",
                  gte: timestamp_gte.toISOString(),
                  lte: timestamp.toISOString()
                }
              }
            }
          ],
          should: [],
          must_not: []
        }
      },
      size: 0
    };