Where are you today? -- Asks where you are now. This is not very common, but could be used, for example, when talking on the telephone, if someone has called you and you don't know where they are.
Where were you today? -- Asks where you were earlier. This would usually be used at or towards the end of the day.