combine daily, download trans, write to DB, Analysis