0 - 3 of 3 tags for aggregation

Hi,
I have below query which is failing in dev environment due to spool issue:
 
INSERT INTO D0_IM_RSTG_TAS_MD4.STG_TEMP_STOCK_DETAILS(MATERIAL_ID,
VALUATION_AREA_ID, PLANT_ID, STORAGE_LOCATION_ID, CUSTOMER_ID,
VENDOR_ID, WBS_ELEMENT_ID, FISCAL_PERIOD_CODE, BEGIN_DATE, END_DATE,

Hello - 
I'm hoping someone can give a little guidance  on how to create a table that includes a "sum to date" - I believe there must be a simple way to do this but I have been unable to find a thread with this topic.
 
I am starting with a table(totals_by_date) with two columns - _date,total.
 
( like this):

One of the more infamous data usage stories over the last week concerned the removal of the iPhone app, “Girls Around Me.”  This app aggregated Foursquare and Facebook data via their respective APIs to generate a map, with pictures, of wo