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 blockchain = 'base'AND (token_bought_symbol IN ('TCAP') OR token_sold_symbol IN ('TCAP'))),final AS (SELECT DATE_TRUNC('minute', block_time) AS day, project, SUM(amount_usd) AS tcap_volume_usdFROM tcap_dex_tradesWHERE project IN ('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