Query editor
WITH tcap_dex_trades AS (SELECT blockchain,project,block_time,token_bought_symbol,token_sold_symbol,token_pair,token_bought_amount, token_sold_amount, amount_usdFROM dex.tradesWHERE token_bought_symbol IN ('TCAP')OR (token_sold_symbol IN ('TCAP'))),final AS (SELECT DATE_TRUNC('day', block_time) AS day, project, SUM(amount_usd) AS tcap_volume_usdFROM tcap_dex_tradesWHERE project IN ('sushiswap', 'uniswap')GROUP BY 1,2)SELECT *,SUM(tcap_volume_usd) over(partition by project order by day) cumu_tcap_volume_usd,SUM(tcap_volume_usd) over(order by day) cumu_tcap_volume_usd_totalFROM finalORDER BY 1 DESC