useStreamQueries is from the @daml/react library, and from the docs, says it can only accept {field: value}, so really you can only query a specific date, and not a range I think.
If you need to query the range, it seems that you shouldn’t be using the hooks from the daml/react library, but rather explicitly create a GET request from your frontend.
I don’t think the code of useStreamQueries adds any restriction, but if you’re using TypeScript it’s possible that the types do. I haven’t looked at the React bindings in a while, but I do remember it was pretty hard to express the full query language in TypeScript.
For the query language itself, though, the syntax for what you want would be: