Query editor
WITH mamo_deposits AS (SELECT * FROM dune.serotonin_data.mamo_deposits WHERE action = 'deposit')SELECTDATE_TRUNC('week', block_time) as week,COUNT(DISTINCT user_address) as unique_depositors,COUNT(*) as total_deposits,SUM(amount_usd) as weekly_volume,SUM(CASE WHEN symbol = 'USDC' THEN amount_usd END) as usdc_volume,SUM(CASE WHEN symbol = 'cbBTC' THEN amount_usd END) as cbbtc_volume,SUM(CASE WHEN symbol = 'MAMO' THEN amount_usd END) as mamo_volume,AVG(amount_usd) as avg_deposit_sizeFROM mamo_depositsGROUP BY 1ORDER BY 1