Query editor
SELECTproject,DATE_TRUNC('day', block_time) AS day,SUM(amount_usd) AS "usd_volume"FROM dex_solana.tradesWHEREblock_time > DATE_TRUNC('day', CURRENT_TIMESTAMP) - INTERVAL '30' dayAND block_time < DATE_TRUNC('day', CURRENT_TIMESTAMP)GROUP BYproject,DATE_TRUNC('day', block_time)