Query editor
SELECTDATE(block_time) AS trade_date,SUM(amount_usd) AS daily_volume_usdFROM dex_solana.tradesWHERE project = 'pumpswap'AND block_time >= CURRENT_DATE - INTERVAL '30' DAYGROUP BY DATE(block_time)ORDER BY trade_date ASC
Query editor
1SELECT2DATE(block_time) AS trade_date,3SUM(amount_usd) AS daily_volume_usd4FROM dex_solana.trades5WHERE project = 'pumpswap'6AND block_time >= CURRENT_DATE - INTERVAL '30' DAY7GROUP BY DATE(block_time)8ORDER BY trade_date ASC