Query editor
SELECTDATE(block_time) AS trade_date,COUNT(DISTINCT trader_id) AS daily_unique_tradersFROM dex_solana.tradesWHERE project = 'pumpswap'AND block_time >= CURRENT_DATE - INTERVAL '30' DAYGROUP BY DATE(block_time)ORDER BY trade_date ASC