Query editor
SELECTDATE_TRUNC ('day', block_time) time,SUM (amount_usd) AS daily_trade_usd,COUNT (tx_id) AS daily_tradeFROM dex_solana.tradesWHERE DATE_TRUNC ('day', block_time) > TRY_CAST('2023-12-31' AS TIMESTAMP)AND DATE_TRUNC ('day', block_time) < CURRENT_DATEGROUP BY 1ORDER BY DATE_TRUNC ('day', block_time)