Query editor
WITH usdc_txs AS (SELECTDATE_TRUNC('month', block_time) AS month,from_owner AS walletFROM tokens_solana.transfersWHERE token_mint_address = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'AND block_time >= TIMESTAMP '2024-10-01'UNION ALLSELECTDATE_TRUNC('month', block_time) AS month,to_owner AS walletFROM tokens_solana.transfersWHERE token_mint_address = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'AND block_time >= TIMESTAMP '2024-10-01')SELECTmonth,COUNT(DISTINCT wallet) AS active_walletsFROM usdc_txsGROUP BY monthORDER BY month;