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