update mdy dailysnapshot