Query editor
WITH first_trade AS (SELECTtx_from as wallet,MIN(DATE_TRUNC('day', block_time)) as first_trade_dayFROM dex.tradesWHERE blockchain = 'bnb'AND (token_bought_address = 0xcf3232b85b43bca90e51d38cc06cc8bb8c8a3e36OR token_sold_address = 0xcf3232b85b43bca90e51d38cc06cc8bb8c8a3e36)AND block_time >= DATE '2025-11-01'GROUP BY 1),july_traders AS (SELECT DISTINCTtx_from as wallet,DATE_TRUNC('day', block_time) as dayFROM dex.tradesWHERE blockchain = 'bnb'AND (token_bought_address = 0xcf3232b85b43bca90e51d38cc06cc8bb8c8a3e36OR token_sold_address = 0xcf3232b85b43bca90e51d38cc06cc8bb8c8a3e36)AND block_time >= DATE '2026-07-01'AND block_time <= DATE '2026-07-31')SELECTj.day as "Day",COUNT(DISTINCT CASE WHEN j.day = f.first_trade_day THEN j.wallet END) as "New Traders",COUNT(DISTINCT CASE WHEN j.day > f.first_trade_day THEN j.wallet END) as "Returning Traders"FROM july_traders jJOIN first_trade f ON j.wallet = f.walletGROUP BY 1ORDER BY 1 ASC;