Query editor
WITH transactions AS (SELECTDATE_TRUNC('day', block_time) AS dt-- COUNT(*) AS txs,"from" as userFROM mantle.transactionsWHERE block_time >= date('2025-10-14')and success-- and block_time < current_date-- and "to" in (0x576CbcdE3fe704B2166E8fAC54D7a664b0325C10,0xb77726291b125515D0A7AfFeeA2b04f2FF243172)and "to" = 0xb77726291b125515D0A7AfFeeA2b04f2FF243172-- GROUP BY 1-- ORDER BY 1 DESC)SELECTdt,count(1) as txs,count(distinct user) as users,SUM(count(1)) OVER (ORDER BY dt) AS cum_txsFROM transactionsgroup by 1WITH daily_users AS (SELECTDATE_TRUNC('day', block_time) AS dt-- COUNT(*) AS txs,"from" as userFROM mantle.transactionsWHERE block_time >= date('2025-10-14')and success-- and block_time < current_date-- and "to" in (0x576CbcdE3fe704B2166E8fAC54D7a664b0325C10,0xb77726291b125515D0A7AfFeeA2b04f2FF243172)and "to" = 0xb77726291b125515D0A7AfFeeA2b04f2FF243172),unique_until AS (SELECTa.dt,COUNT(DISTINCT b.user) AS cumulative_usersFROM daily_users aJOIN daily_users bON b.dt <= a.dtGROUP BY a.dt)SELECT *FROM unique_untilORDER BY dt;