Query editor
WITH mamo_deposits AS (SELECT * FROM dune.serotonin_data.mamo_deposits),user_first_deposit AS (SELECTuser_address,MIN(DATE(block_time)) as first_deposit_dateFROM mamo_depositsGROUP BY 1),daily_users AS (SELECTDATE(md.block_time) as date,COUNT(DISTINCT CASE WHEN DATE(md.block_time) = ufd.first_deposit_date THEN md.user_address END) as new_users,COUNT(DISTINCT CASE WHEN DATE(md.block_time) > ufd.first_deposit_date THEN md.user_address END) as returning_usersFROM mamo_deposits mdJOIN user_first_deposit ufd ON md. user_address = ufd. user_addressGROUP BY 1)SELECTdate,new_users,returning_users,new_users + returning_users as total_daily_users,SUM(new_users) OVER (ORDER BY date) as cumulative_new_usersFROM daily_usersORDER BY date