Query editor
WITH txs AS (SELECTDATE_TRUNC('day', block_time) AS dt,"from" as user,count(1) as txsFROM mantle.transactionsWHERE block_time >= date('2025-10-14')and successand "to" = 0xb77726291b125515D0A7AfFeeA2b04f2FF243172group by 1,2),unique_until AS (SELECTa.dt,COUNT(DISTINCT b.user) AS cumulative_usersFROM txs aJOIN txs bON b.dt <= a.dtGROUP BY a.dt),t1 as(SELECTdt,sum(txs) as txs,count(1) as daily_users,SUM(sum(txs)) OVER (ORDER BY dt) AS cum_txsFROM txsgroup by 1)select a.*, cumulative_usersfrom t1 a join unique_until b on a.dt = b.dt