Query editor
WITH txs AS (SELECTDATE_TRUNC('month', block_time) AS month,from_address AS walletFROM solana.transactionsWHERE mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v' -- USDC mint addressAND block_time >= CURRENT_DATE - INTERVAL '1 year'),wallets_per_month AS (SELECTmonth,COUNT(DISTINCT wallet) AS active_walletsFROM txsGROUP BY month)SELECT *FROM wallets_per_monthORDER BY month;