Query is not respecting date range

GraphQL API
1

The following query will start listing data from 2024-04-06T00:00:00 instead of the defined 2024-04-06T17:00:00. Any idea why is this happening?

{
ethereum(network: bsc) {
dexTrades(
baseCurrency: {is: “0x96ed4db01218608e6c8a8d66c65bdf59601ee735”}
quoteCurrency: {is: “0xbb4CdB9CBd36B01bD1cBaEBF2De08d9173bc095c”}
date: {since: “2024-04-06T17:00:00”, till: “2024-04-11T13:50:00”}
options: {limit: 25000, asc: “block.timestamp.unixtime”}
) {
quotePrice
transaction {
hash
}
block {
timestamp {
unixtime
}
}
}
}
}

2

: Its because you are using date to filter date: {since: “2024-04-06T17:00:00”, till: “2024-04-11T13:50:00”} use time: {since: “2024-04-06T17:00:00”, till: “2024-04-11T13:50:00”} instead then it will also take care of exact time you need to filter from.

3

Works like charm, many thanks!