Aggregate Table with Numbers.app
The formula for the right column of your aggregate table is:

=SUMIF(Data::A,A1,Data::B)


The parameters to SUMIF are:


The column of dates which you wish to group by.
The individual date you wish to output the sum of (i.e. the cell to the left).
The column which you are taking the sum of for the group.