Query editor
WITH daily_transactions AS (SELECTDATE_TRUNC('day', block_time) AS activity_date,signer AS wallet_addressFROM solana.transactionsWHEREblock_time >= CAST('2024-10-01' AS TIMESTAMP)GROUP BYDATE_TRUNC('day', block_time),signer)SELECTactivity_date,COUNT(DISTINCT wallet_address) AS daily_active_walletsFROM daily_transactionsGROUP BYactivity_dateORDER BYactivity_date