Query editor
WITH mamo_deposits AS (SELECT * FROM query_5553800),time_series AS (SELECTDATE(deposit_time) AS date,token,COUNT(DISTINCT strategy_owner) AS unique_depositors,COUNT(*) AS deposit_count,SUM(amount_usd) AS total_usd_depositedFROM mamo_depositsGROUP BY 1, 2),dates AS (SELECTdays,token_typeFROM (SELECT token_type FROM UNNEST(ARRAY['USDC', 'cbBTC']) AS t(token_type)) tokensCROSS JOINUNNEST(SEQUENCE((SELECT DATE(MIN(date)) FROM time_series),(SELECT DATE(MAX(date)) FROM time_series),INTERVAL '1' DAY)) AS t(days))SELECT*,SUM(total_usd_deposited) OVER (PARTITION BY token ORDER BY date ASC) AS cumulative_usd_deposited,SUM(unique_depositors) OVER (PARTITION BY token ORDER BY date ASC) AS cumulative_unique_depositorsFROM (SELECTDATE_TRUNC('day', dt.days) AS date,dt.token_type as token,MAX(COALESCE(ts.unique_depositors, 0)) AS unique_depositors,SUM(COALESCE(ts.deposit_count, 0)) AS deposit_count,SUM(COALESCE(ts.total_usd_deposited, 0)) AS total_usd_depositedFROM dates dtLEFT JOIN time_series ts ON dt.days = ts.date AND dt.token_type = ts.tokenGROUP BY 1, 2)ORDER BY date ASC, token