Query editor
1SELECT 2DATE(block_time) AS trade_date,3SUM(fee_usd) AS daily_fees_usd4FROM dex_solana.trades5WHERE project = 'pumpswap'6AND block_time >= CURRENT_DATE - INTERVAL '30' DAY7GROUP BY DATE(block_time)8ORDER BY trade_date ASC
SELECT
DATE(block_time) AS trade_date,
SUM(fee_usd) AS daily_fees_usd
FROM dex_solana.trades
WHERE project = 'pumpswap'
AND block_time >= CURRENT_DATE - INTERVAL '30' DAY
GROUP BY DATE(block_time)
ORDER BY trade_date ASC