As Luis pointed out, you'll want to fully qualify the column names. Essentially, the [date] column is used by more than one table and SQL Server does not know...
Your comment about 24x values, are you looking for 24 hours? It appears that you are selecting 48 hours of data. Either update the @enddate or remove the DATEADD() if...