Query editor
WITH daily_stats AS (SELECTDATE_TRUNC('day', tx.evt_block_time) AS day,COUNT(DISTINCT tx."from") AS daily_new_users,COUNT(*) AS daily_transactionsFROM erc20_arbitrum.evt_Transfer txWHEREtx.to = FROM_HEX('2df1c51e09aecf9cacb7bc98cb1742757f163df7')AND tx.evt_block_time >= NOW() - INTERVAL '240' DAYGROUP BY 1),cumulative_stats AS (SELECTday,SUM(daily_new_users) OVER (ORDER BY day ASC ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS cumulative_users,SUM(daily_transactions) OVER (ORDER BY day ASC ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS cumulative_transactionsFROM daily_stats)SELECT * FROM cumulative_statsORDER BY day ASC;