Hey Jonathan -
Based on what you describe, you should have 14 days worth of data unless you managed to get a filter on the extract which caused only one day to come down.
Could you upload a screenshot of the extract dialog as configured before you began the extract process?
Jonathan, it sounds like you have two problems: it's taking hours to finish your extract, and you aren't seeing the data you're expecting in your extract when it is complete. I'd tackle those problems in order, as the second problem will be a lot easier to solve if your extracts speed up.
The first thing I'd suggest is contacting whoever manages the database you're connecting to and making sure that the tables you're joining are appropriately indexed based on the columns in the join statement. If that's the issue, it'll speed up your extracts tremendously.