Hi Bruno,
Thanks for the feedback!
It is well known to me that there is a difference between the API data and the database data and I plan to clarify it in the documentation.
Basically the database is always going to be about 2 days behind the API because we have to wait to make sure all the data is established in the API for a given day before we harvest it into the database. We harvest it by date and if we don't wait long enough then we harvest incomplete data for a given day. To get accurate data in the db we need to make sure we wait until all the numbers for a given day have been completely processed in the API.
Using the API directly we always have the most up to date data, though there is some caching used so we are not constantly hitting the API.
Best,
Joe