Query editor
WITH solana_dex_transactions AS (SELECTDATE_TRUNC('day', block_time) AS date,trader_id AS user_address,SUM(amount_usd) AS total_valueFROM dex_solana.tradesWHERE block_time >= DATE '2024-01-01'AND amount_usd > 1000GROUP BY DATE_TRUNC('day', block_time), trader_id)SELECTdate,COUNT(DISTINCT CASE WHEN total_value > 1000 THEN user_address END) AS over_1000,COUNT(DISTINCT CASE WHEN total_value > 10000 THEN user_address END) AS over_10000FROM solana_dex_transactionsGROUP BY dateORDER BY date DESC;