Query editor
SELECTDATE_TRUNC('day', block_time) AS day,SUM(amount_usd) AS total_usdFROM dex_solana.tradesWHEREblock_time >= TRY_CAST('2024-01-01 00:00:00 UTC' AS TIMESTAMP)AND block_time < TRY_CAST('2025-01-01 00:00:00 UTC' AS TIMESTAMP)AND blockchain = 'solana'GROUP BY1ORDER BYday