Query editor
1SELECT2 COUNT(*) AS total_number_of_trades3FROM dex_solana.trades4WHERE5 blockchain = 'solana' AND DATE_TRUNC('day', block_time) = CURRENT_DATE
SELECT
COUNT(*) AS total_number_of_trades
FROM dex_solana.trades
WHERE
blockchain = 'solana' AND DATE_TRUNC('day', block_time) = CURRENT_DATE