Is it possible to query a period overlapping yesterday and today?

No, because real time and past data is not stored on the same servers. One server supplies you in real-time data, and one supplies data stored since you subscribed to your contact.

Data Query will block queries that attempt to request two sources of data simultaneously. The only way to merge real time and past data is to export both time periods and aggregate them in Excel or another software.