Recently we have a situation very similar to a bug solved in July
It looks like current query results are “influenced” by previous queries for the same address but with different parameters.
Here are the steps to reproduce:
1- Query for a transactions done in a year:
curl 'https://deep-index.moralis.io/api/v2/0x207ca4370639120f9A049aF9CAB4fCaa608F2445/erc20/transfers?chain=polygon&from_date=1623586566&to_date=1655122566' -H 'X-API-Key: API-KEY'
ok --> 223 transactions
2- Repeat query:
curl 'https://deep-index.moralis.io/api/v2/0x207ca4370639120f9A049aF9CAB4fCaa608F2445/erc20/transfers?chain=polygon&from_date=1623586566&to_date=1655122566' -H 'X-API-Key: API-KEY'
ok --> 223 transactions
3 - Query for transactions in a given day (same address)
curl 'https://deep-index.moralis.io/api/v2/0x207ca4370639120f9A049aF9CAB4fCaa608F2445/erc20/transfers?chain=polygon&from_date=1655036166&to_date=1655122566' -H 'X-API-Key: API-KEY'
error -> 223 transactions
4 - if we repeat last query, we get the correct result
curl 'https://deep-index.moralis.io/api/v2/0x207ca4370639120f9A049aF9CAB4fCaa608F2445/erc20/transfers?chain=polygon&from_date=1655036166&to_date=1655122566' -H 'X-API-Key: API-KEY'
ok -> 0 transactions